Getting GA4 data into BigQuery, understanding its schema, querying it effectively, and building analytics infrastructure on top of it.
A step-by-step guide to enabling the GA4 BigQuery export — what to set up in GCP, what to configure in GA4, what you get when it's running, and the decisions that matter before you start.
BigQuery · ReferenceA practical reference for the GA4 BigQuery export schema — what every column contains, how to access nested fields, and the SQL patterns you'll use in almost every query.
BigQuery · Data EngineeringGA4's interface uses modelled, sampled, and processed data. BigQuery exports raw unsampled events. The two will never match exactly — here's the complete explanation.
Supermetrics and BigQuery are not competing tools — they solve different problems. An honest comparison of what each does well, what each costs, and how to choose.
Practical BigQuery SQL patterns for content teams and publishers — article performance, scroll depth, referral sources, return visitor rates, content velocity, and more.
GA4 · Analytics Engineering · BigQueryHow to combine data from multiple GA4 properties to track daily readership, detect record-breaking days, and identify which sites in your network are actually growing.