ga4-bigquery

Export GA4 event data to BigQuery and query nested fields with SQL.

77|9|Updated Oct 10, 2025

Search Tags:#sql #bigquery #data-export #ga4 #nested-fields

Ready to run

npx skills add https://github.com/henkisdabro/claudecode-marketplace --skill ga4-bigquery

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: ga4-bigquery
Source: https://github.com/henkisdabro/claudecode-marketplace/tree/main/ga-suite/skills/ga4-bigquery
Command: npx skills add https://github.com/henkisdabro/claudecode-marketplace --skill ga4-bigquery

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires google-cloud-bigquery, and includes references (resource) components.

What problem does it solve?

This Skill provides a complete guide to GA4 BigQuery export, including setup, schema basics, SQL patterns, and performance tips, enabling advanced analysis beyond GA4 UI limits.

Core Features & Use Cases

Export Setup: Link GA4 to BigQuery with daily or streaming exports (360).
Schema & Queries: Understand events*, user, and ecommerce tables; practical SQL patterns.
Performance & Optimization: Best practices for nested data and UNNEST usage.

Quick Start

Link GA4 to a BigQuery project, create a dataset, and run a basic query to count purchases by date.

Frequently Asked Questions about ga4-bigquery

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I export GA4 data to BigQuery for advanced analysis?▼

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.

What SQL patterns work best for analyzing nested GA4 event data in BigQuery?▼

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.

Can I build custom attribution models and ML datasets from GA4 BigQuery exports?▼

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.

Do I need a Google Cloud project to use GA4 BigQuery export?▼

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.

What's the difference between daily and streaming GA4 exports to BigQuery?▼

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.

How do I optimize performance when querying large GA4 BigQuery datasets?▼

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.