Learn business growth with Google Analytics 4 Forums Google Analytics 4 Discrepancy in User Count: GA4 vs Bigquery

  • Discrepancy in User Count: GA4 vs Bigquery

    Posted by Grayson on 23 May 2022 at 9:23 pm

    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:

    1

    And here’s what pops up for user count and event count in Bigquery:

    2

    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 1
    

    And just so we’re clear, I made sure there’s no NULL value hanging around in user_pseudo_id. So what gives?

    Emma replied 11 months, 2 weeks ago 2 Members · 1 Reply
  • 1 Reply
  • Emma

    Member
    7 October 2022 at 3:08 am

    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.