Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Convert Zip code to Google Metro Code?

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

like image 262
Unknown Coder Avatar asked Jul 23 '10 22:07

Unknown Coder


People also ask

Can you target Google ads by ZIP code?

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.

What is a metro code?

A metro code is a zip code like in the states, e.g. 24100.

How do I pull a ZIP code from a map?

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.


1 Answers

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.

like image 166
joe snyder Avatar answered Sep 21 '22 12:09

joe snyder