December 17, 2020

New tutorials on GA4BigQuery: custom channel grouping, all pages report, goals, BigQuery linking & unnesting tables

Hi there,

Thanks for being one of the early subscribers to this newsletter :)

Just a nudge to let you know I've added some new example queries and tutorials:

Google Analytics 4

• Tutorial: How to set up BigQuery linking in your Google Analytics 4 property (GA4)

• Tutorial: How to flatten the GA4 BigQuery export schema for usage in relational databases

• All example queries for GA4 dimensions & metrics

Universal Analytics

• Tutorial: How to create your own custom channel grouping (UA)

• Tutorial: How to replicate the 'Behavior | Site content | All pages' report (UA)

• Tutorial: How to query and calculate goals based on urls and/or events (UA)

• All example queries for UA dimensions & metrics

• All example queries to replicate UA reports

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.