I am still dealing with issues from our summer discounts from 6 months ago!
Here is the issue:
To make things easy for our Front Desk this year, instead of doing it all as a Promo/Source Code (like the year before which gave inaccurate numbers because the Front Desk forgot to switch the source code between orders) I created a Discount for the in-person sales and then kept the Promo/Source code for online sales.
This worked great in built out and for our front end; however, because pricing rules/sources and discounts are two completely different things, reporting on them has been a nightmare. I have 2 different widgets set up; one has the discounts, the second has pricing rules. The problem is the Total Attendance is the same for both, but the breakout is different and we don't know why. I don't know if I built the widgets wrong, or if its because I'm trying to get Tessitura to do something it simply won't.
What our org needs: Total number of attendance by Ticket Type for ALL discounts (discounts and pricing rules combined); separated by discount.
So basically I want to combine the two widgets into one clean widget.
Attached is the dashboard file (ignore the comp reason widget, that is completely correct and what we need).
CLM71223-CompReason&Discounts.dash
We don't use discounts (our admission is free), but could you use Mode of Sale to differentiate between the two? Since all discounts were done on site and sources were only used on the web.
The problem is I do not want them separated in this widget. I need the total number of both. The MOS will still separate it.
Example: If we sold 25 CT Summer Free tickets online (using source code), and sold 75 CT Summer Free tickets in-person (using discount), I need the widget to just tell me that we sold 100 CT Summer Free tickets.
Oh! I misunderstood. Can you filter on the amount of the ticket?
What do you mean by "Amount of the ticket"? Like dollar amount?
Yes. If they are all free, can you filter to just tickets that are $0? Or do you have comp tickets too?
That would work except we run multiple $0 campaigns throughout the summer, so I need to know which attendance is attached to which. Currently we run the following: CT Summer Free (July 1-Sept.5), Blue Star Museum (May 20-Sept.5), and a CT Science Center Member Swap (full month of August).
I need to know how many people came in under each thing, even though they are all $0 tickets.