When do guests book your hotel?

Define the two dates before calculating

For one reservation, subtract the booking date from the arrival date. A reservation made on 1 September for arrival on 15 September has a lead time of 14 days. A booking made on the arrival date has zero days of lead time.

The three guests arrive on the same date, but the hotel had very different amounts of notice. This is the distinction the weekly review needs.

Use dates in a consistent property timezone. A late-night reservation can fall on a different calendar date elsewhere. For a hotel in Bali, an analysis based on the property's local dates avoids shifting the booking simply because a guest or export uses another timezone.

The booking date must mean when the reservation was originally made. It is not necessarily when staff entered it into a new system, imported it, or last edited it. A historical booking typed in yesterday did not become a one-day advance booking.

If the original date is missing, mark it missing. Do not quietly substitute a record-creation date without checking what that field means. The resulting number may look precise while describing the wrong event.

This makes lead time a different measure from length of stay. A guest may book 60 days ahead and stay one night, or book today and stay a week. The hotel pricing strategy guide needs both kinds of context, but they should not be mixed.

Compare stays that had the same chance to sell

A full week that already happened is not a fair comparison with a week still six weeks away. The future week has not yet passed through all its booking opportunities.

Instead, ask what a similar period looked like at the same distance before arrival. If you are reviewing the next holiday period 30 days ahead, compare it with a genuinely comparable period when it was also 30 days ahead, where you have that history.

Keep weekday patterns, season, room type, and unusual events in mind. A weekday business stay and a holiday villa booking may have different decision timing. Do not assume a single average represents both.

If you do not have historical snapshots, say so. Completed booking dates can describe past lead times, but they do not automatically reconstruct everything the hotel knew on a previous review date. Cancellations and modifications can change that picture.

Kiyo's booking calendar can help the team see the current recorded stays and available room context. Direct and manual bookings must be recorded, and OTA reservations depend on active mapped connections. That gives the weekly discussion an operating base without pretending incomplete historical data is a forecast.

Use a few groups your team can understand

Start with a small set of lead-time groups and keep the definitions consistent. The following bands are a working example, not an Indonesian hotel benchmark:

Choose different boundaries if your own booking pattern justifies them. Keep the original definitions in the notes when you change them so the next comparison remains understandable.

Count bookings and room nights separately. A long-lead group containing one large multi-room stay can dominate room nights without representing how most individual guests book. Average booking value is another separate view.

For an independent property with limited data, a clear count is often more useful than a complicated chart. Show how many valid bookings are in each group and how many were excluded because dates were missing or unclear.

Look beyond the average

Consider these fictional lead times for seven bookings: 0, 2, 4, 5, 6, 8, and 80 days. Their average is 15 days, but six of the seven bookings were made within eight days of arrival.

The middle value, or median, is five days. Neither measure is dishonest; they describe different aspects of the same small group. The unusually early booking pulls the average upward.

If the owner uses only the 15-day average, they may expect most demand to be visible two weeks ahead. The individual values tell a different story. That is why the count and spread matter alongside the average.

This example is arithmetic, not a recommendation to wait until the last week before acting. The property still needs to examine which dates are weak, what rooms remain, and whether the pattern repeats across enough comparable stays.

Use the occupancy and pricing discussion to frame an actual decision. Lead time provides timing context; it does not set the correct room price by itself.

Keep cancellations and changes visible

Decide whether you are studying all bookings made, currently active bookings, or stays that actually occurred. Each answers a different question.

All bookings can help describe when reservations were initially created. Stayed bookings help describe realised demand. Active future bookings describe what the hotel currently holds. None is a substitute for the others.

A group that books far ahead may also cancel or change plans before arrival. If you remove those cancellations without saying so, the analysis may make early demand look more dependable than it was.

Date changes also need a consistent rule. For example, you might measure original booking date to final arrival date for stayed bookings, then keep changes flagged. That is a chosen method, not proof of what a guest originally intended.

Do not silently replace an original booking date with the last modification date. If the available record cannot support the chosen definition, exclude it from that calculation and keep the limitation visible.

Give the weekly meeting one useful outcome

Choose a future arrival period, look at the current bookings, and compare the relevant historical pattern. Then identify one decision the team can make now.

If a date is approaching the short-lead window with more unsold rooms than usual, review the offer and visibility for that specific date. If the property tends to receive later bookings, do not automatically apply a broad discount months in advance because the calendar is not yet full.

If long-lead bookings account for a meaningful share of a particular room type, keep its information and terms clear early enough for those guests. If a channel mainly contributes closer to arrival, consider that timing when reviewing its value.

These are hypotheses to test against your records. Do not attach a guarantee to a lead-time pattern. Flights, events, competing supply, or changes in the property's own offer may alter guest behaviour.

Use Kiyo's Revenue Analytics to examine the recorded room and channel results beside your date calculation. If short-notice demand usually buys a particular room type, check that room's availability and recent selling prices before deciding what to offer. Keep the lead-time calculation in the records where you have reliable original dates; do not substitute a later import or edit date.

This is where Kiyo helps the owner move from a pattern to a hotel decision. Reception can see the recorded reservations, while the owner checks which rooms and channels produced the result. The team can discuss a specific arrival period instead of reacting to an empty-looking month.

Explore room and channel results in the Kiyo demo

Connect timing to a bookable offer

Knowing that guests decide within a certain window is useful only if the property can respond with a clear offer. Check the room information, available dates, and terms the guest will encounter.

Kiyo's configured Direct Booking Engine gives an enabled property a path from available room choice through checkout. It connects a completed reservation to the booking operation, with payment and guest handoff conditions depending on setup.

That helps turn an owner's timing decision into something a guest can buy. It does not guarantee demand or mean Kiyo changes prices automatically based on this article's lead-time groups.

The direct-booking guide for small hotels explains how to make that route useful. Keep the channel mix in view too: the OTA costs guide considers what the property pays for different ways of reaching a guest.

For a small team, fewer disconnected decisions are the point. The owner reviews a specific future period, reception understands the offer, and the booking calendar shows the recorded result.

Use short lead time to prepare operations too

Lead time is not only a pricing question. Same-day or next-day bookings give the team less time to collect arrival information and resolve questions before the guest appears.

Keep room availability current and review the upcoming arrival record. Make sure late-arrival or access questions reach the person who can answer them. Do not wait for a routine message intended for guests who booked several days ahead.

The front desk handover guide helps the team carry those open jobs into the next shift. This is an operating response to a short preparation window, not a claim that a lead-time report automatically assigns work.

Start with a pattern you can defend

Choose one comparable set of stays, verify the original booking dates, and calculate the days to arrival. Keep the number of bookings, the grouping method, and the missing records beside the result.

Kiyo can support the discussion with recorded bookings, room availability, and revenue context. The operator supplies the careful comparison and the decision. Together, those are more useful than a confident average with no clear meaning.

At the next weekly review, ask whether the expected demand appeared and whether the chosen offer made sense. Adjust from observed results, not from a universal booking-window claim.

Open the Kiyo Revenue Analytics demo