GA4 + BigQuery Tutorial - Creating Sessions Table (#6)
Now we are going to convert events table into sessions table. We don't need to use any new SQL functions, just aggregate existing hits.
Important code template for you:
WITH
table1 as (SELECT * FROM ...),
table2 as (SELECT * FROM table1)
SELECT * FROM table2
Timecodes:
00:00 Intro
00:35 Schedule Query Advice
01:27 Fixing utm_term
03:28 Session level query
07:05 Counting conversions
Useful links:
1. Create Google Console here: https://console.cloud.google.com/?pli=1
2. Open BigQuery here: https://console.cloud.google.com/bigq...
3. Great guide on how to connect GA4 with BigQuery: https://online-metrics.com/ga4-bigquery/
4. Great article on GA4 + BigQuery for beginners: https://www.simoahava.com/analytics/b...
5. Firebase Ga4 Tutorial: https://www.bounteous.com/insights/20...
Add me on LinkedIn: / rpetrochenkov
Read me on Medium: / rpetrochenkov
📌 Want to discuss your project?
Me on UpWork: http://bit.ly/3b9FLw2-MWH
Me on Fiverr: http://bit.ly/3oiAeac-MWH
Google Ads into BigQuery Playlist: • Complete Guide To BigQuery for Google...
My other Google Ads Scripts tutorials: • GAS #1: Create Your First Report via ...
On this page of the site you can watch the video online GA4 + BigQuery Tutorial - Creating Sessions Table (#6) with a duration of hours minute second in good quality, which was uploaded by the user Marketing Watch House 30 December 2020, share the link with friends and acquaintances, this video has already been watched 4,941 times on youtube and it was liked by 84 viewers. Enjoy your viewing!
