• Replies 6 replies
  • Subscribers 413 subscribers
  • Views 84 views
  • Users 0 members are here
Related

Total Seats Report

Christopher Cuhel
$organization

Hello Everyone,

Our venue is wondering if there is a report in Tessitura that can be run to tell you how many seats are in each price level. I know there are availability reports, but he is just wanting to know a total number of seats in each price level.

Any thoughts?

Chris

  • $organization

    Do you have Tstats? Seems like you could do that in the seats cube.

  • $organization

    I have T-Stats but our venue does not.

     

    Christopher Cuhel, Patron Services Manager

    First Stage

    Transforming Lives Through Theater

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Amanda Freeman
    Sent: Friday, October 21, 2011 2:10 PM
    To: Christopher Cuhel
    Subject: Re: [Tessitura Ticketing Forum] Total Seats Report

     

    Do you have Tstats? Seems like you could do that in the seats cube.

    From: Christopher Cuhel <bounce-christophercuhel9903@tessituranetwork.com>
    Sent: 10/21/2011 1:59:46 PM

    Hello Everyone,

    Our venue is wondering if there is a report in Tessitura that can be run to tell you how many seats are in each price level. I know there are availability reports, but he is just wanting to know a total number of seats in each price level.

    Any thoughts?

    Chris




    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 Christopher Cuhel

    Christopher -

    I'm not exactly sure how they want it (i.e. multiple shows/across venues/etc) but you can easily see the information you are looking for (I think) by going into Season Manager -> House View and selecting Seat Map view for a performance. If you click on the Price Zones tab and then Price Zones Legend it will show you the seat breakdown by Price Zone in there.

    Is that sort of what you are looking for?

    - Heather

  • $organization

    That should work. Thanks Heather. I remembered seeing it somewhere, but it’s Friday and my brain is powering down for the weekend.

     

    Christopher Cuhel, Patron Services Manager

    First Stage

    Transforming Lives Through Theater

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Heather Kraft
    Sent: Friday, October 21, 2011 2:20 PM
    To: Christopher Cuhel
    Subject: RE: [Tessitura Ticketing Forum] Total Seats Report

     

    Christopher -

    I'm not exactly sure how they want it (i.e. multiple shows/across venues/etc) but you can easily see the information you are looking for (I think) by going into Season Manager -> House View and selecting Seat Map view for a performance. If you click on the Price Zones tab and then Price Zones Legend it will show you the seat breakdown by Price Zone in there.

    Is that sort of what you are looking for?

    - Heather

    From: Christopher Cuhel <bounce-christophercuhel9903@tessituranetwork.com>
    Sent: 10/21/2011 2:13:01 PM

    I have T-Stats but our venue does not.

     

    Christopher Cuhel, Patron Services Manager

    First Stage

    Transforming Lives Through Theater

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Amanda Freeman
    Sent: Friday, October 21, 2011 2:10 PM
    To: Christopher Cuhel
    Subject: Re: [Tessitura Ticketing Forum] Total Seats Report

     

    Do you have Tstats? Seems like you could do that in the seats cube.

    From: Christopher Cuhel <bounce-christophercuhel9903@tessituranetwork.com>
    Sent: 10/21/2011 1:59:46 PM

    Hello Everyone,

    Our venue is wondering if there is a report in Tessitura that can be run to tell you how many seats are in each price level. I know there are availability reports, but he is just wanting to know a total number of seats in each price level.

    Any thoughts?

    Chris




    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!

  • Former Member
    Former Member $organization

    Hello Chris, are you looking to get something like this below?

    Perf_No Perf_name Perf_Dt Zone Section txSeats Seat_Status
    C RES Total 1
    1 Available Total
    C RES Total 85
    85 Blacked Out Total
    A RES Total 10
    C RES Total 3
    PREM Total 22
    Stand Total 22
    57 Held Total
    PREM Total 1
    1 Reserved, Paid Total
    PREM Total 2
    2 Reserved, Unpaid Total
    A RES Total 792
    B RES Total 476
    C RES Total 588
    D RES Total 81
    PREM Total 622
    2559 Ticketed Total
    2705 Grand Total

    cheers

    Varsha

  • $organization in reply to Former Member

    Hello varsha,

        I am looking for a similar report to get total capacity . capacity sold & total sales on each zone. you have any sql . Thanks