Getting Started


Setup the BigQuery environment
Link Google Analytics 4 and Google BigQuery
Access the course dataset
Explore the Google Analytics 4 export schema
Run your first SQL query




Events & Users


Understand GA4’s session and user data models
Sessionize the event data stream in BigQuery
Group data by users and different user-based dimensions
Access user properties
Learn how to unnest data
Learn about query costs (and optimization)




Engagement & Retention


Replicate and customize GA4’s sessionization logic
Use “engagement” as a way to segment data
Build custom pathing reports to show how users navigate your website
Build comprehensive event reports and event funnels
Replicate and customize GA4’s retention model
Integrate Google BigQuery with Google Data Studio




Monetization & Lifetime Value


Explore the ecommerce event schema in the GA4 data
Calculate ecommerce metrics
Explore how GA4 utilizes “items” in ecommerce events
Build a comprehensive items funnel report
Calculate and visualize the lifetime value of users




Advanced Queries


Learn advanced techniques for working with Google BigQuery and Google Analytics 4
Craft your own concept of an “engaged session”
Combine GA4 data with other public datasets
Flatten the GA4 schema to work with relational databases
And many more…this section is constantly updated with new content


Sales Page:
Code:

https://www.teamsimmer.com/checkout/ga4-google-bigquery/bq-course-page/