Length of Stay Statistics .ng

Length of Stay Statistics Report Overview

Parent Hub: πŸ“ˆ Revenue & Analytics

Category: πŸ“Š Performance Summaries

Target Roles: Directors of Revenue Management, General Managers, Directors of Sales, Extended Stay Operations Managers, Revenue Analysts

Key Value: Optimize guest length-of-stay (LOS) tier mix, evaluate extended stay rate performance, analyze room night volume and revenue contributions across stay duration tiers, filter dynamically by customizable LOS Categories, and refine LOS restriction policies.

Date Parameter: Date Range Selector (Start & End) | Past | No Maximum Window

Executive Summary

The Length of Stay Statistics Report is a primary revenue management and operational analytics document within the πŸ“Š Performance Summaries category of the πŸ“ˆ Revenue & Analytics hub. Designed to provide comprehensive post-stay duration analysis, it aggregates property performance across standardized and customizable length-of-stay tiers to evaluate how short-term transient vs. extended stay guests contribute to overall occupancy and revenue performance.

  • By categorizing operational metrics across length-of-stay tiersβ€”including granular stay duration brackets (e.g., 1 Night, 2 to 3 Nights, 4 to 6 Nights, 7 to 30 Nights, 31 Nights or More) as well as traditional extended-stay rollups (1-6, 7-14, 15-29, 30+ nights)β€”this report tracks daily room night sales (Room Sold), occupancy contribution (Occupancy), cumulative volume (Room Sold MTD, Room Sold YTD), monetary revenue generation (Revenue, Revenue MTD, Revenue YTD), and key rate performance yield indicators (ADR, RevPAR). Using the LOS Categories multi-select filter, revenue managers and leadership teams can isolate specific stay duration buckets prior to executing the report to evaluate pricing tier efficiency, measure extended stay displacement, and optimize minimum/maximum length-of-stay (LOS) controls across distribution channels.

πŸš€ Upcoming Release Note (Version 6.0.6):

The new LOS Categories multi-select filter featureβ€”located in the top parameter bar alongside Start Date and End Dateβ€”will become available starting in the 6.0.6 version release. It allows users to select one or multiple stay duration brackets (or select All) before clicking Run to dynamically filter the report output.

Key Capabilities

    • Customizable LOS Categories Parameter Filter (Available in Version 6.0.6): Provides a dedicated LOS Categories multi-select dropdown selector in the top report parameter bar next to Start Date and End Date, enabling users to filter by All or select specific stay duration brackets (such as 1 Night, 2 to 3 Nights, 4 to 6 Nights, 7 to 30 Nights, 31 Nights or More) before running the report.

    • LOS Tier Mix Segmentation: Breaks down operational performance across stay duration tiers, contrasting short-stay transient demand against mid-length and long-term extended-stay segments.

    • Multi-Period Revenue & Volume Tracking: Monitors daily performance (Room Sold, Revenue, ADR, RevPAR) alongside Month-to-Date (MTD) and Year-to-Date (YTD) cumulative figures, with an interactive Show Grand Total toggle for instant rollup summaries.

    • Yield & Displacement Optimization: Evaluates rate yield variance between short-term transient stays and discounted extended-stay rate plans to maximize RevPAR and base inventory occupancy.

Report Views & Functional Breakdown

The Length of Stay Statistics Report presents stay duration performance in a unified single-table matrix that supports three key analytical perspectives:

β”Œβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”
β”‚                   LENGTH OF STAY STATISTICS REPORT                     β”‚
β”œβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€
β”‚                         Unified Matrix View                            β”‚
β”œβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”¬β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”¬β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€
β”‚ 1. Transient vs. Extendedβ”‚ 2. Yield & Rate Performanceβ”‚ 3. Cumulative     β”‚
β”‚    Stay Volume Mix       β”‚    By LOS Tier           β”‚    MTD / YTD Paceβ”‚
β””β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”˜

1. Transient vs. Extended Stay Volume Mix

Monitors daily room night production and occupancy contribution across length-of-stay tiers.

  • Primary Use: Evaluating property base business stability provided by extended stay tiers (7-14, 15-29, 30+ nights) compared to short-stay transient volume (1-6 nights).

  • Key Metrics: Date, Length of Stay, Room Sold, Occupancy.

2. Yield & Rate Performance By LOS Tier

Measures financial yield, average daily rates, and revenue contributions for each stay duration bracket.

  • Primary Use: Analyzing rate dilution across extended stay brackets, verifying that long-term tier discounts (ADR) maintain property RevPAR goals, and optimizing minimum stay restriction rules.

  • Key Metrics: Date, Length of Stay, Revenue, ADR, RevPAR.

3. Cumulative MTD / YTD Pace

Tracks Month-to-Date and Year-to-Date room night and revenue accumulation per stay duration tier.

  • Primary Use: Assessing long-term extended stay trends over annual and monthly accounting cycles to support corporate and extended-stay sales strategies.

  • Key Metrics: Length of Stay, Room Sold MTD, Room Sold YTD, Revenue MTD, Revenue YTD.

Image 11-21-26 at 5.02β€―PM.png
Length of Stay Statistics Report

Data Dictionary (Dynamic View Columns)

Customize your default view using the Configure (βš™οΈ) icon on the report page. Below is the full data dictionary representing all 17 columns available in this report:

πŸ’° Monetary & Rate Treatment Note:

  • Revenue, Revenue MTD, and Revenue YTD represent Gross Base Room Revenue (Excludes Taxes & Fees).

  • Occupancy is rendered as a percentage or decimal ratio representing the share of total available rooms occupied by the specific LOS tier.

Column Name

Description

Data Source / System Mapping

Includes Taxes & Fees?

ADR

Realized Average Daily Rate earned per occupied room in the LOS tier.

Calculated: (Revenue / Room Sold)

❌ No

Date

Official business date for which length-of-stay performance is summarized.

System Business Date

N/A

Length of Stay

Stay duration bracket or LOS category tier (e.g., 1 Night, 2 to 3 Nights, 4 to 6 Nights, 7 to 30 Nights, 31 Nights or More, or 1-6, 7-14, 15-29, 30+).

Stay Duration Classification

N/A

Occupancy

Proportion of total available property rooms occupied by the specific LOS tier.

Calculated: (Room Sold / Available Rooms)

N/A

Revenue

Gross base room revenue generated on the business date for the specific LOS tier.

$\sum(\text{Tier Base Room Revenue})$

❌ No

Revenue MTD

Cumulative Month-to-Date base room revenue generated within the specific LOS tier.

M-T-D Revenue Ledger Engine

❌ No

Revenue YTD

Cumulative Year-to-Date base room revenue generated within the specific LOS tier.

Y-T-D Revenue Ledger Engine

❌ No

RevPAR

Revenue Per Available Room generated by the specific LOS tier.

Calculated: (Revenue / Total Available Rooms)

❌ No

Room Sold

Total physical room nights sold and occupied on the business date for the specific LOS tier.

sum=(Tier Occupied Rooms)

N/A

Room Sold MTD

Cumulative Month-to-Date room nights sold within the specific LOS tier.

M-T-D Room Ledger Engine

N/A

Room Sold YTD

Cumulative Year-to-Date room nights sold within the specific LOS tier.

Y-T-D Room Ledger Engine

N/A

Customization & Platform Features

User & Property Preferences

  • Personal Preference: Tailor your individual view by hiding or dragging columns. Your preferences save automatically for future sessions.

  • Property Defaults: System Admins can configure standard default layouts across all property users to streamline operational reporting. To maximize audit efficiency, group the columns into the below logical blocks:

    • Business Date & Stay-Duration Bucket (Cols 1–2): Date | Length of Stay

    • Daily Volume, Stay Duration & Occupancy KPIs (Cols 3–6): Room Sold | Number Of Nights | Average LOS | Occupancy

    • Cumulative & Historical Room Night Benchmarks (Cols 7–10): Room Sold MTD | Room Sold LMTD | Room Sold YTD | Room Sold LYTD

    • Daily Revenue & Yield Performance Metrics (Cols 11–13): Revenue | ADR | RevPAR

    • Cumulative & Historical Revenue Benchmarks (Cols 14–17): Revenue MTD | Revenue LMTD | Revenue YTD | Revenue LYTD

Report Toolbar & Quick Actions

Use the top-right toolbar icons on the report page to manage and export your data view:

Icon

Action / Feature

Description

Image 9-29-26 at 1.04β€―PM.png

Knowledge Article

Opens the knowledge base article to learn how to interpret this report.

Image 9-29-26 at 12.37β€―PM.png

Saved Views

Saves your column filtering, sorting, and highlight preferences so you can easily reload your custom view later without reconfiguring the report.

Image 9-29-26 at 12.51β€―PM.png

Bar Chart

Displays report data in a visual bar chart format.

Image 9-29-26 at 12.39β€―PM.png

Filter

Opens filter controls to isolate specific data within a column based on your selected criteria.

Image 9-29-26 at 12.40β€―PM.png

Highlight

Highlights column values in a designated color based on selected conditions.

Image 9-29-26 at 12.42β€―PM.png

Export

Exports and downloads the report in various formats (Excel, PDF, CSV) for offline analysis or printing.

Image 9-29-26 at 12.43β€―PM.png

Configure

Opens column selection controls to toggle visibility, reorder columns, or hide rows with all zeros.

Image 9-29-26 at 12.44β€―PM.png

Additional Configuration

Provides advanced report configuration and display formatting options to customize data presentation.

Image 9-29-26 at 12.53β€―PM.png

Group By

Summarize and group report data dynamically in real time.

Interactive Visualizations & Grouping Controls

  • Group By & Pie Chart Visualization: The Length of Stay Statistics report features an interactive pie chart to help analyze guest duration patterns and revenue share. Users can group metrics on the fly by Length of Stay tier or Date to analyze stay duration performance trends over time. By selecting a metric from the Select Base Column dropdown menuβ€”such as Room Sold, Revenue, or cumulative MTD/YTD totalsβ€”the chart dynamically displays percentage share breakdowns alongside an interactive color-coded legend.

Image 10-6-26 at 12.42β€―PM.png
Group By & Pie Chart Visualization
  • Bar Chart Visualizer: The Length of Stay Statistics report features an interactive bar chart to help analyze property volume and revenue trends over time. By adjusting the Select Column (Y-Axis) dropdown menu, users can dynamically switch the chart view to plot room volume (Room Sold, Room Sold MTD/YTD) or financial performance (Revenue, Revenue MTD/YTD) alongside the detailed statistics table.

Image 10-6-26 at 12.44β€―PM.png
Bar Chart Visualizer

Advanced Controls

  • Exporting & Yield Analysis: Download in Excel or PDF format to support monthly revenue strategy meetings, extended stay sales contract reviews, and displacement analysis.

  • Filtering: Filter data by specific date ranges or length-of-stay brackets (e.g., isolate 15-29 and 30+ tiers for extended-stay audits).

  • Highlighting (Conditional Formatting): Apply custom rules to automatically highlight high-occupancy days or tiers experiencing significant ADR rate drops.

Within πŸ“ˆ Revenue & Analytics & πŸ“Š Performance Summaries:

  • General Manager Report – Review property-wide macro statistics, total room revenues, ADR, and RevPAR performance.

  • Hotel Statistics – Complete 360-degree operational overview including room counts, occupancy, taxes, payments, and booking activity.

  • Market Segment Summary – Analyze how room revenue and ADR performance vary across retail, corporate, group, and OTA segments.

Cross-Pillar Deep Dives:

  • πŸ›ŽοΈ Front Desk & Guest Services: Cross-reference active long-stay guest profiles in In-House Guest List.

  • πŸ’³ Payments & Transactions: To inspect specific room charges and long-term folio settlements, review All Transactions.