Monthly Group Aggregate Email Report Spreadsheets

This document describes a very specific use-case where it is required to produce a monthly email usage report covering the users in a Google group.

The report results will be in the form of a spreadsheet and is designed to be run on the first day of the following month. The period covered will always represent the calendar month of the previous month, whether it has 28, 29, 30 or 31 days. The results will be the aggregated totals for each user for the whole month.

The report is run from the ‘Users’ audit on the GAT home page. Once inside the ‘Users’ audit, select the ‘Emails’ tab, enter the Google group name and click on ‘Search Users’.

After the results are returned click on ‘Show daily stats’ and from this new view, select ‘Schedule’.

Once in the scheduler select a run cycle of ‘Every first of the month’.

In addition, select the output option ‘Single spreadsheet with the last 30 days (aggregated)’. Selecting this option, when used in conjunction with the report cycle of ‘first of every month’ will in fact report for the period of the previous calendar month. That is, depending on the month from the 1st to the 28th, 29th, 30th or 31st.