Search
Clear search
Close search
Google apps
Main menu

Aggregate reports

View trends and administrative data

As an administrator, you can use aggregate reports to review trends or to see an overview of administrative information for various settings and statuses, including verification status, account status, administration status, storage quotas, document visibility, email flow, and Drive file counts. The reports generate a series of charts and graphs that display information for all users in your G Suite domains. Use aggregate reports to see an overview of information or review trends. To review user-level data, access account activity reports.

Step 1: Open your aggregate report

  1. Sign in to your Google Admin console.

    Sign in using your administrator account (does not end in @gmail.com).

  2. From the Admin console dashboard, go to Reports.

    To see Reports, you might have to click More controls at the bottom.

  3. Go to Aggregate reports.
  4. On the toolbar, click Select columns Select columns. Then select the data you want to show in your report.
  5. See below for how to interpret and customize report data.

Step 2: Understand aggregate reports data

The Admin console bases its aggregate reports on the following user data.
Accounts
Report type Description
2-Step Verification enrollment Number of users in your domains who are enrolled in 2-Step Verification.
2-Step Verification enforcement Number of users in your domains who are required to be enrolled in 2-Step Verification.
User account status
Number of users in your domains, by their account status (Active, Blocked, or Suspended).
  • A blocked user has violated the Terms of Service. Our systems automatically suspend them and mark them Abusive. For more information, you can contact Support.
  • A suspended user has an account that has been temporarily disabled by an administrator. As an administrator, you can suspend a user account without deleting the domain profile or associated information, such as documents and presentations. Suspended users can't sign in until an administrator has restored the suspended user account.
Admin status Number of users in your domains, by their administrative access (Super Admin, Delegated Admin, or None).
Less secure apps access status Number of users in your domains, by whether the user has the option to block or allow (Allowed or Denied​) less secure app access to their own accounts.
Storage used by apps (MB) Storage (in MB) used by all users in your domains for Gmail, Google Drive, and Google Photos.

This report type isn’t displayed for customers who have the G Suite Enterprise or Business or Education edition.

Total used storage (MB) Storage (in MB) used by all users in your domains.

This report type isn’t displayed for customers who have the G Suite Enterprise or Business or Education edition.

Gmail
Report type Description
Inbound Email: Delivery Total number of inbound messages (delivered, rerouted, rejected) received by your users from senders outside your organization's associated domains.
Inbound Email: Spam Number of inbound messages tagged as spam, shown as a fraction of total inbound messages.
Inbound Email: Encryption Number of inbound-encrypted messages, shown as a fraction of total inbound messages.
Outbound Email: Delivery Number of outbound-delivered messages (delivered, rerouted, rejected), shown as a fraction of total outbound messages.
Outbound Email: Encryption Number of outbound-Transport Layer Security (TLS)-encrypted messages, shown as a fraction of total outbound messages.
Total emails Total number of emails stored by all users in your domains.

To learn more about inbound and outbound email messages in reports, see Definitions for mail flow terminology.

Known issue for Gmail aggregate reports—Messages rejected by the “default routing” rule aren't counted as rejected messages. Messages with viruses detected during SMTP MSA negotiation are not counted as rejected messages in the Aggregate reports, but are counted as “Rejected” in Email Log Search.
Mobile
Report type Description
Managed devices (7DA)

Number of managed devices (Google Sync, Android Sync, and iOS Sync) that were active in the last 7 days.

If a device has 2 types of sync set up—Google Sync and Android Sync on an Android device, or Google Sync and iOS Sync on an iOS device—then it's counted in both corresponding data sets on the graph.

Managed devices (30DA)

Number of managed devices (Google Sync, Android Sync, and iOS Sync) that were active in the last 30 days.

If a device has 2 types of sync set up (see below), then it's counted in both corresponding data sets on the graph:

  • Google Sync and Android Sync on an Android device
  • Google Sync and iOS Sync on an iOS device

Note: By default, this report isn't displayed.

Managed users (7DA) Number of managed users (Google Sync, Android Sync, and iOS Sync) that were active in the last 7 days.
Managed users (30DA) Number of managed users (Google Sync, Android Sync, and iOS Sync) that were active in the last 30 days.
Note: By default, this report isn't displayed.
Managed Android devices (7DA) Number of Android devices, by version (Google Sync and Android Sync), that were active in the last 7 days.
Managed Android devices (30DA) Number of Android devices, by version (Google Sync and Android Sync), that were active in the last 30 days.
Note: By default, this report isn't displayed.
Managed iOS devices (7DA) Number of iOS devices, by version (Google Sync and iOS Sync), that were active in the last 7 days.
Managed iOS devices (30DA) Number of iOS devices, by version (Google Sync and iOS Sync), that were active in the last 30 days.
Note: By default, this report isn't displayed.
If your mobile reports show no activity, then you need to enable Mobile management by enforcing policies on your users' devices.
Drive
Report type Description
External link shared files

Number of externally visible files all users in your domains have in Google Drive, where the graph displays this data:

  • Publicly visible—Number of Drive files uploaded to Drive and visible to anyone.
  • Visible to anyone with link—Number of Drive files uploaded to Drive and visible to anyone who has the link.
Internal link shared files Number of internally visible files all users in your domains have in Drive, where the graph displays this data:
  • People at domain—Number of Drive files uploaded to Drive and visible to anyone in your domains.
  • People at domain with link—Number of Drive files uploaded to Drive and visible to anyone in your domains who has the link.
  • Private—Number of Drive files uploaded to Drive that are private and only visible to the user who uploaded it.
Files owned Number of files in Drive owned by all users in your domains, where the graph displays this data:
  • File Uploads—Number of times files of any type were uploaded to Drive.
  • Google Docs—Number of text documents in Drive.
  • Google Sheets—Number of spreadsheets in Drive.
  • Google Slides—Number of presentations in Drive.
  • Google Forms—Number of forms in Drive.
Classroom
Report type Description
Active classes Number of 14-day active classes. 
Classes created Number of classes created.
Posts created Total number of posts created by teachers and students.
Chrome devices

These reports appear for domains with purchased Chrome device management licenses.

Report type Description
Chrome devices (7-day active)

Number of unique Chrome devices your users have signed in to over the past week.

Chrome device release channels

Chrome release channel of your devices.

Note: We recommend that you keep most of your users on the latest stable release of Chrome OS and 5% of your users on the Beta channel. You may choose to also keep your IT team on the Beta or Dev channels. Learn more about auto-updating Chrome devices.

Chrome device boot modes Boot mode for your devices, where most, if not all, should be "Verified boot".
Chrome devices count by version

Number of Chrome devices running a version of Chrome.

Note: We recommend that you keep most of your users on the latest stable release of Chrome OS. We recommend you have some users and your IT team on newer versions of Chrome, which you can do by setting them to the Beta channel. Learn more about auto-updating Chrome devices.

Google+
Report type Description
Video Hangouts Total number of video conferences generated by all users in your domains for a particular date.
Cloud Search
Report type Description
Active users

Total number of users in your domain who did a search using Google Cloud Search.

Step 3: Change the data you see in the chart

  1. Open your report as shown above.
  2. Next to the title above the chart, click the Down arrow Down Arrow .
  3. Select an option from the list or click a column in the table.
  4. Hover your cursor over any point in the chart to see specific data over the timeline.

Step 4: Change the data you see in reports

  1. Open your report as shown above.
  2. On the toolbar, click Select columns Select columns to view all available columns.
  3. Click the box next to each column you want to display and click Apply.
You'll see the same columns the next time you open this report.

Step 5: Customize and export your report data

Filter the report data by user or activity

You can narrow your report to show specific events or users. For example, you can create a filter to find all users who are using 2-Step Verification. Or, you can create a filter to list people who share a lot of external links.

  1. Open your report as shown above.
  2. If you don't see the Filters section, on the toolbar, click Filter Filter.
  3. Enter or select the criteria for your filter. You can filter on any combination of the data you can view in the report.

Export your report data

You can export your aggregate report data to a Google Sheet, or download it as a CSV file.

  1. Open your report as shown above.
  2. (Optional) To change the data to include in your export, on the toolbar, click Select columns Select columns .
  3. Click the box next to each column with data you want to export and click Apply.
  4. On the report, click Download Download.

You can export up to 210,000 cells. The maximum number of rows depends on the number of columns you select.

Change how much data you show

You won’t see complete data up to the present day. Instead, activity in recent days might only be partially reported while it’s still being collected. To choose an end date for collecting data and see the most recent date full data is available:

  1. At the top, next to the calendar, click the Down arrow Down Arrow.
  2. In the calendar, choose an end date for collecting data in your report.

    A green background marks the latest date when all data are collected. You can select a date after that, but later days might report only partial data.

For details on exactly when data becomes available and how long it's retained, see Data retention and lag times.

Was this article helpful?
How can we improve it?
Sign in to your account

Get account-specific help by signing in with your G Suite account email address, or learn how to get started with G Suite.