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

Publicado el: 29 diciembre 2020
en el 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 ...

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

6,750