New BigQuery UI, Simo Ahava collaboration, engaged session definition, public weather & GA data
Hi there,
Hope you're well.
Did you already enjoy the new BigQuery user interface?
Some of the best features:
- work simultaneously in multiple tabs
- improved auto complete function
- command palette (hit F1 to see!)
I guess I'll be spending my lockdown nights uploading new UI screenshots for GA4BigQuery...
🤷♂️
GA4 & BigQuery course
I'm very happy to announce that I'll be partnering with marketing technology expert Simo Ahava. We're planning to release an extensive online course on GA4 and BigQuery later this year (ETA August 2021). I'll keep you posted about that. In the meantime, subscribe to Simo's newsletter.
New example queries and tutorials
As always, I’ve added some new example queries and tutorials to the platform:
Google Analytics 4
How to query multiple GA4 'events_' tables with '_table_suffix' in BigQuery
Every day of Google Analytics 4 data in BigQuery is stored in a separate table. Learn how to query multiple days at once using static or dynamic dates.
How to combine public global weather and GA4 ecommerce data in BigQuery
In this tutorial I will show you - step by step - how to combine weather data from the public BigQuery 'noaa_gsod' set with your own Google Analytics 4 data.
How to customise the default GA4 engaged session definition in BigQuery
In this tutorial I will show you - step by step - how to replicate the engaged session definition in GA4, so you can customise it at will.
All Google Analytics 4 content on GA4BigQuery:
Universal Analytics
How to replicate the 'Conversions | (Enhanced) Ecommerce | Shopping behavior' funnel report
A query to generate the Google Analytics Shopping behavior funnel report in BigQuery. In this report you'll find completion and abandonment data about your enhanced ecommerce funnel performance, segmented by user type.
All Universal Analytics content on GA4BigQuery:
Feel free to forward this mail to anyone you think is interested in learning how to query Google Analytics data in BigQuery.
See you at GA4BigQuery!
Cheers,
Johan
PS: Any topics you would like to see a tutorial on? Just hit the reply button and let me know.