Hotel Booking Lead Time: How to Calculate and Use It

What is booking lead time?

Lead time measures notice. It tells you how far ahead guests commit to a stay.

Example booking	Booked on	Arrives	Lead time
A	1 September	15 September	14 days
B	10 September	15 September	5 days
C	15 September	15 September	0 days

All three guests arrive on the same day. But you had two weeks of notice for one and none for another. That difference is what lead time shows.

Lead time is not the same as length of stay. A guest can book 60 days ahead for one night, or book today for a week. Keep the two numbers apart. Our hotel pricing strategy guide (opens in new tab) uses both.

How do you calculate lead time from your own bookings?

You need two dates for each booking: when it was made and when the guest arrives. Then follow these steps.

Export your bookings for a past period, such as the last 90 days. Include the booking date, arrival date, channel and room type.
Subtract the booking date from the arrival date. That is the lead time for each booking.
Sort into groups, for example 0 to 7 days, 8 to 30 days, and 31 days or more.
Count how many bookings fall in each group. Also count room nights if some stays are long.
Find the median. Sort the lead times from lowest to highest and take the middle one. It is often more useful than the average.

Two rules keep the numbers honest:

Use the original booking date. Not the day someone typed an old booking into a new system, and not the last edit date. If the original date is missing, leave that booking out and note it.
Use one time zone, the property's own. A booking made late at night abroad can otherwise land on the wrong day.

Why the median matters

Take seven bookings with lead times of 0, 2, 4, 5, 6, 8 and 80 days. The average is 15 days. But six of the seven guests booked within eight days. The median is 5 days.

If you plan around the 15-day average, you expect demand two weeks out that never comes. The median and the group counts show the real pattern.

See your bookings by date in the Kiyo demo

How does lead time change by channel and season?

Lead time is rarely one number. It shifts with where guests book and when they travel. Split your results before you act on them.

By channel

Run the same groups for each booking source: each OTA, your website, WhatsApp and walk-ins. You may find that one booking site brings guests weeks ahead while direct and walk-in bookings come in the same week. That changes how you read a quiet calendar. Empty dates three weeks out may be normal if most of your guests book late.

By season

Compare like with like. A busy holiday period and a quiet month fill at different speeds. So do weekdays and weekends. Compare next month with the same month last year, at the same distance from arrival. Ask: "Thirty days before arrival last year, how full were we?" Not: "How full did we end up?"

In Indonesia, long weekends, school holidays and Lebaran often shift booking patterns, so treat them as their own season.

By room type

Family rooms and villas often book further ahead than single rooms. If one room type books early, its photos, prices and terms need to be ready early too.

Keep cancellations visible

Decide what you are measuring: all bookings made, stays that actually happened, or bookings you hold today. Each answers a different question.

Guests who book far ahead may also cancel more. If you quietly remove cancellations, early demand looks safer than it was. Keep a count of cancelled bookings beside each group.

What should you change when lead time gets shorter?

When guests start booking later than before, an empty calendar is not always bad news. Check first, then act on the dates that are behind.

Do not discount the whole month. If guests now book within a week, dates three weeks out will look empty. Compare with the same point last year before cutting prices.
Hold your rate on dates that are on track. If pickup matches last year, keep the price.
Review minimum stays close to arrival. A three-night minimum can block the short, late stays you now get. Our guide to minimum stays and booking gaps (opens in new tab) shows how to relax rules by date.
Check visibility on late-booking channels. If one site brings most short-notice guests, make sure your best rooms are open there.
Use a short-notice offer with care. Booking.com, for example, has Early Booker and Last-Minute deals with their own booking windows. Use them on the dates that are behind, not across the board.
Check how far ahead guests can book. On Airbnb, your availability window sets how many months ahead the calendar is open. If it is short, early bookers cannot find you at all.
Prepare the desk. Same-day bookings leave little time for arrival details. Make sure late arrivals and access questions reach someone who can answer.

When lead time gets longer, flip the logic. Open dates further ahead, set prices early and avoid last-minute discounts you no longer need. For short-notice pricing tactics, see our guide to last-minute hotel rates (opens in new tab).

Review rates by date in the Kiyo demo

Make it a ten-minute weekly habit

Lead time is most useful as a routine, not a one-off report.

Pick the next four to six weeks of arrivals.
Compare current bookings with the same point last year, or with your typical pattern.
Mark dates that are behind, on track or ahead.
Make one decision for the dates that are behind, and write down why.
Check the result next week.

Track occupancy and average rate beside it. Our guide to occupancy, ADR and RevPAR (opens in new tab) explains those numbers in plain terms.

How Kiyo helps you read lead time

Kiyo keeps every booking in one calendar, with the booking source and dates on each one.

Revenue dashboard and rate calendar, on every plan: see bookings, room results and channels in one place, then adjust rates by date.
One calendar for every channel: OTA bookings from 75+ connected channels sit beside direct, phone and walk-in bookings, so your lead-time counts include them all.
AI insights and forecasting, on Pro and Business: forecasts and a daily AI briefing sit next to your booking data.
Business as the full setup: add housekeeping and up to 3 properties when you grow.

Plans start from Rp40k per room per month. See plans and prices (opens in new tab). Kiyo is live and open to all properties. We set it up with you over WhatsApp or a demo call.

Try the Kiyo demo