![]() You can unsubscribe from this newsletter anytime. Yes! Become a free member and get a monthly newsletter packed with GA4 & BigQuery news, tips & tricks in your inbox. On this platform I will not go into too much detail about the SQL syntax. If not, I suggest you start with a SQL introduction course ( this one, or this one) or purchase our GA4 focused SQL course where you'll get up to speed with the SQL syntax while working with the GA4 data export and BigQuery. I assume you have a basic understanding of SQL as a querying language and BigQuery as a database tool. I like my beer cold, my music loud, and whenever possible I unite these two hobbies by playing bass guitar and attending concerts. I live in the Netherlands (Utrecht area) with my wife and two daughters. On the off-hours, however, I work on the GA4BigQuery platform. By day, I work at New10 as a Digital Analyst. I thrive best at the sweet spot between data, business & tech. I have 8+ years hands-on experience in marketing and data analytics. My goal is to provide valuable content to data analysts, online marketeers and engineers who seek guidance on how to query the GA4 BigQuery export data set. GA4BigQuery is a digital guide & newsletter with example queries and tutorials on how to query Google Analytics data in BigQuery. 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 #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? Traffic source and user acquisition dimensions & metrics (GA4)ĭevice, app, web, stream and platform dimensions & metrics (GA4) 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 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. |