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) 在 2018年1月4日星期四 UTC+8上午3:20:50，Milind Sankeshware (AdWords API Team)写道： > > Hi Lijy, > > As you are generating report for UAC campaigns, you could use Campaign > Location Target Report > <https://developers.google.com/adwords/api/docs/appendix/reports/campaign-location-target-report>. > > This report summarizes the performance of campaigns by location-based > CampaignCriterion > <https://developers.google.com/adwords/api/docs/reference/latest/CampaignCriterionService.CampaignCriterion>. > > You will the get ID of location target from this report. You need to use > LocationCriterionService > <https://developers.google.com/adwords/api/docs/reference/v201710/LocationCriterionService> > to > get location name for that ID. Please check the LookupLocation > <https://www.google.com/url?q=https%3A%2F%2Fgithub.com%2Fgoogleads%2Fgoogleads-java-lib%2Fblob%2Fmaster%2Fexamples%2Fadwords_axis%2Fsrc%2Fmain%2Fjava%2Fadwords%2Faxis%2Fv201710%2Ftargeting%2FLookupLocation.java&sa=D&sntz=1&usg=AFQjCNGoBcyf1dD9-Yma_x62iDt0lOW1HQ> > example > in java for reference. Samples in other languages can also be found here > <https://developers.google.com/adwords/api/docs/clientlibraries>. > > > Let me know if you have further questions. > > Thanks, > Milind, AdWords API Team. > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 [email protected] To unsubscribe from this group, send email to [email protected] 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 [email protected]. 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/33212491-9766-4f4e-8862-62a3da607419%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
0107 Google adwords数据.xlsx
Description: MS-Excel 2007 spreadsheet
