Reports/Canned Reports

Follow

Contents

By utilizing this feature, you will be able to gain visibility into how well your domain is using and integrating with G Suite and receive metrics on everything from security to user adoption. With the new scheduled reporting you will be able to regularly receive these reports for constant updates on your domain metrics.

For clarification on the terms used in the Reports check out the Reports Glossary.

Canned Reports

The Reports page includes a number of Canned Reports, providing commonly requested information on Users, Groups, OUs, and Drive.

To run a Canned Report:

  1. Click on the play button next to the report you would like to run.Screen_Shot_2019-06-11_at_11.48.50_AM.png
  2. Click the auto-generated report link. Screen_Shot_2019-06-11_at_11.53.41_AM.png
  3. The generated report will open in a new browser tab and will be stored in your Google Drive for easy access. Screen_Shot_2019-06-11_at_11.56.11_AM.png
  4. If you'd like, use formulas or filtering options available in Google Spreadsheets to further modify your data and return more targeted results.
Screen_Shot_2019-06-11_at_12.07.26_PM.png

Report Builder

To create a custom report:

  1. Click on "Build a Report"Screen_Shot_2019-06-11_at_12.12.26_PM.png
  2. Choose from the 6 report types across the top (Users, Groups, Group Membership, Org Units, Drive, Drive Policies), select as many columns and filters as you'd like.Screen_Shot_2019-06-11_at_12.19.09_PM.png
  3. To save this report, in order to run it at another time, click "Save", name your report, and the report will be saved under "My Reports" and nested by type.Screen_Shot_2019-06-11_at_12.22.37_PM.png
  4. Once the report is tailored to your needs, click "Run Report", then click the generated link to display the report in Google Sheets. From this screen, you also have the options to save your report, and schedule it to run automatically at a future date.Screen_Recording_2019-06-11_at_12.23_PM.gif

Reports Glossary

Building your own report can be confusing with over 100 different types of filters and columns for organizing the data across 6 different types of Reports.

Take a look at the Reports Glossary to get a little clarification on what each term is referring to so you can get the most of your Reports!

Schedule Reports

Scheduling a report will enable the report to run automatically on regular time intervals to give you a updates on your domain

  1. Click the calendar icon next to the report you would like to schedule. Screen_Shot_2019-06-11_at_12.28.11_PM.png
  2. Select the name, frequency, and run time of the report as well as which users you would like to receive the reportScreen_Shot_2019-06-11_at_12.29.00_PM.png
  3. Click to receive the report upon the first run time according to the schedule or click to receive the first report now and have it run on its regular schedule.

Requirements

Ensure that you have the proper Admin Console settings by navigating to Apps > G Suite > Drive and Docs > Settings for Drive and Docs > Sharing Settings, and checking that "users can share document outside this organization":

Screen_Shot_2019-06-11_at_12.31.20_PM.png

You will also need to enable the setting that allow users to install Google Drive apps, to allow BetterCloud to add and modify spreadsheets in Drive. This setting is found by going to Apps > G Suite > Drive and Docs > Settings for Drive and Docs > Features and Applications and selecting "Allow users to install Google Docs add-ons from add-ons store":

Screen_Shot_2019-06-11_at_12.39.31_PM.png

 

Was this article helpful?
1 out of 2 found this helpful
Have more questions? Submit a request