Hi Andrew, To pull campaign metrics from Geo Performance Report <https://developers.google.com/adwords/api/docs/appendix/reports/geo-performance-report>, you will have to query for the CampaignId <https://developers.google.com/adwords/api/docs/appendix/reports/geo-performance-report#campaignid> , CampaignName <https://developers.google.com/adwords/api/docs/appendix/reports/geo-performance-report#campaignname> and any other fields depending on your use case. The Geo Performance report will return all the stats aggregated at the country/territory level, one row per country/territory. Also, please note that if you're trying to pull stats for the Universal App campaigns, Geo Performance report is currently not supported to pull metrics for these campaigns. You may refer to this guide <https://developers.google.com/adwords/api/docs/guides/mobile-app-campaigns#reporting> for available report types for Universal app campaigns.
Can you make these changes and try again? If you continue to have an issue with this, could you provide us the complete report definition <https://developers.google.com/adwords/api/docs/guides/reporting#create_a_report_definition>, so I can take a look and assist you further? Please use *Reply privately to author* option while responding. Regards, Bharani, AdWords API Team On Monday, November 27, 2017 at 4:26:27 AM UTC-5, Andrew Nguyen wrote: > > Hi, > > We have some campaigns running for a few months and we are able to query > these campaigns' performance in CAMPAIGN_LOCATION_TARGET_REPORT. However, > it doesn't return anything when we tried with GEO_PERFORMANCE_REPORT. > > Query for CAMPAIGN_LOCATION_TARGET_REPORT: > >> select CampaignId, Id from CAMPAIGN_LOCATION_TARGET_REPORT during > 20170901, 20171126 > returns: > "CAMPAIGN_LOCATION_TARGET_REPORT (Sep 1, 2017-Nov 26, 2017)" > Campaign ID,Location > <campaign id>,2392 > <campaign id>,2840 > <campaign id>,2840 > <campaign id>,2356 > <campaign id>,2368 > <campaign id>,2840 > <campaign id>,2840 > <campaign id>,2840 > <campaign id>,2840 > <campaign id>,2840 > <campaign id>,2840 > <campaign id>,2840 > <campaign id>,2356 > <campaign id>,2250 > <campaign id>,2554 > <campaign id>,2124 > <campaign id>,2392 > Total, -- > > Query for GEO_PERFORMANCE_REPORT: > >> select CityCriteriaId, CountryCriteriaId from GEO_PERFORMANCE_REPORT > during 20170901, 20171126 > >> returns: > "GEO_PERFORMANCE_REPORT (Sep 1, 2017-Nov 26, 2017)" > City,Country/Territory > Total, -- > > Can we get some instructions about what are we doing incorrectly please? > Thanks > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and Google+: https://googleadsdeveloper.blogspot.com/ https://plus.google.com/+GoogleAdsDevelopers/posts =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API Forum" group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. Visit this group at https://groups.google.com/group/adwords-api. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/ff699048-8509-4cdb-a6dd-2ff52ceea6f7%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
