Hi all! I'm looking for a way to pull in bookings to Analytics for tickets that are status SUP. All of our group bookings sit in this status until a few weeks before their visit when they are paid via an invoice payment method, but I want to be able to report on the bookings themselves rather than when they are paid/attend.
I typically use total ticket paid for my sales widgets but I can't quite figure out how to report on tickets that have been seated but not paid or ticketed. I'm sure there is something obvious I'm missing!
Any tips appreciated!
Hello Tash,
I think you'll need to use one of the Unpaid Amounts with a filter of SLI Status of either Seated, Unpaid or Unseated, Unpaid.
Another thing to check is compare the Ticket numbers with what you get when you ask for the # of unique SLI ID. The only reason I mention this is in case you have more than one pricing layer on a performance. The Ticket count will be off, but the # of unique SLI ID would be correct.
I had a situation where there was only a single pricing layer showing within the application, but SSMS indicated that there was more than one. This caused this one performance ticket numbers to be off. I now always compare the two methods to make sure they match.