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: