• 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?

Parents
  • $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!
Reply
  • $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!
Children
No Data