Table of Contents
- 1. Why GA4 Raw BigQuery Exports Are Non-Negotiable in 2026
- 2. Architectural Teardown: GA4 Event Schema & Nested Array Structures
- 3. Mastering Array Unnesting: UNNEST() vs Scalar Subqueries
- 4. Production SQL Blueprint 1: Clean Event Flattening & Parameter Extraction
- 5. Production SQL Blueprint 2: Deterministic Session Reconstruction & Landing Page Attribution
- 6. Production SQL Blueprint 3: First-Touch vs Last-Non-Direct Attribution Modeling
- 7. Production SQL Blueprint 4: 12-Month Cohort LTV & Repurchase Velocity
- 8. Production SQL Blueprint 5: Cross-Device Identity Stitching (user_pseudo_id to user_id)
- 9. Production SQL Blueprint 6: Reconciling GA4 Purchases with Shopify / Stripe ERP Data
- 10. Production SQL Blueprint 7: Geo-Lift and Regional Holdout Incrementality Analysis
- 11. Production SQL Blueprint 8: dbt (Data Build Tool) Production Transformation Pipeline
- 12. BigQuery Machine Learning (BQML): Logistic Regression Conversion Propensity
- 13. BigQuery Query Cost Optimization: Table Partitioning, Clustering & BI Engine
- 14. Frequently Asked Questions (FAQ)




