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?


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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.