Hello all,
I'm looking to create a formula that shows what the revenue potential is for remaining seats. The seats in the screenshot below can be across a multitude of price zones/classes. I was initially thinking whatever the seat's home base value is and multiplying the unsold seat by it, but on an aggregate level where I'd also have the entire season's remaining unsold revenue potential in addition to the performance level...
I saw that Chris Wallingford and Heath Wilder discussed something along these lines a few years ago in this thread, but wasn't quite sure if this is what I should be referring to.
(+) Analytics formula help - Reporting & Analytics - Forums - Tessitura Network
Any thoughts are appreciated!
Mike
Could it be as simple as using "Seat Unsold Value"?
Otherwise, CW had a recent post that might help you or at least help potential pitfalls.
(+) Identifying Seat Count - Reporting & Analytics - Forums - Tessitura Network
"From help:
Seat Count: The number of seats (inventory) for a product. Only price layers in the Ticket Price price category are counted for this field. If multiple Ticket Price price layers exist for a performance, the Ticket Price price layer with the min start date and min price layer type rank is counted. If you break out counts by price layer, layers in all other categories will have a count of 0.
One caveat to that is this setting: Include Blacked Out Seats. When set to No (the default) seats that are held with a blackout hold code are not included in Tessitura Analytics. Setting this entry to Yes will include seats held with blackout hold codes in unsold seat counts and capacity calculations. If you include them, you can filter them out with a Hold Code filter on the widget or dashboard that is set to exclude the kill holds.
I would avoid using Ticket Count as a method of counting the sold segmentation of your seat capacity, as a single seat could be sold multiple times (benevolent returns), and a ticket could be unseated and still count toward an overall sold ticket count.
A similar issue can occur with distinct counts of Perf Seat Key, Seat Key, and Seat ID as tickets without seats will still have a placeholder value (e.g. -999999) that will contribute to the overall total unique count of values."
Neil
Hi Neil, I think it could be as simple as that. Where seat unsold value is filtered by seat status.
Using a formula like this filtered on seat status.
([Total Seat Unsold Value], [Seat Status])
Leaving it at default, does work and the unsold amount pretty much lines up with the Tess season manager total unsold amount (knowing there is an overnight lag). Our marketing team was asking about unsold amounts by certain seat statuses in a daily report. I'll probably confer first with our box office staff so what I'm seeing is what they are seeing and start sending this out.
Thanks,
Thanks for letting me know about the Seat Status.
We only want numbers where the status is Available. Your info helps. I did a Filtered Value with the seat status of Available only.
I renamed the Seat Status to "Seat Status = Available". I like doing that for the filtered values so I can easily see how I filtered it.
Now, the only remaining issue is the management going to focus on the revenue taken in or the potential revenue NOT taken in.