[SalesForce] ExactTarget Automation Studio — sending multiple emails in one automation

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.

Best Answer

There’s a few ways you can do this:

  1. You can create some data filters based on event ID’s and use these data filters in your user initiated emails as splits this will split your open rate if you want to see these separately.

OR

  1. Write another query to split the data into separate data extension from the daily data extension.

Or

  1. Write some AMPscript to generate dynamic HTML’s something like this

%%[set EVENTID = event ID]%%
%%[IF EVENTID == 123 THEN]%% HTML 1 %%[IF EVENTID == 345 THEN]%% HTML 2 %%[ELSE]%% HTML 3 %%[ENDIF]%%

Hope this helps

Related Topic