I'm having trouble getting what I think should be two sets of numbers to equal out. On the one hand I have "Capacity", on other I have Sold, Resold, Comp, Held, and Available, defined thusly:
Capacity
sum([Seat Count])
Sold
( sum([Ticket Count]), [Price Type Category] , [Resale Status1] )
Price Type Category: -Comp
Resale Status1: - Resale
Resold
( sum([Ticket Count]), [Resale Status1] )
Resale Status1: Resale
Comp
( sum([Ticket Count]), [Price Type Category1] )
Price Type Category1: Comp
Held
( sum([Total Seat Count]), [Seat Hold Code] ) - ( sum([Total Ticket Count]), [Seat Hold Code] )
Seat Hold Code: -(none)
Available
sum([Seat Unsold Count]) - ( [Total Seat Unsold Count] , [Seat Hold Code] )
I'm off, but not by much. For example:
[Perf 1]
Capacity: 1732
Sold: 735; Resold: 0; Comp: 74; Held: 641; Available: 283 (Total 1733)
Pretty close, but
[Perf 2]
Capacity: 649
Sold: 611; Resold: 7 (ignore); Comp: 19; Held: 9; Available: 22 (Total 661)
I'm still digging around, but it's not obvious to me where I'm going wrong. An old custom report is closer on these figures: it shows lower sales and higher resold.
Hi Gawain,
Does this take into account allocated seats (if you use that functionality) or tickets that were donated for resale (that hadn't resold)? If not, either of those might explain the discrepancy.
Thanks,Maurice
Hi Maurice!
Good question. The numbers certainly get worse when resales are involved. I'm trying to fix that by filtering out Resale Status = Resale from my Sold numbers. Interestingly, the old report tallies very different resale numbers, but the difference between the two doesn't really match up to the apparent excess in Sold tickets in Analytics.
Okay, well the next step was to just break one performance out by Seat Id. In theory we shouldn't have have too many buckets filled in for any one seat, with the exception of resales.
Now, for starters, it looks like I'm guaranteed to be off by one on every show: and I do see to be off by at least one on every show (based on the the old report at least):
With resales I'm seeing a few, at least, marked as sold and resold (good) and comp, which is curious, but at least I have some seat Ids to research further.
Okay, more details:
So, the two tickets in question that were Resold and Comps were initially resold and then the resold tickets were refunded and exchanged into a comp price type for the customer. I wonder how, logically, I should count such a thing? Is it really a resale if we wound up getting no income from it? We had another similar issue: a ticket was resold, then the resold ticket was refunded (not benevolent), then later that seat was sold to a third customer (albeit at a discounted price type...). I guess that one should definitely still count, since the ticket was eventually sold.
The discrepancy between the Analytics numbers and the old custom report seems fixed: the old report was basically counting each "Payment Paid" T_ORDER_SEAT_HIST row associated with a benevolent return that was resold, which was double and occasionally triple counting the seats depending on how many times it changed hands, so Analytics is more correct there.
That Seat Id 0 "sale" was in fact a rogue unseated ticket floating around, so that's actually expected (I think).