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.
GA4 | tutorials
It can be hard to make sense of the data in the GA4 BigQuery export tables. Our tutorials show you - step by step - how to utilise Google Analytics 4 data in BigQuery.
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.
In this tutorial I will show you - step by step - how to use the SQL coalesce function to collect the event_params values from multiple columns with different data types.
In this tutorial I will show you - step by step - how to replicate the engaged session definition in GA4, so you can customise it at will.
Every day of Google Analytics 4 data in BigQuery is stored in a separate table. Learn how to query multiple days at once using static or dynamic dates.