Hey all,
I've read the help definitions of Total Ticket Paid/Reserved and Ticket Count. When I populate both in my dashboard, they both return the exact same number of seats. What's the difference between the two? I do see that Ticket Paid/Reserved Count makes mention that "...tickets are identified based on a Ticket Measure (hyperlink) value of Paid or Reserved". Is this coming from SLIs or not? I also see that Ticket Count states - the number of tickets (SLIs). I'm just really confused as to what does what where and why.
As a side note, I think some time needs to spent definitions of all the ticket count data elements and what they really do and where they pull their data and perhaps renaming them so they make sense. I've put all of them in a pivot table to see...and literally the numbers are not that different across all the data element types, whether is a ticket count or a paid amount total. Just my two cents.
- Chris
Hi Chris,
Happy to help. I’m going to refer to the existing Seats and Tickets Cube Field Definitions documentation, which is probably what you already read. I see that a number of the definitions say “(SLI)” or “(SLIs)” at the end and I think that’s a little confusing. All of the “Ticket…” values are SLIs, which it says at the top, but a few of them then restate “(SLI)” explicitly as though to say that those that don’t say “(SLI)” are somehow not. I’ll look at getting that cleaned up a bit. On then to your specific question about the [Ticket Count] vs [Ticket Paid/Reserved Count]…
The [Ticket Measure] field is a grouping of SLI Statuses. Statuses for, “Unseated, Paid”, “Seated, Paid”, “Ticketed, Paid”, and “Return in Benevolent Mode” all have a [Ticket Measure] value of “Paid”. The “Reserved” [Ticket Measure] value is a grouping of “Unseated, Unpaid” and “Seated, Unpaid”. However, regardless of the SLI Status, if the ticket is a Comp, then the [Ticket Measure] is “Comp”. So in essence, every ticket will be flagged up as either Paid, Reserved, or Comp under the [Ticket Measure] field.
From there, the values for [Ticket Paid Count] is the count of tickets with a [Ticket Measure] of “Paid”, [Ticket Reserved Count] is the count of tickets with a [Ticket Measure] of “Reserved”, and [Ticket Paid/Reserved Count] is the sum of the two. We can also refer to that as a count of tickets excluding Comps. There is also a [Ticket Comp Count] value. Finally, the [Ticket Count] value you referred is all of these together, so we should generally see that [Ticket Paid Count]+[Ticket Reserved Count]+[Ticket Comp Count] = [Ticket Paid/Reserved Count]+[Ticket Comp Count] = [Ticket Count].
Best,Chris
Thanks for this detail Chris. This is actually really helpful in understand the data elements. I would personally love this level of detail as definitions of the ticket count and amount/revenue ticket measures.