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
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.
Every analyst who works with GA4's raw BigQuery export ends up writing the same SQLX sooner or later: sessionise the event stream, resolve users across device and login boundaries, tidy purchase and engagement events into something a stakeholder can actually query. GA4Dataform Community is the fresh answer to that repeated chore, an open-source Dataform package that generates the session, user and event models for you instead of hand-rolling them per client.
Rather than shipping fixed SQLX files, the package generates its session, user and event Dataform models through a JS class layer, so the modelling logic is configurable rather than copy-pasted and re-edited for every new account. It is built and maintained by a named team of GA4 analytics engineers at Superform Labs, Jules Stuifbergen, Krisztián Korpa, Artem Korneev, Simon Breton and Johan van de Werken, and it is the acknowledged successor to the older dataform-ga4-sessions project, which is now deprecated. It is GPL-3.0 licensed, free and open source.
events_* tables.The current release is version 1.19.0, last updated 15 January 2026, with 73 commits and 84 stars on GitHub at time of writing. It replaces the older, deprecated dataform-ga4-sessions project, so if you inherit a client account still running that one, this is the migration target. As with any GPL-3.0 dependency, check the licence terms fit your delivery model before shipping it inside a client-facing product.
More Like This
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.