GA4 + BigQuery Tutorial - Creating Sessions Table (#6)

Publicado el: 30 diciembre 2020
en el canal de: Marketing Watch House

4,941

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 ...

En esta página del sitio puede ver el video en línea GA4 + BigQuery Tutorial - Creating Sessions Table (#6) de Duración hora minuto segunda en buena calidad , que subió el usuario Marketing Watch House 30 diciembre 2020, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 4,941 veces y le gustó 84 a los espectadores. Disfruta viendo!