Simo Ahava – Google Analytics 4 in Big Query 2023

File size: 9.7 GB

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