dbt-ga4: the community standard for modelling the GA4 BigQuery export
A dbt package that turns the raw GA4 BigQuery export into report-ready models for sessions, users, ecommerce and attribution.
The Measurement Room
Analytics & Measurement
GA4 BigQuery SQL, tagging utilities and consent-safe measurement patterns, written for people who have to defend the numbers.
GA4 BigQuery starter pack: unnest event_params, count users, rank pages
Three foundation queries for the GA4 BigQuery export: the event_params unnesting pattern, daily users and sessions, and top pages by view, all with a date filter that controls scan cost.
GA4 channel and campaign SQL: session source, medium and conversions from BigQuery
Session-scoped source, medium and campaign reporting from the GA4 BigQuery export, aggregating sessions and conversions per channel, with an honest note on why it will not tie out to the GA4 UI.
GA4 Data-Quality Auditor: the BigQuery checks to run before you trust the numbers
BigQuery SQL that audits your GA4 export for unassigned traffic, missing event parameters, possible PII in page URLs and broken purchase revenue before anyone trusts the dashboard.
GA4 purchase funnel SQL: view_item to purchase with step conversion rates
A BigQuery ecommerce funnel across view_item, add_to_cart, begin_checkout and purchase, counting distinct users per step and the step-to-step drop, using conditional aggregation instead of fragile joins.
The GA4 sample ecommerce dataset: a free BigQuery sandbox for practising SQL
Google's free public BigQuery dataset of obfuscated Merchandise Store GA4 events, the standard sandbox for practising GA4 SQL with no live property and no setup cost.
GA4BigQuery.com: tutorials built specifically for the raw export
A dedicated tutorial site of example SQL and lessons for querying the raw GA4 BigQuery export, with interviews from the dbt/GA4 ecosystem.
GA4Dataform Community: raw GA4 export into clean session and user models
An open-source Dataform package that turns raw GA4 BigQuery export tables into clean session, user and event models, maintained by a team of well-known GA4 analytics engineers.
GA4SQL: a no-code builder for GA4 BigQuery queries
Pick metrics, dimensions and a date range in a form, and this free tool generates the matching GA4 BigQuery SQL for you.
The GTM Community Template Gallery: install before you hand-code a tag
Google's official directory of community-built GTM tag and variable templates, web and server-side, that install straight into a container instead of a hand-coded custom HTML tag.
Simo Ahava's Consent Mode template for Google Tag Manager
The community-gallery GTM template for Google Consent Mode, adjusting tag behaviour from the visitor's recorded consent state.
The Tuesday Briefing
One editor-curated email. The updates that matter, the noise filtered out.
Free. Occasionally includes sponsored messages from our partners. Unsubscribe anytime.