ga4-bigquery

Export GA4 data to BigQuery by linking your GA4 property to a BigQuery project, selecting daily or streaming export mode, and configuring the dataset. This creates events_*, user, and ecommerce tables containing raw, event-level data accessible via SQL queries beyond GA4 UI limitations.

Use UNNEST to flatten nested and repeated fields in GA4 events tables, enabling analysis of event parameters, user properties, and ecommerce details. This approach optimizes performance for complex queries on event-level schemas.

Yes. GA4 BigQuery exports provide raw event-level data structured for building custom attribution models, ML-ready datasets, and performance-optimized reports. You query multiple projects and apply advanced transformations directly on exported tables.

Yes. GA4 BigQuery export requires a Google Cloud project with BigQuery enabled. You link your GA4 property to this project, configure a dataset for exports, and depend on google-cloud-bigquery to manage data connections and queries.

Daily exports batch-load GA4 data once per day into events tables, while streaming exports (GA4 360 only) ingest data in near-real-time. Choose based on your latency requirements and whether you have GA4 360 access.

Apply performance best practices for nested data: partition queries by date, filter on event tables early, use UNNEST efficiently, and leverage BigQuery's query optimizer. The Skill documents SQL patterns and techniques for handling complex analytics at scale.