Triggered email campaigns: Where to "store" info in Tess that is specific to venue/campus vs. specific to an event?

I would give my eyeteeth for a "one size fits all" document to walk me seamlessly through set-up of our first Triggered email campaigns. Short of that, I am grateful for any assistance more experienced Marketers can provide.

We are working on setting up pre-show reminders right now. 

We are a performing arts centers with multiple campuses and venues.

To keep things as streamlined as possible, we are hoping to set up a SINGLE list that pulls people with a show coming up in the next 48 hours. 

My example: One list, with 5 different performances pulling into that list.

Those performances are on separate campuses that may each have different traffic alerts/warnings related to city-wide construction projects.

For events that may each have different security procedures (some involve bag check, some involve wanding, some involve metal detectors).

For events that may also have specific pre and/or post-show entertainment in the lobby or bar.

I am not involved in building events in Tess; just in marketing them.

WHERE in Tessitura should I be asking my Ticket Set-up peers to start inputting these (special instructions) blocks of text that relate to traffic, security, pre/post-show events? 

So that I can create a Tess Output set that then pulls those blocks of text [for a specific campus, or specific event] dynamically into my Triggered Wordfly email template? 

Thanks for your help!

Christine

Parents
  • Hi Christine

    If you have someone who can write sql on your database, you can create a custom view for this that can pull in Inventory Content items for the performance, this give you a lot of flexibility over messaging without having to change the template each time.

    I have code for this that I am using currently, my view pulls in the customers and the information for both pre and post show emails and for the 2 different venues (which in my case also have send at different times). I use the view in the list to identify whether it is re or Post and the Venue and then have 4 output sets for each possibility.

    You could add in the additional elements of time in order to break that down further,it wasn't needed where I currently work.

    Happy to share this code if it useful.

    It is possible to do multiple shows in a single email. I have done this in the past at both Royal Opera House and National Theatre but it involved a lot of custom sql.
    I believe I pushed the main code for doing this to the Code Repository on the Developer site.
    The sql is a lot more complicated but the user interaction is the same.

    Mark

Reply
  • Hi Christine

    If you have someone who can write sql on your database, you can create a custom view for this that can pull in Inventory Content items for the performance, this give you a lot of flexibility over messaging without having to change the template each time.

    I have code for this that I am using currently, my view pulls in the customers and the information for both pre and post show emails and for the 2 different venues (which in my case also have send at different times). I use the view in the list to identify whether it is re or Post and the Venue and then have 4 output sets for each possibility.

    You could add in the additional elements of time in order to break that down further,it wasn't needed where I currently work.

    Happy to share this code if it useful.

    It is possible to do multiple shows in a single email. I have done this in the past at both Royal Opera House and National Theatre but it involved a lot of custom sql.
    I believe I pushed the main code for doing this to the Code Repository on the Developer site.
    The sql is a lot more complicated but the user interaction is the same.

    Mark

Children
No Data