How to Query GA4 Data in BigQuery (sample SQL queries included)

Learn how to query your Google Analytics 4 data with BigQuery and SQL.
In this video, you'll learn the basics of BigQuery and how it works in the context of GA4. You'll see how to use a very simple query to access your raw data, how to write an intermediate query to use GROUP BY to check your session and pageview data, and how to write a complex query that will help you analyze your average scroll depth across pages using custom event data.
Our guest instructor is Sam Brand, ex product manager at Stack Overflow, Slader, and Papa, a product management and analytics expert.
This video won't teach you all you need to know about SQL (far from it), but will give you some practical examples that you can test out if you're looking to learn SQL to query your GA4 data in BigQuery.
You can find the SQL examples in this video here: www.rootandbranchgroup.com/bi...
Feel free to copy and paste and test them out on your own.
You can get more of Sam's perspective on SQL and BigQuery at www.samthebrand.com/ and you can find him at / samuelbrand .
Sam supports healthy bird ecosystem and any ad revenue from this video is being donated to the American Bird Conservancy: abcbirds.org/
Root and Branch offers free digital marketing training and tips focused on Google Analytics, Google Ads, Google Tag Manager, and SEO.

[@michaelroberts5160]

Thank you for this demo of SQL.

[@rooted-digital]

Thanks for coming by, Michael! If you’re keen to do more SQL type stuff, Sam’s site is here -> www.samthebrand.com
Best wishes!
- Zack