Length of StayTotal ReservationsSum of Total RevenueSum. Of Total Nights% of Total Rev% of Total Nights% of Total ReservationsRevenue Per Night

1	4052	$                             224,477.33	4052	23%	22%	55%	$                                           55.40
2	1578	$                             210,626.48	3156	22%	17%	21%	$                                           66.74
3	693	$                             127,335.82	2079	13%	12%	9%	$                                           61.25
4	372	$                                79,923.26	1488	8%	8%	5%	$                                           53.71
7	156	$                                47,124.36	1092	5%	6%	2%	$                                           43.15
5	153	$                                39,711.86	765	4%	4%	2%	$                                           51.91
6	113	$                                38,085.30	678	4%	4%	2%	$                                           56.17
59	6	$                                21,454.64	586	2%	3%	0%	$                                           36.61
8	53	$                                17,331.69	424	2%	2%	1%	$                                           40.88
9	32	$                                16,159.73	288	2%	2%	0%	$                                           56.11
28	12	$                                13,062.94	336	1%	2%	0%	$                                           38.88
14	20	$                                13,061.93	280	1%	2%	0%	$                                           46.65
31	9	$                                11,414.89	279	1%	2%	0%	$                                           40.91
10	22	$                                   9,910.50	220	1%	1%	0%	$                                           45.05
13	12	$                                   9,813.47	156	1%	1%	0%	$                                           62.91
30	10	$                                   9,367.46	300	1%	2%	0%	$                                           31.22
11	16	$                                   7,757.29	176	1%	1%	0%	$                                           44.08
27	7	$                                   6,621.83	189	1%	1%	0%	$                                           35.04
12	12	$                                   6,387.56	144	1%	1%	0%	$                                           44.36
34	3	$                                   5,938.10	102	1%	1%	0%	$                                           58.22
21	7	$                                   5,282.64	147	1%	1%	0%	$                                           35.94
33	3	$                                   4,399.19	99	0%	1%	0%	$                                           44.44
26	4	$                                   4,391.36	104	0%	1%	0%	$                                           42.22
35	4	$                                   4,188.69	140	0%	1%	0%	$                                           29.92
47	1	$                                   4,001.25	47	0%	0%	0%	$                                           85.13
22	2	$                                   3,195.96	44	0%	0%	0%	$                                           72.64
16	5	$                                   3,159.68	80	0%	0%	0%	$                                           39.50
17	3	$                                   2,877.58	51	0%	0%	0%	$                                           56.42
25	4	$                                   2,855.11	100	0%	1%	0%	$                                           28.55
29	4	$                                   2,755.55	116	0%	1%	0%	$                                           23.75
18	3	$                                   2,232.87	54	0%	0%	0%	$                                           41.35
19	2	$                                   1,984.02	38	0%	0%	0%	$                                           52.21
52	1	$                                   1,854.64	52	0%	0%	0%	$                                           35.67
37	1	$                                   1,531.14	37	0%	0%	0%	$                                           41.38
41	1	$                                   1,508.50	41	0%	0%	0%	$                                           36.79
24	1	$                                   1,114.70	24	0%	0%	0%	$                                           46.45
15	3	$                                       895.83	45	0%	0%	0%	$                                           19.91
36	1	$                                       630.50	36	0%	0%	0%	$                                           17.51
32	1	$                                       148.39	32	0%	0%	0%	$                                              4.64

 

 

 

 

07/12/2026 09:13 AM EST

This is exactly the dataset we needed.

The biggest surprise is that 1-night stays are not the problem I expected them to be.

Here’s the breakdown.

LOS	Reservations	Revenue	Revenue/Reservation	Revenue/Night
1	4,052	$224,477	$55.40	$55.40
2	1,578	$210,626	$133.48	$66.74
3	693	$127,336	$183.75	$61.25
4	372	$79,923	$214.85	$53.71
5	153	$39,712	$259.56	$51.91
6	113	$38,085	$336.99	$56.17
7	156	$47,124	$302.08	$43.15

Now let’s apply your $30 turnover cost.

LOS	Revenue/Reservation	Cleaning	Net After Cleaning
1	$55.40	$30	$25.40
2	$133.48	$30	$103.48
3	$183.75	$30	$153.75
4	$214.85	$30	$184.85
5	$259.56	$30	$229.56
6	$336.99	$30	$306.99
7	$302.08	$30	$272.08

This makes something very clear.

One-night stays

• 55% of all reservations
• 23% of total revenue
• 22% of total occupied nights

So they create a tremendous amount of operational work while generating less than one quarter of revenue.

However…

They still generated

$224,477

over the period.

That is not insignificant.

---

Here’s what I would calculate next.

Multiply the reservation count by the cleaning cost.

1-night

4,052 × $30

= $121,560

Cleaning consumed

54.2%

of the room revenue.

---

2-night

1,578 × $30

= $47,340

Only

22.5%

of revenue.

---

3-night

693 × $30

= $20,790

Only

16.3%

of revenue.

---

Immediately you can see the operational leverage.

LOS	Cleaning % of Revenue
1	54.2%
2	22.5%
3	16.3%
4	14.0%
5	11.6%
6	8.9%
7	9.5%

That chart alone tells the story.

---

My biggest takeaway

The issue isn’t that one-night stays produce low ADR.

They don’t.

The issue is that every reservation has a fixed turnover cost.

You have discovered something much more important than ADR:

Your business has a fixed operational cost per reservation, not per night.

That changes how pricing should be optimized.

I’d actually stop looking at ADR altogether.

Instead I’d build a dashboard around these five metrics:

• Total reservations
• Total revenue
• Revenue per reservation
• Cleaning cost as % of revenue
• Net contribution after turnover

Those five numbers tell you almost everything you need to know about whether a particular length of stay is economically attractive.

Finally, one statistic stands out more than any other:

• 55% of reservations generate only 23% of revenue.

That is probably the single most important operational KPI in your portfolio, because it quantifies how much of your workload is being driven by one-night bookings.