I know that Google publishes its "metro areas" for adwords. Is there a converter from ZIP code to metro area code available? The metro list I'm referring to is at: http://code.google.com/apis/adwords/docs/developer/adwords_api_us_metros.html
If you want your ads to appear only in specific locations, you can select the city, province, or region by specifying geo codes or postal codes and adjusting bids for the area.
A metro code is a zip code like in the states, e.g. 24100.
Click on the map to start drawing an area. Once you have defined the area in which you wish to search, click the [Search For Zip Codes] button. After a small delay, the results will appear inside the area. If you hover over or tap a marker, you will see its ZIP code.
Google's metro names appear to be restricted to USPS post office names, so you can do the conversion with 2 tables:
The USPS city-state file, which lists all ZIP codes and the corresponding place names and post office names attached to the ZIP. Beware, this file is updated monthly, and the "free" versions floating around and copied from purchased USPS files are often out of date.
Google's metro list, normalized so entries like "Huntsville-Decatur (Florence) AL 691" become "Huntsville AL: 691/Decatur AL: 691/Florence AL: 691".
Find the ZIP in the city-state file, fetch the corresponding post office name, find the post office name in the normalized metro list, fetch the corresponding metro code.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With