Realtime attendance monitoring

We are using Tessitura to ticket a large-scale feast event, with capacity (weather-dependant) of up to 10,000 per night - with a combination of presales and door sales.

Obviously for an event of this scale, crowd management is very complex - especially when it comes to selling door sales without going over capacity. What we really need is a realtime count of constituents currently at the event - eg people who have actually scanned their tickets in (and, if possible, discounting constituents who have scanned back out).

There is a report that might be useable here:
http://www.tessituranetwork.com/community/members/annieedlich6977/files/attendance-by-performance-ssrs-report-_2d00_-session-material.zip.aspx
but would that be real time? And would there be any way of tracking people who had scanned out, to keep a count of current attendees?

This presentation
http://www.tessituranetwork.com/tlcc/2014/pdfs/01-o_integrating_third_party.pdf
also seems to mention realtime attendance as a possible third-party messaging possibility, but doesn’t go into much detail. Is there a third-party system that would offer this functionality?

Thanks!,
Daniel.

 

  • Daniel,

    The Attendance by Performance report in Reports/Utilities>Ticketing Box Office is likely your best bet for real-time reporting of attendance figures.

    Alternatively, if it's one performance in Tessitura, you can simply monitor using Season Manager>House View.  (Double click on the performance in the calendar to open up the seat map). As a house is being scanned, it's fun to watch the seats turn green! :) Under the legend, you can also get counts on those who've entered the house, and the count of those who still need to enter.

    Michele

  • Hi Daniel, long time ago I had created a SQL SP to be called by a SQL job at a fixed interval to send out real time statistics via email to the supervisors and Front of House managers who are in charge of the doors and ticket scanning so that they can reassign ushers based on the real time ticket scanning status. The proc just sits there and automatically kicks off one hour (adjustable) before any show start time and continues until 30 minutes (adjustable) after the show start time and send ticket scanning status every 10 minutes (adjustable). The advantage of this proc is you don't have to open Tessitura or any report to see the status. All you need is a smart phone with email access. 

    I had also presented it in one of the Tessitura magic sessions - may be you can still find the notes if you search in Tessitura network site. Or I can just share the code with you, if you are interested.

    Best,

    Mo

    National Ballet of Canada

     

  • Mo, can you forward me a copy as well?

     

    Thanks!

     

    Randall A. Mitchell
    Director of Information Systems | The Phoenix Symphony | Tel. (602) 452-0440 | Mobile. (602) 796-9323 | Fax. (602) 253-1772
    RMitchell@PHOENIXSYMPHONY.ORG | www.phoenixsymphony.org

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Mohiuddin Faruqe
    Sent: Wednesday, January 07, 2015 10:02 AM
    To: Randall A. Mitchell
    Subject: Re: [Tessitura Technical Forum] Realtime attendance monitoring

     

    Hi Daniel, long time ago I had created a SQL SP to be called by a SQL job at a fixed interval to send out real time statistics via email to the supervisors and Front of House managers who are in charge of the doors and ticket scanning so that they can reassign ushers based on the real time ticket scanning status. The proc just sits there and automatically kicks off one hour (adjustable) before any show start time and continues until 30 minutes (adjustable) after the show start time and send ticket scanning status every 10 minutes (adjustable). The advantage of this proc is you don't have to open Tessitura or any report to see the status. All you need is a smart phone with email access. 

    I had also presented it in one of the Tessitura magic sessions - may be you can still find the notes if you search in Tessitura network site. Or I can just share the code with you, if you are interested.

    Best,

    Mo

    National Ballet of Canada

     

    From: Daniel Reid <bounce-danielreid7030@tessituranetwork.com>
    Sent: 12/16/2014 7:53:46 PM

    We are using Tessitura to ticket a large-scale feast event, with capacity (weather-dependant) of up to 10,000 per night - with a combination of presales and door sales.

    Obviously for an event of this scale, crowd management is very complex - especially when it comes to selling door sales without going over capacity. What we really need is a realtime count of constituents currently at the event - eg people who have actually scanned their tickets in (and, if possible, discounting constituents who have scanned back out).

    There is a report that might be useable here:
    http://www.tessituranetwork.com/community/members/annieedlich6977/files/attendance-by-performance-ssrs-report-_2d00_-session-material.zip.aspx
    but would that be real time? And would there be any way of tracking people who had scanned out, to keep a count of current attendees?

    This presentation
    http://www.tessituranetwork.com/tlcc/2014/pdfs/01-o_integrating_third_party.pdf
    also seems to mention realtime attendance as a possible third-party messaging possibility, but doesn’t go into much detail. Is there a third-party system that would offer this functionality?

    Thanks!,
    Daniel.

     




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

    
    
    
    
    
    
    
    
    
  • Hi all,

    Thanks, Michele - sometimes it's just a question of knowing the right place to look (and you're right, the house view is fun to watch).

    Mo, that sounds great - if you could send me the code I would really appreciate it.

    My only question now is about tracking people who have left, during a general admission event - so we have an accurate number of the people currently inside. Is it possible to track that - can people be scanned out? And if so, will these solutions count those?

    Thanks everyone!,
    Daniel.

     

  • Hi Mo,

     

    I would love a copy as well, please.

     

    Thanks,

     

    Laura House, Shared Services Database Manager

    Kauffman Center for the Performing Arts

    1601 Broadway | Kansas City, MO 64108

    direct 816.994.7214 | fax 816.994.9037

    kauffmancenter.org | a non-profit 501(c)3 organization

     

    Description: cid:image001.jpg@01D029CC.C1C0F560

    Enriching the lives of everyone in our community through extraordinary and diverse performing arts experiences.

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Randall Mitchell
    Sent: Wednesday, January 07, 2015 11:24 AM
    To: Laura House
    Subject: RE: [Tessitura Technical Forum] Realtime attendance monitoring

     

    Mo, can you forward me a copy as well?

     

    Thanks!

     

    Randall A. Mitchell
    Director of Information Systems | The Phoenix Symphony | Tel. (602) 452-0440 | Mobile. (602) 796-9323 | Fax. (602) 253-1772
    RMitchell@PHOENIXSYMPHONY.ORG | www.phoenixsymphony.org

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Mohiuddin Faruqe
    Sent: Wednesday, January 07, 2015 10:02 AM
    To: Randall A. Mitchell
    Subject: Re: [Tessitura Technical Forum] Realtime attendance monitoring

     

    Hi Daniel, long time ago I had created a SQL SP to be called by a SQL job at a fixed interval to send out real time statistics via email to the supervisors and Front of House managers who are in charge of the doors and ticket scanning so that they can reassign ushers based on the real time ticket scanning status. The proc just sits there and automatically kicks off one hour (adjustable) before any show start time and continues until 30 minutes (adjustable) after the show start time and send ticket scanning status every 10 minutes (adjustable). The advantage of this proc is you don't have to open Tessitura or any report to see the status. All you need is a smart phone with email access. 

    I had also presented it in one of the Tessitura magic sessions - may be you can still find the notes if you search in Tessitura network site. Or I can just share the code with you, if you are interested.

    Best,

    Mo

    National Ballet of Canada

     

    From: Daniel Reid <bounce-danielreid7030@tessituranetwork.com>
    Sent: 12/16/2014 7:53:46 PM

    We are using Tessitura to ticket a large-scale feast event, with capacity (weather-dependant) of up to 10,000 per night - with a combination of presales and door sales.

    Obviously for an event of this scale, crowd management is very complex - especially when it comes to selling door sales without going over capacity. What we really need is a realtime count of constituents currently at the event - eg people who have actually scanned their tickets in (and, if possible, discounting constituents who have scanned back out).

    There is a report that might be useable here:
    http://www.tessituranetwork.com/community/members/annieedlich6977/files/attendance-by-performance-ssrs-report-_2d00_-session-material.zip.aspx
    but would that be real time? And would there be any way of tracking people who had scanned out, to keep a count of current attendees?

    This presentation
    http://www.tessituranetwork.com/tlcc/2014/pdfs/01-o_integrating_third_party.pdf
    also seems to mention realtime attendance as a possible third-party messaging possibility, but doesn’t go into much detail. Is there a third-party system that would offer this functionality?

    Thanks!,
    Daniel.

     




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

  • You can definitely scan out, but I don't believe that is tracked on House View - at least there's nothing in the legend to indicate.

    I looked in the NScan documentation and found this:

    800x600

    Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4

    NOTE: Scanning a ticket out does not update Tessitura.  The seat is still listed as Entered House. However, there is an N-Scan table which records tickets scanned out and records when the ticket is scanned in again.

    Of course, it doesn't tell you what table that is!

    Michele



    [edited by: Michele Keutsch at 3:45 PM (GMT -6) on 8 Jan 2015]
  • From the documentation:

     

    Scanning a ticket out does not update Tessitura. The seat is still listed as Entered House. However, there is an N-Scan table which records tickets scanned out and records when the ticket is scanned in again.

     

    I don’t know off the top of my head the N-Scan table where tickets scanned out are noted (in case you wanted to think about using it for those custom scripts), but I’m sure support could help point you to it if you open a help ticket.

     

    Kevin Sheehan

    Senior Technical Writer & Consultant

    Tessitura Network

    +1 888 643 5778 x 329

    ksheehan@tessituranetwork.com

     

  • Cheers everyone, that's a great help! I was looking around in Tessitura documentation, not n-scan.

    Thanks all! I'll see what I can put together.

  • Daniel/Randall, sorry for the late reply, I got caught up with few things. I found the mini magic presentation and other docs from the 2011 Mini Magic session and uploaded them to my profile. I wrote the stored procedure in 2008, so it's pretty dated. Anyway I updated it to reflect the new NScan table name. Check the Readme.txt for setup details. Please, feel free contact me if you need any clarification or help.

    Best,

    Mo

    National Ballet of Canada