Hi there! Can anyone help me understand what "Zero Package" is?
I'm looking at the total revenue brought in through subscriptions and there's been some debate back and forth between marketing and finance about whether we should be looking at the Ticket Paid Amount versus the Ticket Original Paid Amount. In building out a pivot to compare the difference I came across the "zero package" that has a massive amount of money floating in it that is SIMILAR TOO but NOT THE SAME as the amount of money in exchanges. Is this real money? Is this money being double counted somewhere? Trying to untangle the web.
If I filter the dashboard by subscription price type and the season, I see this miscellaneous amount of money that I can attribute to "zero package" if I use a package filter. It appears in the pivot table below under "none." But if I filter by subscription price type and the package season, the zero package just doesn't appear.
Zero package is applied to non-package tickets.
Can you explain a little more about that?
Sure: In the database, all sub line items have a perf_no and a pkg_no. If a ticket is sold outside of a package, the pkg_no is set to 0, so I would expect that to be the single tickets sales that match the other filters. So, for instance I can filter on Price Type Category to "Subscription", and then I'll know that all tickets with the 0 package are our "Subscription Add On" price type sales.
Thank you so much for explaining! That makes sense!
You're welcome! There are a few instances of this in the various Analytics cubes: "None" customer for unpurchased seats, for instance.