JLK Staff Portal Tour Analytics
📊 Tour analytics
Every metric that matters for the family pipeline — bookings, attendance, waitlist joins, enrolments, drop-off. Read live from the Viewings, Bookings, Waiting List and Children Registry sheets.
Range: —
Where the pipeline leaks. Each bar shows count + conversion % from the previous stage.
Rows that shouldn't stay in this state for long. Fix these first.
| Site | Bookings | Attended | No-shows | Attend rate | Waitlist joins | Enrolled | Book → Enrol |
|---|
Which channels bring families that actually enrol. Focus marketing where the conversion — not the volume — is best.
| Source | Bookings | Attended | Interested (M/H) | Waitlist | Enrolled | Attend → Enrol |
|---|
Tour lead performance — attendance rate + interest read. Useful for coaching, not a leaderboard.
| Guide | Tours led | Attended | High/Med interest | Waitlist joins | Care-plan use |
|---|
Time-to-enrol · deposits · projected revenue · Net Promoter Score (once review-ask captures a rating).
Whether the warm-up call is being made — and whether it moves the attend rate. Called-and-spoke should crush no-called by 20+ points.
| Call status | Tours | Attended | Attend rate | Uplift vs baseline |
|---|
Baseline = the "Not attempted" row. Positive uplift is the lift the call gave us.
Predicted attend probability for each booking in the next 30 days — based on the historical attend rate for that site × referral source. Grey rows have too little history for a confident prediction (falls back to overall attend rate).
| Tour date | Family | Site | Source | Predicted attend | Confidence |
|---|
Use this to pre-warm no-show follow-ups: for anyone below 60%, send a warm confirmation text 24hrs before the tour.
Recognition, not ranking. Celebrates the practitioners who are quietly running the family pipeline well.
Last 6 months of bookings, attendance, no-shows, enrolments.
| Month | Bookings | Attended | No-shows | No-show % | Waitlist | Enrolled |
|---|