Reply To: Comparing Active Users in GA4 and BigQuery: How to Ensure Consistency?

[Ethan]

There could be a few reasons why you’re seeing differences in active users between BigQuery and GA4. First, make sure you’re comparing the same time periods in both. If your BigQuery query is using UTC time zone and GA4 is set to another, this could cause discrepancies.

Additionally, data in BigQuery is recorded on an event basis where multiple events may be produced by a single user, whereas GA4 aggregates data before displaying it. Thus, you might be counting duplicate users when directly counting user_pseudo_id from the raw BigQuery dataset. You must ensure to count distinct user_pseudo_id over a certain time period to get the unique active users.

Lastly, it’s also important to note GA4 filters out bot traffic and applies its own data thresholding for privacy reasons while BigQuery does not, which could cause a discrepancy.

However, if these adjustments still don’t get your numbers to match, you might want to reach out to the Google Analytics and BigQuery support teams for additional help.