How would I go about pulling the median ticket price for last year?
Exporting it to Excel is fine, but where do I pull the price of every ticket?
Thanks
My thought was to go into the Seat Cube and pull in the Fiscal Year and Per Ticket Price under Categories and then pull in Paid Num and Paid Val and then based upon the Paid Num find the Median Val where 50% of the number of tickets are on either side of that number of tickets. If you want to see Avg Price instead that is a measure as well. Those are my two cents. Nicole From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Tom Brown Sent: Monday, February 08, 2016 4:29 PM To: Nicole Keating <nkeating@arshtcenter.org> Subject: RE: [Tessitura Ticketing Forum] Median Ticket Price Importance: High Nicole, My understanding is that T-Stats will give average (or mean) a useful measure of central tendency. Particularly if your ticket prices follow a standard distribution. However, the median is another useful description of central tendency. The challenge with median is that one needs to know the ticket prices at the individual ticket level, (the sli level) to calculate a median. I thought about suggesting the order export utility or the ticket sales by period report. However, these reports summarize multiple tickets to same performance and price type into a single row of data. The T-Stats underlying TICKET_FACT table does the same thing. I guess if one wanted to figure out a way to de summarize these data items. You could get to mean. That said if I were to try to do this here at BAM I’d likely use the Ticket_detail_fact table in the T-Stats Server which does provide a detailed set of seat details. However it provides too much detail because it is designed to talk to the seat level whether sold or unsold. From the Ticket_detail_fact table someone would have to carefully sort out unsold inventory. You would have to filter unsold seats from this. You would have to decide what you want to do with Comps and some other things. However from this you could calculate a median. However we are talking about a lot of data. The tools that I just used for this were PowerQuery & PowerPivot in Excel. This assumes that you are not on RAMP and can get to the underlying tables in the TSTATS database on your T-Stats Server. I hope that someone has an easier answer. --Tom … 718.724.8135 tbrown@BAM.org From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Nicole Keating Sent: Monday, February 08, 2016 3:36 PM To: Thomas Brown <tbrown@bam.org> Subject: RE: [Tessitura Ticketing Forum] Median Ticket Price Do you use T-stats? From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Nick Torres Sent: Monday, February 08, 2016 2:53 PM To: Nicole Keating <nkeating@arshtcenter.org> Subject: [Tessitura Ticketing Forum] Median Ticket Price Importance: High How would I go about pulling the median ticket price for last year? Exporting it to Excel is fine, but where do I pull the price of every ticket? Thanks 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! 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!
My thought was to go into the Seat Cube and pull in the Fiscal Year and Per Ticket Price under Categories and then pull in Paid Num and Paid Val and then based upon the Paid Num find the Median Val where 50% of the number of tickets are on either side of that number of tickets. If you want to see Avg Price instead that is a measure as well.
Those are my two cents.
Nicole
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Tom Brown Sent: Monday, February 08, 2016 4:29 PM To: Nicole Keating <nkeating@arshtcenter.org> Subject: RE: [Tessitura Ticketing Forum] Median Ticket Price Importance: High
Nicole,
My understanding is that T-Stats will give average (or mean) a useful measure of central tendency. Particularly if your ticket prices follow a standard distribution. However, the median is another useful description of central tendency. The challenge with median is that one needs to know the ticket prices at the individual ticket level, (the sli level) to calculate a median.
I thought about suggesting the order export utility or the ticket sales by period report. However, these reports summarize multiple tickets to same performance and price type into a single row of data. The T-Stats underlying TICKET_FACT table does the same thing. I guess if one wanted to figure out a way to de summarize these data items. You could get to mean.
That said if I were to try to do this here at BAM I’d likely use the Ticket_detail_fact table in the T-Stats Server which does provide a detailed set of seat details. However it provides too much detail because it is designed to talk to the seat level whether sold or unsold. From the Ticket_detail_fact table someone would have to carefully sort out unsold inventory. You would have to filter unsold seats from this. You would have to decide what you want to do with Comps and some other things. However from this you could calculate a median. However we are talking about a lot of data. The tools that I just used for this were PowerQuery & PowerPivot in Excel. This assumes that you are not on RAMP and can get to the underlying tables in the TSTATS database on your T-Stats Server.
I hope that someone has an easier answer.
--Tom
…
718.724.8135
tbrown@BAM.org
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Nicole Keating Sent: Monday, February 08, 2016 3:36 PM To: Thomas Brown <tbrown@bam.org> Subject: RE: [Tessitura Ticketing Forum] Median Ticket Price
Do you use T-stats?
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Nick Torres Sent: Monday, February 08, 2016 2:53 PM To: Nicole Keating <nkeating@arshtcenter.org> Subject: [Tessitura Ticketing Forum] Median Ticket Price Importance: High
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!