Failed to download report

[Миша Васильев]

Hello. I have a problem getting GEO_PERFORMANCE_REPORT. Query: SELECT CampaignName FROM GEO_PERFORMANCE_REPORT DURING LAST_30_DAYS I used different variants of fields. Didn't help. Other of the reports work well.
Thanks.

Error:

{System.ApplicationException: Failed to download report. ---> Google.Api.Ads.AdWords.Util.Reports.AdWordsReportsException: AdWordsReportsException: One or more AdWords Report download errors have occurred.

SelectorError.MISSING_FIELDS. (Error: SelectorError.MISSING_FIELDS, FieldPath:, Trigger: Must choose at least 1 field from the group [CountryCriteriaId])

[Luis Xander Talag (AdWords API Team)]

Hi,

The Geo Performance Report is intended to get the statistics data of your campaign that is aggregated at the country/territory level. To be able to use the report, you must include at least one field of the location criteria IDs (CityCriteriaId, CountryCriteriaId, MetroCriteriaId, MostSpecificCriteriaId, RegionCriteriaId).

If you want to retrieve the Campaign Name only, I would suggest to just use the Campaign Performance Report instead.

Thanks and regards,

Luis

AdWords API Team

[Миша Васильев]

Thanks for the answer. I did as you said. I used the following query SELECT CityCriteriaId, CampaignName FROM GEO_PERFORMANCE_REPORT DURING LAST_30_DAYS.

But I got this error again.

I need to receive a request that contains fields of "company names" and information about cities. Thanks

[Luis Xander Talag (AdWords API Team)]

Hi,

My apologies for the misinformation on my previous response. The field that is required to be in every SELECT query for this report is the CountryCriteriaId. Could you add these field again and regenerate the report?

Let me know if it works.

Thanks and regards,

Luis

AdWords API Team

[Миша Васильев]

It turned out to receive a report using such a request Select CityCriteriaId, Clicks, CampaignName, CountryCriteriaId FROM GEO_PERFORMANCE_REPORT DURING LAST_30_DAYS.

But it's empty. Although the report Geography -> Geography in Adwords returns a lot of data, or is it different reports?

[Luis Xander Talag (AdWords API Team)]

Hi,

For Geographic view just like in the UI, you should add the IsTargetingLocation = true or No predicate on IsTargetingLocation while for User locations view, you could add IsTargetingLocation IN [true,false] AND LocationType = LOCATION_OF_PRESENCE as your predicate. See this guide for reference.

If it's still empty after trying my suggestions, could you provide the clientCustomerId you are using when generating the Geo Performance Report so I could further investigate? Please reply via Reply privately to author.

Regards,

Luis

AdWords API Team

[郝顺成]

hi,I have encountered the same problem，got the empty data. it is the mobile-app-campaigns,how can i solve it?

[Google Ads API Forum Advisor Prod]

Hello, 

Could you please share the report query along with the client customer Id to check this further? You can share the details privately via Reply privately to author option.

Regards,
Bharani, Google Ads API Team

ref:_00D1U1174p._5001UBl8Or:ref