Skip to main content
Johan van de Werken

Johan van de Werken

— 113 posts published
Website Twitter Netherlands
July 2024

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

— 🔒 GA4 | tutorials
July 2024

Privacy info (consent mode) dimensions & metrics (GA4)

— GA4 | dimensions & metrics
July 2024

#13 - Consent mode in GA4 export, announcing GA4Dataform

— GA4 | newsletter
June 2024

Navigating consent mode in the GA4 BigQuery export

— GA4 | tips & tricks
March 2024

#12 - Exploring BigQuery's new 'group by all' clause & other updates

— GA4 | newsletter
January 2024

#11 - Rising interest in Dataform and BigQuery's cross-cloud query feature

— GA4 | newsletter
January 2024

Which (web) analytics tools provide a raw data export to BigQuery?

— GA4 | alternatives
January 2024

How to create a fully automated BigQuery ecommerce data warehouse with Eyk: get pre-built marketing insights in minutes

— GA4 | tips & tricks
December 2023

#4 - How to create and run your first SQL model on GA4 BigQuery export data in Dataform

— 🔒 GA4 | Dataform
December 2023

#3 - How to point Dataform to your GA4 BigQuery export data source using declarations

— 🔒 GA4 | Dataform
December 2023

#2 - How to create a Dataform development workspace for your GA4 export data SQL workflow

— 🔒 GA4 | Dataform
December 2023

#1 - How to create a Dataform repository for your GA4 export data SQL workflow

— 🔒 GA4 | Dataform
December 2023

How to create and maintain a Dataform powered GA4 export SQL workflow in BigQuery

— GA4 | tips & tricks
November 2023

#10 - Increased data sampling pushes GA4 users towards BigQuery

— GA4 | newsletter
November 2023

#9 - Breaking change: item-scoped custom parameters added to GA4 export schema

— GA4 | newsletter
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)

— 🔒 GA4 | tutorials
October 2023

How to set up the Google Ads data transfer to BigQuery

— GA4 | tips & tricks
October 2023

Unofficial GA4 BigQuery export schema change log (or how to generate your own)

— GA4 | tips & tricks
September 2023

#8 - Google adds example queries for GA4 user-data export

— GA4 | newsletter
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

— GA4 | newsletter
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

— GA4 | newsletter
April 2023

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

— 🔒 GA4 | tutorials
April 2023

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

— GA4 | newsletter
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