roydan
Elite Member
- Dec 17, 2013
- 5,633
- 14,565
I'm running many campaigns in the US, and some of them require frequent bulk uploads of cities for GEO targeting either on Google or Bing Ads.
Since Google and Bing use different methods to describe the names of each city (none of which is consistent, unfortunately), I needed to create a "key" file that would allow me to paste a number of city names and get the location ID without looking them one by one because just pasting them in the Editors it quite unreliable.
I used this DB to have the names of all the cities and counties in the US and matched them with Google's canonical name.
Anyway, here's the file I made.
The first tab is the data, and the 'Lookup Example' tab contains an example of how you can use it
Hope you'll find it useful.
Since Google and Bing use different methods to describe the names of each city (none of which is consistent, unfortunately), I needed to create a "key" file that would allow me to paste a number of city names and get the location ID without looking them one by one because just pasting them in the Editors it quite unreliable.
I used this DB to have the names of all the cities and counties in the US and matched them with Google's canonical name.
Anyway, here's the file I made.
The first tab is the data, and the 'Lookup Example' tab contains an example of how you can use it
Code:
https://www.mediafire.com/file/dy5dwfslqsaeldh/Google_and_Bing_Location_ID_per_City.xlsx/file
Code:
https://www.virustotal.com/gui/file/55c9db6a727e4e48b410911b413bf8b3d60e6d73be343ad60f51175c872ca3ad?nocache=1Hope you'll find it useful.