Getting Began
Setup the BigQuery atmosphere
Hyperlink Google (*4*) 4 and Google BigQuery
Entry the course dataset
Discover the Google (*4*) 4 export schema
Run your first SQL question
Occasions & Customers
Perceive GA4’s session and person knowledge fashions
Sessionize the occasion knowledge stream in BigQuery
Group knowledge by customers and totally different user-based dimensions
Entry person properties
Learn to unnest knowledge
Find out about question prices (and optimization)
Engagement & Retention
Replicate and customise GA4’s sessionization logic
Use “engagement” as a approach to section knowledge
Construct customized pathing experiences to indicate how customers navigate your web site
Construct complete occasion experiences and occasion funnels
Replicate and customise GA4’s retention mannequin
Combine Google BigQuery with Google Knowledge Studio
Monetization & Lifetime Worth
Discover the ecommerce occasion schema in the GA4 knowledge
Calculate ecommerce metrics
Discover how GA4 makes use of “objects” in ecommerce occasions
Construct a complete objects funnel report
Calculate and visualize the lifetime worth of customers
Superior Queries
Study superior methods for working with Google BigQuery and Google (*4*) 4
Craft your personal idea of an “engaged session”
Mix GA4 knowledge with different public datasets
Flatten the GA4 schema to work with relational databases
And lots of extra…this part is consistently up to date with new content material