Create aggregate domain reports

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:

  1. Open a new Google Sheet.
  2. In the top menu, go to Add-ons>Gopher for Chrome>Launch Sidebar
  3. Once the sidebar loads, click Run reports.
    RunReportsButton.png
  4. Click Aggregate.
  5. Check the checkbox for the type of reports to run; OU 15-day Activity, Chrome Version, Chrome Version by OU, Model/AUE, Model/Aue by OU, Daily Activity by OU.
    Screen_Shot_2019-10-31_at_4.57.39_PM.png
  6. Click SAVE/REFRESH. 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.

AggregateReportOUActivityHL.png

Chrome Version report: Shows totals for each major and minor OS version running across the entire domain.

AggregateReportChromeVersionHL.png

Chrome Version by OU: Provides the same information as the Chrome Version report, but broken out by org unit

AggregateChromebyOU_HL.png

Model/AUE report: Shows totals for each model, along with end-of-life date, for all active and deprovisioned devices on the domain.

AggregateReportModel_AUE_HL.png

Model/AUE by OU: Shows the same information, but broken out by org unit.

AggregateReportModel_AUE_ByOU_HL.png

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.

AggregateReportDailyActivityHL.png