Hello all!
What I am trying to show: Information based on package sales, such as # of packages, # constituents, # tickets, etc.
What I am having an issue with: # constituents who purchased a package and package counts. The problem arises when I have patrons who purchased a package, but then later ended up exchanging all of their original package tickets to other performances, so now in the package order all of the sub line items have a status of VOO. It would seem that when this happens, I can't use the Package Season filter, because then those packages are no longer included in the counts. Even though the original tickets were exchanged, we still count that patron has having an active subscription and thus they should still be counted. Does anyone else have this problem? How can I still show # patrons that no longer have active tickets from their original package order?
Am I just unable to use Package Season as a filter and have to go by season and price type instead?
Thanks,Sara
Sara, Are you trying to show this information season over season or for just one season?
Probably eventually both, but for now just one season.
Here's a quick dash I pulled for someone the other day - this gives us the number of constituents and it has no impact whether they have exchanged all their tickets or not. I hope it helps!PackageSalesforBrandon.dash
Thanks Madeline! Unfortunately it's that package season filter that's causing the problem. It would seem that for the scenario I referred to where a patron has exchanged all of their package tickets, they are no longer included with package season. I think this is because we use flex packages and we had to make a custom procedure to update package history for the same reason. We saw it as a feature, but it was a defect in v12 that they fixed in v15 that for flex packages, when all the tickets within the package were returned, the package would still show as a line in package history. I suspect the same principle is applied to Analytics as well, but for us we do still want that patron to have that package history record.