LinkedIn
Twitter
Hi,
I have two data sources, one is GA4 events coming from BigQuery and the other is my Postgres Users table. I have a blend of these two sources, and when I try to get the all-time event count for a specific event I get different results. I noticed that when there is no Event Time dimension in blend the event count will be higher and correct than when it is present in blend data.
To check the correct Event count I ran a simple query in BigQuery.
SELECT event_name, COUNT(*) AS event_count FROM `dataset`
WHERE event_name IN ('connect', 'start_session', 'save_session', 'delete_session','stop_session', 'send_workout', 'update','start_training', 'save_training', 'delete_training','stop_training', 'start_workout')
GROUP BY event_name ORDER BY event_count DESC
Below, you can see the difference in the Event count and how I joined these two data sources.
Without Event Time dimension:
With Event Time dimension:
