• Replies 8 replies
  • Subscribers 701 subscribers
  • Views 172 views
  • Users 0 members are here
Options
Related

Waitlist- AKA Zone history?

Kanani Reichlin
$organization

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?

Parents
  • $organization

    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.

  • $organization in reply to Neil Cole

    Hi Neil and Heath,

    I looked up an order that had been moved from the waitlist zone to the registrant zone and pulled up the contents of t_order_seat_hist and TX_perf_seat for that order.  Unfortunately neither of those tables show the zone history.  Tickets are not issued for classes.

    Any ideas for how I could find a table that has zone history?  I think Heath posted something on finding tables recently and I'll try to find that.  Appreciate your help.

    This is the order in T_order_seat_hist

    and here is the same order in TX_perf_seat

  • $organization in reply to Kanani Reichlin

    give this little number a go if should be enough to get you started (obs edit in your own perf_no etc - that was just my playing)

    Oh, and for all the Table Look up stuff - it's in the Developer Wiki 

    use impresario

Select --*
	a.id
	,a.event_date
	,a.customer_no
	,a.order_no
	,seat_row + ' ' +seat_num
	,d.description as event
	,c.description as zone

from T_ORDER_SEAT_HIST a
JOIN TX_PERF_SEAT b with (nolock)
	on a.seat_no = b.seat_no and a.perf_no = b.perf_no
JOIN V_ZONE_LIST c with (nolock)
	on b.zone_no = c.zone_no
Join TR_EVENT_CODE d
	on a.event_code = d.id
where a.perf_no = 1102
and a.seat_no = 13326
order by event_date

  • $organization in reply to Heath Wilder

    Thanks for the script, Heath! I manipulated it to help make this visualization in Excel.

    I think it'll help justify our level of staffing in our Box Office during our fall evening events. We charged a fee to put the returned amount onto a gift certificate.

    Heath, you never know who you'll inspire. Keep the posts coming.

    Neil

Reply
  • $organization in reply to Heath Wilder

    Thanks for the script, Heath! I manipulated it to help make this visualization in Excel.

    I think it'll help justify our level of staffing in our Box Office during our fall evening events. We charged a fee to put the returned amount onto a gift certificate.

    Heath, you never know who you'll inspire. Keep the posts coming.

    Neil

Children
No Data