Can anyone tell me of a way to set up a daily email report or notification of event sell outs? Does such a thing exist? Is it possible?
UPDATE ON 9/10/19: Thanks to everyone's help, I broke out each venue into its own view and set a threshold of 100 tickets unsold. I'm still unable to create a pulse, even with the bar chart view (as opposed to the table view I had originally.) I don't have the three stacked bars in my widget, only three stacked dots. I really want to create an email alert for when events drop below the 100 seat threshold. Help?
Are you on v15 of Tessitura, to have access to Analytics?
If so, you'll want to use the Pulse option, and set pulse alerts to mail out to the relevant parties once the condition you set is met.
Hi Tim, I am! I am also a novice to it. I took the hands-on learning at TLCC but I don't think we went through anything like this. Do you happen to know the criteria sets I might need to use?
Sure.
So, I went into a dashboard and went to Create New Widget, then Advanced Configuration at the bottom. I went ahead and set up an Indicator, as this should just be an integer track, I imagine.
For the Value, I picked anything at all, then hit the pencil icon to get to edit the formula directly. I filtered on the word Count, and found Total Seat Unsold Count. Based on how you exactly sell, you might want to do Total Seat Count - Ticked Sold Count - Ticket Comp Count, or look into Ticket Sold/Reserved Count or something similar. But you basically want this widget to display your seats-left-available.
You may want to add a Widget Filter to the specific performance, if you have multiple performances you're trying to do this for and don't have a separate dashboard for each.
Next, you want to hit the three dots on the upper right hand part of the completed Widget and select Add to Pulse.
It defaults the notification criteria to Threshold, which we want to keep, but we want to adjust the Threshold Report from Greater Than to Equals, and set the value to 0.
There are a few places that I didn't go into detail that could still be tricky with this, especially around isolating your still-available seats. It may be easier (especially in a General Admission situation) to instead track Total Ticket Sold Count and then add your Comps and Reserves (if you use those), and set your Threshold on the Pulse to Greater Than whatever your maximum seats is. Either approach should work.
Please feel free to reach out if you have any more questions.
Oh my gosh, thank you so much for this! I never would have figured this out!
I've created my table but I can't add it to a pulse. Do you know if only certain kinds of widgets or views can be added? Here is a screenshot.
AND
Staci Stickovich
I've not used Pulse before. I'm only seeing Pulse as an option on the "Indicator" type of widget only. Pivot tables don't seem to have this option on my V15.0.4 system.
I'm wondering if the approach is to build an indicator that shows the number of existing "Sold Out Shows" Then setup Pulse to report changes in these values. You would still have to bring up the dashboard to see which performance changed. Just a thought.
Hi Staci. As Tom says (and Tim shows in his screeny) you need and Indicator (or a bar chart with threshold which might be better for your multiple performances) widget to trigger it when you get to a certain number.There are a couple of different alerts in Pulse - Data alerts are the ones you need and the guide for that is below
https://www.tessituranetwork.com/Help_System_v151/Content/Tessitura%20Analytics/Pulse/Data%20Alerts.htm
What I found interesting is this ...
For each type of widget you can monitor a single value. For example, for Column charts you can monitor a single section (value) of a column. To monitor multiple values, you can add each value you want to monitor to Pulse separately.
So what that would mean is that for each performance I think you would need to add a new value to pulse - ie: a new indicator/barchart threshold for each performance.Hope that helps
H
Thanks Heath! The problem I'm running into is that we have so many events (4 performance venues and a cinema) so the bar chart is just too messy to show the over 100 events currently on sale. In my limited knowledge, I'm not sure how to create a chart that filters only the events approaching sell out since each venue has a different threshold.
As I type, I'm wondering if I need to create separate dashboards for each venue although I'm not sure if that is possible. I will have to play around with it some.
Staci, I'm still new to Analytics as well but I think I can help with this part. Check out the documentation on widget filters, especially value filters: https://www.tessituranetwork.com/Help_System_v151/Content/Tessitura%20Analytics/Designing%20Dashboards/Adding%20a%20Widget%20Filter.htm
If you decide on a threshold of "close" to sold out (say you have a 2500 seat venue, your threshold might be 2000 seats sold), I think you should be able to filter to only see shows above that threshold and thus are close to being sold out. If your venues vary wildly in size, I do think a different widget for each venue might be useful so you can have different thresholds. You should be able to add a filter by Facility as well to limit your widget to a specific venue if that's the route you use. (Plus you can duplicate a widget within your dashboard so you just have to adjust the filters once you get a single widget working well).
Something that I really love in pivot tables is the data bars option, which might make it visually easier to see which shows are super close to selling out.Have fun exploring Analytics!
Hi Maery! Adding the threshold and breaking each venue into it's own view helped a lot! Thanks for the tip!