Breadcrumbs

Market Segment Details Forecast .ng

Market Segment Details Forecast Report Overview

Parent Hub: 📈 Revenue & Analytics

Category: 🥧 Market & Segmentation

Target Roles: Directors of Revenue Management, General Managers, Directors of Sales, Asset Managers, Revenue Analysts

Key Value: Evaluate forward-looking market segment demand pace, monitor market-specific revenue projections, track out-of-order and out-of-service inventory displacement, and optimize pricing strategies across segment classifications.

Executive Summary

The Market Segment Details Forecast Report is a primary forward-looking demand intelligence and market mix projection document within the 🥧 Market & Segmentation category of the 📈 Revenue & Analytics hub. Designed to provide complete visibility into upcoming business mix performance, it projects daily room demand, guest demographics, revenue streams, and capacity utilization for every active market segment over a future date range.

By mapping future calendar dates (Date) across market segment master codes (Market Segment Code, Market Segment Name like P - Corp Preferred, M - Government Individual, L - Corp Negotiated), inventory availability controls (Total Rooms, OOO, OOS Rooms, Day Use, Cancelled Rooms), guest movement projections (Arrivals, Departures, No of Guests, No of Adults, No of Children, Package Including/Excluding Breakfast Guests), and multi-departmental revenue forecasts (Room Revenue, Room Rent Amount, F&B Revenue, Other Revenue, Non Revenue, Projected Occupancy), this report enables revenue management teams and executive leadership to identify pace gaps, manage inventory displacement, and optimize forward rate structures.

Key Capabilities

  • Forward-Looking Market Segment Projections: Itemizes daily projected performance across market segment classifications over future booking horizons.

  • Physical & Operational Capacity Auditing: Tracks total physical room capacity (Total Rooms) alongside maintenance holds (OOO - Out of Order, OOS Rooms - Out of Service) to measure net sellable inventory displacement.

  • Guest Movement & Package Inclusions: Forecasts expected guest movements (Arrivals, Departures), guest occupant headcounts (No of Guests, No of Adults, No of Children), and package meal inclusions (Package Including Breakfast Guests, Package Excluding Breakfast Guests).

  • Multi-Department Revenue & Occupancy Projections: Projects gross room revenue (Room Revenue, Room Rent Amount), food and beverage revenue (F&B Revenue), ancillary charges (Other Revenue, Non Revenue), and overall segment capacity penetration (Projected Occupancy).

Report Views & Functional Breakdown

The Market Segment Details Forecast Report presents forward-looking market segment data in a unified single-table projection matrix that supports three key analytical perspectives:

┌────────────────────────────────────────────────────────────────────────┐
│               MARKET SEGMENT DETAILS FORECAST REPORT                   │
├────────────────────────────────────────────────────────────────────────┤
│                         Unified Matrix View                            │
├──────────────────────────┬──────────────────────────┬──────────────────┤
│ 1. Forward Capacity &    │ 2. Guest Movement &      │ 3. Departmental  │
│    Inventory Controls    │    Demographic Pace      │    Revenue Forecast│
└──────────────────────────┴──────────────────────────┴──────────────────┘

1. Forward Capacity & Inventory Controls

Monitors projected physical room capacity, out-of-order/out-of-service inventory holds, and cancellation pace by market segment.

  • Primary Use: Evaluating future physical inventory availability (Total Rooms), tracking maintenance displacement (OOO, OOS Rooms), and monitoring forward room cancellations (Cancelled Rooms) and day-use bookings (Day Use).

  • Key Metrics: Date, Market Segment Code, Market Segment Name, Total Rooms, Number Of Rooms Sold, OOO, OOS Rooms, Day Use, Cancelled Rooms.

2. Guest Movement & Demographic Pace

Projects upcoming guest arrival/departure activity and guest occupant headcounts for operational staffing and breakfast planning.

  • Primary Use: Forecasting front desk and housekeeping workload (Arrivals, Departures), auditing guest occupant density (No of Guests, No of Adults, No of Children), and planning breakfast/meal outlet production (Package Including Breakfast Guests, Package Excluding Breakfast Guests).

  • Key Metrics: Date, Market Segment Name, Departures, Arrivals, No of Guests, No of Adults, No of Children, Package Including Breakfast Guests, Package Excluding Breakfast Guests.

3. Departmental Revenue Forecast

Evaluates projected monetary revenue generation and capacity penetration per market segment.

  • Primary Use: Measuring projected base room earnings (Room Revenue, Room Rent Amount), forecasting food & beverage sales (F&B Revenue), tracking non-room ancillary income (Other Revenue, Non Revenue), and evaluating segment capacity utilization (Projected Occupancy).

  • Key Metrics: Date, Market Segment Code, Currency, Room Revenue, Room Rent Amount, F&B Revenue, Other Revenue, Non Revenue, Projected Occupancy.

Image 10-7-26 at 4.23 PM.png
Market Segment Details Forecast 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 every column available in this report:

💡 Monetary & Occupancy Calculation Note: Room Revenue, Room Rent Amount, F&B Revenue, Other Revenue, and Non Revenue represent Gross Base Financial Forecasts (Excludes Taxes & Fees). Projected Occupancy is rendered as a decimal ratio or percentage (e.g., 0.00 = 0.00%) representing Number Of Rooms Sold ÷ (Total Rooms - OOO)

Column Name

Description

Data Source / System Mapping

Includes Taxes & Fees?

Date

Future business date for which market segment performance is forecasted.

Forecast Date Engine

N/A

Market Segment Code

Unique alphanumeric code identifying the market segment (e.g., P, M, L, C, U, G, D, A, B).

Market Segment Master

N/A

Market Segment Name

Full description of the market segment (e.g., Corp Preferred, Government Individual, Corp Negotiated, Association Meeting, Business Products).

Market Segment Master

N/A

Total Rooms

Total physical room capacity configured at the property.

Physical Inventory Engine

N/A

Number Of Rooms Sold

Projected number of rooms sold and occupied within the market segment on the future date.

Reservation Forecast Engine

N/A

OOO

Count of physical rooms scheduled to be Out of Order (maintenance/repairs).

OOO Inventory Logs

N/A

OOS Rooms

Count of physical rooms scheduled to be Out of Service (temporary hold).

OOS Inventory Logs

N/A

Day Use

Projected day-use room bookings that do not involve an overnight stay.

Reservation Engine

N/A

Cancelled Rooms

Total rooms cancelled for the future business date.

Cancellation Engine

N/A

Departures

Projected number of guest room departures scheduled for the date.

Departure Forecast Engine

N/A

Arrivals

Projected number of guest room arrivals scheduled for the date.

Arrival Forecast Engine

N/A

No of Guests

Projected total guest headcount expected in house for the segment.

Occupant Forecast Engine

N/A

No of Adults

Projected adult guest headcount expected for the market segment.

Occupant Forecast Engine

N/A

No of Children

Projected child guest headcount expected for the market segment.

Occupant Forecast Engine

N/A

Package Including Breakfast Guests

Projected guest count booked on rate plans with breakfast package inclusions.

Package Rate Engine

N/A

Package Excluding Breakfast Guests

Projected guest count booked on room-only rate plans without breakfast inclusions.

Package Rate Engine

N/A

Currency

Currency code for all monetary amounts (e.g., USD).

System Currency Setup

N/A

Room Revenue

Total projected gross room revenue generated by the market segment.

Revenue Forecast Engine

❌ No

Room Rent Amount

Net accommodation portion of room revenue for the segment.

Revenue Forecast Engine

❌ No

F&B Revenue

Projected food and beverage sales associated with the segment bookings.

Outlet Forecast Engine

❌ No

Other Revenue

Projected ancillary fees and incidental earnings.

Ancillary Revenue Engine

❌ No

Non Revenue

Projected non-revenue pass-through or balance sheet transactions.

Non-Revenue Ledger Engine

❌ No

Projected Occupancy

Forecasted capacity penetration ratio for the segment (Sold / Total Sellable Rooms).

Occupancy Forecast 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:

    • Timeline & Market Segment Anchors (Cols 1–3): Date | Market Segment Code | Market Segment Name

    • Physical Capacity & Inventory Status (Cols 4–7): Total Rooms | OOO | OOS Rooms | Day Use

    • Forecasted Reservation Movements (Cols 8–11): Arrivals | Departures | Cancelled Rooms | Number Of Rooms Sold

    • Projected Guest Demographics & Meal Inclusions (Cols 12–18): No of Adults | No of Children | No of Guests | Package Including Breakfast Guests | Package Excluding Breakfast Guests | Currency

    • Projected Revenue Streams & Rate Yields (Cols 19–22): Room Revenue | Room Rent Amount | F&B Revenue | Other Revenue | Non Revenue

    • Projected Occupancy Yield (Col 23): Projected Occupancy

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: Within the Market Segment Details Forecast section, users can utilize the interactive pie chart to evaluate forward booking pace and inventory distribution trends. Users can group forecast entries on the fly by Code or Date to analyze forward booking pace trends. By selecting a metric from the Select Base Column dropdown menu—such as Number Of Rooms Sold, Total Rooms, Arrivals, Departures, or OOO—the chart dynamically displays percentage contribution share alongside an interactive color-coded legend.

Image 10-7-26 at 4.29 PM.png
Group By & Pie Chart Visualization

  • Bar Chart Visualizer: The Market Segment Details Forecast report includes an interactive bar chart to help visualize forward room demand, occupancy pace, and guest movement trends over time. By adjusting the Select Column (Y-Axis) dropdown menu, users can dynamically toggle the chart view to plot metrics such as Number Of Rooms Sold, Arrivals, Departures, OOO, OOS Rooms, or No of Guests chronologically alongside the detailed forecast table.

Image 10-7-26 at 4.34 PM.png
Bar Chart Visualizer

Advanced Controls

  • Exporting & Demand Strategy Analysis: Download in Excel or PDF format to support weekly revenue strategy meetings, forward pricing adjustments, and group block pickup reviews.

  • Filtering: Filter data by specific future date ranges or market segment codes (e.g., isolate corporate segments P, L vs. group segments C, U).

  • Highlighting (Conditional Formatting): Apply custom rules to automatically highlight high-occupancy dates (Projected Occupancy > 80%), high out-of-order room holds, or dates with significant arrival volume.

Within 📈 Revenue & Analytics & 🥧 Market & Segmentation:

  • Market Segment Details – Historical transaction details and daily summary rollup of market segment performance.

  • Local Market Segment – Summary-level view tracking daily revenue, stays, ADR, and RevPAR contribution by local market segment.

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

Cross-Pillar Deep Dives:

  • 🛎️ Front Desk & Guest Services: Cross-reference forward arrival forecasts with Arrivals.

  • 🧹 Rooms & Facilities: Monitor scheduled maintenance holds in All Rooms.