Analytics & Measurement

A dbt package that turns the raw GA4 BigQuery export into report-ready models for sessions, users, ecommerce and attribution.

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.

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.

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.

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.

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.

A dedicated tutorial site of example SQL and lessons for querying the raw GA4 BigQuery export, with interviews from the dbt/GA4 ecosystem.

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.

Pick metrics, dimensions and a date range in a form, and this free tool generates the matching GA4 BigQuery SQL for you.

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.

The community-gallery GTM template for Google Consent Mode, adjusting tag behaviour from the visitor's recorded consent state.