We are a large cultural institution that produces hundreds of events every year. I am trying to set up an automation inside of ExactTarget Automation Studio which would send "You are coming" emails to customers who are attending an event on the following day.
We currently have setup the following data extensions:
Event Information - Ticketing Transactions - Customer Information
We have a query setup that works to populate another data extension called "Daily You're Coming Data Extension", that when run, populates a data extension correctly with all customers that are attending an event on the following day.
The problem we run into is telling the automation which email to send to which customer when there are multiple events the following day. Each event has a unique identifier which tells us event information. Is there some way that we can relate the event ID to an email ID so that when the automation runs, it would know to send one email to those who are attending event A and a different email to those attending event B?
One thought would be to create a data extension which relates to event information and has the email ID of the corresponding "You're Coming" email. I know we could also build one email that uses Ampscript to create dynamic content depending on which event the customer is attending.
Please help...we know we are close to a solution, but would love any advice.