This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Mismatch data between google ads UI Report and Data pulled from Data Transfer

Posted 2 weeks ago
matcoi
Bronze 2
Bronze 2
Reply posted on --/--/---- --:-- AM
I'm currently using data transfer to upload data into BigQuery from a google ads account. I've noticed that the video quartile metrics (video_quartile_X) in the "AdCrossDeviceStats" table don’t match up with the figures in the report generated by the Google Ads UI.

Here are the images for the same ad on the same day:

Data from the Data Transfer Report:

matcoi_0-1713280378508.png

Data from Google Ads UI:

matcoi_1-1713280403033.png

To calculate the video quartile metrics in the Data Transfer (tables in bigquery) report, I use this weighted average formula: sum(video_percentile_x * views) / sum(views)

So far i have tried:

  • Checking the Math: I made sure the weighted average was calculated properly. Turns out, the discrepancies are there even before using the weighted average.

  • Testing Timezones: I tweaked the timezones to see if that was the issue, but no luck there.

  • Looking for Fixes: I searched to see if others had the same problem and found some potential fixes. Unfortunately, none fit my situation since I need the data grouped by Ad ID.

6 2 269
Topic Labels
2 REPLIES 2

Posted on --/--/---- --:-- AM
nceniza
Staff
Reply posted on --/--/---- --:-- AM

Is there a way to compare the raw data from GA to transferred data?( To check for missing data) 

Another reason that I can think of is the difference between BQ and GA estimates cardinality. Which is better explained in the document "Unique count approximation in Google Analytics" which explains that GA uses HLL++ algorithm for some of their queries. 

Good Refernce: https://developers.google.com/analytics/blog/2023/bigquery-vs-ui

Posted on --/--/---- --:-- AM
matcoi
Bronze 2
Bronze 2
In response to nceniza
Reply posted on --/--/---- --:-- AM

Thanks for your suggestions! Just to clarify, I'm working with Google Ads data, not Google Analytics  The mismatch is between Google Ads data in BigQuery and the Google Ads UI. Nevertheless, the documents you mentioned are great to know about for broader context. Do you have any advice or resources specific to resolving discrepancies with Google Ads data transfers to BigQuery?