Hi All,
I'm trying to get at data for our waitlisted students. Our waitlist is a zone in the same performance/facility where they would be moved to if they get off of the waitlist. Is it possible to get at the zone data if the patron is no longer in that zone? Such as people who got off of the waitlist.
Some additional information: The household is the owner of the order and the student is the recipient of the line item (class/performance)
Some of the questions our MD is trying to answer:
what % of ppl who join the waitlist go on to be offered a spot.What % end up registering for a class after being on the waitlist. The avg wait time between joining the waitlist and being offered a spot. What is the % of ppl who join the waitlist and are then never offered a spot? What happens to them in the future? Do they stop trying to register for SCT classes?
Off the top of my head, I'm guessing you'll need access to SSMS. Specifically, data from T_ORDER_SEAT_HIST, unless the system issued a ticket number. If it issued a ticket number, then you would have additional options.
Another idea is using TX_PERF_SEAT data. It has order_no, customer_no, perf_no, zone_no, zmap_no, seat_status, and prior_seat_status.
Thanks, Neil for that table info. I have the SQL skills to get that data from the table, but I'm afraid I wouldn't know how to compare it to anything else in a meaningful way. But I'll give it the ol college try and see what if anything I can come up with.
I've got TLCC Sydney on at the moment but if you need a hand digging into T_ORDER_SEAT_HIST I've done it before (thanks Covid)