Videos on BigQuery
This page collects other video courses and presentations previously broadcasted on webinars, conferences and course lectures, about BigQuery and/or digital analytics data.
Check out the following videos for a concise introduction into loading data into BigQuery. These were presented on various different occasions and might have a certain amount of overlap with each other. They're all available for free for GA4BigQuery subscribers.
In case you are looking for the Simmer SQL course with Johan on GA4 data in BigQuery:
Johan van de Werken
The power of Data Transfers in BigQuery
This video describes the most commonly used mechanisms to load data from digital platforms into Google BigQuery; originally aired on MeasureSummit 2024. This includes both some native export mechanisms and the Data Transfer service. Includes a demo on how to set it up a Data Transfer job, and information on the data from the most important platforms to help you get started.
Presentation about the most commonly used data transfers and native exports.
Note that we also have some articles on GA4BigQuery regarding some of these data ingestion mechanisms:
- Google Analytics 4 export (how to set up)
- general introduction
- how to filter events if you have too many
- user tables
- Google Ads data transfer — basic setup
- 🔒 Google Ads data transfer — advanced ways of operation (premium)
- Using Fivetran's free plan to load data into BigQuery
Beyond the Interface: Unleash Google Ads Data Potential with BigQuery and Looker Studio
This was presented as a guest lecture in the 2024 cohort of Looker Studio Masterclass. The presentation focuses on the Google Ads Data Transfer and goes into more detail about how you can find your way around the 109 tables (and another 109 views) and how this data can be queried to produce some useful output. The video is a courtesy of Siavash Kanani, owner and main instructor of the Masterclass.
Creating a Data Warehouse in BigQuery
This is my newest talk, presented on MeasureSummit in 2025. If you have purchased the All-Access Pass, you can watch it on the MeasureU platform, but it is also available for premium GA4BigQuery subscribers.
The video walks through how you can model GA4 data in BigQuery into meaningful entities (tables), and how multiple data sources (such as Google Ads, Facebook and other advertising data, Search Console, CRM data etc) can be integrated to serve various business use cases across sales support, advertising, attribution and SEO. It also talks about some engineering / housekeeping principles that should not be overlooked around organizational ownership, scheduling, and keeping costs at bay.
Data Science and Machine Learning Approaches for E-Commerce
This video is not about BigQuery per se—but it might be interesting if you would like to get a short summary of data science / machine learning / AI approaches relevant to retail and e-commerce companies.
