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

Publicado em: 30 Dezembro 2020
no 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 ...

Nesta página do site você pode assistir ao vídeo on-line GA4 + BigQuery Tutorial - Creating Sessions Table (#6) duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Marketing Watch House 30 Dezembro 2020, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 4,941 vezes e gostou 84 espectadores. Boa visualização!