Breadcrumbs

Revenue Forecast by Market Segment .ng

Revenue Forecast By Market Segment Report Overview

Parent Hub: 📈 Revenue & Analytics

Category: 🔭 Yield & Forecasting

Target Roles: Directors of Revenue Management, Revenue Analysts, General Managers, Hotel Controllers, Directors of Sales & Marketing

Key Value: Evaluate forward-looking daily revenue and stay demand across master corporate market segments, monitor segment stay volume and Average Daily Rates (ADR), track occupant headcounts, and analyze segment contribution to projected property occupancy, RevPAR, and total room stock.

Executive Summary

The Revenue Forecast By Market Segment Report is a primary macro-segment forward projection and yield management document within the 🔭 Yield & Forecasting category of the 📈 Revenue & Analytics hub. Designed to deliver high-level financial and occupancy foresight across corporate market classifications, it projects daily room stay production, gross base room revenue, Average Daily Rate (ADR), occupant headcounts, occupancy contribution, and RevPAR contribution for every active master market segment across future stay dates.

  • By mapping master market segment parameters (Date, Day Of Week, Market Segment Name, Market Segment Code) to guest occupant headcounts (Stays, Adults, Children, Total Guests), physical room capacity metrics (Total Rooms, Projected Occupancy), and forward monetary performance indicators (Revenue, ADR, Occupancy Contribution, RevPAR Contribution), this report enables revenue managers, general managers, and sales teams to project market mix profitability, evaluate corporate vs. transient vs. leisure pickup, and align dynamic pricing and yield controls.

Key Capabilities

  • Master Market Segment Demand Forecasting: Projects daily stay volume (Stays), gross base room revenue (Revenue), and Average Daily Rate (ADR) across master market segment classifications (e.g., LEISURE OTHER, CORPORATE PREFERRED, CORPORATE NEGOTIATED, WHOLESALE, DISCOUNT AND TRANSIENT DISCOUNT, CORPORATE REGULAR, POLICY AND PROCEDURE AND AIRLINE DELAY).

  • Guest Occupant Headcount Breakdown: Itemizes adult occupants (Adults), child occupants (Children), and total guest headcounts (Total Guests) for each market segment to evaluate guest density and ancillary spend potential.

  • Forward Occupancy & RevPAR Contribution Tracking: Measures the exact contribution of each master market segment toward projected total hotel capacity (Occupancy Contribution) and overall property RevPAR (RevPAR Contribution).

  • Physical Capacity Alignment: Contextualizes daily segment demand against total property room stock (Total Rooms) and overall projected house occupancy (Projected Occupancy).

  • Time-Series Demand Horizon Analysis: Tracks day-by-day forecasted production across specified date ranges to identify projected compression dates, weekday versus weekend segment demand shifts, and seasonal performance patterns.

Report Views & Functional Breakdown

The Revenue Forecast By Market Segment Report presents master market segment forward demand metrics in a unified single-table ledger that supports three key analytical perspectives:

┌────────────────────────────────────────────────────────────────────────┐
│           REVENUE FORECAST BY MARKET SEGMENT REPORT                    │
├────────────────────────────────────────────────────────────────────────┤
│                         Unified Matrix View                            │
├──────────────────────────┬──────────────────────────┬──────────────────┤
│ 1. Segment Revenue &     │ 2. Occupant Headcount &  │ 3. Daily Stay &  │
│    Yield Projection      │    Guest Density         │    Contribution  │
└──────────────────────────┴──────────────────────────┴──────────────────┘
1. Segment Revenue & Yield Projection

Monitors projected base room revenue generation and Average Daily Rates across individual master market segment codes.

  • Primary Use: Evaluating which master market segments are projected to generate the highest accommodation revenue (Revenue), auditing rate yield premiums (ADR), and identifying top-performing corporate or leisure categories for future stay dates.

  • Key Metrics: Market Segment Code, Market Segment Name, Revenue, Stays, ADR.

2. Occupant Headcount & Guest Density

Tracks projected guest headcounts and occupant density across master market segment classifications.

  • Primary Use: Analyzing guest demographic mix across corporate and leisure segments, forecasting breakfast and amenity demand, and evaluating family versus single-occupant corporate stay patterns.

  • Key Metrics: Market Segment Name, Stays, Adults, Children, Total Guests.

3. Daily Stay & Contribution Analysis

Tracks projected daily room night production and calculates market segment contribution to overall hotel capacity and RevPAR.

  • Primary Use: Measuring forward daily stay volume (Stays), analyzing day-of-week segment demand patterns, and evaluating market segment contribution to projected occupancy (Occupancy Contribution) and property yield (RevPAR Contribution).

  • Key Metrics: Date, Day Of Week, Market Segment Code, Stays, Total Rooms, Occupancy Contribution, RevPAR Contribution, Revenue.

Image 10-9-26 at 4.48 PM.png
Revenue Forecast by Market Segment

Data Dictionary (Dynamic View Columns)

Customize your default view using the Configure (⚙️) icon on the report page. Below is the full data dictionary representing every column available in this report:

💡 Monetary & Rate Calculation Note: Revenue and ADR represent Base Room Revenue (Excludes Taxes & Non-Room Charges). ADR is calculated as ADR = Revenue ÷ Stays.

Column Name

Description

Data Source / System Mapping

Includes Taxes & Fees?

Date

Projected calendar date of the reported stay production (e.g., 2026-10-09).

PMS > Target Stay Date

N/A

Day Of Week

Corresponding day of the week for the stay date (e.g., Friday, Saturday).

System Calendar > Day Of Week

N/A

Market Segment Name

Full name of the master corporate market segment (e.g., LEISURE OTHER, CORPORATE PREFERRED, WHOLESALE).

PMS > Master Market Segment Title

N/A

Market Segment Code

Single-letter or alphanumeric code identifying the master market segment (e.g., K, P, L, W, D, G, V).

PMS > Master Market Segment Code

N/A

Stays

Total physical room nights / stays projected for the market segment on the date.

SUM(Projected Stays by Market Segment)

N/A

Adults

Count of registered adult occupants projected for stays in the market segment.

SUM(Adult Guests by Market Segment)

N/A

Children

Count of registered child occupants projected for stays in the market segment.

SUM(Child Guests by Market Segment)

N/A

Total Guests

Combined guest headcount projected for the market segment (Adults+ Children).

Adults + Children

N/A

Revenue

Projected gross base room revenue generated by stays in the market segment on the date.

SUM(Projected Base Room Revenue)

❌ No

ADR

Average Daily Rate projected per room stay for the market segment (Revenue ÷ Stays).

Revenue / Stays

❌ No

Occupancy Contribution

Proportion of total available room capacity projected to be contributed by the market segment on the date.

Stays / Total Available Rooms

N/A

RevPAR Contribution

Revenue Per Available Room projected to be contributed by the market segment on the date.

Revenue / Total Available Rooms

❌ No

Total Rooms

Total physical room stock / capacity of the property.

Physical Room Inventory Count

N/A

Projected Occupancy

Overall property-wide occupancy percentage projected for the stay date incorporating all segments.

Total Projected Rooms / Hotel Capacity

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.

    • Time & Date Tracking (Cols 1–2): Date | Day Of Week

    • Market Segmentation Mapping (Cols 3–4): Market Segment Code | Market Segment Name

    • Guest Demographics & Headcount (Cols 5–8): Adults | Children | Total Guests | Stays

    • Revenue & Pricing Metrics (Cols 9–10): Revenue | ADR

    • Yield & Contribution Metrics (Cols 11–12): Occupancy Contribution | RevPAR Contribution

    • Capacity & Forecast Metrics (Cols 13): Total Rooms

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: he Revenue Forecast By Market Segment report features an interactive pie chart to help analyze forward market segment mix and projected demand distributions. Users can group forward market performance entries on the fly by Market Segment Name or Day Of Week to evaluate segment demand trends over future weekly or monthly horizons. By selecting a metric from the Select Base Column dropdown menu—such as ADR, Revenue, Stays, Total Guests, RevPAR Contribution, or Total Rooms—the chart dynamically renders percentage share breakdowns accompanied by an interactive color-coded legend.

Image 10-9-26 at 4.50 PM.png
Group By & Pie Chart Visualization

  • Bar Chart Visualizer: The Revenue Forecast By Market Segment report includes an interactive bar chart to help visualize forward market segment demand, guest volume, and financial performance trends over time. By adjusting the Select Column (Y-Axis) dropdown menu, users can dynamically toggle the chart view to plot metrics such as Revenue, Stays, Adults, Children, Total Guests, Total Rooms, or Projected Occupancy chronologically alongside the detailed forecast data grid.

Image 10-9-26 at 4.54 PM.png
Bar Chart Visualizer
Advanced Controls

  • Exporting & Segment Strategy Analysis: Download in Excel or PDF format to support weekly revenue strategy meetings, corporate market mix audits, and segment pricing evaluations.

  • Filtering: Filter data by specific Market Segment Code (e.g., isolate P for Corporate Preferred or K for Leisure Other), or filter out zero-stay dates.

  • Highlighting (Conditional Formatting): Apply custom rules to automatically highlight high-revenue projected market segments, zero-stay dates, or low-ADR performance periods.

Within 📈 Revenue & Analytics & 🔭 Yield & Forecasting:

  • Revenue Forecast By Local Market Segment – Granular forward projection evaluating demand across property-specific local market segment classifications.

  • Market Segment Details Forecast – Forward-looking demand forecast breakdown by master market segment and rate code.

  • Rate Plan Forecast– Granular rate-level forward projection evaluating daily revenue and stay demand across individual rate plans.

  • Booking Pace – Multi-section tracking report evaluating pickup velocity across Revenue, Rooms Sold, ADR, and Occupancy.

  • Occupancy Forecast and History – Comprehensive daily overview tracking historical and forecasted occupancy, revenue, and movement counters.

Cross-Pillar Deep Dives: