Hi Folks,
Just thought I'd share my Seat Availability Dashboard some of which I briefly presented on at TLCC. The top bit of it is a Chris Cuhel special - his Dynamic Pricing board.
The availability widget has a lot of neat formulas that Chris Wallingford helped me with including filters and conditional statements. Discussion of the Conditional Statement in hte final column can be found here
There is also an example and a link to instructions for a barchart triggered Pulse Data Alert for when your availability drops and you want the dashboard to email you.
If you need a help with any of it please ask.
3107.SDC_S2Availability.dash
This is great Heath! Thank you so much for sharing! I haven't worked too much with heat maps, could you possibly explain what I'm looking at? Is it pretty much just showing which seats are more popular across performances selected in the widget?
That's exactly it. Similar to the JCA heat map in the old dashboards from v12. Youll see 'cold' areas in places you have recurring offsale holds like House seats
I can't take creighton fit the hear map and the dynamic pricing grid which are originally from Dr Christopher Cuhel
And I can't take credit for the heat map. That is a creation of The Right Honorable Chris Wallingford
So I am trying to use this for a merchandise performance (uniform sales) and sadly all the Counts are coming up ZERO... any thoughts?
Is any of the pricing for the merchandise performance set up on a "Ticket Price" price category price layer?
They are not in Ticket Price category - but the Analytics Ind box is checked for the Merchandise Price Category.
I think they have to be in Ticket Price, pricing layer, for Analytics to recognize them currently.
Work around for this you might try, using COUNT ([SLI ID]) or [# unique SLI ID]
OK - I can get what is sold - but what about available? looking for available inventory
Yeah...that's a tough one because unsold GA is grouped together into a single row a placeholder Seat Key and a >1 Seat Count that represents that total inventory, but without a Ticket Price layer, it's not giving it to you. And with only a single row and placeholder SLI ID, you aren't getting the expected count back for unsold seats.
Are we talking about a one-off thing here or several things all with the same total inventory before sales? If so, you could hardcode the inventory into an Available formula that's like e.g. 1500 - [# unique SLI ID].
Another thing we recommend at times is to put a $0 Ticket Price layer on the pricing setup. Then the counts will start showing up in Analytics.
Thanks Chris Wallingford - I have zones by size so likely need to setup the $0 ticket Price Layer.
Is this something that is going to be fixed in the future?
Hi Mary,
Yes, it's on the list to figure out how to support that.