I'm looking to send out emails to customers that refer upcoming events, based on their zip codes. We have hundreds of events every month, occurring across the country.
Unfortunately, our CRM does not update lead information with the upcoming events in their area; instead I'd have to refer to a separate file based on their zip. Is there any way to do this?
For instance, I get a .csv file with the upcoming events, their addresses, and maybe a list of zip codes that are within a certain radius of the event, but no customer data associated with it. How can I then put that into Marketo, so that my tokens can refer to it in an email?
Alternatively, is there a way to put the document into Marketo, and update a lead's field value for an upcoming event, based on their zip code? Ex, "If Zip Code matches [x], update [field] to [upcoming event]."