This article describes the Reservation by Lead Time Report, which shows how far in advance guests book, grouped by Travel Agent, Company, Booking Source, Rate Type, Res Type or Sub Res Type.
Overview
The Reservation by Lead Time Report provides insights into booking trends within a selected date range.
The report allows properties to analyze guest booking behavior by tracking how far in advance reservations are made prior to arrival.
Reports can be generated based on one of three date filters: Reservation Made Between, Reservation Arriving Between, or Reservation In House Between.
Results can be refined to selected Categories, Companies, Loyalty Membership Types, Travel Agents and Group By options.
Please Note! RMS is highly configurable. Some Terminology, User Access & Permissions, Images, Labels, and Functions used in these articles may differ from your setup. CLICK HERE to find out more.
Use Cases
- Reviewing booking windows ahead of a season - a revenue team runs the report for the upcoming season to see how many days in advance guests are booking, so pricing and marketing campaigns can be timed to the typical lead time.
- Comparing channel performance - grouping by Booking Source or Travel Agent shows which channels bring in reservations early versus last-minute, which is useful when planning promotional spend.
- Investigating a drop in average revenue - comparing Average Revenue and Average Lead Time across Rate Types can highlight whether last-minute rate types are pulling down the average.
How to Access
In the side menu of RMS, go to Reports > Management > Reservations > Reservation by Lead Time.
Report Options
Tip! Report build screens default to a common use configuration, and selections can be made as required.
| Report Option | Type | Default | Description |
|---|---|---|---|
| Date | Date range | Today | The date range the report reads from. Which date field it filters (made, arrival, or in-house) is set by the Reservation Between option below. |
| Reservation Made Between / Arriving Between / In House Between | Radio (one selected) | Reservation Made Between | Determines whether the Date range filters by the date the reservation was made, the arrival date, or the in-house date. |
| Property | Multi-select | All Selected | Limits the report to selected Properties. Only appears on multi-property Enterprise databases. |
| Category | Multi-select | All Selected | Limits the report to reservations in selected Categories. |
| Company | Multi-select | None Selected | Limits the report to reservations linked to selected Companies. |
| Loyalty Membership Type | Multi-select | None Selected | Limits the report to reservations linked to selected Loyalty Membership Types. |
| Travel Agent | Multi-select | None Selected | Limits the report to reservations linked to selected Travel Agents. |
| Report Type | Dropdown (single-select) | Travel Agent |
Groups the report rows by this category. Options:
|
| Sort By | Dropdown (single-select) | Report Type Description |
Sets the row order. Options:
|
| Lead Time Segment (Segment 1-4 from / to Days) | Numeric ranges | 0-3, 4-7, 8-14, 15-28 | Sets the day boundaries for the four Lead Time By Days bands on the report. A fifth band catches any lead time beyond Segment 4's "to" value. |
| Booking Source | Multi-select (More Options) | None Selected | Limits the report to reservations linked to selected Booking Sources. |
| Rate Type | Multi-select (More Options) | None Selected | Limits the report to reservations on selected Rate Types. |
| ResType | Multi-select (More Options) | None Selected | Limits the report to reservations on selected Reservation Types. |
| Sub Res Type | Multi-select (More Options) | None Selected | Limits the report to reservations on selected Sub Reservation Types. |
| Group 1 | Dropdown (single-select, More Options) | Property |
Groups report rows into a first-level total. Options:
|
| Group 2 | Dropdown (single-select, More Options) | None |
Groups report rows into a second-level total, nested under Group 1. Options:
|
| Do Not Show Graph | Checkbox (More Options) | Off | When ticked, hides the bar graph above the data table. |
| Only Show Totals | Checkbox (More Options) | Off | Only applies to a multi-property selection. When ticked, shows only the grand total row instead of a row per property. |
Column Headers
The columns below appear on the report output. Values that depend on a calculation are explained under Data Sources & Calculations.
| Column | Description | Source / Calculation |
|---|---|---|
| Travel Agent / Company / Booking Source / Rate Type / Res Type / Sub Res Type | The category value for the row, named after whichever Report Type option was selected. | Report Type option selected on the Report Options panel. |
| Reservations | Total number of reservations included for the row, within the selected date range. | Count of reservations matching the row's category and the Report Options filters. |
| Nights Booked | Total number of nights booked across the row's reservations. | Sum of reservation nights for the row. |
| Avg LOS | Average Length of Stay for the row's reservations. | See Average Length of Stay, Average Lead Time, and Average Revenue. |
| Lead Time By Days: 0-3, 4-7, 8-14, 15-28, and a final "+" band | Breakdown of how many of the row's reservations fall into each Lead Time Segment band. | See Lead Time By Days. Band boundaries follow the Lead Time Segment values entered on the Report Options panel. |
| Average Lead Time | Average lead time, in days, for the row's reservations. | See Average Length of Stay, Average Lead Time, and Average Revenue. |
| Average Revenue | Average revenue per reservation for the row. | See Average Length of Stay, Average Lead Time, and Average Revenue. |
| Total Revenue | Total revenue for all of the row's reservations. | See Total Revenue. |
Data Sources & Calculations
The following concepts each govern more than one column on the report.
Average Length of Stay, Average Lead Time, and Average Revenue
These three columns are row-level averages, calculated by dividing a row total by the row's Reservations count:
- Avg LOS = Nights Booked ÷ Reservations
- Average Lead Time = the sum of each reservation's lead time (the number of days between the date used by the Reservation Between option and the arrival date) ÷ Reservations
- Average Revenue = Total Revenue ÷ Reservations
Lead Time By Days
Each reservation's lead time is placed into one of the bands set by the Lead Time Segment values on the Report Options panel: four configurable bands plus a final "+" band for any lead time beyond Segment 4's "to" value.
Please Note! A reservation with a negative lead time (made after its arrival date) is counted in the Reservations total but does not fall into any Lead Time By Days band. The Lead Time By Days bands will not always sum to the Reservations total for a row.
Total Revenue
Total Revenue for a reservation covers its entire stay, even if part of that stay falls outside the report's selected date range.
Please Note! Because Total Revenue is calculated across a reservation's full stay, running the report separately for two adjacent date ranges and adding the totals will not always match running it once for the combined range. A reservation that spans both ranges is counted in full in each separate report, but only once in the combined report.
Related Reports
- Reservation Made/Modified Report - lists individual reservations made or modified within a date range.
- Reservation Production Report - shows reservation production trends over time.
- Reservation Position Forecast Report - forecasts future occupancy position based on current bookings.
Related Articles
Comments
0 comments
Please sign in to leave a comment.