Five practical examples how to query GA4 data in BigQuery
Tired of paying monthly for a cookie banner? ►► Get my FREE cookie banner here: https://leonkorteweg.com/cookie-banner
Want to analyze your raw Google Analytics 4 (GA4) data in BigQuery but don’t know where to start? In this video, I’ll guide you through where to find your GA4 data in BigQuery, understand the key tables and fields. And I'll cover 5 practical examples how you can get started with GA4 data in BigQuery.
Links mentioned in the video:
- Grow your traffic cheatsheet: https://leonkorteweg.com/cheatsheet
- How to link GA4 to BigQuery:
https://www.youtube.com/watch?v=SgwE4uLmXCI
- All code snippets from the video: https://leonkorteweg.notion.site/YouTube-Introduction-to-BigQuery-code-snippets-196d25df9bf880ee8840e09b654a0615?pvs=4
Chapters:
0:00 Intro
0:30 Welcome
1:09 Where to find your GA4 data in BigQuery
2:49 Exploring the raw GA4 data
9:26 Example 1: Our first query
15:06 Example 2: List of top events
20:51 Example 3: List of top pages
25:00 Example 4: Traffic sources
30:25 Example 5: Research a converted user
34:25 Close
#googleanalytics4 #bigquery #ga4 #digitalanalytics #tutorial #beginners