Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

calculation of sessions in Bigquery

Hi All,

I am using Bigquery to replicate the GA4 dashboard using Data Studio. I have a query regarding the calculation of total sessions. I went across many blogs which says that to calculate the total sessions we should count_distinct(user_pseudo_id + event_time_stamp) for all session start events. 

But while researching more there are many sessions for which session_start event does not trigger and GA4 assigns a session_id to that sessions. Is the correct way to caluclate sessions is to use count_distinct(user_pseudo_id + ga_session_id) ?

0 2 1,515
2 REPLIES 2