Geographic Performance Report returns different data than interface

[Tiana S.]

Hi guys,

Requesting geographic data for 2 campaigns using the API, but the result shows a lot less clicks and impressions for some locations than the interface does.

The query: 

SELECT+CountryCriteriaId,CityCriteriaId,CampaignName,Clicks,Impressions,Cost+FROM+GEO_PERFORMANCE_REPORT+WHERE+Imp

ressions > 0+AND+CampaignId IN [<campaignids>]+DURING+20160309,20160315

The result shows 2 clicks for Royal Palm Beach for one campaign, but the same city for the campaign in the interface shows 64 clicks for that date range. And impressions in the API for the city+campaign are only 14 while the interface shows there were 3262 impressions...

Can provide some more specifics such as the campaign id(s) requested and a screenshot from the interface in a confidential reply.

Any help would be greatly appreciated!

[Tiana S.]

I would like to add that I've already played around with the `IsTargetingLocation` field to see whether setting `IsTargetingLocation = false`, `IsTargetingLocation = true` or `IsTargetingLocation IN [true, false]` would have any influence in getting the correct values, but no luck...

[Yin Niu]

Hello, 

Please provide the report definition and report sample as well as screenshot of the UI report that you are seeing discrepancy. 

Thanks, 

Yin, AdWords API Team. 

[alessandr...@intarget.net]