What You Get:
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
