Duplicate data in BigQuery export from GA UA 360

[nyan]

Hi there,

I hope this is the right place to ask for help. We noticed that BigQuery GA (UA) export is not matching with the GA UI for one of recent days for some properties. Happy to provider more details or please let me know if there is a better place to raise the issue.

Thank you!

[Poala_Tenorio · Accepted solution]

Data Processing Latency: Data might not be immediately available in BigQuery due to processing delays. There could be a delay of up to 24-48 hours before the data appears in BigQuery after it is processed in GA. Discrepancies between Google Analytics data and BigQuery exports can happen due to various reasons such as data sampling, differences in configuration settings, or processing latency. Google Analytics UI might use sampling when displaying data, especially for larger datasets or complex queries. BigQuery exports generally contain unsampled data. Ensure that the sampling level in GA matches the BigQuery export configuration.

Also check if there are any filters applied in Google Analytics that might affect the data being displayed. Ensure the configuration settings in both GA and BigQuery are consistent.

Ensure that the time zones are consistent between your Google Analytics view settings and your BigQuery environment.

To address this issue:

Verify the date range and time zone settings in both Google Analytics and BigQuery.
Compare specific metrics or dimensions between GA and BigQuery exports to pinpoint the differences.
Check for any recent changes in configurations or tracking implementations that might have affected data collection.

[nyan]

Thanks for the reply. However, this is happening for data of 12/10. We have multiple properties and are only seeing the issue for few of them. Is there a way I can share the SQL query and/ or property ID privately? Also please see attached screenshots for examples of duplicates from BigQuery.