This guide will show you how to connect your BigQuery data to Data Studio, to easily visualize your data for reporting.
Once you have your data transferred into BigQuery, the next step is to visualize it for reporting. With the Supermetrics BigQuery connector you can easily connect to your datasets and fetch your results directly into Data Studio. We offer this as part of your Supermetrics for Big Query license or trial account.
This connector offers more flexibility than the Google BigQuery connector as it can fetch and combine data from multiple tables. It can also work with data tables not from Supermetrics, as long as the fields are named appropriately.
This guide will show you how to set up a basic query in Data Studio using this connector to demonstrate how it works.
Please note that queries using this connector will cost BigQuery credits.
Connecting your BigQuery data to Data Studio
1. Go to Google Data Studio at datastudio.google.com.
2. In the top left corner, click on Create → Data source to create a new data source file
3. Search for "Google BigQuery" to find the Supermetrics connector in the Partner Connectors section. You can also access the Supermetrics for BigQuery connector directly through this link.
4. On the connector page, click on AUTHORIZE to give permission to the connector to access your Google account.
- A pop-up will ask you to log in with your Google account – select the same account you used with the BigQuery project you wish to access, and click on Allow to accept the access request.
5. Select the BigQuery dataset and the Field list type among:
- Full field list - shows all columns from your tables in BigQuery.
- Simplified field list - shows each unique field name just once, if it's present in multiple tables.
- Simplified list with join fields only - shows only the fields that are available for multiple data sources.
Click on CONNECT to create the data source file.
- Depending on the size of the dataset, it may take a few moments to load.
6. You will be taken to the field list, where you can see all available fields from your dataset tables, as well as special combination fields that will pull data for all tables with that field name – this is especially useful for blending data from different sources, or even your own custom tables.
- Note that you can rename the data source file here, if you're planning on creating multiple data source files from different BigQuery datasets.
Click on CREATE REPORT to start using the data in a new Data Studio report.
- Basic date dimensions and common calculations such as CTR, CPC etc. are included in the field set.
- Each field should note which source and table it came from – for example, Action type (Facebook Ads conversion) is sourced from the FBADS_CONVERSION table in BigQuery:
- There can also be combination fields, marked in their name with an asterisk - for example, CTR (* ad) is sourced from all tables that are for ADs. These can be used once you have created transfers for multiple data sources to the same BigQuery dataset, and connected that dataset to Data Studio.
Simple chart setup with Facebook Ads: Campaign as the dimension, and Impressions and Amount spent as the metrics.
Chart setup blending ad data from Facebook, Microsoft and LinkedIn Ads, all of which are transferred to the same dataset in BigQuery. Using the * ad join fields, we can easily compare the performance of our advertising campaigns across different advertising platforms.