Now that you have your ad platform or social data transfered into BigQuery, the next steps are to visualize it for reporting. To help with this, Supermetrics has created a Data Studio connector that can connect to your BigQuery 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 even 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.
IMPORTANT - Queries using this connector will cost BigQuery credits.
- You can find the Supermetrics for BigQuery Data Studio connector here. (As it's still beta, there may be a warning it hasn't been reviewed by Google yet.)
- When the connector opens, click Authorize and log in with your Google account that is also connected to the BigQuery project that you wish to access. Follow the prompts to allow access.
- When the authorization is successful, you can now select a data set to use from the drop-down:
- Click CONNECT in the upper-right corner to continue with the setup. Depending on the size of the dataset, it may take a few moments to load.
- You will now see the the field list. This contains all fields in your dataset tables, as well as special combination fields that will pull data for all tables with that field name. Very useful to blend data from different sources or your even own custom tables!
- Basic date dimensions are included in the field set
- Common calculations (CTR, CPC, etc.) are included
- Each field should note which source and table it came from - for example, "CTR (Bing Ads ad)" is sourced from the Bing Ads "AD" table:
- 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 "AD"s
- Click CREATE REPORT to continue.
- Below are a couple of example queries showing what the connector can do:
Basic query for Facebook campaign and cost:
Using the (*ad) join fields to get data from both Microsoft Advertising (formerly Bing Ads) and Facebook Ads, along with a Facebook-specific conversion, for easy data blending: