Play Video

Query GA4 Data In Google BigQuery

Unlock advanced insights with Google BigQuery and Google Analytics 4.

Unlock advanced insights with Google BigQuery and Google Analytics 4

Query GA4 Data In Google BigQuery is a comprehensive zero-to-hero course designed to teach you everything you need to know about raw data access, query, and analysis. Enroll now to learn how to become more skilled, more curious, and more adventurous with data!

About this course

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.

What you'll learn

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.

Course overview

  1. Setup the BigQuery environment
  2. Link Google Analytics 4 and Google BigQuery
  3. Access the course dataset
  4. Explore the Google Analytics 4 export schema
  5. Run your first SQL query
  1. Understand GA4’s session and user data models
  2. Sessionize the event data stream in BigQuery
  3. Group data by users and different user-based dimensions
  4. Access user properties
  5. Learn how to unnest data
  6. Learn about query costs (and optimization)
  1. Replicate and customize GA4’s sessionization logic
  2. Use “engagement” as a way to segment data
  3. Build custom pathing reports to show how users navigate your website
  4. Build comprehensive event reports and event funnels
  5. Replicate and customize GA4’s retention model
  6. Integrate Google BigQuery with Google Data Studio
  1. Explore the ecommerce event schema in the GA4 data
  2. Calculate ecommerce metrics
  3. Explore how GA4 utilizes “items” in ecommerce events
  4. Build a comprehensive items funnel report
  5. Calculate and visualize the lifetime value of users
  1. Learn advanced techniques for working with Google BigQuery and Google Analytics 4
  2. Craft your own concept of an “engaged session”
  3. Combine GA4 data with other public datasets
  4. Flatten the GA4 schema to work with relational databases
  5. And many more… this section is constantly updated with new content!

Is this course a good fit for me?

You work in an organization where GA4 is the leading web and app analytics tool

You want to leverage GA4 data outside of the GA user interface, to join and enrich it with other marketing, CRM and contextual data

You want to learn SQL in a meaningful way in the context of relevant marketing use cases

You want to perform advanced analysis on your GA4 data

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

You want to visualize your GA4 data in tools like Data Studio, Tableau, Looker, or PowerBI

You are not interested in the SQL programming language

You believe that the Google Analytics 4 user interface is enough for your data analysis needs

You do not want to or your organization prevents you from accessing the Google Cloud Platform

Task-based, bite-sized, self-paced lessons

The course is self-paced, and you can take it at your own leisure. The individual topics always contain text content to help flesh out the concepts. There are illustrations, links, and tips to help you understand more about the topic.

The text content frequently contains tooltips that point to entries in a glossary. There’s a lot of domain terminology introduced in this course, so the tooltips are almost essential.

Quizzes, certificate, and lifetime access

At the end of each section there will be a smaller quiz to test your progress. After the last section, there will be a final quiz, which tests you on everything learned during the course.

Once you complete all course content, you will receive a certificate, which you can proudly share on social media and in your professional profiles.

As with all Simmer courses, you’ll receive lifetime access to the content and the Simmer Community upon enrollment.

Success Stories

What students are saying

"I'm a complete beginner to BigQuery and this course was the perfect introduction to get me started."

“This course gave me a great understanding of how GA4 data works in BigQuery, so I can’t wait to start exploring this for our clients.

I loved the way the lessons were bite-size, making it easy to digest each concept and also make you feel like you were continuously progressing. Each bite-size lesson builds on the next until you have all the building blocks needed to design any query you might need for your analysis.

I’d highly recommend this course for anyone interested in exploring GA4 data in BigQuery.”

Meet Your Expert Instructor

Hi, I'm Johan van de Werken

Johan van de Werken

We are honored to train employees from companies such as these

Frequently Asked Questions

If you watch the videos at normal speed and read everything there is to read, you will get through all the content in roughly 10 hours.

Once you enroll, you will get your Simmer login credentials that will let you access the course content. Shortly after, you’ll receive an email with your onboarding package. If you provided the information at checkout, you will also receive access to the course dataset

You’ll also receive an invite to the Simmer Community and lifetime access to everything listed above.

Just that. Unless you specifically ask us to, we will not remove your access to the course content or to the Simmer Community.

You will also stay on the course email list, which we will never, ever use for marketing purposes. It is solely for distributing useful information about the course.

Nothing. Nada. Zilch. This course is designed to teach you everything you need to know. 

If you do want to get your feet wet, we recommend you take the Mode Analytics SQL Tutorial. It’s not BigQuery-specific, but it’s an excellent (and free!) resource for learning about SQL.

The more the better. This is not a Google Analytics 4 course. We will simply be using Google Analytics 4 as the dataset we’ll run our queries against.

While you can certainly learn BigQuery (and SQL) thoroughly without knowing anything about GA4, it might help to take some courses (see this or this) in case you want to understand the world of GA4 better.

We offer a full refund, no questions asked, if you request it within 30 days of your purchase and if you’ve got 100% completion of the course content. We really want you to give it your best shot – we are absolutely positive that you will find the course useful and the learning curve manageable.

Start learning

Query GA4 Data In Google BigQuery

Hide picture