Breadcrumbs

Market Segment Summary .ng

Market Segment 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, Revenue Analysts

Key Value: Evaluate daily commercial market mix profitability, audit room and incidental revenue contributions by market segment, monitor guest demographics, and analyze Average Daily Rate (ADR), occupancy contribution, and RevPAR contribution across commercial classifications.

Executive Summary

The Market Segment Summary Report is a primary commercial market mix audit and yield performance document within the 🥧 Market & Segmentation category of the 📈 Revenue & Analytics hub. Designed to deliver consolidated daily visibility into commercial source channels, it aggregates room night production, occupant headcounts, gross revenue realizations, and yield penetration metrics across all active market segments configured at the property.

By pairing stay timeline parameters (Date, Day Of Week) with market classification master codes (Market Segment, Market Segment Code like K - LEISURE OTHER, W - WHOLESALE, V - POLICY AND PROCEDURE AND AIRLINE DELAY, D - DISCOUNT AND TRANSIENT DISCOUNT, Y - LONG STAY, G - CORPORATE REGULAR, L - CORPORATE NEGOTIATED, M - GOVERNMENT INDIVIDUAL, P - CORPORATE PREFERRED) and monetary yield indicators (Room Revenue, Other Room Revenue, Total Revenue, Stays, Adults, Children, Total Guests, ADR, Occupancy Contribution, RevPAR Contribution), this report enables revenue managers, sales directors, and controllers to evaluate segment mix profitability, track transient versus corporate volume, prevent rate dilution, and optimize forward pricing structures.

Key Capabilities

  • Categorical Market Mix Analysis: Itemizes daily performance across primary market classifications (e.g., Discount and Transient Discount, Corporate Preferred, Corporate Regular, Long Stay, Corporate Negotiated, Leisure Other, Government Individual, Policy and Procedure, Wholesale).

  • Multi-Stream Revenue Unbundling: Differentiates base accommodation earnings (Room Revenue) from incidental room-adjacent fees (Other Room Revenue) to calculate combined departmental yield (Total Revenue).

  • Guest Demographics & Stay Production: Tracks total occupied room nights (Stays) alongside registered guest headcounts (Adults, Children, Total Guests) for each market segment.

  • Penetration & Yield Benchmarking: Calculates key performance indicators—including Average Daily Rate (ADR), proportional share of total physical capacity (Occupancy Contribution), and revenue yield per available room (RevPAR Contribution)—for every market segment.

Report Views & Functional Breakdown

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

┌────────────────────────────────────────────────────────────────────────┐
│                    MARKET SEGMENT SUMMARY REPORT                       │
├────────────────────────────────────────────────────────────────────────┤
│                         Unified Matrix View                            │
├──────────────────────────┬──────────────────────────┬──────────────────┤
│ 1. Segment Revenue &     │ 2. Production & Guest    │ 3. Penetration & │
│    Departmental Mix      │    Demographics          │    Contribution  │
└──────────────────────────┴──────────────────────────┴──────────────────┘

1. Segment Revenue & Departmental Mix

Monitors gross revenue generation and unbundles earnings across room revenue and incidental revenue streams per market segment.

  • Primary Use: Evaluating which commercial market segments generate the highest total revenue (Total Revenue), auditing base room charges (Room Revenue), and tracking incidental fee add-ons (Other Room Revenue).

  • Key Metrics: Date, Day Of Week, Market Segment, Market Segment Code, Room Revenue, Other Room Revenue, Total Revenue.

2. Production & Guest Demographics

Tracks occupied room night volumes and registered guest headcounts by commercial market source.

  • Primary Use: Measuring room night production (Stays), evaluating guest occupant density (Adults, Children, Total Guests), and analyzing commercial volume trends.

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

3. Penetration & Contribution Analytics

Measures pricing realization and each market segment's share of total property occupancy and RevPAR.

  • Primary Use: Comparing ADR realization across commercial segments (ADR), assessing market segment capacity penetration (Occupancy Contribution), and evaluating segment yield contribution to total property RevPAR (RevPAR Contribution).

  • Key Metrics: Date, Market Segment Code, Stays, Total Revenue, ADR, Occupancy Contribution, RevPAR Contribution.

Image 10-7-26 at 6.41 PM.png
Market Segment 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 & Rate Calculation Note: Room Revenue, Other Room Revenue, Total Revenue, ADR, and RevPAR Contribution represent Gross Base Room Revenue (Excludes Taxes & Fees). Total Revenue is calculated as Total Revenue = Room Revenue + Other Room Revenue. Occupancy Contribution is rendered as a decimal ratio (e.g., 0.2857 = 28.57%).

Column Name

Description

Data Source / System Mapping

Includes Taxes & Fees?

Date

Official business date for which market segment performance is reported.

System Business Date

N/A

Day Of Week

Calendar day of the week corresponding to the business date (e.g., Tuesday).

System Calendar Engine

N/A

Market Segment

Full description of the commercial market segment classification (e.g., DISCOUNT AND TRANSIENT DISCOUNT, CORPORATE PREFERRED, CORPORATE REGULAR, LONG STAY, LEISURE OTHER, CORPORATE NEGOTIATED, GOVERNMENT INDIVIDUAL, POLICY AND PROCEDURE, WHOLESALE).

Market Segment Master Setup

N/A

Market Segment Code

Unique alphanumeric code assigned to the market segment (e.g., K, W, V, D, Y, G, L, M, P).

Market Segment Master Setup

N/A

Room Revenue

Gross base room revenue generated by guest stays within the market segment.

SUM(Segment Room Charges)

❌ No

Other Room Revenue

Additional room-adjacent revenue charges posted to folios within the market segment.

SUM(Segment Other Charges)

❌ No

Total Revenue

Consolidated gross room revenue generated by the market segment (Room Revenue + Other Room Revenue).

SUM(Segment Gross Revenue)

❌ No

Stays

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

SUM(Segment Occupied Rooms)

N/A

Adults

Total registered adult guests occupying rooms in the market segment.

Reservation > Occupancy

N/A

Children

Total registered child guests occupying rooms in the market segment.

Reservation > Occupancy

N/A

Total Guests

Total registered guest occupant headcount within the segment (Adults + Children).

SUM(Adults + Children)

N/A

ADR

Average Daily Rate earned per occupied room night in the segment (Total Revenue / Stays).

Total Revenue / Stays

❌ No

Occupancy Contribution

Proportional share of total property physical capacity occupied by the segment (Stays / Total Available Rooms).

Stays / Property Total Rooms

N/A

RevPAR Contribution

Revenue Per Available Room yield contributed specifically by the segment (Total Revenue / Total Available Rooms).

Total Revenue / Property Total Rooms

❌ 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–4): Date | Day Of Week | Market Segment Code | Market Segment

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

    • Revenue Streams (Cols 9–11): Room Revenue | Other Room Revenue | Total Revenue

    • Rate Yield & Contribution Metrics (Cols 12–14): ADR | Occupancy Contribution | RevPAR Contribution

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 summary section of the Market Segment Summary report, users can utilize the interactive pie chart to evaluate market segment performance and share distribution. Users can group market records on the fly by Market Segment or Day Of Week Market Segment to evaluate segment mix performance trends over time. By selecting a metric from the Select Base Column dropdown menu—such as Room Revenue, Stays, ADR, or RevPAR Contribution—the chart dynamically renders percentage contribution breakdowns alongside an interactive color-coded segment legend.

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

  • Bar Chart Visualizer: The Market Segment Summary report includes an interactive bar chart to help analyze market segment production and revenue performance over time. By adjusting the Select Column (Y-Axis) dropdown menu, users can dynamically toggle the chart view to plot financial yields (Room Revenue) or room night volumes (Stays) chronologically alongside the detailed summary data grid.

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

Advanced Controls

  • Exporting & Mix Strategy Analysis: Download in Excel or PDF format to support weekly revenue strategy meetings, corporate account target reviews, and commercial market mix optimization.

  • Filtering: Filter data by specific date ranges or market segment codes (e.g., isolate corporate segments P, G, L vs. transient discount segment D).

  • Highlighting (Conditional Formatting): Apply custom rules to automatically highlight high-performing market segments or segments experiencing rate dilution.

Within 📈 Revenue & Analytics & 🥧 Market & Segmentation:

  • Market Segment Overview – Executive-level report tracking daily, MTD, and YTD market segment performance and contribution share.

  • 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.