All articles
Revenue analysis

Length of stay: booking count and room-night calculations

Stayax3 min read
Navy blocks grouped differently on two stone trays beside a hotel model

Booking count does not explain revenue by itself

Do not compare hotel revenue using reservation count alone. The same sold room nights can come from fewer, longer stays. Read reservation count, room nights, room revenue and stay length with the same scope. This is a guide to reporting units, not a recommendation to impose minimum stays. Fewer bookings do not necessarily mean fewer nights sold; more transactions can also leave room nights unchanged. Oracle's public OPERA Cloud 26.2 statistics guide describes length-of-stay reporting for room nights, room revenue and ADR. Its forecast guide describes stay-length forecasts by room class or type. These are examples from a particular product, not features guaranteed by every PMS or claimed for Stayax. Keep expected future stays separate from completed stays. A booking received today is not evidence of today's realized stay revenue.

Explicit assumptions: the same forty room nights

Consider two entirely fictional periods. Every reservation is for one room; all stays begin and end within their comparison period, with no cancellations or unused nights. Assume example room revenue of TRY 3,000 per sold room night. Period A has 20 reservations lasting two nights: 20 × 2 = 40 room nights. Period B has 10 reservations lasting four nights: 10 × 4 = 40 room nights. Both produce example room revenue of 40 × 3,000 = TRY 120,000. Booking count halves while nights and room revenue remain equal. Average length is 40 / 20 = 2 nights for A and 40 / 10 = 4 for B. This does not establish that longer stays are always better. Amounts are fictional, not market prices or property results. Taxes, channel expenses, staff, cleaning and other costs are excluded, so the result is not profit. Collection is not assumed either.

Weight mixed lengths correctly

A second fictional group has 20 completed one-night stays and 10 four-night stays, each for one room. There are 30 reservations and 20 × 1 + 10 × 4 = 60 room nights. Average stay length is 60 / 30 = 2 nights. Averaging the group labels as (1 + 4) / 2 = 2.5 is wrong here because the groups have different reservation counts. Check whether a real report counts single-room or multi-room records before borrowing this denominator. Counting only nights used inside a period does not necessarily describe the full length of stays crossing its boundaries. Consult the report definition. Increasing an average is not, by itself, a reason to change availability or minimum-night settings.

A weekly comparison card

Record date basis, reservation status, room scope and currency. Compare completed stays separately from future reservations. Read count, nights, room revenue and average length together. If bookings fall while nights stay stable, investigate the duration mix. If nights rise while revenue does not, price or room mix may differ, but establish the reason with additional evidence. Fewer arrivals can change the distribution of work for equal nights, without proving a specific cleaning saving. Capacity, service frequency and room type need separate review. Ask whether period and status match, the unit is consistent, weighting is correct and revenue remains separate from profit. Editorial examples require only fictional numbers, not actual guest or property records.

Let's put this to work for you

Let's start with a free, personalized demo.

Book a FREE demo
Book a FREE demoApply for free