Schedule Reports for Top Email Senders and Receivers in Gmail
This post will show you how GAT+ can generate a report of all email activity for each user.
The report can be scheduled daily, weekly, or monthly and will be generated in the form of a spreadsheet that can be sorted by the desired column.
The report will cover both internal and external emails.
Find emails
To start building this scheduled report the Admin should go to:
GAT+ then navigate Emails audit
- Select the ‘User statistics’ from the top menu
- Choose Type (Stats by Date range and Users)
- Time period – Date From and Date to
- User/Group/OU for the report to run against.
Schedule report
From there, select the ‘Scheduled’ button. It will open extra fields to be filled, such as “Enabled” to enable the report, then choose the ‘Occurrence’ in this case we select daily (Every day -After midnight), then ‘Apply & Schedule.
For the daily report, select as a schedule ‘Every day – after midnight’ or choose weekly, monthly, or a custom Cron period.
You may also add additional email recipients for the report.
Result
The Admin will be emailed a link to the spreadsheet
The generated spreadsheet will display:
- Statistics of all emails sent and received by members of the searched group/OU.
- Stats for how many emails they have sent and received from their account whether it was sent from Email or Group they use.
Admin can then sort the Spreadsheet to display by the number of emails sent and received, by each individual user.
A new spreadsheet will be created every day, cover the previous day.
An example of the spreadsheet output looks like this.
Freeze row 1 and then select any column of interest, finally sort the sheet based on that column in the Z to an order to bring the largest numbers to the top.
Top emails – by Email Content Search
There is also another way to find Top Email sender and receivers.
In Email audit – select ‘Email Content search’, (this is a real-time Gmail search).
In this example, we are searching for all emails in our domain “/” including sub-OUs.
We search for emails ‘newer_than:2d’ – Admin can use any other search parameter (examples from the same line ‘small arrow on the right-hand side’)
Select ‘Search emails’ this will start a search.
When the result is displayed simply click on the “Sender/Receiver” option from the top bar.
Here an Admin can sort each of the fields.
See top Internal and External Email senders and receivers on your domain.
Each of the tables can be exported into a spreadsheet.
This is very useful if, for example, your managers want a list of all emails sent and received by your users in a certain period of time.
To see who received and sent what amount of emails.
If you would like to run a trial of our products please install GAT+ from the Google Workspace Marketplace and contact us at support@gatlabs.com with any questions you may have.
To request a demo please click here and fill the form, we will get back to you in less than 12 hours during weekdays.
If you trailed GAT in the past and you would like to run a fresh trial again, please enquire through this form.