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.
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