All But Removed data equals All Enabled in getting data from API (Different in the UI)

[Alon Reznik]

Hello.

We have a strange problem getting data from Adwords using the equivilant mechanism of "All But Removed" and "All Enabled" filters (Adgroup/Campgian/Ad) in AD_PERFORMANCE_REPORT.

When asking these specific report selectors:

(Filter All Ads):

{'reportName': u'AD_PERFORMANCE_REPORT', 'selector': {'predicates': [{'operator': 'IN', 'field': 'Status', 'values': ['DISABLED', 'ENABLED', 'PAUSED']}], 'fields': ['Date', 'CreativeDestinationUrl', 'CampaignId', 'CampaignName', 'AdGroupName', 'Headline', 'Impressions', 'Clicks', 'Cost', 'CreativeFinalUrls', 'CreativeTrackingUrlTemplate', 'HeadlinePart1', 'HeadlinePart2', 'Description', 'Path1', 'Path2', 'Id', 'AdGroupId', 'AccountDescriptiveName', 'CriterionId'], 'dateRange': {'max': '20190716', 'min': '20190701'}}, 'reportType': u'AD_PERFORMANCE_REPORT', 'dateRangeType': 'CUSTOM_DATE', 'downloadFormat': 'CSV'}

 

(Filter All But Removed):

{'reportName': u'AD_PERFORMANCE_REPORT', 'selector': {'predicates': [{'operator': 'IN', 'field': 'Status', 'values': ['ENABLED', 'PAUSED']}], 'fields': ['Date', 'CreativeDestinationUrl', 'CampaignId', 'CampaignName', 'AdGroupName', 'Headline', 'Impressions', 'Clicks', 'Cost', 'CreativeFinalUrls', 'CreativeTrackingUrlTemplate', 'HeadlinePart1', 'HeadlinePart2', 'Description', 'Path1', 'Path2', 'Id', 'AdGroupId', 'AccountDescriptiveName', 'CriterionId'], 'dateRange': {'max': '20190716', 'min': '20190701'}}, 'reportType': u'AD_PERFORMANCE_REPORT', 'dateRangeType': 'CUSTOM_DATE', 'downloadFormat': 'CSV'}

 

We're getting the same cost/impressions metrics, while in the UI they are different.

How do I make represent the filter of All But Removed as it's in the UI, in the API?

Thanks

Alon 

[Google Ads API Forum Advisor Prod]

Hi Alon,

Thanks for posting your concern.

To investigate the issue, would you mind providing the information below via Reply privately to author option?
1. Customer ID
2. Sample screenshot of the Google Ads UI and the sample reports where I can see the data discrepancies

Regards,
Ejay
Google Ads API Team

ref:_00D1U1174p._5001U8Lgbh:ref

[Alon Reznik]

Hi, Just Made it :)

Thanks

[Alon Reznik]

Hi @adsapiforumadvisor

Any updates on this?

How do I get the answer?

Thanks

On Wednesday, July 17, 2019 at 9:14:31 AM UTC+3, adsapiforumadvisor wrote:

[Google Ads API Forum Advisor Prod]

Hi Alon,

My apologies for the delayed response as we discussed your issue to my team.

Upon checking, you need to remove the 'CriterionId' field as it behave differently and there is a possibility that it will consider the status of criterion, not the ad. This is the reason why you couldn't able to replicate the "All but removed ads" status in the Ad Performance Report.

I also tried in on my end and I was able to get the 104.69 total cost.

Let me know if you're still having the issue.