Johan van de Werken

In this tutorial I will show you how to create a user segment based on a sequence of GA4 events in BigQuery. And how to combine this with other conditions, such as time constraints between events.

In this tutorial I will show you how to create a light-weight 'extract' table on top of the raw data that we can use as a data source for our GA4 Looker Studio dashboard.

Although it can be great fun to explore your GA4 data in BigQuery, it can also be frustrating to have the feeling that you are reinventing the wheel. As you probably noticed by

This course, called Query GA4 Data In Google BigQuery, is designed for marketing professionals who want to dive into the world of SQL queries, and for data professionals who need to skill up on GA4-specific knowledge.