This mini-course will equip you with the skills and knowledge needed to build your marketing data warehouse. No prior technical experience is required.
In these 3 lessons, you'll learn how to create a robust data warehouse in Google BigQuery without writing complex SQL, visualize your data from the data warehouse in Looker Studio, and use the data-driven insights to improve your marketing campaigns.
Lesson 1. Get started with Google BigQuery
In this lesson, we'll set everything up to build a data warehouse in Google BigQuery:
Use Supermetrics Hub to access to the sources you want to pull data from (Facebook Ads, Google Ads, Google Analytics).
Create a BigQuery dataset and a service account. Connect to BigQuery as a destination for your Supermetrics team.
Set up a test transfer to ensure you can get your marketing data into BigQuery.
Lesson 2. Transform your data in Google BigQuery
In this lesson, we'll learn how to pick the metrics and dimensions you want to transfer to your data warehouse and how to manage the data transfers:
Delete existing tables in BigQuery.
Build a custom table group in your Supermetrics Hub for each data source, selecting the metrics and dimensions you want to transfer to a data warehouse.
Disable and delete existing transfers, schedule and monitor the new transfers.
Lesson 3. Visualize your data in Looker Studio
In this lesson, we'll create a report in Looker Studio to visualize the data in the data warehouse:
Connect the data tables from BigQuery to Looker Studio.
Create the calculated metrics and charts in Looker Studio to finalize the report.
More resources
Now that you know the basics and much more about setting up a data warehouse, you may find the following articles useful: