GA4BigQuery
  • 🔒 GA4 | reports
    • How to create a GA4 tech (device, OS & browser) performance report in BigQuery
    • How to create a GA4 page performance report in BigQuery
    • How to create a GA4 landing page performance report in BigQuery
    • How to create a GA4 ecommerce transactions performance report in BigQuery
    • How to replicate the GA4 'Traffic acquisition' report in BigQuery
    • How to replicate the 'Life cycle | Acquisition | User acquisition' report (GA4)
  • 🔒 GA4 | tutorials
    • How to create a GA4 funnel exploration table with completion and abandonment rates in BigQuery
    • How to build your own GA4 attribution model comparison tool in BigQuery and Looker Studio
    • How to join search queries and SEO metrics with GA4 data in BigQuery
    • How to deal with repetitive chunks of SQL code: let a UDF create your GA4 channel group dimensions in BigQuery
    • How to join your CRM and GA4 event data in BigQuery
    • How to create a GA4 user retention cohort table in BigQuery (and visualise it in Looker Studio)
    • Why the landing page report in GA4 sucks and how to fix it in BigQuery (GA3 style)
    • How to fix the major GA4 BigQuery export misattribution bug where paid search events and sessions are mistaken for organic or direct traffic
    • How to sessionize your GA4 event data in BigQuery (part 2: custom session definitions)
    • How to sessionize your GA4 event data in BigQuery (part 1: default 30-minute session timeout definition)
    • How to (back)stitch your custom user id to GA4's client id in BigQuery to enable cross-device analysis
    • How to create a custom user segment based on a sequence of GA4 events in BigQuery
    • How to create a low-cost, lightning fast GA4 Looker Studio dashboard powered by the BigQuery export
    • How to deal with string, integer and float GA4 event parameter values in BigQuery using the coalesce function
    • How to customise the default GA4 engaged session definition in BigQuery
  • GA4 | dimensions & metrics
    • Items dimensions & metrics (GA4)
    • Ecommerce dimensions & metrics (GA4)
    • Events dimensions & metrics (GA4)
    • Page dimensions & metrics (GA4)
    • Date and time dimensions & metrics (GA4)
    • Session dimensions & metrics (GA4)
    • Traffic source and user acquisition dimensions & metrics (GA4)
    • Geo location dimensions & metrics (GA4)
    • Device, app, web, stream and platform dimensions & metrics (GA4)
    • User dimensions & metrics (GA4)
  • GA4 | newsletter
    • #5 - 90 days to go: are you ready to query your GA4 data?
    • #4 - Search Console introduces BigQuery bulk export
    • #3 - Relevant blog posts, join the conversation, GA4 bible released
    • #2 - SQL query support from ChatGPT, GA4 count approximation demystified
    • #1 - New website, updated queries, premium tutorials, GA4 x dbt
  • GA4 | tips & tricks
    • How to sync your marketing data with BigQuery using Fivetran's free plan
    • How to query streaming GA4 export data and combine it with historical data in BigQuery
    • How to explore GA4 event data with the sample ecommerce data set in BigQuery
    • How to filter events in your GA4 BigQuery export to avoid exceeding daily 1 million event limit
    • How to create a pivot table with GA4 data in BigQuery
    • Let's build together: towards an open-source community-driven dbt package for the GA4 BigQuery export
    • Why your BigQuery results don't (exactly) match with Google Analytics reports (GA4)
    • How to query multiple GA4 'events_' tables with '_table_suffix' in BigQuery
    • How to set up BigQuery linking in your Google Analytics 4 property
  • UA | Universal Analytics
    • How to replicate the 'Conversions | (Enhanced) Ecommerce | Shopping behavior' funnel report
    • Tutorial: How to create your own custom channel grouping
    • Custom dimensions & metrics
    • Enhanced Ecommerce products: dimensions & metrics
    • Ecommerce products: dimensions & metrics
    • (Enhanced) Ecommerce transactions: dimensions & metrics
    • Goal conversions: dimensions & metrics
    • How to query an intraday table (and combine it with daily tables)
    • Event tracking: dimensions & metrics
    • Page tracking: dimensions & metrics
    • Platform and device: dimensions & metrics
    • Geo network: dimensions & metrics
    • How to query realtime tables and views (and combine it with daily tables)
    • Traffic sources: dimensions & metrics
    • Date and time: dimensions & metrics
  • 🔒 Premium tutorials
  • 📈 Dimensions & metrics
  • 🎓 Video course (with Simo Ahava)
  • ❓ FAQ
  • 🐦 Twitter
  • Sign in
  • Sign up
You've successfully subscribed to GA4BigQuery
Great! Next, complete checkout for full access to GA4BigQuery
Welcome back! You've successfully signed in.
Success! Your account is fully activated, you now have access to all content.
Success! Your billing info is updated.
Billing info update failed.

Premium

This page is for paying subscribers only

Subscribe now

Already have an account? Sign in