Adwords Geo Location codes mapping with city/region/country names using Geographical targeting csv

[Sny]

Folks,

I am using GEO_PERFORMANCE_REPORT for adgroups performance for location wise stats. Now since, the report returns region/countryTerritory/metro/mostSpecificLocation in codes and not in names, I am seeding the code-name mapping using latest (2015-10-13) Geographical targeting csv (recommended by AdWords API team). My search criteria right now is on mostSpecificLocation (and then on countryTerritory if miss) for getting the name of the region from csv (also recommended by AdWords API team)

While I am getting most of the records mapped to the region names from the csv, there are 5% of the records that has mostSpecificLocation and countryTerritory code but its not there in CSV (neither in Criteria ID nor in Country Code). Does the CSV needs refresh?

Some of the examples of mostSpecificLocation codes not found in CSV are:
1007926,  1012093,  21212,  1007916,  1010216,  1028595,  1007937,  1007917,  1028602,  1007938,  1007941,  21210,  1007910,  2891,  2760,  2104,  1007933,  1028612,  1007923,  1007911,  1012723, 1007944,  2736,  1028614,  1007922,  1007936,  1007912,  1028599,  1007913,  1007921,  1007925,  1007928,  1028587,  21213,  20500,  1028591,  1007920,  1028613,  1007919,  1028610,  1028590,  1007924,  1028597,  1007932,  1028616,  1003690,  1003693,  1007930,  1028814,  1007927,  1028611,  1007939,  1028596,  1007943,  1007934,  2364,  1007940,  1028598,  20501,  1007914,  1007946,  1028604,  1007918,  1007947

These are 63 unknown locations that belongs to just one adGroup, now once I move to a campaign and aggregate all adGroups geo stats of that campaign, this unknown region count becomes too many to ignore. Am I missing something here?

Also latest (2015-10-13) Geographical targeting csv has some problems in few of the records I think (PFA screenshot of this kind of data in CSV), name and countryCode are not in the right columns of csv. Is the CSV need some corrections?

[Anash P. Oommen (AdWords API Team)]

Hi Suchit,

Thanks for letting us know. I'll ask our tech writer to regenerate the CSVs.

Cheers,
Anash P. Oommen,
AdWords API Advisor.

[Suchit Puri]

Hi Anash,

We also had one more question, we are actually trying to map the locations on a map so we need the latitude longitude for the location. We are using maxmind to map that. But since the name of the locations of google and max mind dont necessarily map. For example for United States of America some use America and some use United States of America.

Is there any standard you guys follow ?

Also when can we expect the updated csv, is there any time line you have in mind ?

Regards

Suchit Puri

[Anash P. Oommen (AdWords API Team)]

Hi Suchit,

AdWords doesn't have a public list of geo name to location decoder. You could check the Google Maps API and see if their Geocoding API works for you.

About updating the csv: I think next week or the one after that might be more realistic, since the US offices are closed till the 4th of Jan for new year.

Cheers,

Anash P. Oommen,
AdWords API Advisor.

[Sny]

Hi Anash,

Any update on the csv. It (https://developers.google.com/adwords/api/docs/appendix/geotargeting#columns) still list old one.

[Suchit Puri]

Hi Anash,

Do you have any update on the csv ? its blocking us to release as we are not able to plot all the locations on the map.

Regards

Suchit

--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 adwor...@googlegroups.com
To unsubscribe from this group, send email to
adwords-api...@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...@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/ed024df4-e5bc-47ad-898b-ae1db078be6f%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

[Anash P. Oommen (AdWords API Team)]

Hi Suchit,

Could you please let me know for what campaigns you are seeing these IDs? These locations are non-targetable, that's why they are missing in the CSVs. But I'd like to figure out why they are showing up in your geo performance report. Could you share the campaign IDs using the "Reply to Author" option?

Thx,
Anash

adwords-api+unsubscribe@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+unsubscribe@googlegroups.com.

Visit this group at https://groups.google.com/group/adwords-api.