Ticketing Gross Price Dashboard

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.

Parents
  • Hi Kaity,

    You might also look at these fields in addition to [Ticket Paid Amount]

    • [Seat Home Base Value]
    • [Seat Order Date Base Value]
    • [Seat Current Base Value]

    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.

Reply
  • Hi Kaity,

    You might also look at these fields in addition to [Ticket Paid Amount]

    • [Seat Home Base Value]
    • [Seat Order Date Base Value]
    • [Seat Current Base Value]

    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.

Children