How to build a marketing data warehouse with Supermetrics & Google BigQuery
Are you using spreadsheets to report on your marketing? Are all your results and reports spread across multiple silos? Is your reporting becoming too time-consuming?
If yes to any of these, you might want to build a marketing data warehouse.
In this webinar, we go through the basics of BigQuery and how to get started with data transfers.
Navigate this video:
Intro: 00:00-03:44
What is a modern marketing data warehouse: 03:46-05:12
Data warehouse vs. Data lake: 05:13-08:11
Why do you need a marketing data warehouse: 08:12-12:23
Cloud vs. On-premise data warehouse: 12:25-13:32
Two use cases for marketing data warehouse: 13:33-15:43
How to build a marketing data warehouse: 15:45-20:16
Simple schema examples: 20:17-23:02
Introduction to BigQuery: 23:03-34:23
How to load data into BigQuery and build a report in Looker Studio: 34:24: 57:31
Useful resources: 57:36-59:56
Check out Supermetrics for BigQuery: https://supermetrics.com/products/big...
Learn how to build a marketing data warehouse: https://supermetrics.com/blog/marketi...
This webinar was recorded on May 15, 2020.