Aggregate domain reports can be created or refreshed from the Gopher for Chrome sidebar. All domain reports can be set to refresh automatically once every 24 hours via the toggle. The exact time of the refresh will be determined randomly based on the last auto-refresh time of your device cache, however, it will be timestamped in cell A1 of the relevant report tab.
Setting up auto-refreshing reports on a Sheet and sharing the doc can be a great way to provide dashboards to non-IT-admin stakeholders like principals, superintendents, and technology integrators to gain insight into how devices are being used throughout the domain.
To generate aggregate domain reports:
Open a new Google Sheet.
- In the top menu, go to Extensions > Gopher for Chrome > Launch Sidebar.
- Once the sidebar loads, click Run reports.
- Click Aggregate.
- Select an arrow at the left for all the reports to run OU 15-day Activity, Chrome Version, Chrome Version by OU, Model/AUE, Model/Aue by OU, Daily Activity by OU. Once selected, the arrow turns to a selected checkbox.
- Check the checkbox at the right of any report that is to refresh daily.
- Click RUN # SELECTED REPORTS. A tab opens for each report you’ve selected.
Aggregate reports description
OU 15-day Activity report: Displays a snapshot of device utilization and policy sync activity in the last 15 calendar days across org units.
Pro Tip: The Avg Total Minutes Per Device in Last 15 Days column is pulled from the Admin console and represents total active usage, including off-campus and on-campus.
Chrome Version report: Shows totals for each major and minor OS version running across the entire domain.
Chrome Version by OU: Provides the same information as the Chrome Version report, but broken out by org unit
Model/AUE report: Shows totals for each model, along with end-of-life date, for all active and deprovisioned devices on the domain.
Model/AUE by OU: Shows the same information, but broken out by org unit.
Daily Activity by OU: Provides a day-by-day accounting of available devices, device utilization represented in avg. minutes per device and % of fleet utilized, as well as a count of devices not synced. This report will contain the most recent 15 calendar days when it is first run. When refreshed daily, via the Refresh domain reports daily option, data for new calendar days will continue to be appended to the report so that it always contains the 30 most recent calendar days.
Note: To avoid overloading the Sheet, this report will purge any data older than 30 days when refreshed.