Cancellation Lead Time
Overview
Modeled after the Booking Lead Time Analysis this report too provides a detailed view of cancellation lead times across booking windows.
Data Source(s)
-
Historical and On-the-books data from PMS
-
Bookings are Confirmation Numbers received from the PMS E. g 1 unique Confirmation Number = 1 Booking
Calculations
-
Lead Time = Number of Days between reservation Cancellation Date and Arrival Date
-
Average Lead Time = Total Lead Time of Cancellations/ Number of Cancellations
-
Median Lead Time = Middle Value in Sorted List of Lead Times
-
Separates the higher half from lower half, is less affected by outliers than Average
-
-
Cancellation Rate = Canceled Bookings/Total Bookings
-
ADR of Canceled Bookings = Revenue of Canceled Bookings/Canceled Room Nights