About Gmail reports and BigQuery

Supported editions for this feature: EnterpriseEducation Standard and Education PlusCompare your edition

Google Workspace gives you several ways to search and export your Gmail logs to create email reports:

To streamline your BigQuery tasks and let you manage all your BigQuery data in one place, we’re merging Gmail logs in BigQuery with Workspace logs and reports in BigQuery, starting in February 2023. You’ll manage BigQuery logs and reports for all your Workspace services in the same place in your Google Admin console. We recommend that you migrate your Gmail BigQuery views, queries, and scripts to Workspace logs and reports in BigQuery as soon as possible. For detailed steps, go to Migrate Gmail logs in BigQuery to Workspace logs in BigQuery.

BigQuery reporting

For customizable, scalable reports for your enterprise or large organization, we recommend BigQuery. BigQuery is Google's managed analytics data warehouse.

With BigQuery, you can:

  • Create custom Gmail reports.
  • Create reports that combine Gmail data with data from other sources or apps. 
  • Keep and analyze Gmail data in BigQuery for as long as you need. The Admin console keeps Gmail data for only 30 days.

For example, you can create custom BigQuery reports to:

  • Identify which rule quarantined a message.
  • Track the number of distinct messages sent to a specified recipient.
  • Review Gmail activity by combining Gmail data with organization directory data.

Note: You can also use BigQuery to analyze data from other Google Workspace apps and features. Learn more about other ​Google Workspace​ reporting logs with BigQuery.

Next steps

To get started with BigQuery for Gmail reporting:

Other Gmail reporting options

Email Log Search

Use the pre-defined reports in Email Log Search in the Admin console to review mail delivery logs. Email Log Search keeps Gmail data for 30 days.

For example, you can use Email Log Search to:

  • Find missing messages.
  • Check the status of messages after delivery.
  • Determine message IP addresses.
  • Troubleshoot how policies affect mail flow.

Learn more about Email Log Search and supported reports.

Reports API

Use the Google Workspace Reports API to create these types of custom Gmail reports:

For example, you can use API reports to identify:

  • The last time user accounts were accessed. 
  • How many emails are marked as spam, per user.
  • Number of active user Gmail accounts.

Get started with the Reports API.

Was this helpful?
How can we improve it?

Need more help?

Sign in for additional support options to quickly solve your issue

Clear search
Close search
Google apps
Main menu
Search Help Center