Cherry Seed

Should I use GA4 BigQuery export or direct export?

ga4 bigquery export direct bigquery export woocommerce bigquery bigquery streaming ga4 nested schema server-side export real-time analytics

Quick Answer

Use both if your stack supports it, but direct export solves the problems GA4 export creates. GA4 BigQuery export sends data in Google's nested schema with a one-million-event daily cap and batch processing delays up to 24 hours. Direct export through a server-side plugin streams events in real time using your own schema, with no event limits and no data modelling applied by Google. Most WooCommerce stores get more actionable data faster through the direct pipeline, while keeping GA4 export as a secondary reference layer.

Full Answer

GA4 BigQuery export is a built-in feature that copies your Google Analytics data into BigQuery tables. It sounds convenient, but the implementation comes with structural constraints that matter for WooCommerce stores. The data arrives in a deeply nested schema that requires UNNEST queries for even simple questions. Events are batched — daily exports for free GA4, streaming only for GA4 360 customers paying fifty thousand dollars a year. And there is a hard ceiling of one million events per day before data starts being sampled or dropped.

Direct export takes a fundamentally different approach. A server-side plugin captures events at the source — your WordPress application layer — and streams them into BigQuery in real time using a flat, readable schema you control. There is no event limit, no sampling, and no 24-hour delay. Every page view, add-to-cart, and purchase lands in BigQuery within seconds, structured exactly how your queries need it.

The practical difference shows up in three areas. First, timeliness: direct export gives you live data for dashboards and alerting. Second, completeness: consent-blocked or ad-blocker-dropped sessions that never reach GA4 still fire server-side events. Third, queryability: a flat schema means simple SQL instead of nested UNNEST chains. Run both if you want GA4 as a reference, but build your analytics and AI workflows on the direct pipeline.

Sources

Programmatic Access

GET https://seresa.io/wp-json/cherry-tree-by-seresa/v1/seeds/801

Cite This Answer

Cherry Tree by Seresa - https://seresa.io/seed/wordpress-woocommerce/woocommerce-bigquery-bigquery-export-ga4