Hi Majid, Could you access this link <https://developers.google.com/adwords/api/docs/appendix/geotargeting> and click on the "Open Table" button and see if you have access to it?
Regards, Dannison AdWords API Team On Friday, November 16, 2018 at 7:30:24 PM UTC+8, Majid Khosravi wrote: > > Sure. here it is. > > On Thursday, 15 November 2018 17:17:37 UTC, Dannison Yao (AdWords API > Team) wrote: >> >> Hi Majid, >> >> The link I sent should be publicly available. Could you send over a >> screenshot of what you're seeing upon accessing it? >> >> Regards, >> Dannison >> AdWords API Team >> >> On Thursday, November 15, 2018 at 8:07:36 AM UTC+8, Majid Khosravi wrote: >>> >>> Thanks but it seems that fusion table is private and I don't have access >>> to it. >>> >>> On Thursday, 15 November 2018 00:01:39 UTC, Dannison Yao (AdWords API >>> Team) wrote: >>>> >>>> Hi Majid, >>>> >>>> What you can do here is upon retrieving the Id of the Location from >>>> CAMPAIGN_LOCATION_TARGET_REPORT, you can map the location ID to the >>>> country code using this guide >>>> <https://fusiontables.google.com/DataSource?docid=1PMUKjN14MzsHiDlk5QfpkcpFJCEyEQOU4f6AQFwi#rows:id=1> >>>> . >>>> >>>> Regards, >>>> Dannison >>>> AdWords API Team >>>> >>>> On Thursday, November 15, 2018 at 4:48:42 AM UTC+8, Majid Khosravi >>>> wrote: >>>>> >>>>> Thanks Dannison, >>>>> >>>>> So what would be the best way to get the country codes? In the above >>>>> example I am using CAMPAIGN_LOCATION_TARGET_REPORT service to pull the >>>>> result per location and I want to get the country code of each location >>>>> id >>>>> as well. >>>>> >>>>> Thanks. >>>>> >>>>> On Wednesday, 14 November 2018 20:10:40 UTC, Dannison Yao (AdWords API >>>>> Team) wrote: >>>>>> >>>>>> Hi Majid, >>>>>> >>>>>> It is expected that the value for countryCode will be blank when you >>>>>> retrieve it as this field is generally used for filters. According >>>>>> to the documentation >>>>>> <https://developers.google.com/adwords/api/docs/reference/v201806/LocationCriterionService.LocationCriterion#countrycode>, >>>>>> >>>>>> it is used as a hint or suggestion when you are doing your filtering. >>>>>> For >>>>>> example, you specified *CountryCode** EQUALS 'US' *when calling the >>>>>> API. This means that the results returned by the API is filtered by the >>>>>> countryCode, specifically if it is equal to 'US'. >>>>>> >>>>>> Hope this helps. >>>>>> >>>>>> Regards, >>>>>> Dannison >>>>>> AdWords API Team >>>>>> >>>>>> On Thursday, November 15, 2018 at 2:05:42 AM UTC+8, Majid Khosravi >>>>>> wrote: >>>>>>> >>>>>>> I have recently started an open source project called Chartramp >>>>>>> which pulls data from different ad networks including Google Adwords >>>>>>> API >>>>>>> for analysis purposes, In case might be useful: >>>>>>> >>>>>>> https://github.com/Chartramp/Chartramp >>>>>>> >>>>>>> Currently I have an issue regarding fetching the country code >>>>>>> from LocationCriterionService to map daily GEO records per country. >>>>>>> >>>>>>> Here is the code: >>>>>>> >>>>>>> >>>>>>> https://github.com/Chartramp/Chartramp/blob/master/application/src/Service/Network/Google/GoogleAds.php >>>>>>> >>>>>>> using getCountryCodes function. >>>>>>> >>>>>>> Can you guys have a look and let me know if there is a way to get >>>>>>> the countryCode from LocationCriterionService? It always returns as >>>>>>> null. >>>>>>> >>>>>>> Thanks! >>>>>>> >>>>>> -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads 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 and Google Ads 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/fa04e0e1-2b9b-4822-869c-af25eecae929%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
