← All articles

Analytics · 11 min read · 2026-06-18

GA4's BigQuery Export Problem: What It Means for SaaS

On June 16, 2026, Decode Data announced that its Decode GA4 utility had reached general availability on Google Marketplace, a BigQuery-native tool that, in the company's framing, solves the "GA4 BigQuery Export Problem after years of custom pipelines and SQL workarounds." You can read the announcement on Yahoo Finance. The specific product matters less than what its existence signals: cleaning GA4's raw export, once a multi-week data-engineering project, is becoming something you buy off a marketplace. For SaaS teams that have quietly poured engineering hours into this plumbing, that is a meaningful shift in where your effort should go.

What the "export problem" actually is

GA4's BigQuery export is genuinely powerful — it gives you raw, event-level data with no sampling, which is exactly what a product team wants. The catch is the shape it arrives in. Each row is a single event, and the interesting details — which button, which plan, which experiment variant — are buried inside nested, repeated event_params records that you have to UNNEST to read. There is no session table, no user-journey table, and certainly no funnel table. The export hands you the raw ingredients and none of the meal.

For a SaaS analytics team, that means even a routine question carries a hidden tax. "What is our signup-to-activation rate by acquisition channel, by week?" requires rebuilding sessions from event timestamps, defining what activation means in SQL, stitching events into ordered journeys, and handling late-arriving and duplicate hits. Every team that has done this has written more or less the same few hundred lines of recursive query logic, and then spent the following year maintaining it as GA4's schema shifted underneath them. It is undifferentiated work that nonetheless eats real engineering capacity.

Why this work is being commoditized now

The reason a tool like this can reach general availability in 2026 is that the GA4 export schema, for all its awkwardness, is stable and identical across every property. That makes the cleanup a perfect candidate for commoditization: the unnesting, sessionization, and deduplication logic is the same for a two-person startup as it is for an enterprise, so it makes no sense for each team to build and maintain it privately. When the same boilerplate is being written thousands of times across the industry, a packaged layer that does it once is inevitable.

This mirrors a broader pattern in the analytics stack: the move toward warehouse-native tooling, where the warehouse is the source of truth and thin layers sit on top of it rather than separate data silos. The practical effect for a SaaS team is that the boundary between "data engineering" and "analytics" keeps moving. The plumbing below the line is becoming a utility you rent; the modeling above the line is where your actual product understanding lives. Knowing where that line sits — and refusing to spend scarce engineering time below it — is the strategic takeaway from this release.

What to own versus what to outsource

Draw a sharp line. Below it sits the undifferentiated plumbing: flattening nested events, rebuilding sessions, deduplicating hits, keeping pace with GA4 schema changes. This is exactly the work a commodity export-cleaning layer should absorb, because doing it in-house buys you nothing your competitors do not also have. There is no proprietary advantage in unnesting event_params correctly; there is only cost and maintenance risk.

Above the line sits everything that encodes how your business actually works: the precise definition of an activated user, the stages of your signup funnel, the cohorts you measure retention against, and the metric definitions your board deck depends on. This is the layer you should keep in version control, review like code, and never let drift into an opaque reporting tool. The same discipline we argue for in GA4 event setup discipline for investor-grade metrics applies here: clean inputs and explicit definitions are what make any downstream number trustworthy. Outsource the schema; own the semantics.

A clean export is a foundation, not a finished stack

It is worth resisting the temptation to read this as "GA4 is now a great product analytics tool." A tidy BigQuery export removes one real obstacle, but it leaves the structural ones untouched. The data is still shaped by consent — visitors who decline tracking simply are not in the export, so the cleanest possible table is still modeling a partial population. And the raw event stream still has to be turned into product concepts; a warehouse full of well-structured events is not the same as understanding why users activate or churn.

This is the same distinction we draw in product analytics versus web analytics for SaaS: moving data efficiently is not the same as answering product questions. A commoditized export layer is genuinely useful because it lets your team spend its hours on the modeling and interpretation that do require judgment, rather than on pipeline maintenance. But the value is realized only if you actually redirect the freed-up time toward better definitions and analysis, instead of treating the clean table as the finish line.

Where privacy-first measurement still has the edge

The export-cleaning shift also clarifies why a first-party, privacy-first pipeline can beat bolting tools onto GA4's raw schema. When you collect events directly into your own infrastructure, you control the schema from the start — events arrive already shaped around your product concepts, with consistent naming and the properties you care about, rather than needing a translation layer to recover meaning that GA4 flattened away. You are not paying a tool to undo a structure you never wanted; you defined the right structure at the point of collection.

First-party collection also sidesteps the population gap. A consent-aware first-party setup can measure aggregate product usage without the third-party cookie dependencies that hollow out GA4's coverage, which is the same argument we make in cookieless analytics for accurate SaaS acquisition data. The lesson from the Decode GA4 release is not "GA4 is fixed" — it is that the parts of the stack with no proprietary value are being commoditized, which makes it clearer than ever that the durable investment is owning your event schema and metric definitions, wherever the data physically lands.

A practical checklist for this quarter

Start with an honest audit: how many engineering hours, per month, go into maintaining GA4-to-warehouse plumbing — the unnesting jobs, the sessionization logic, the breakages every time GA4 nudges its schema? If the answer is more than trivial, you have a candidate for a commodity layer, and the time it frees is the real return. Quantify it before you buy anything, so you are deciding on evidence rather than on a vendor's framing of a problem.

Then do the part no tool can do for you: move your activation, funnel, and retention definitions into versioned models that sit on top of the cleaned tables, documented and reviewed like any other code. Make the definition of an activated user something a new hire can read in a repo, not something locked in a dashboard's configuration. The teams that win in 2026 are not the ones with the cleverest UNNEST queries — that work is now a commodity — but the ones whose metric definitions are explicit, auditable, and built on a first-party foundation they actually control.

FAQ

What is the GA4 BigQuery export problem?

GA4 can stream raw event data into BigQuery, but it lands in a deeply nested, one-row-per-event schema with event parameters buried in repeated records, no clean sessionization, and no ready-made funnel or retention tables. To answer a basic question like 'what is our signup-to-activation conversion rate by week,' a SaaS team has to write recursive UNNEST queries, rebuild sessions, and define funnels from scratch. That gap between the raw export and an analysis-ready table is the export problem, and for years teams solved it with bespoke SQL and dbt pipelines.

What changed in June 2026?

On June 16, 2026, Decode Data announced that its Decode GA4 utility reached general availability on Google Marketplace, a BigQuery-native tool that transforms raw GA4 export tables into analysis-ready models. The significance is not the specific vendor; it is that cleaning the GA4 export — once a custom data-engineering project — is becoming a commodity you can buy. That shifts where SaaS analytics teams should spend their scarce engineering time.

Should SaaS teams still build their own GA4 pipeline?

The plumbing — unnesting events, rebuilding sessions, deduplicating hits — is increasingly not worth building by hand, because it is undifferentiated and now commoditized. What is worth owning is the modeling layer above it: your activation definition, your funnel stages, your retention cohorts, and the metric definitions investors and your own team rely on. Outsource the schema cleanup; keep the business logic in version control where you control it.

Does this make GA4 a good product analytics tool for SaaS?

It lowers the cost of getting GA4 data into a warehouse, but it does not change GA4's structural limits: consent-driven gaps, modeling on raw event streams, and a reporting UI built for marketers rather than product teams. A clean BigQuery export is a foundation, not a finished product analytics stack. The teams that benefit most are the ones that pair the cleaned export with a disciplined first-party event schema and clear metric definitions.

What should a SaaS team do this quarter?

Audit how much engineering time currently goes into maintaining GA4-to-warehouse plumbing. If it is more than trivial, evaluate whether a commodity export-cleaning layer frees that time for modeling work that actually differentiates you. Then move your activation, funnel, and retention definitions into versioned models on top of the cleaned tables, so the logic is auditable and reproducible rather than trapped in a reporting tool.