Breadcrumbs

Market Segment Details Summary Report .ng

Market Segment Details Summary Report Overview

Parent Hub: 📈 Revenue & Analytics

Category: 🥧 Market & Segmentation

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

Key Value: Evaluate daily market segment demand performance, audit multi-departmental revenue contributions by segment, track guest movement and inventory displacement, and reconcile room night production across commercial classifications.

Executive Summary

The Market Segment Details Summary Report is a primary commercial mix and market performance audit document within the 🥧 Market & Segmentation category of the 📈 Revenue & Analytics hub. Designed to deliver consolidated daily operational and financial intelligence, it aggregates room production, guest movement, inventory holds, and multi-departmental revenue realizations across all active market segments configured at the property.

By pairing reservation business dates (Reservation Date) and market classifications (Market Segment Code, Market Segment Name like I - Local Corporate, B - Tour Series, C - Advanced Purchase Direct, A - Fully Flex BAR Direct) with inventory controls (Total Rooms, Number Of Rooms Sold, OOO, OOS Rooms, Day Use, Cancelled Rooms, No Show Rooms), guest movement counts (Departures, Arrivals, No of Guests, No of Adults, No of Children, Package Including/Excluding Breakfast Guests), and financial posting metrics (Currency, Room Revenue, Room Rent Amount, F&B Revenue, Other Revenue, Non Revenue), this report enables revenue managers, sales directors, and controllers to audit market segment profitability, evaluate inventory displacement, and optimize commercial channel pricing.

Key Capabilities

  • Consolidated Market Segment Rollup: Itemizes daily room production, occupant headcounts, and revenue contributions for each commercial market segment.

  • Physical & Maintenance Capacity Governance: Tracks total physical property capacity (Total Rooms) alongside maintenance holds (OOO - Out of Order, OOS Rooms - Out of Service) and booking adjustments (Day Use, Cancelled Rooms, No Show Rooms).

  • Guest Movement & Package Meal Tracking: Monitors daily turn volume (Arrivals, Departures), guest occupant density (No of Guests, No of Adults, No of Children), and meal plan inclusions (Package Including Breakfast Guests, Package Excluding Breakfast Guests).

  • Multi-Departmental Revenue Breakdown: Unbundles gross room earnings (Room Revenue, Room Rent Amount) from food & beverage sales (F&B Revenue), incidental charges (Other Revenue), and balance sheet pass-throughs (Non Revenue).

Report Views & Functional Breakdown

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

┌────────────────────────────────────────────────────────────────────────┐
│               MARKET SEGMENT DETAILS SUMMARY REPORT                    │
├────────────────────────────────────────────────────────────────────────┤
│                         Unified Matrix View                            │
├──────────────────────────┬──────────────────────────┬──────────────────┤
│ 1. Capacity Utilization  │ 2. Guest Movement &      │ 3. Multi-Department│
│    & Inventory Control   │    Meal Inclusions       │    Revenue Yield │
└──────────────────────────┴──────────────────────────┴──────────────────┘

1. Capacity Utilization & Inventory Control

Monitors physical room capacity, sold room night volume, out-of-order holds, and non-arrival activity per market segment.

  • Primary Use: Evaluating physical capacity utilization (Total Rooms, Number Of Rooms Sold), tracking maintenance holds (OOO, OOS Rooms), and monitoring booking drop-offs (Cancelled Rooms, No Show Rooms, Day Use).

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

2. Guest Movement & Meal Inclusions

Tracks daily guest turnover and occupant headcounts for front desk operations and food & beverage planning.

  • Primary Use: Managing arrival and departure turn volume (Arrivals, Departures), auditing guest occupant density (No of Guests, No of Adults, No of Children), and planning breakfast outlet production (Package Including Breakfast Guests, Package Excluding Breakfast Guests).

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

3. Multi-Department Revenue Yield

Measures financial revenue generation across accommodation, dining, and incidental department posting categories.

  • Primary Use: Evaluating gross room revenue (Room Revenue, Room Rent Amount), auditing food and beverage earnings (F&B Revenue), tracking ancillary charges (Other Revenue, Non Revenue), and confirming operational currency mapping (Currency).

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

Image 10-7-26 at 5.32 PM.png
Market Segment Details Summary

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 Treatment Note: Room Revenue, Room Rent Amount, F&B Revenue, Other Revenue, and Non Revenue represent Gross Financial Amounts (Excludes Taxes & Fees). Room Revenue reflects total accommodation earnings, which includes Room Rent Amount plus room-adjacent add-ons.

Column Name

Description

Data Source / System Mapping

Includes Taxes & Fees?

Reservation Date

Official business date for which market segment performance is reported.

System Business Date

N/A

Market Segment Code

Unique alphanumeric code identifying the market segment (e.g., I, B, C, A).

Market Segment Master

N/A

Market Segment Name

Full description of the commercial market segment (e.g., Local Corporate, Tour Series, Advanced Purchase Direct, Fully Flex BAR Direct).

Market Segment Master

N/A

Total Rooms

Total physical room capacity configured at the property (e.g., 255.0).

Physical Inventory Engine

N/A

Number Of Rooms Sold

Total physical room nights sold and occupied by the market segment on the business date.

SUM(Segment Occupied Rooms)

N/A

OOO

Physical rooms removed from inventory due to maintenance or repairs.

OOO/OOS Inventory Logs

N/A

OOS Rooms

Physical rooms temporarily placed out of service.

OOS Inventory Logs

N/A

Day Use

Count of day-use rooms rented without overnight stay within the segment.

Reservation Engine

N/A

Cancelled Rooms

Total reservations cancelled for the business date in the market segment.

Cancellation Engine

N/A

No Show Rooms

Total reservations where guests failed to arrive without advance cancellation.

Non-Arrival Engine

N/A

Departures

Total guest room departures completed or scheduled for the segment on the business date.

Departure Engine

N/A

Arrivals

Total guest room arrivals completed or scheduled for the segment on the business date.

Arrival Engine

N/A

No of Guests

Total registered guest occupant headcount for the market segment (No of Adults + No of Children).

SUM(Adults + Children)

N/A

No of Adults

Total registered adult guests occupying rooms in the market segment.

Reservation > Occupancy

N/A

No of Children

Total registered child guests occupying rooms in the market segment.

Reservation > Occupancy

N/A

Package Including Breakfast Guests

Count of registered guests booked on rate plans with breakfast package inclusions.

Package Rate Engine

N/A

Package Excluding Breakfast Guests

Count of registered guests booked on room-only rate plans without breakfast inclusions.

Package Rate Engine

N/A

Currency

Monetary currency code governing all financial values (e.g., USD).

System Currency Setup

N/A

Room Revenue

Gross accommodation revenue generated by the market segment.

SUM(Segment Room Charges)

❌ No

Room Rent Amount

Base room rate revenue component earned by the market segment.

SUM(Base Room Charges)

❌ No

F&B Revenue

Food and beverage sales posted to folios within the market segment.

POS / Outlet Ledger

❌ No

Other Revenue

Incidental fees and ancillary earnings generated by the market segment.

Ancillary Revenue Ledger

❌ No

Non Revenue

Non-revenue balance sheet transfers or pass-through postings within the segment.

Non-Revenue Ledger Engine

❌ No

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): Reservation Date | Market Segment Code | Market Segment Name

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

      Actualized Reservation Movements (Cols 8–12): Arrivals | Departures | Cancelled Rooms | No Show Rooms | Number Of Rooms Sold

    • Guest Demographics & Meal Inclusions (Cols 13–17): No of Adults | No of Children | No of Guests | Package Including Breakfast Guests | Package Excluding Breakfast Guests

    • Financial Revenue Streams (Cols 18–22): Room Revenue | Room Rent Amount | F&B Revenue | Other Revenue | Non Revenue

    • Currency Control (Col 23): Currency

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-30-26 at 2.14 PM.png

 

Background Export

Allows users to download up to 365 days of data directly to their computer in CSV format.
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.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 Summary 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 5.35 PM.png
Group By & Pie Chart Visualization

Advanced Controls

  • Exporting & Mix Strategy Analysis: Download in Excel or PDF format to support weekly revenue meetings, market segment yield strategy reviews, and month-end accounting tie-outs.

  • Filtering: Filter data by specific date ranges or market segment codes (e.g., isolate corporate segments I vs. BAR segments A).

  • Highlighting (Conditional Formatting): Apply custom rules to automatically highlight high-performing market segments, non-zero cancellation counts, or high ancillary revenue entries (Other Revenue > $0.00).

Within 📈 Revenue & Analytics & 🥧 Market & Segmentation:

  • Market Segment Details – Dual-section report combining a daily market summary with itemized guest folio transaction details.

  • Market Segment Details Forecast – Forward-looking demand intelligence report projecting market segment room nights, guest movements, and revenues.

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

Cross-Pillar Deep Dives:

  • ⚖️ Ledgers & Trial Balance: Reconcile room revenue realizations against General Ledger control accounts in Trial Balance or Day End Summary.

  • 💳 Payments & Transactions: To inspect specific guest payments and folio charges driving market segment revenue, review All Transactions.