Lead time data is now available in the Demand360 topic, showing how room nights are distributed across booking windows for your property and your competitive set. This article covers what the data includes, how to use the pre-built sample query, and how to build a custom lead time mix visualization.
What is lead time data?
Lead time is the number of days between when a booking is made and the arrival date. The lead time mix shows what percentage of room nights were booked within each lead time window, helping you understand whether demand is building early or skewing toward last-minute bookings — and how that compares to your comp set.
Lead time data in Demand360 is available for both your property (Subscriber) and your competitive set (Comp Set), across six buckets:
Bucket | Booking window |
Same Day | Booked on the day of arrival |
1–3 Days | 1 to 3 days before arrival |
4–7 Days | 4 to 7 days before arrival |
8–14 Days | 8 to 14 days before arrival |
15–30 Days | 15 to 30 days before arrival |
31+ Days | More than 31 days before arrival |
Each bucket has two measures available for both Subscriber and Comp Set:
Room Nights — the count of room nights booked within that lead time window
Room Night Percentage (RN%) — room nights for that bucket as a share of total room nights sold, expressed as a percentage. The six buckets sum to 100%.
Same Time Last Year (STLY) variants are also available for both measures.
Using the sample query
A pre-built Lead Time Mix Analysis sample query is available in the Demand360 topic. It shows a grouped bar chart of RN% by lead time bucket, with your property and comp set displayed side by side.
To access it:
Open the Demand360 topic.
Select Sample Queries from the top of the topic view.
Choose Lead Time Mix Analysis.
The chart opens ready to use. Apply a Stay Date Range filter to focus on the period you want to analyze.
Building the lead time mix chart yourself
If you want to customize the visualization — adjust the date range, add STLY comparisons, or embed it in a dashboard — you can build it from scratch. The video below walks through the full process, and the steps are documented underneath.
Note: The data structure behind lead time is different from most other D360 data. Each bucket is a separate measure rather than a filterable dimension, which requires a few extra steps to get the chart format right. The process is more involved than a typical query setup but only needs to be done once per workbook.
Step 1 — Select the lead time measures
Open the Demand360 topic and start a new workbook. From the field picker, add the following measures:
Subscriber (your property)
Same Day RN%
1–3 Days RN%
4–7 Days RN%
8–14 Days RN%
15–30 Days RN%
31+ Days RN%
Comp Set
Same Day RN%
1–3 Days RN%
4–7 Days RN%
8–14 Days RN%
15–30 Days RN%
31+ Days RN%
Apply a Stay Date Range filter to the period you want to analyze. Run the query. You should see a table with 12 columns of percentages.
Step 2 — Swap rows and columns
Select Swap Rows and Columns from the table options. This pivots the table so each measure becomes its own row, with a single column containing all the RN% values.
Step 3 — Rename the value column
The auto-generated column containing the RN% values will have a system name. Rename it to something descriptive — for example, RN Percentage or rnPercent. This column will become your chart's Y-axis.
Step 4 — Add a "Type" calculated column
Add a calculated column and name it Type. This column will identify whether each row belongs to your property or the comp set.
For each row, manually type the value that applies:
Rows for Subscriber measures → type Subscriber
Rows for Comp Set measures → type Comp Set
This step is manual. Work through each row and enter the correct label. Once saved, this does not need to be repeated.
Step 5 — Add a "Lead Time Bucket" calculated column
Add a second calculated column and name it Lead Time Bucket. This column will be the X-axis of the chart.
For each row, manually type the label that matches the measure:
Same Day RN% rows → type Same Day
1–3 Days RN% rows → type 1–3 Days
4–7 Days RN% rows → type 4–7 Days
8–14 Days RN% rows → type 8–14 Days
15–30 Days RN% rows → type 15–30 Days
31+ Days RN% rows → type 31+ Days
Step 6 — Configure the chart
Switch to the Chart view and configure:
Setting | Value |
X-axis | Lead Time Bucket |
Left Y-axis | RN Percentage (the column from Step 3) |
Color / Legend | Type |
Recommended formatting:
Rotate X-axis labels to -45 degrees for readability
Place the legend in the upper right
Format the Y-axis as a percentage
The result is a grouped bar chart showing RN% by lead time bucket for your property and comp set side by side.
Things to know
Revenue-related KPIs are not available for lead time. ADR, RevPAR, and revenue measures are not included in lead time data — for either your property or your comp set. For the comp set, this follows the same anti-competitive rules that apply across Demand360: Amadeus does not share comp set revenue data. For your own property, this data is also absent: Amadeus does not provide subscriber revenue data as part of the lead time feed. Lead time analysis is Occupancy and Room Night Percentage only.
Lead time is a measure, not a dimension. You cannot filter the topic by lead time bucket the way you filter by segment or channel. Each bucket is its own measure. This is a characteristic of how the data arrives from Amadeus.
AI Agent may display a different visualization. When asking the Insights AI Agent about lead time data, it may return a markdown visualization or table rather than the bar chart. The sample query is the most reliable way to view the visualization.
For more about the Demand360 topic, see Benchmarking (Demand360). Questions? Click the ? icon at the bottom of the left-hand menu.