I have over 100,000 records in a subscribers list. Each of these records have a first name, last name, email address, and zip code field. I need to add a new field called "state" populate it with the name of the state that matches the zip code. Does the Marketing Cloud platform have anything that can support this? If not, any recommendations on how to achieve this?

1 Answer 1


There's nothing that'll in SFMC that'll match states from zip codes.

My recommendation would be to:

  1. Add a new Profile Attribute called "State"
  2. Export your All Subscribers to a tab-delimited file
  3. Open the file in Excel and populate the State column with a source data vlookup (a few sources are noted here)
  4. Save it as a tab-delimited file
  5. Import the file into All Subscribers as an Update

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .