Free Download Simo Ahava – Google Analytics 4 in Big Query Download 2023
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)
  

• 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
  

• 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
  

• 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
  

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