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:
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
- Log in to console.cloud.google.com.
- Create a new project.
How to set up a BigQuery export
- Log in to admin.google.com.
- From the main menu, click Reports.
- On the left, scroll to 'BigQuery Export'.
- Click the GCP project that you made in Step 1.
- Create a dataset name.
- 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.
- Sign in to Data Studio.
- On the top left, click Create
Data source.
- Select the BigQuery connector.
- On the left side of the screen, click My projects
- Make sure that you tick the box under 'Partitioned table'.
- Click Connect.
Data source.Optional: Rename your data source to something you can remember.
How to create your Data Studio dashboard
- Open the template.
- On the top right, click Use Template.
- Under 'New Data Source', choose the 'activity' data source that you previously created.
- Click Copy Report to copy this template into your own Data Studio environment.