Set up BigQuery export & 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 customizable 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. Setup 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 you familiarize yourself with the limits of a long-term use of a Sandbox Account.

How to set up a BigQuery project

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

How to set up a BigQuery export 

1. Log into admin.google.com.
2. From the main menu, click Reports.
3. On the left, scroll to “BigQuery Export.”
4. Click the GCP project 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 Looker 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 you created  select Activity.
5. Make sure to check 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 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