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!