Session: dimensions & metrics
The most important session dimensions and metrics for GA360 BigQuery export, like sessions and bounce rate.
-
🔒 GA4 | reports
- How to replicate the 'Life cycle | Acquisition | User acquisition' report (GA4)
- How to replicate the GA4 'Traffic acquisition' report in BigQuery
- How to create a GA4 ecommerce transactions performance report in BigQuery
- How to create a GA4 landing page performance report in BigQuery
- How to create a GA4 page performance report in BigQuery
- How to create a GA4 tech (device, OS & browser) performance report in BigQuery
- How to create a GA4 item / product performance report in BigQuery
-
🔒 GA4 | tutorials
- How to flatten the GA4 BigQuery export schema for usage in relational databases
- How to combine public global weather and GA4 ecommerce data in BigQuery
- How to customise the default GA4 engaged session definition in BigQuery
- How to deal with string, integer and float GA4 event parameter values in BigQuery using the coalesce function
- How to create a low-cost, lightning fast GA4 Looker Studio dashboard powered by the BigQuery export
- How to create a custom user segment based on a sequence of GA4 events in BigQuery
- How to (back)stitch your custom user id to GA4's client id in BigQuery to enable cross-device analysis
- How to sessionize your GA4 event data in BigQuery (part 1: default 30-minute session timeout definition)
- How to sessionize your GA4 event data in BigQuery (part 2: custom session definitions)
- How to fix the major GA4 BigQuery export misattribution bug where paid search events and sessions are mistaken for organic or direct traffic
- Why the landing page report in GA4 sucks and how to fix it in BigQuery (GA3 style)
- How to create a GA4 user retention cohort table in BigQuery (and visualise it in Looker Studio)
- How to join your CRM and GA4 event 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 search queries and SEO metrics with GA4 data in BigQuery
- How to build your own GA4 attribution model comparison tool in BigQuery and Looker Studio
- How to create a GA4 funnel exploration table with completion and abandonment rates in BigQuery
- Why (and how) to use GA4 event_timestamp with your local time zone instead of event_date in BigQuery
- How to get the GA4 property id from the BigQuery export metadata and join it with your event data
-
GA4 | dimensions & metrics
- User dimensions & metrics (GA4)
- Device, app, web, stream and platform dimensions & metrics (GA4)
- Geo location dimensions & metrics (GA4)
- Traffic source and user acquisition dimensions & metrics (GA4)
- Session dimensions & metrics (GA4)
- Date and time dimensions & metrics (GA4)
- Page dimensions & metrics (GA4)
- Events dimensions & metrics (GA4)
- Ecommerce dimensions & metrics (GA4)
- Items dimensions & metrics (GA4)
-
GA4 | tips & tricks
- How to set up BigQuery linking in your Google Analytics 4 property
- Introduction to Google Analytics 4 (GA4) export data in BigQuery
- How to query multiple GA4 'events_' tables with '_table_suffix' in BigQuery
- Why your BigQuery results don't (exactly) match with Google Analytics reports (GA4)
- Let's build together: towards an open-source community-driven dbt package for the GA4 BigQuery export
- How to create a pivot table with GA4 data in BigQuery
- How to filter events in your GA4 BigQuery export to avoid exceeding daily 1 million event limit
- How to explore GA4 event data with the sample ecommerce data set in BigQuery
- How to query streaming GA4 export data and combine it with historical data in BigQuery
- How to sync your marketing data with BigQuery using Fivetran's free plan
- How (and why) to activate the GA4 user activity data export to BigQuery
- How to set up Google 'Connected' Sheets to access GA4 BigQuery export data without learning SQL
-
UA | Universal Analytics
- Tutorial: How to query multiple 'ga_session' tables with '_table_suffix'
- How to replicate the 'Audience | Geo | Location' report
- How to replicate the 'Audience | Behavior | New vs Returning' report
- Tutorial: How to query and calculate goals based on urls and/or events
- How to replicate the 'Conversions | Goals | Reverse Goal Path' report
- How to replicate the 'Audience | Geo | Language' report
- How to replicate the 'Audience | Technology | Browser & OS' report
- How to replicate the 'Audience | Mobile | Device Category Overview' report
- How to replicate the 'Audience | Mobile | Devices' report
- How to replicate the 'Acquisition | All traffic | Channels' report
- How to replicate the 'Acquisition | All traffic | Source/Medium' report
- How to replicate the 'Acquisition | All traffic | Referrals' report
- How to replicate the 'Acquisition | Campaigns | All campaigns' report
- Tutorial: How to replicate the 'Behavior | Site content | All pages' report
- How to replicate the 'Behavior | Events | Top Events' report
- How to replicate the 'Behavior | Events | Pages' report
- How to replicate the 'Conversions | (Standard) Ecommerce | Transactions' report
- How to replicate the 'Conversions | (Standard) Ecommerce | Product performance' report
- How to replicate the 'Conversions | (Enhanced) Ecommerce | Product performance' report
- How to replicate the 'Conversions | (Enhanced) Ecommerce | Sales performance' report
- Introduction to Google Analytics 360 export data in BigQuery
- User: dimensions & metrics
- Session: dimensions & metrics
- Date and time: dimensions & metrics
- Traffic sources: dimensions & metrics
- How to query realtime tables and views (and combine it with daily tables)
- Geo network: dimensions & metrics
- Platform and device: dimensions & metrics
- Page tracking: dimensions & metrics
- Event tracking: dimensions & metrics
- How to query an intraday table (and combine it with daily tables)
- Goal conversions: dimensions & metrics
- (Enhanced) Ecommerce transactions: dimensions & metrics
- Ecommerce products: dimensions & metrics
- Enhanced Ecommerce products: dimensions & metrics
- Custom dimensions & metrics
- Tutorial: How to create your own custom channel grouping
- How to replicate the 'Conversions | (Enhanced) Ecommerce | Shopping behavior' funnel report
