Difference between Google Ads UI, Google Ads Big Query Export Data and Google Ads API

[Manuel Spierenburg]

Hi,

I'm seeing some difference in the data when I compare the google ads ui with data from our daily BQ export and when I query data with the google ads api.

For example number of campaigns:

When I check in the UI on MCC level and use filter enabled + eligible I see 10887 campaigns

In the BQ table with filter enabled and serving I count 10859 campaigns

And querying all enabled and serving campaigns via the google ads api I see 10862 campaigns.

These are small differences but what could be the reason to get these different numbers?

When I compare audiences though the differences are much bigger.

Unfortunately I can not see all audiences on MCC level in the UI.

But when I query all user list criteria with help of the api I get: 454167 criteria which have 9673 unique campaign ids

When I check the Audience table I see 223155 entries though with 5871 unique campaign ids

And when I check the Criteria table with filter USER_LIST on criteria type I get 156290 entries with 121 unique campaign ids

Why do I see these differences?

Maybe I do not fully understand the content of the Audience and Criteria table. 

Shouldn't they include all audiences on a daily level?

Thank you,

Manuel

 

[Google Ads API Forum Advisor Prod]

Hello Manuel,

I see that you are seeing differences form the UI, API and Big Query results. The differences between the API and UI results might be that some of the campaign types like discovery, smart campaigns are not supported via API. Regarding the BigQuery and UI discrepancies please contact big Query support team from here. 

Related to the audiences since looking for the UI views and API. One thing to remember is the search that you are doing from the API and UI must match and the dates should match. Please share the account id, complete screenshot of UI and the API report definition you are using to get the audience lists to check further? Please use reply privately to the author option while sharing the information requested.

Regards,
Sai Teja, Google Ads API Team

ref:_00D1U1174p._5001UOCvaF:ref

[Venika Wadhwa]

Hi 
Did your problem get solved ? I am facing the same issue certain campaigns are missing can't figure out why.

[Google Ads API Forum Advisor Prod]

Hi Venika,

Thank you for reaching out. In terms of the discrepancies between the Google Ads UI and API, can you please provide your client customer ID plus any relevant logs/reports that further explain the issue via Reply privately to author so that I can further investigate the issue?

For issues with BigQuery, I would recommend contacting their support team here.

Regards,
Mitchell

Google Ads API Team

ref:_00D1U1174p._5004Q1zJxMv:ref

[Marcel Daryanto]

Hi, is there any update on these problems? I also facing the same issue, that a campaign appears on Google Ads UI but it doesn't appear on Google Ads API, I suspect that that particular campaign has Not Eligible status.

[Google Ads API Forum Advisor]

Hi Marcel,

Thanks for reaching out to the Google Ads API team. I hope you are doing well today.
 

Upon checking on the raised feature request for this issue, this is already fixed. However, for our team to further check this, could you provide a full screenshot of the Google Ads UI where you can see the data you want to retrieve in the API and the complete request and response logs with the request ID and request header generated on your end? If you haven't yet, logging can be enabled by navigating to the Client Libraries > Your client library (ex. Java) > Logging documentation, which you can access from this link, so that we can further check and provide precise guidance accordingly.

You may then send the requested information via the Reply privately to author option. If this option is not available, you may send the details directly to our googleadsa...@google.com alias instead

Regards,

Darwin Google Ads API Team

ref:_00D1U1174p._5004Q1zJxMv:ref