Hi all,
My team is currently taking some time to re-evaluate our fee structure and we are running in to some issue in finding the financial/ticketing data we need.
Specifically, what we are trying to do is create a breakdown of the quantity of tickets sold at each gross price point within our web sales. For example, we want to know how many tickets we sell at $35, $36, etc.
We've been able to pull out the quantity of tickets sold at each net price, and make a general estimate of the gross based on how our current fee structure is laid out, but I'm looking for something more specific. Does anyone have a dashboard like this, or any insight onto how to create one?
Thank you.
How about something like this:
A pivot Table, filtered by the season(s) you want to examine, and by the Mode(s) of Sale you want.
Values would be Total Ticket Count, and Rows would be Ticket Paid Amount.
Would that work?
This was originally what I tried as well. We are concerned because this only shows a single price layer and we are looking for something that shows the price layers combined.
Hi Kaity,
You might also look at these fields in addition to [Ticket Paid Amount]
Tessitura v15.1 Help System - Seats and Tickets Cube (tessituranetwork.com) > Seat &Ticket Values dimension
Where this could still trip you up is if you have price layers within these gross values. They'll be broken out into separate rows without some further action in the widget design. You can add a filter one of the available Price Layer fields to just show your Ticket Price layer, if that's sufficient for your needs. If you need to see the gross amount including all layers, then I can follow up with a recommendation.
Cross-posting in a tab that hadn't yet refreshed with this comment.
If you add Zone on rows, and move the Seat Base Value into the Values panel, it'll sum up the base value across all seats in each of those zones. A sort of financial capacity. All seats in a zone have the same home base price, so to get the distinct price of that zone, edit the Seat Base Value value and its formula, and update it to divide by the Seat Count. E.g.
SUM ( [Seat Home Base Value] ) / SUM ( [Seat Count] )
... or it may also appear in your Analytics as
[Total Seat Home Base Value] / [Total Seat Count]
Best,Chris
We are specifically looking for a gross amount including all layers. If you have a recommendation on how to make this happen, it would be greatly appreciated.
See above - thanks!
community.tessituranetwork.com/.../76549