This post will explain the differences between what is stored in the intraday table and the processed table – when consent is not yet granted at the beginning of the visit
Smart incremental GA4 tables in Dataform
Race conditions, Murphy’s Law, and assumptions – a story on why my models suddenly failed, and what I did about it to fix it.
Prepare your cloud project for “Bulk data export” Google Search Console
In this post I’ll give you a script to create and prepare your Cloud Project for the bulk data export feature
Using Big Query to calculate DAU / MAU
This post shows you how to calculate unique Daily Users per Monthly Users. Or: DAU/MAU – a measure of stickyness.
It uses GA4 data and BigQuery SQL