This message was deleted.
# ask-questionsw
worried-planet-2191
10/06/2023, 3:40 PMThis message was deleted.
t
thankful-oil-10632
10/06/2023, 4:02 PMI guess i need to count the unique session id based on user_pseudo_id any idea on how to that please ?? @helpful-application-7107
thankful-oil-10632
10/06/2023, 7:47 PMHey @fresh-football-47124 please help me with the above.
f
fresh-football-47124
10/06/2023, 10:08 PM
you need more where clauses as you’ve unnesting the event params
fresh-football-47124
10/06/2023, 10:08 PM
you’re going to get a row per param
fresh-football-47124
10/06/2023, 10:09 PM
but you should be able to run this in BigQuery to get the data right
fresh-football-47124
10/06/2023, 10:10 PM
you might just need to unique by user_pseudo_id
t
thankful-oil-10632
10/09/2023, 9:32 AMWe tried adding DISTINCT for user_pseudi_id at the select statement but still, the numbers are huge. Yeah we can get the data at the big query right, but how to capture the right session counts for tracking purposes please let me know @fresh-football-47124 @cuddly-finland-73937
f
fresh-football-47124
10/09/2023, 2:34 PM
If you managed to query the data correctly in BQ, you can just use that in GrowthBook
139 Views