Skip to main content
Johan van de Werken

Johan van de Werken

— 94 posts published
Website Twitter Netherlands
September 2023

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

— 🔒 GA4 | tutorials
August 2023

#7 - AI-powered SQL code assistance coming to BigQuery Studio

August 2023

How to create a GA4 item / product performance report in BigQuery

— 🔒 GA4 | reports
August 2023

How to set up Google 'Connected' Sheets to access GA4 BigQuery export data without learning SQL

— GA4 | tips & tricks
August 2023

How (and why) to activate the GA4 user activity data export to BigQuery

— GA4 | tips & tricks
August 2023

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

— 🔒 GA4 | tutorials
June 2023

#6 - New fields in GA4 export & SQL query generators

April 2023

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

April 2023

#5 - 90 days to go: are you ready to query your GA4 data?

March 2023

How to create a GA4 tech (device, OS & browser) performance report in BigQuery

— 🔒 GA4 | reports
March 2023

How to create a GA4 page performance report in BigQuery

— 🔒 GA4 | reports
March 2023

How to create a GA4 landing page performance report in BigQuery

— 🔒 GA4 | reports
February 2023

How to create a GA4 ecommerce transactions performance report in BigQuery

— 🔒 GA4 | reports
February 2023

#4 - Search Console introduces BigQuery bulk export

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

— 🔒 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

January 2023

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

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 bug where paid search events and sessions are mistaken for organic or direct traffic

— 🔒 GA4 | tutorials
December 2022

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

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