Skip to main content

🔒 GA4 | tutorials

It can be hard to make sense of the data in the GA4 BigQuery export tables. Our premium tutorials show you - step by step - how to utilise Google Analytics 4 data in BigQuery.

— A collection of 21 posts
July 2024

How to fix the major GA4 BigQuery export misattribution (part 3: use the 'session_traffic_source_last_click' record)

October 2023

How to fix the major GA4 BigQuery export misattribution (part 2: join 'gclid' parameter with Google Ads data transfer and get your campaign data right)

September 2023

How to get the GA4 property id from the BigQuery export metadata and join it with your event data

August 2023

Why (and how) to use GA4 event_timestamp with your local time zone instead of event_date in BigQuery

April 2023

How to create a GA4 funnel exploration table with completion and abandonment rates in BigQuery

February 2023

How to build your own GA4 attribution model comparison tool in BigQuery and Looker Studio

February 2023

How to join search queries and SEO metrics with GA4 data in BigQuery

January 2023

How to deal with repetitive chunks of SQL code: let a UDF create your GA4 channel group dimensions in BigQuery

January 2023

How to join your CRM and GA4 event data in BigQuery

January 2023

How to create a GA4 user retention cohort table in BigQuery (and visualise it in Looker Studio)

January 2023

Why the landing page report in GA4 sucks and how to fix it in BigQuery (GA3 style)

December 2022

How to fix the major GA4 BigQuery export misattribution (part 1: overwrite source, medium & campaign when 'gclid' parameter is available)

December 2022

How to sessionize your GA4 event data in BigQuery (part 2: custom session definitions)

December 2022

How to sessionize your GA4 event data in BigQuery (part 1: default 30-minute session timeout definition)

December 2022

How to (back)stitch your custom user id to GA4's client id in BigQuery to enable cross-device analysis

November 2022

How to create a custom user segment based on a sequence of GA4 events in BigQuery

November 2022

How to create a low-cost, lightning fast GA4 Looker Studio dashboard powered by the BigQuery export

April 2021

How to deal with string, integer and float GA4 event parameter values in BigQuery using the coalesce function

January 2021

How to customise the default GA4 engaged session definition in BigQuery

December 2020

How to combine public global weather and GA4 ecommerce data in BigQuery

December 2020

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