✅ 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
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
(We can create charts if you'd like.)
🧩 How Both Reports Were Used
Excel File
Provided:
Transfers + replacement unit info This is the primary quantitative source.
PDF Move-Ins/Move-Outs Report
MoveInsAndMoveOuts_20240901_202…
Used to validate:
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:
NE (Never Expiring) Discounts These produce:
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:
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
🧱 Breakdown by Unit Size (Top Examples)
Here’s the combined length of stay converted to months (using an average of 30.44 days per month):
Shortest stay: less than 1 month