• Replies 4 replies
  • Subscribers 332 subscribers
  • Views 87 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

Parents
  • $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!

Reply
  • $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!

Children
No Data