Post-Performance Emails

Hi Tom

I was doing this in a semi-automated fashion for both pre and post performance emails, through TMS. I ran it once a week for all performances that happened the previous week (or would occur  the week after next).

Essentially I set up a local function that would bring back the first performance the person attended (or would attend for the reminders) for a particular time period (relative to todays date) - for reminders it also pulled back an Also Attending field to show other performances or events attended during that week..

The function took 2 variables one to state whether you wanted to send a Reminder or a Thank -you email, the other was whether you wanted the full information returning or just a list of customer_nos (this was just to make the pulling the counts quicjker)

 I used the function in the extraction to get the list of customers then wrote various Output (query) Elements and set up 2 standard Output sets and used these when extracting the email list, which then populated Custom Variables on TMS.

With WordFly coming, I am looking to redo this such that this can be fully automated, however, I will still look to maintain the fact thta a customer only receives one of each email each week.

Mark

Hi Tom

I was doing this in a semi-automated fashion for both pre and post performance emails, through TMS. I ran it once a week for all performances that happened the previous week (or would occur  the week after next).

Essentially I set up a local function that would bring back the first performance the person attended (or would attend for the reminders) for a particular time period (relative to todays date) - for reminders it also pulled back an Also Attending field to show other performances or events attended during that week..

The function took 2 variables one to state whether you wanted to send a Reminder or a Thank -you email, the other was whether you wanted the full information returning or just a list of customer_nos (this was just to make the pulling the counts quicjker)

 I used the function in the extraction to get the list of customers then wrote various Output (query) Elements and set up 2 standard Output sets and used these when extracting the email list, which then populated Custom Variables on TMS.

With WordFly coming, I am looking to redo this such that this can be fully automated, however, I will still look to maintain the fact thta a customer only receives one of each email each week.

Mark

Thanks to all for your responses!  Much appreciated.  See you next week.

Cheers,

Tom