-
Discrepancy in User Count: GA4 vs Bigquery
Alright folks, I’m running into a bit of a conundrum here. I’ve sent the GA4 data off to Bigquery, but when I put the GA4 data and Bigquery data head-to-head, the user count is off the mark. The weird thing is, other events like ‘session start’ or custom events are holding up just fine. Feels like I’ve hit a snag, anyone got any thought on this?
Here’s what I’m getting from GA4 for user count and event count:
And here’s what pops up for user count and event count in Bigquery:
Just in case you wanna take a peek, here’s the code I’m using in Bigquery:
SELECT event_name, COUNT(*) as event_count, COUNT(DISTINCT(user_pseudo_id)) AS user_id, FROM mytable WHERE event_name = 'page_view' AND _TABLE_SUFFIX BETWEEN '20230201' AND '20230228' GROUP BY 1And just so we’re clear, I made sure there’s no NULL value hanging around in user_pseudo_id. So what gives?
-
1 Reply
-
Your mismatch could potentially be due to Google Analytics 4 (GA4) data thresholds. Reports that include demographic data can sometimes withhold rows if the total number of users isn’t high enough. This is particularly true when the report’s identity relies on device ID.
Log in to reply.