• Replies 6 replies
  • Subscribers 414 subscribers
  • Views 58 views
  • Users 0 members are here
Related

How do I create a list of people who have missed a performance?

Adria Gunter
$organization

We had a promotion of small subscriptions that people purchased through a coupon website. We created a subscription for the people who called in to redeem the coupons. I sent out email confirmations but we had trouble with our email system. How do I find out who purchased the mini subscription but did not attend the performances that they were scheduled for?



[edited by: Adria Gunter at 11:50 AM (GMT -6) on 17 Mar 2013]
  • $organization

    You could create a Nscan list element to see if the ticket was scanned in. Create a list element pulling from LVS_Nscan_attendance for Nscan_perf_dt and Nscan_Attendance status. We also created some for Nscan_production_name, Nscan_Day_of_week, and  Nscan_Perf_name. You could always write a query in a few minutes to get this, but you will probably want these list elements too. Our box managers like using them.  If you need more detail shoot me an email or something.

    Travis

  • $organization

    If you can get the constituents that purchased the subscription into a list, you can run the Attendance by Performance Report (under Ticketing Box Office).

  • $organization

    Thanks. This was Greek to me. I have no idea what the NSCAN list element is. Where do I write the query?

     

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Travis Armbuster
    Sent: Monday, March 18, 2013 9:02 AM
    To: Adria Gunter
    Subject: Re: [Tessitura Ticketing Forum] How do I create a list of people who have missed a performance?

     

    You could create a Nscan list element to see if the ticket was scanned in. Create a list element pulling from LVS_Nscan_attendance for Nscan_perf_dt and Nscan_Attendance status. We also created some for Nscan_production_name, Nscan_Day_of_week, and  Nscan_Perf_name. You could always write a query in a few minutes to get this, but you will probably want these list elements too. Our box managers like using them.  If you need more detail shoot me an email or something.

    Travis

    From: Adria Gunter <bounce-adriagunter1034@tessituranetwork.com>
    Sent: 3/17/2013 11:49:21 AM

    We had a promotion of small subscriptions that people purchased through a coupon website. We created a subscription for the people who called in to redeem the coupons. I sent out email confirmations but we had trouble with our email system. How do I find out who purchased the mini subscription but did not attend the performances that they were scheduled for?




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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 in reply to Adria Gunter

    You would create a list element in t_keyword.  You would be creating new elements call them what you will. Ours lead with NSCAN_. The detail table you would use is LVS_NSCAN_ATTENDANCE. I am assuming you do not have access to SSMS, so you can do a manual edit in list manager and write the query there. If need help with a query let me know, or speak to you DBA if your org has one.

    Here is information on the system table.

    http://www.tessituranetwork.com/Help_System/Content/System_Tables/T_KEYWORD.htm

     

    Here is an example of what the entry in the table for attendance would look like.

  • Former Member
    Former Member $organization

    Adria – This would be really simple to do in T-Stats if you have it using the Seats cube.

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Travis Armbuster
    Sent: Monday, March 18, 2013 12:33 PM
    To: Nicole Keating
    Subject: RE: [Tessitura Ticketing Forum] How do I create a list of people who have missed a performance?

     

    You would create a list element in t_keyword.  You would be creating new elements call them what you will. Ours lead with NSCAN_. The detail table you would use is LVS_NSCAN_ATTENDANCE. I am assuming you do not have access to SSMS, so you can do a manual edit in list manager and write the query there. If need help with a query let me know, or speak to you DBA if your org has one.

    Here is information on the system table.

    http://www.tessituranetwork.com/Help_System/Content/System_Tables/T_KEYWORD.htm

     

    Here is an example of what the entry in the table for attendance would look like.

    From: Adria Gunter <bounce-adriagunter1034@tessituranetwork.com>
    Sent: 3/18/2013 11:07:49 AM

    Thanks. This was Greek to me. I have no idea what the NSCAN list element is. Where do I write the query?

     

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Travis Armbuster
    Sent: Monday, March 18, 2013 9:02 AM
    To: Adria Gunter
    Subject: Re: [Tessitura Ticketing Forum] How do I create a list of people who have missed a performance?

     

    You could create a Nscan list element to see if the ticket was scanned in. Create a list element pulling from LVS_Nscan_attendance for Nscan_perf_dt and Nscan_Attendance status. We also created some for Nscan_production_name, Nscan_Day_of_week, and  Nscan_Perf_name. You could always write a query in a few minutes to get this, but you will probably want these list elements too. Our box managers like using them.  If you need more detail shoot me an email or something.

    Travis

    From: Adria Gunter <bounce-adriagunter1034@tessituranetwork.com>
    Sent: 3/17/2013 11:49:21 AM

    We had a promotion of small subscriptions that people purchased through a coupon website. We created a subscription for the people who called in to redeem the coupons. I sent out email confirmations but we had trouble with our email system. How do I find out who purchased the mini subscription but did not attend the performances that they were scheduled for?




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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 Ticketing Forum. You may reply to this message to post to the Ticketing 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

    The Attendance by Performance report is built to help with just this sort of thing.  You can set it to just show you people who didn’t attend and to list the constituent detail.  And as was previously suggested, if you run the report using a list of these subs, the only no shows that will be listed are the subs who didn’t attend.  Once you have the report results, you can save it to a list if you need to.

     

    Kevin Sheehan

    Senior Technical Writer & Consultant

    Tessitura Network

    +1 888 643 5778 x 329

    ksheehan@tessituranetwork.com