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.

Let's build together: towards an open-source community-driven dbt package for the GA4 BigQuery export

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

New digital course: unlock advanced insights with Google BigQuery and Google Analytics 4

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

Tutorial: How to deal with string, integer and float event parameter values using the coalesce function (GA4)

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.

Tutorial: How to customise the default engaged session definition (GA4)

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.

Tutorial: How to query multiple 'events_' tables with '_table_suffix' (GA4)

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.