Blog
Field notes on GA4, BigQuery, and modern analytics.
Perspectives from the engineers building Decode Data. On the data structures we wrestle with, the patterns that emerge, and what comes next.
2 articles
Setting your GA4 data free: export to GCS, S3, or Azure
GA4 data doesn't have to live in BigQuery forever. Here's how to export clean, flat, hive-partitioned Parquet to Google Cloud Storage, Amazon S3, or Azure Blob — and read it from whatever sits downstream.
Read article → The GA4 BigQuery export problem
Every GA4 query in BigQuery needs a correlated subquery per field. We got tired of writing the same painful SQL and built something to make it stop.
Read article →