DownloadCriteriaReportWithAwql got empty data

[lijy...@gmail.com]

Hi

I Run the demo code DownloadCriteriaReportWithAwql.php   ,not get any [Impressions,clicks,cost] data.

if set incloudeZeroImpressions False get this

if set incloudeZeroImpressions True get this

But,I'm sure this clientCustomerID has cost.

English not very good,hope you can know what i say...

Thanks!

[Milind Sankeshware (AdWords API Team)]

Hi Lijy,

As per your report output, it seems all the campaigns with impressions in given date range are UAC campaigns, which is not supported in Criteria Performance Report. UAC campaigns are supported by few reports only which are listed here.

Let me know if you have further questions.

Thanks,
Milind, AdWords API Team.

[lijy...@gmail.com]

Thank you

Through your answer I can get data now

But I have a new question

now I got data is like below

 Campaign ID,Conversions,Impressions,Clicks,Cost

 990364463,118.00,924953,5185,1643015598

 936797417,1335.00,2679162,16878,12916141088

 953142174,2533.00,1263598,26275,1118543755

 934943696,1650.00,1123871,18876,690802399

 936575915,330.00,6982484,33202,6256734605

 939053186,354.00,407426,2301,1977611328 

 Total,6320.00,13381494,102717,24602848773

how can i get every Campaign ID in every country's cost

like below's data it's my expectation

 Campaign ID,Country Code,Conversions,Impressions,Clicks,Cost

 990364463,US,118.00,924953,5185,1643015598

 990364463,JP,118.00,924953,5185,1643015598

 990364463,KR,118.00,924953,5185,1643015598

 990364463,CN,118.00,924953,5185,1643015598

 936797417,US,1335.00,2679162,16878,12916141088

 936797417,DE,1335.00,2679162,16878,12916141088

 936797417,SG,1335.00,2679162,16878,12916141088

 936797417,CN,1335.00,2679162,16878,12916141088

 936797417,JP,1335.00,2679162,16878,12916141088

[Milind Sankeshware (AdWords API Team)]

Hi Lijy,

As you are generating report for UAC campaigns, you could use Campaign Location Target Report. This report summarizes the performance of campaigns by location-based CampaignCriterion. You will the get ID of location target from this report. You need to use LocationCriterionService to get location name for that ID. Please check the LookupLocation example in java for reference. Samples in other languages can also be found here.

[lijy...@gmail.com]

Thanks You

i get data buy this swql 

SELECT CampaignId,Impressions, Clicks, Cost,Id FROM CAMPAIGN_LOCATION_TARGET_REPORT DURING YESTERDAY

it's return me

Report was downloaded and printed below: "CAMPAIGN_LOCATION_TARGET_REPORT (Jan 7, 2018)" Campaign ID,Impressions,Clicks,Cost,Location 934943696,905995,12456,737831703,2360 934943696,38160,574,48208467,2458 936797417,2634862,14408,12633422994,2840 939053186,39423,298,265340000,2036 939053186,458646,2803,1567433131,2276 939053186,164820,1253,178688876,2702 953142174,2024397,43210,3871816213, -- 936575915,7369453,42380,9509125519,2410 936824633,33833,55,351088640,2392 Total,13669589,117437,29162955543, --

i guess the Location is country through this page

https://developers.google.com/adwords/api/docs/appendix/geotargeting

but only can get country who cost too much.

some country cost only A few cents or A few dollars can't got

how can i get all country's cost.

i need a detail country data like this excel(0107 Google adwords数据.xlsx)

[Milind Sankeshware (AdWords API Team)]

Hi Lijy,

To get the stats of all campaigns, could you set IncludeZeroImpressions in the header to true and run the report? For more information please find this guide. I ran the report in AdWords API and I was getting the values for all campaigns. The stats in API report was matching with the report in the old UI view in this case. 
I also observed that there is a slight discrepancy in clicks and impressions between the old and new UI views. Since that is a issue with the UI, you could either post this on the Advertisers community forum or use the help button in the AdWords UI to call the AdWords Support team?

[lijy...@gmail.com]

Thank you

I think you may not understand my means.

i need's data like Geo Performance report's description[The Geo Performance report includes all statistics aggregated at the country/territory level, one row per country/territory]

i need campaign's cost in every country.

but it looks like The Geo Performance report are not supported UAC ads

Although Campaign Location Target Report can get some country's data but only a little country,not all. i need all detial datas

[Milind Sankeshware (AdWords API Team)]

Hi Lijy,

Unfortunately, it is not possible to get all countries data in Campaign Location Target Report. You will only get targeted countries for campaign. If this not the case then could you please elaborate "get some country's data but only a little country,not all" ?