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.

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.

Tutorial: How to combine public global weather and Google Analytics data in BigQuery (GA4)

In this tutorial I will show you - step by step - how to combine weather data from the public BigQuery 'noaa_gsod' set with your own Google Analytics 4 data.

Tutorial: How to flatten the GA4 BigQuery export schema for usage in relational databases

In this tutorial I will show you - step by step - how to flatten the Google Analytics 4 export schema with the purpose of using the data in a relational database outside of BigQuery.