N
☀
—°
≈
AQI —
0
Wed 13 May
P
PBS ▾
Snapshot
Directory
Reputation
Journey
Loyalty
Messy data
Findings
From
inquiry
to repeat — every touchpoint, every drop.
AGENT
PLANNED
Concierge Agent
LAST RUN
no runs · agent not registered
SOURCE
reservations
· guest.journey_events
WINDOW
180d
IN-HOUSE
1
guests on property now
CANCEL
31%
282 of 921
EVENTS
0
journey_events logged
Reservation funnel
Stages from reservations.status
Reservations created
Reservations created · 921 reservations · public.reservations
921
Confirmed
Confirmed · 637 reservations · 69.2% of prior stage · public.reservations
637
69% ↓
Arrived
Arrived · 561 reservations · 88.1% of prior stage · public.reservations
561
88% ↓
Departed
Departed · 560 reservations · 99.8% of prior stage · public.reservations
560
100% ↓
Lead-time distribution
booking_date → check_in_date · median 40d · avg 81d
Lead time 0–7d · 189 reservations · 20.5% of 921 · public.reservations
189
0–7d
Lead time 8–14d · 63 reservations · 6.8% of 921 · public.reservations
63
8–14d
Lead time 15–30d · 134 reservations · 14.5% of 921 · public.reservations
134
15–30d
Lead time 31–60d · 168 reservations · 18.2% of 921 · public.reservations
168
31–60d
Lead time 61–90d · 98 reservations · 10.6% of 921 · public.reservations
98
61–90d
Lead time 90+ d · 269 reservations · 29.2% of 921 · public.reservations
269
90+ d
Contact coverage
email + phone on file · marketing-actionable
Email
Email contact · 152 of 921 reservations · 16.5% · public.reservations
17%
152 of 921
Phone
Phone contact · 0 of 921 reservations · 0.0% · public.reservations
0%
0 of 921
921
Reservations
69.2%
Confirm rate
88.1%
Arrive rate
30.6%
Cancel rate
40d
Median lead
2
No-shows
Touchpoints
by stage
0 events · 180d window · channel breakdown
guest.journey_events
No journey events logged yet — pre-arrival emails, post-stay surveys, and SMS will write to
guest.journey_events
once Make scenarios are wired.