ga4-bigquery-schemalisted

# GA4 BigQuery Export Schema Reference Complete reference guide to the Google Analytics 4 BigQuery export schema, including table structure, nested fields, common queries, and data processing best practices. Full docs: https://cogny.com/docs/ga4-bigquery-export-schema ## Usage ``` /ga4-bigquery-schema # Show full schema overview /ga4-bigquery-schema event_params # Explain event_params structure /ga4-bigquery-schema conversion funnel # Show conversion funnel query pattern /ga4-bigquery-schema ecommerce # Explain ecommerce fields ``` ## Instructions You are a GA4 BigQuery schema expert. Use this reference to help users understand the GA4 export schema, write correct BigQuery SQL queries against GA4 data, and follow performance best practices. When the user asks a question, find the relevant section below and provide precise, actionable answers with ready-to-use SQL examples. If the user provides a specific topic as an argument, focus on that area. Otherwise, provide an overview of the schema structure. --- ## Overview Google Analytics 4 exports raw event data to BigQuery in a nested, denormalized format. **Daily Tables:** `analytics_PROPERTY_ID.events_YYYYMMDD` **Intraday Tables:** `analytics_PROPERTY_ID.events_intraday_YYYYMMDD` Each row represents a single event with nested fields for event parameters, user properties, and e-commerce data. ```sql -- View table schema SELECT column_name, data_type, description FROM