Set up BigQuery export and Data Studio template

Important: BigQuery logs and Data Studio are only available for Workspace for Education Plus users.

Activity logs in BigQuery let admins view usage and adoption reports with customisable Data Studio templates.

If BigQuery Export of your audit logs isn't configured from your admin console, set it up first. Check if BigQuery is enabled on your admin console.

If this isn't configured yet:

1. Set up a BigQuery project for reporting logs.
2. Set up service log exports to BigQuery.

Optional: Use BigQuery Export without a billing account.

You can enable the BigQuery Export feature without a billing account set up on Google Cloud Console. If you don't have a billing account set up, you'll have a sandbox account created. While it's sufficient for testing purposes, we recommend that you familiarise yourself with the limits of the long-term use of a sandbox account.

How to set up a BigQuery project

1. Log in to console.cloud.google.com.
2. Create a new project.

How to set up a BigQuery export

1. Log in to admin.google.com.
2. From the main menu, click Reports.
3. On the left, scroll to 'BigQuery Export'.
4. Click the GCP project that you made in Step 1.
5. Create a dataset name.
6. Click Save

How to create a data source in Data Studio for my activity BigQuery Export table

Follow the steps to add your Big Query activity table as a data source. Learn more about Google BigQuery.

1. Sign in to Data Studio.
2. On the top left, click Create   Data source.
3. Select the BigQuery connector.
4. On the left side of the screen, click My projects  The project and dataset that you created  select Activity.
5. Make sure that you tick the box under 'Partitioned table'.
6. Click Connect.

Optional: Rename your data source to something you can remember.

How to create your Data Studio dashboard

1. Open the template.
2. On the top right, click Use Template.
3. Under 'New Data Source', choose the 'activity' data source that you previously created.
4. Click Copy Report to copy this template into your own Data Studio environment.

Learn how to share your report with others.

Related resources

View classroom usage reports