• Replies 4 replies
  • Subscribers 332 subscribers
  • Views 85 views
  • Users 0 members are here
Related

Triggered emails with multiple venues

Stacey Voigt
$organization

Hi!

We're just getting into the magical world of triggered emails, and thought we had everything working (thanks to all who have pitched in with SQL and advice so far!!)...

But we're finding that our performance reminders list is pulling reminders for performances at multiple venues, despite the list being set up in Tessitura List Manager to filter down very specifically to one season at one venue.

This may be something others at consortiums have experienced... I hope so! Right now my best guess for fixing it is to attempt to add a list criteria element which will allow us to filter by venue/facility.

Any thoughts or suggestions? Something obvious I'm missing? Thanks in advance.

Stacey Voigt
Database Manager
Santa Barbara Center for the Performing Arts
(805)899-3000 x128
svoigt@granadasb.org

  • $organization

    Hi Stacey,

    Do you use Mail2?  If so, have you explored using Scheduled Campaigns as opposed to Triggered emails? 

    There are 2 options - Performance Reminder and Custom View.  I've gone with the latter because we stagger our reminders based on order date plus I've included a couple of other fields we wanted.

    The performance reminder option can filter on a keyword if that is any help.

    The documentation for set up is at http://mail2support.lynch2.com/customer/portal/articles/613890-custom-scheduled-campaign-setup

    If you use Wordfly, hopefully someone else will respond.

    Cheers,

    Kevin

  • $organization

    We use WordFly and re: perf reminders, I create a new custom view for each prod_season_no (only differing in that one detail), thus each associated triggered pull, list element, output set, etc., is limited to one facility.

  • $organization in reply to Chris Jensen

    Great information, thanks all!

    We are using WordFly, and I currently have a separate list and output set for each venue (and likewise, each venue is using a separate campaign; in fact they are using completely separate instances of WordFly too!).

    However, the lists and output sets are drawing from a single custom view... which might be the source of the problem.

    Sounds like we will need to go at least a couple layers deeper with the custom view(s) we're using. I like Chris' suggestion, though I think I will try to get away with creating the views for season_no -- as we have dozens of prod_season_nos in any given year, and I'm it as far as manpower for creating these right now.

    If anyone has other suggestions - or if someone at a consortium has already overcome this - I'd love to hear.

    Thanks again!

     

     

  • $organization
    We run ours via WordFly, but our "trouble" with this was entirely Tessitura based. I can't speak to why your query in Tess is pulling multiple venues--that will be all about how the different elements are interacting and I don't personally read SQL (though can say I had to have our DBA custom prep something for me for these campaigns)--but can add that we found we needed to set up a list, an output set, and a campaign per venue in order to send to the right people. The sticking point is that List Manager (and WordFly) will only include an email address once per send, so any customer with multiple performances would still only get one message.

    Despite assumptions, it turned out we had enough constituents attending multiple events that it was worth the small amount of extra prep to make sure we weren't only sending reminders/follow up about half of what they were joining us to do.




    JAMIE O'BRIEN

    ASSISTANT DIRECTOR OF DIGITAL SERVICES

    THE NEW 42ND STREET
    229 W 42ND STREET, NEW YORK, NY 10036
    JOBRIEN@NEW42.ORG
    646.223.3063



    On Sun, Mar 15, 2015 at 6:13 PM, Kevin Madeira <bounce-kevinmadeira9286@tessituranetwork.com> wrote:

    Hi Stacey,

    Do you use Mail2?  If so, have you explored using Scheduled Campaigns as opposed to Triggered emails? 

    There are 2 options - Performance Reminder and Custom View.  I've gone with the latter because we stagger our reminders based on order date plus I've included a couple of other fields we wanted.

    The performance reminder option can filter on a keyword if that is any help.

    The documentation for set up is at http://mail2support.lynch2.com/customer/portal/articles/613890-custom-scheduled-campaign-setup

    If you use Wordfly, hopefully someone else will respond.

    Cheers,

    Kevin

    From: Stacey Voigt <bounce-staceyvoigt1752@tessituranetwork.com>
    Sent: 3/13/2015 7:17:46 PM

    Hi!

    We're just getting into the magical world of triggered emails, and thought we had everything working (thanks to all who have pitched in with SQL and advice so far!!)...

    But we're finding that our performance reminders list is pulling reminders for performances at multiple venues, despite the list being set up in Tessitura List Manager to filter down very specifically to one season at one venue.

    This may be something others at consortiums have experienced... I hope so! Right now my best guess for fixing it is to attempt to add a list criteria element which will allow us to filter by venue/facility.

    Any thoughts or suggestions? Something obvious I'm missing? Thanks in advance.

    Stacey Voigt
    Database Manager
    Santa Barbara Center for the Performing Arts
    (805)899-3000 x128
    svoigt@granadasb.org




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Marketing Forum. You may reply to this message to post to the Marketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!