GA4 + BigQuery Tutorial - Getting session_id Using Window Function (#4)

Publicado em: 29 Dezembro 2020
no canal de: Marketing Watch House

5,625

133

Step-by-step tutorial on how to assign session_if to each hit inside GA4 (firebase) table.

Your code template №1:
MAX(CASE WHEN params.key = "ga_session_id" THEN params.value.int_value ELSE NULL END) OVER (PARTITION BY event_timestamp, user_pseudo_id) AS ga_session_id

Your code template №2:
SELECT * EXCEPT (column_name1, column_name2) FROM ...

Timecodes:
00:00 Intro
01:05 Window Definition
03:07 Result of window function
03:32 Cleaning date and timestamp
05:45 Excluding irrelevant columns

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 - Getting session_id Using Window Function (#4) duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Marketing Watch House 29 Dezembro 2020, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 5,625 vezes e gostou 133 espectadores. Boa visualização!

6,750