-
Hey, no worries, we’ve all been there! You’re right, the numbers seem to be dancing on different beats in GA4 and BigQuery. But hey, let’s see if we can get them to tango together.
One area to peek into might be your source table. If your website is rolling with a consent mode, you might find some ‘user_pseudo_id’s that have turned out to be shy and ended up blank. These elusive ones might count their dance steps in GA4, but give BigQuery the cold shoulder. Hence, the awkward difference.
Another possibility that might throw your dance off rhythm could be that BigQuery and GA4 are swinging to different time zone tunes. BigQuery has a thing for UTC, but your GA4, well, it might have its own preferences.
So, shine your spotlight on these possibilities and see if they transform this awkward dance-off into a graceful ballet. Cheers mate!
