AnsweredAssumed Answered

Is there a way to link a csv with event information, but no customer data, to leads in Marketo, based on Zip Codes?

Question asked by 16bb5463a0143aab4780ee36e5906dbc8ff65d81 on Dec 11, 2017
Latest reply on Dec 13, 2017 by Sanford Whiteman

Hi all!


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]."