Has anyone successfully utilized Tess/TMS to send post-performance emails in an automated or at least semi-automated fashion? Specifically, I am interested in sending emails to all ticket buyers who attend each performance, preferably by the following morning, without manually running an extraction each morning (or multiple extractions, when we have multiple shows running).
Thanks for whatever feedback you can offer, and we'll see some of you in a few weeks.
All best,Tom
---
Tom O'Connor
Associate Director of Marketing
Roundabout Theatre Company
212.719.9393 x346
tomo@roundabouttheatre.org
Hi Tom,
My understanding is that this functionality will be available to us in an automated manner once we upgrade to Wordfly. At this point, I don’t know of a way to do this without manually running the extractions. But I’m excited at the prospect of eventually doing so!
Clint
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Clint Riley
Marketing Projects Manager
The Santa Fe Opera
www.santafeopera.org
O: 505.946.2427
F: 505.986.5999
criley@santafeopera.org
P.O. Box 2408 – Santa Fe, NM 87504
This will not help with the automation, but I wanted to point out a report that will be helpful for this sort of thing. In v9 the Attendance by Performance report has been enhanced, and you can run it to find all the constituents who used or did not use their tickets for a performance (assuming you are recording attendance data). You can then save the results to a list. This will save you the trouble of putting together an extraction to get a list of attendees or non-attendees.
Kevin Sheehan
Documentation & Learning Resources Specialist
Tessitura Network
1 888 643 5778 ext 329 Office
ksheehan@tessituranetwork.com
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