Hello my Tessitura friends. Hope everyone had a spectacular holiday!
Our new AD has requested a plethora of data on tickets sales and I'm having a bear of a time finding an elegant way to pull it without having to pull hundreds of individual reports and drop everything into Excel or is that the only way?
Also, we're in a consortium and do not have access to tables.
I have a bit of a concern using T-Stats because the data is aggregate and never matches ticket reports.
He is specifically looking for:
Sales / Percentage Data for All Ticket Prices - We're trying to find which price does best. Do lower prices sell better? We're looking for percentages across sales by ticket price i.e., what ticket price accounts for the highest percentage of sales? This would not be revenue but numbers of tickets sold.
Average Ticket Price per Genre? - I've not been able to find anything here.
I can get all the above from box office statements given I need each ticket price but this would require pulling thousands of reports and weeks of data entry. Any insight would be greatly appreciated!
Hi Michelle, I just sent you an email with some thoughts about how you might get to these answers! Hopefully some others will chime in as well. --Stacey From: Michelle Wiesel <bounce-michellewiesel7133@tessituranetwork.com> Sent: 12/28/2015 2:45:21 PM Hello my Tessitura friends. Hope everyone had a spectacular holiday! Our new AD has requested a plethora of data on tickets sales and I'm having a bear of a time finding an elegant way to pull it without having to pull hundreds of individual reports and drop everything into Excel or is that the only way? Also, we're in a consortium and do not have access to tables. I have a bit of a concern using T-Stats because the data is aggregate and never matches ticket reports. He is specifically looking for: Sales / Percentage Data for All Ticket Prices - We're trying to find which price does best. Do lower prices sell better? We're looking for percentages across sales by ticket price i.e., what ticket price accounts for the highest percentage of sales? This would not be revenue but numbers of tickets sold. Average Ticket Price per Genre? - I've not been able to find anything here. I can get all the above from box office statements given I need each ticket price but this would require pulling thousands of reports and weeks of data entry. Any insight would be greatly appreciated! 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!
Hi Michelle,
I just sent you an email with some thoughts about how you might get to these answers! Hopefully some others will chime in as well.
--Stacey
From: Michelle Wiesel <bounce-michellewiesel7133@tessituranetwork.com> Sent: 12/28/2015 2:45:21 PM