Skip to content

Length of Stay


Length of Stay Analysis — Battlefield Storage

This analysis merges data from:
Move-Ins/Move-Outs PDF Report (provides full tenant activity history) MoveInsAndMoveOuts_20240901_202…
Move-Ins/Move-Outs/Transfers Excel Report (provides LOS field for moved-out tenants)
The Excel file contains a clean LOS field ("Days in Unit") for tenants who have moved out. This gives us the most reliable measurable LOS. The PDF provides supporting activity data but does not include LOS directly, so the LOS calculations are driven primarily by the Excel dataset.

📊 Summary of Length of Stay (LOS)

(based on 69 tenants with recorded move-outs + LOS values)

LOS Statistics

Table 5
Metric
Value
Average LOS
80.96 days (~2.7 months)
Median LOS
65 days
Shortest Stay
1 day
Longest Stay
365 days
25th Percentile
37 days
75th Percentile
89 days
There are no rows in this table

Interpretation

Half of customers stay >65 days, meaning turnover is relatively high.
The top quartile stays nearly 3 months or more, indicating a small but meaningful segment of stickier tenants.
A few long-term tenants (200–365+ days) significantly pull the average upward.

Length of Stay Distribution

Table 6
LOS Range
% of Tenants
Notes
0–30 days
High volume
Many short-term or promo-driven tenants
31–90 days
Largest group
Typical short-term storage behavior
91–180 days
Moderate
Higher retention, possible rate-sensitive
180+ days
Smaller group
Long-term core tenants
There are no rows in this table
(We can create charts if you'd like.)

🧩 How Both Reports Were Used

Excel File

Provided:
MOVE DATE
ACTIVITY TYPE
DAYS IN UNIT (your LOS)
Transfers + replacement unit info
This is the primary quantitative source.

PDF Move-Ins/Move-Outs Report

MoveInsAndMoveOuts_20240901_202… Used to validate:
Move-ins and move-outs
Transfer behavior
Date ranges & activity volume
Presence of promotional discounts, which help explain short LOS
The PDF includes 60 move-outs vs. 69 LOS entries in the Excel, indicating Excel includes activity beyond the PDF range (through 11/30/25).

📌 Key Takeaways

1. LOS is short—storage here behaves like a high-turnover market

Your median LOS of 65 days indicates the majority of customers stay 2–3 months, likely due to:
Heavy use of discounts (PDF shows many half-off and 1st-month-free tenants)
Seasonal or transitional customer base

2. Promotional strategy is directly impacting churn

The PDF file contains a very high number of:
Half-Off First Month
1 Month Free Promo
NE (Never Expiring) Discounts
These produce:
More move-ins
Shorter stays
Fewer stable long-term tenants

3. Long-term tenants do exist—and represent your sticky revenue

A small set stayed 200–365+ days, which we can segment further if you want:
by unit size
by rate
by promo used
by transfer history
Total tenants: 275
Average stay: ~4.9 months
Median stay: ~3.9 months
Shortest stay: ~0.03 months (1 day)
Longest stay: ~15.0 months

🔢 Overall Summary

Table 3
Status
Count
Avg Days
Median
Min
Max
Active
183
192.4
159
1
456
Moved Out
92
63.7
44.5
1
299
There are no rows in this table

🧱 Breakdown by Unit Size (Top Examples)

Table 4
Size
Status
Count
Avg Days
Median
Min
Max
10x10
Active
40
193.2
158
13
445
10.0x10.0
Moved Out
18
59.2
35
1
245
10x20
Active
45
212.2
214
4
420
10.0x20.0
Moved Out
19
57.9
49
1
178
5.0x10.0
Moved Out
15
95.3
68
2
299
There are no rows in this table
Here’s the combined length of stay converted to months (using an average of 30.44 days per month):
Total tenants: 275
Average stay: 4.9 months
Median stay: 3.9 months
Shortest stay: less than 1 month
Longest stay: 15 months

output (20).png
output (23).png
Want to print your doc?
This is not the way.
Try clicking the ··· in the right corner or using a keyboard shortcut (
CtrlP
) instead.