![]() define static and/or dynamic start and end dateĪnd format_date('%Y%m%d',date_sub(current_date(), interval 1 day))Ĭount(distinct case when (select value.string_value from unnest(event_params) where key = 'session_engaged') = '1' then concat(user_pseudo_id,(select value.int_value from unnest(event_params) where key = 'ga_session_id')) end) as engaged_sessions change this to your google analytics 4 export location in bigquery Calculated sessions metricsĬount(distinct concat(user_pseudo_id,(select value.int_value from unnest(event_params) where key = 'ga_session_id'))) as sessions Session acquisition dimensions can be found here. How to query realtime tables and views (and combine it with daily tables) Platform and device: dimensions & metrics How to query an intraday table (and combine it with daily tables) (Enhanced) Ecommerce transactions: dimensions & metrics Tutorial: How to create your own custom channel groupingĮnhanced Ecommerce products: dimensions & metrics How to replicate the 'Conversions | (Enhanced) Ecommerce | Shopping behavior' funnel report How to set up BigQuery linking in your Google Analytics 4 property 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 #1 - New website, updated queries, premium tutorials, GA4 x dbt #2 - SQL query support from ChatGPT, GA4 count approximation demystified #3 - Relevant blog posts, join the conversation, GA4 bible released #4 - Search Console introduces BigQuery bulk export #5 - 90 days to go: are you ready to query your GA4 data? #6 - New fields in GA4 export & SQL query generators Traffic source and user acquisition dimensions & metrics (GA4)ĭevice, app, web, stream and platform dimensions & metrics (GA4) 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 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 ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |