• Replies 7 replies
  • Subscribers 332 subscribers
  • Views 239 views
  • Users 0 members are here
Related

Output Set element for a constituents next performance date

Mason Wright
$organization

I'm trying to create an output set that will include the date and name of the next performance a constituent will attend. This output set will be used along with Mail2 to automatically remind people that they have a performance coming up. I've been looking a lot at the TR_QUERY_ELEMENT table and put together 2 queries that I thought should work. These queries are as follows:

 

Description: Next Performance Name

Data Select: !.perf_name

Data From: (SELECT TOP 1 a.* FROM lvs_tkt_hist a WHERE perf_dt >= getdate() ORDER BY perf_dt)

Data Where: (blank)

single row is checked

 

Description:Next Performance Date

Data Select: !.perf_dt

Data From: (SELECT TOP 1 a.* from lvs_tkt_hist a WHERE perf_dt >= getdate() ORDER BY perf_dt)

Data Where: (blank)

single row is checked

 

When I use the Execute An Output Set report, these fields are always left blank. To me it seems that they should only be returning one row and that the desired data should appear. Can anyone tell me what I may be doing wrong or a better alternative for this?

  • $organization

    A few things. You are looking at ticket history. Chances are that the next performance is not even in the history table. Secondly, if this is for Mail2 why not create a view that mail2 can pull directly from? You will most likely want to look at the order itself.  If you would like to see and example view let me know .

     

    Travis



    [edited by: Travis Armbuster at 12:58 PM (GMT -6) on 22 Jun 2016]
  • $organization in reply to Travis Armbuster

    Travis,

    I wasn't aware that you could set up views for Mail2 to automatically pull from until now, but that sounds like it could be very useful. Seeing an example view would actually be great for me so I can get an idea of what it should include. Thanks for the help!

    Mason

  • $organization in reply to LeeAnn Day Douglas

    LeeAnn,

    I  haven't explored Mail2 a lot. I've looked enough to know that autoresponders need some criteria to match to within the contact fields or information about their interactions with the emails or Mail2 system to work. Can you explain to me how I could use the performance-based scheduled campaigns to send emails to remind people about events that they have tickets for? How would Mail2 even know that they have upcoming events unless you manually upload a list of constituents from Tessitura that have that event in their ticket history as criteria? Or is that what you're recommending I do?

  • $organization
    I can only speak as someone who uses things like this rather than writes them, but I would suggest switching to a Date Range rather than a Date equals idea. I believe in laymen's terms this is because a Date equals means the search will be for a performance at exactly 00:00:00 hours of the date, which isn't so useful for productions that begin earlier than midnight.

      
      

    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
    WWW.NEW42.ORG
    The New 42nd Street



    On Wed, Jun 22, 2016 at 1:05 PM, Travis Armbuster <bounce-travisarmbuster9061@tessituranetwork.com> wrote:

    A few things. You are looking at ticket history. Chances are that the next performance is not even in the history table. Secondly, if this is for Mail2 why not create a view that mail2 can pull directly from? If you would like to see and example view let me know .

     

    Travis

    From: Mason Wright <bounce-masonwright3210@tessituranetwork.com>
    Sent: 6/22/2016 12:36:05 PM

    I'm trying to create an output set that will include the date and name of the next performance a constituent will attend. This output set will be used along with Mail2 to automatically remind people that they have a performance coming up. I've been looking a lot at the TR_QUERY_ELEMENT table and put together 2 queries that I thought should work. These queries are as follows:

     

    Description: Next Performance Name

    Data Select: !.perf_name

    Data From: (SELECT TOP 1 a.* FROM lvs_tkt_hist a WHERE perf_dt >= getdate() ORDER BY perf_dt)

    Data Where: (blank)

    single row is checked

     

    Description:Next Performance Date

    Data Select: !.perf_dt

    Data From: (SELECT TOP 1 a.* from lvs_tkt_hist a WHERE perf_dt >= getdate() ORDER BY perf_dt)

    Data Where: (blank)

    single row is checked

     

    When I use the Execute An Output Set report, these fields are always left blank. To me it seems that they should only be returning one row and that the desired data should appear. Can anyone tell me what I may be doing wrong or a better alternative for this?




    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!

  • $organization

    Is there any reason you aren’t using the performance-based scheduled campaigns that already exist in mail2?

     

    LeeAnn E. Day l Marketing Director – Digital & Experience Marketing l leeann.day@strazcenter.org
    David A. Straz, Jr. Center for the Performing Arts l
    STRAZCENTER.ORG
    1010 N. W.C. MacInnes Place l Tampa, Florida 33602
    O: 813.222.1051 F: 813.222.1057

     

    From: Tessitura Marketing Forum [mailto:forums-marketing@tessituranetwork.com] On Behalf Of Mason Wright
    Sent: Wednesday, June 22, 2016 12:39 PM
    To: Day, LeeAnn <LeeAnn.Day@strazcenter.org>
    Subject: [Tessitura Marketing Forum] Output Set element for a constituents next performance date

     

    I'm trying to create an output set that will include the date and name of the next performance a constituent will attend. This output set will be used along with Mail2 to automatically remind people that they have a performance coming up. I've been looking a lot at the TR_QUERY_ELEMENT table and put together 2 queries that I thought should work. These queries are as follows:

     

    Description: Next Performance Name

    Data Select: !.perf_name

    Data From: (SELECT TOP 1 a.* FROM lvs_tkt_hist a WHERE perf_dt >= getdate() ORDER BY perf_dt)

    Data Where: (blank)

    single row is checked

     

    Description:Next Performance Date

    Data Select: !.perf_dt

    Data From: (SELECT TOP 1 a.* from lvs_tkt_hist a WHERE perf_dt >= getdate() ORDER BY perf_dt)

    Data Where: (blank)

    single row is checked

     

    When I use the Execute An Output Set report, these fields are always left blank. To me it seems that they should only be returning one row and that the desired data should appear. Can anyone tell me what I may be doing wrong or a better alternative for this?




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

    Give me a call. 813-222-1051 I’ll walk you through it.

     

    LeeAnn E. Day l Marketing Director – Digital & Experience Marketing l leeann.day@strazcenter.org
    David A. Straz, Jr. Center for the Performing Arts l
    STRAZCENTER.ORG
    1010 N. W.C. MacInnes Place l Tampa, Florida 33602
    O: 813.222.1051 F: 813.222.1057

     

    From: Tessitura Marketing Forum [mailto:forums-marketing@tessituranetwork.com] On Behalf Of Mason Wright
    Sent: Wednesday, June 22, 2016 2:52 PM
    To: Day, LeeAnn <LeeAnn.Day@strazcenter.org>
    Subject: RE: [Tessitura Marketing Forum] Output Set element for a constituents next performance date

     

    LeeAnn,

    I  haven't explored Mail2 a lot. I've looked enough to know that autoresponders need some criteria to match to within the contact fields or information about their interactions with the emails or Mail2 system to work. Can you explain to me how I could use the performance-based scheduled campaigns to send emails to remind people about events that they have tickets for? How would Mail2 even know that they have upcoming events unless you manually upload a list of constituents from Tessitura that have that event in their ticket history as criteria? Or is that what you're recommending I do?

    From: LeeAnn Day <bounce-leeannday5475@tessituranetwork.com>
    Sent: 6/22/2016 6:09:43 PM

    Is there any reason you aren’t using the performance-based scheduled campaigns that already exist in mail2?

     

    LeeAnn E. Day l Marketing Director – Digital & Experience Marketing l leeann.day@strazcenter.org
    David A. Straz, Jr. Center for the Performing Arts l
    STRAZCENTER.ORG
    1010 N. W.C. MacInnes Place l Tampa, Florida 33602
    O: 813.222.1051 F: 813.222.1057

     

    From: Tessitura Marketing Forum [mailto:forums-marketing@tessituranetwork.com] On Behalf Of Mason Wright
    Sent: Wednesday, June 22, 2016 12:39 PM
    To: Day, LeeAnn <LeeAnn.Day@strazcenter.org>
    Subject: [Tessitura Marketing Forum] Output Set element for a constituents next performance date

     

    I'm trying to create an output set that will include the date and name of the next performance a constituent will attend. This output set will be used along with Mail2 to automatically remind people that they have a performance coming up. I've been looking a lot at the TR_QUERY_ELEMENT table and put together 2 queries that I thought should work. These queries are as follows:

     

    Description: Next Performance Name

    Data Select: !.perf_name

    Data From: (SELECT TOP 1 a.* FROM lvs_tkt_hist a WHERE perf_dt >= getdate() ORDER BY perf_dt)

    Data Where: (blank)

    single row is checked

     

    Description:Next Performance Date

    Data Select: !.perf_dt

    Data From: (SELECT TOP 1 a.* from lvs_tkt_hist a WHERE perf_dt >= getdate() ORDER BY perf_dt)

    Data Where: (blank)

    single row is checked

     

    When I use the Execute An Output Set report, these fields are always left blank. To me it seems that they should only be returning one row and that the desired data should appear. Can anyone tell me what I may be doing wrong or a better alternative for this?




    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!




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

    These might help.

     

    http://mail2support.lynch2.com/customer/en/portal/articles/375598-how-to-set-up-tessitura-integration-for-scheduled-campaigns

     

    http://mail2support.lynch2.com/customer/en/portal/articles/2414768-how-to-create-a-performance-based-tessitura-integrated-scheduled-campaign

     

     

    LeeAnn E. Day l Marketing Director – Digital & Experience Marketing l leeann.day@strazcenter.org
    David A. Straz, Jr. Center for the Performing Arts l
    STRAZCENTER.ORG
    1010 N. W.C. MacInnes Place l Tampa, Florida 33602
    O: 813.222.1051 F: 813.222.1057

     

    From: Tessitura Marketing Forum [mailto:forums-marketing@tessituranetwork.com] On Behalf Of Mason Wright
    Sent: Wednesday, June 22, 2016 2:52 PM
    To: Day, LeeAnn <LeeAnn.Day@strazcenter.org>
    Subject: RE: [Tessitura Marketing Forum] Output Set element for a constituents next performance date

     

    LeeAnn,

    I  haven't explored Mail2 a lot. I've looked enough to know that autoresponders need some criteria to match to within the contact fields or information about their interactions with the emails or Mail2 system to work. Can you explain to me how I could use the performance-based scheduled campaigns to send emails to remind people about events that they have tickets for? How would Mail2 even know that they have upcoming events unless you manually upload a list of constituents from Tessitura that have that event in their ticket history as criteria? Or is that what you're recommending I do?

    From: LeeAnn Day <bounce-leeannday5475@tessituranetwork.com>
    Sent: 6/22/2016 6:09:43 PM

    Is there any reason you aren’t using the performance-based scheduled campaigns that already exist in mail2?

     

    LeeAnn E. Day l Marketing Director – Digital & Experience Marketing l leeann.day@strazcenter.org
    David A. Straz, Jr. Center for the Performing Arts l
    STRAZCENTER.ORG
    1010 N. W.C. MacInnes Place l Tampa, Florida 33602
    O: 813.222.1051 F: 813.222.1057

     

    From: Tessitura Marketing Forum [mailto:forums-marketing@tessituranetwork.com] On Behalf Of Mason Wright
    Sent: Wednesday, June 22, 2016 12:39 PM
    To: Day, LeeAnn <LeeAnn.Day@strazcenter.org>
    Subject: [Tessitura Marketing Forum] Output Set element for a constituents next performance date

     

    I'm trying to create an output set that will include the date and name of the next performance a constituent will attend. This output set will be used along with Mail2 to automatically remind people that they have a performance coming up. I've been looking a lot at the TR_QUERY_ELEMENT table and put together 2 queries that I thought should work. These queries are as follows:

     

    Description: Next Performance Name

    Data Select: !.perf_name

    Data From: (SELECT TOP 1 a.* FROM lvs_tkt_hist a WHERE perf_dt >= getdate() ORDER BY perf_dt)

    Data Where: (blank)

    single row is checked

     

    Description:Next Performance Date

    Data Select: !.perf_dt

    Data From: (SELECT TOP 1 a.* from lvs_tkt_hist a WHERE perf_dt >= getdate() ORDER BY perf_dt)

    Data Where: (blank)

    single row is checked

     

    When I use the Execute An Output Set report, these fields are always left blank. To me it seems that they should only be returning one row and that the desired data should appear. Can anyone tell me what I may be doing wrong or a better alternative for this?




    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!




    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!