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.