“This course is available and delivery within a few hours!” If you want to store your GA4 data in BigQuery (Google Cloud) and/or send it to your data warehouse in other cloud services like AWS, Azure, or Snowflake, this course is for you.
Simo Ahava – Google Analytics 4 in Big Query
What students are saying…
I can’t think of a better teacher to learn BigQuery from than Johan van de Werken. As a daily user of his site – GA4BigQuery.com – I can attest to his expertise of Google Analytics data in BigQuery and his willingness to help others learn. This is the training course I wish existed when I was learning BigQuery.
Welcome to our zero-to-hero course in Google BigQuery. This course will teach you all you need to know about SQL and Google BigQuery, and you’re going to use the popular Google Analytics 4 data export as the basis for your explorations.
Google BigQuery is a data warehouse solution running on the Google Cloud Platform. But it’s not just for storing data – as its name implies, BigQuery is all about querying the data in order to answer your most burning analytics questions. Once you get the hang of it, you’ll prefer it to anything that the analytics platforms themselves offer natively in their user interfaces!
We designed this course to cater to a number of different student profiles. The course has a linear ramp-up progression, beginning with very straightforward introductory lessons, before diving into the different aspects of BigQuery using real-world data and real-world use cases.
If you work in an organization where GA4 is the leading web and app analytics tool, this course is for you.
If you want to leverage GA4 data outside of the GA user interface, to join and enrich it with other marketing, CRM and contextual data, this course is for you.
If you want to learn SQL in a meaningful way in the context of relevant marketing use cases, this course is for you.
If you want to perform advanced analysis on your GA4 data, this course is for you.
If you want to store your GA4 data in BigQuery (Google Cloud) and/or send it to your data warehouse in other cloud services like AWS, Azure, or Snowflake, this course is for you.
If you want to visualize your GA4 data in tools like Data Studio, Tableau, Looker, or PowerBI, this course is for you.
The course comprises bite-sized, task-based video lessons, plenty of supportive materials and text content, quizzes to test your knowledge, and LIFETIME ACCESS to the material.
The course curriculum includes…
The course comprises five sections, with 70+ videos, and a total running time of 7+ hours.
1. 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
2. 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)
3. 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
4. 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
5. 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
—————
“NOTE: The content above has been rewritten by our library.”
“To read more original content please visit here. Powered by Simo Ahava.”
Course Features
- Lectures 0
- Quizzes 0
- Duration 10 weeks
- Skill level All levels
- Language English
- Students 52
- Assessments Yes
