Skip to main content
Johan van de Werken

Johan van de Werken

— 109 posts published
Website Twitter Netherlands
February 2023

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

— 🔒 GA4 | tutorials
February 2023

How to sync your marketing data with BigQuery using Fivetran's free plan

— GA4 | tips & tricks
January 2023

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

— 🔒 GA4 | tutorials
January 2023

#3 - Relevant blog posts, join the conversation, GA4 bible released

— GA4 | newsletter
January 2023

How to join your CRM and GA4 event data in BigQuery

— 🔒 GA4 | tutorials
January 2023

How to query streaming GA4 export data and combine it with historical data in BigQuery

— GA4 | tips & tricks
January 2023

How to explore GA4 event data with the sample ecommerce data set in BigQuery

— GA4 | tips & tricks
January 2023

How to filter events in your GA4 BigQuery export to avoid exceeding daily 1 million event limit

— GA4 | tips & tricks
January 2023

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

— 🔒 GA4 | tutorials
January 2023

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

— 🔒 GA4 | tutorials
December 2022

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

— 🔒 GA4 | tutorials
December 2022

#2 - SQL query support from ChatGPT, GA4 count approximation demystified

— GA4 | newsletter
December 2022

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

— 🔒 GA4 | tutorials
December 2022

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

— 🔒 GA4 | tutorials
December 2022

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

— 🔒 GA4 | tutorials
December 2022

How to create a pivot table with GA4 data in BigQuery

— GA4 | tips & tricks
November 2022

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

— 🔒 GA4 | tutorials
November 2022

#1 - New website, updated queries, premium tutorials, GA4 x dbt

— GA4 | newsletter
November 2022

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

— 🔒 GA4 | tutorials
July 2022

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

— GA4 | tips & tricks
April 2021

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

— 🔒 GA4 | tutorials
February 2021

Why your BigQuery results don't (exactly) match with Google Analytics reports (GA4)

— GA4 | tips & tricks
February 2021

How to create a session based GA4 traffic acquisition report in BigQuery

— 🔒 GA4 | reports
January 2021

How to create a GA4 user acquisition report in BigQuery

— 🔒 GA4 | reports
January 2021

How to customise the default GA4 engaged session definition in BigQuery

— 🔒 GA4 | tutorials
January 2021

How to query multiple GA4 'events_' tables with '_table_suffix' in BigQuery

— GA4 | tips & tricks
December 2020

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

— 🔒 GA4 | tutorials
December 2020

How to replicate the 'Conversions | (Enhanced) Ecommerce | Shopping behavior' funnel report

— UA | Universal Analytics
December 2020

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

— 🔒 GA4 | tutorials
December 2020

Items dimensions & metrics (GA4)

— GA4 | dimensions & metrics