Data Discrepancies between Bigquery Google Ads Transfer and Google Ads UI Data Download

34 views
Skip to first unread message

Colby Hamilton

unread,
Mar 3, 2020, 4:13:26 PM3/3/20
to AdWords API and Google Ads API Forum
I'm trying to set up an analytics pipeline using the Bigquery Google Ads Transfer but I'm having difficulty trying to get the queries we're using of the bigquery data to match the existing data pulls that are being done on the Google Ads Dashboard. What could be causing this discrepancy if all the same filters are applied and the both sets of data are aggregated up to the same level?

Google Ads API Forum Advisor Prod

unread,
Mar 4, 2020, 3:30:21 PM3/4/20
to adwor...@googlegroups.com
Hi Colby,

There may be an issue from the BigQuery side. I'd recommend reaching out to their team for assistance on this issue.

Regards,
Anthony
Google Ads API Team 

ref:_00D1U1174p._5001UXU0Pb:ref

Colby Hamilton

unread,
Mar 5, 2020, 2:27:45 PM3/5/20
to adsapifor...@gmail.com, adwor...@googlegroups.com
Hi Anthony,

Do you mean that there's a problem with the transfer itself? Because for specific portions of the data it matches pretty well and I would assume that if there was a problem with the transfer most of the data wouldn't match at all.

Best,
Colby

--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
 
You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwor...@googlegroups.com
To unsubscribe from this group, send email to
adwords-api...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
---
You received this message because you are subscribed to a topic in the Google Groups "AdWords API and Google Ads API Forum" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/adwords-api/-TqcZXL7K8E/unsubscribe.
To unsubscribe from this group and all its topics, send an email to adwords-api...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/rGLd4000000000000000000000000000000000000000000000Q6ORLU00hJeUeNHvTZKy19HJ205ggQ%40sfdc.net.

Colby Hamilton

unread,
Mar 10, 2020, 4:23:28 PM3/10/20
to AdWords API and Google Ads API Forum
To Specify, We're seeing less incidences of the "Search Partners" and "YouTube Videos" Ad Network types. Is there any limitation on what can be transferred to bigquery using the API for those network types?

Google Ads API Forum Advisor Prod

unread,
Mar 11, 2020, 2:29:56 PM3/11/20
to adwor...@googlegroups.com
Hi Colby,

The reports should be in sync. Since you are noticing discrepancies, I'd recommend reaching out to the BigQuery team as I mentioned.
Reply all
Reply to author
Forward
0 new messages