Org unit reports

Org Unit reports can be created or refreshed from the Chrome Gopher sidebar.  OU 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.  

Screen_Shot_2017-05-03_at_1.24.19_PM.png Screen_Shot_2017-05-03_at_1.25.15_PM.png

 

Screen_Shot_2017-05-03_at_1.28.16_PM.png

Setting up auto-refreshing reports on a Sheet and sharing the doc with view rights can be a great way to provide dashboards to non-IT-admin stakeholders like principals, superintendents, and technology integrators.  By constraining the report to a specific parent OU, like a school for example, you can provide just the information a school principal or site-based coach might need.

Feeling ambitious? With a fairly minor lift, you can always take this dashboard concept to the next level by building Charts in Sheets, embedding Charts in a Google Doc or Site, or using a free tool like Google Data Studio to build your graphs and linking it to your self-refreshing spreadsheet.

Below is the data that's provided in an OU report:

Screen_Shot_2017-05-03_at_3.13.38_PM.png