Geo Performance Report doesn't match UI

[Inbar]

Hi,

The Geo Performance report has 2 problems:
1. The number of rows returned is about 25% of the rows in the UI.
2. Some of the values, such as Clicks and Cost, don't match.

I used the same date range, and no other filters.

Does anyone have a suggestion what the problem is?

Thanks,
Inbar

[Josh Radcliff (AdWords API Team)]

Hi Inbar,

Are you using the same view that's specified for the Geo Performance Report on our Mapping Reports to the UI page?

If so, and you're still seeing inconsistencies, please send over:

1. The report request you are sending (with any sensitive information removed).
2. A sample campaign ID and date range where you are seeing inconsistencies.

Thanks,

Josh, AdWords API Team

[Tiana S.]

Hi Josh,

I'm seeing the same difference but even more odd is that the total cost returned from the Geo performance report doesn't match what's returned from other endpoints. From any other endpoint, e.g. the Keyword performance report, I get a total of $406.24, but Geo returns $407.83.

I will provide more information in a private response. ;)

Thanks,

Tiana

[Josh Radcliff (AdWords API Team)]

Hi Tiana, Inbar,

One tip if you're seeing differences is to check out the instructions on how to match the user interface views at the top of the GEO_PERFORMANCE_REPORT documentation. This explains how to construct an API request to match the Geographic and User locations views.

Thanks,

Josh, AdWords API Team

[Tiana S.]

Hi Josh,

I already tried the settings mentioned in the Geo performance report documentation, but can't make the number match the result from e.g. Campaign performance.
The number should be $406.24. 

The Geo performance queries with their responses:

SELECT+CountryCriteriaId,Clicks,Impressions,Cost+FROM+GEO_PERFORMANCE_REPORT+WHERE+Impressions > 0+AND+IsTargetingLocation = false+AND+LocationType IN ["LOCATION_OF_PRESENCE"]+DURING+20151001,20151031

Result is: $85.01

SELECT+CountryCriteriaId,Clicks,Impressions,Cost+FROM+GEO_PERFORMANCE_REPORT+WHERE+Impressions > 0+AND+IsTargetingLocation = false+AND+LocationType IN ["AREA_OF_INTEREST"]+DURING+20151001,20151031

Result is: $235.84

SELECT+CountryCriteriaId,Clicks,Impressions,Cost+FROM+GEO_PERFORMANCE_REPORT+WHERE+Impressions > 0+AND+IsTargetingLocation = false+DURING+20151001,20151031

Result is: $320.85

SELECT+CountryCriteriaId,Clicks,Impressions,Cost+FROM+GEO_PERFORMANCE_REPORT+WHERE+Impressions > 0+AND+IsTargetingLocation = true+AND+LocationType IN ["LOCATION_OF_PRESENCE"]+DURING+20151001,20151031

Result is: $322.82

SELECT+CountryCriteriaId,Clicks,Impressions,Cost+FROM+GEO_PERFORMANCE_REPORT+WHERE+Impressions > 0+AND+IsTargetingLocation = true+AND+LocationType IN ["AREA_OF_INTEREST"]+DURING+20151001,20151031

Result is: $85.01

SELECT+CountryCriteriaId,Clicks,Impressions,Cost+FROM+GEO_PERFORMANCE_REPORT+WHERE+Impressions > 0+AND+IsTargetingLocation = true+DURING+20151001,20151031

Result is: $407.83

Any other ideas what might be causing this behavior?

Thanks,

Tiana

[Josh Radcliff (AdWords API Team)]

Hi Tiana,

Could you share a campaign ID from your account so I can run the reports from my side?

Thanks,

Josh, AdWords API Team