Breadcrumbs

Local Market Segment .ng

Local Market Segment Report Overview

Parent Hub: 📈 Revenue & Analytics

Category: 🥧 Market & Segmentation

Target Roles: Directors of Revenue Management, General Managers, Directors of Sales, Financial Analysts, Market Segment Strategists

Key Value: Evaluate daily property yield and demand contribution across localized market segment classifications, monitor occupancy and RevPAR penetration per segment, and optimize market pricing strategies.

Executive Summary

The Local Market Segment Report is a primary market segmentation audit and demand contribution intelligence document within the 🥧 Market & Segmentation category of the 📈 Revenue & Analytics hub. Designed to deliver granular visibility into market source performance, it tracks daily revenue generation, room stay volumes, guest headcounts, and rate yield metrics across all locally defined market segments configured at the property.

By pairing stay timeline parameters (Date, Day Of Week) with market classification codes (Local Market Segment, Local Market Segment Code) and performance metrics (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 (e.g., Association Meeting, Business Products, Corporate Preferred, Leisure Group), monitor segment occupancy and RevPAR penetration, and refine market-specific yield strategies.

Key Capabilities

  • Granular Local Market Segmentation: Itemizes performance across property-specific local market segment codes (e.g., A - Association Meeting, B - Business Products, G - Corporate Regular, L - Corporate Negotiated, P - Corporate Preferred, U - Leisure Group, W - Wholesale).

  • Multi-Dimensional Yield & Production Tracking: Logs daily revenue earnings (Revenue), occupied room nights (Stays), registered guest headcounts (Adults, Children, Total Guests), and Average Daily Rate (ADR) for each local segment.

  • Contribution & Penetration Analytics: Calculates each local market segment's proportional share of overall property occupancy (Occupancy Contribution) and revenue yield (RevPAR Contribution).

Report Views & Functional Breakdown

The Local Market Segment Report presents market segment performance in a unified single-table ledger that supports three key analytical perspectives:

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

1. Segment Revenue & Rate Yield Audit

Monitors gross revenue generation and Average Daily Rates across individual local market segments.

  • Primary Use: Evaluating which local market segments generate the highest total revenue (Revenue), auditing rate realization (ADR), and tracking segment code attributions (Local Market Segment Code).

  • Key Metrics: Date, Day Of Week, Local Market Segment, Local Market Segment Code, Revenue, ADR.

2. Production & Guest Demographics

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

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

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

3. Penetration & Contribution Analytics

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

  • Primary Use: Assessing market segment penetration (Occupancy Contribution), evaluating segment contribution to overall RevPAR (RevPAR Contribution), and optimizing business mix strategies.

  • Key Metrics: Date, Local Market Segment Code, Revenue, Occupancy Contribution, RevPAR Contribution.

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

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., Thursday, Friday, Saturday).

System Calendar Engine

N/A

Local Market Segment

Full description of the localized market segment classification (e.g., Association Meeting, Business Products, Corporate Regular, Leisure Group, Wholesale).

Market Segment Setup Master

N/A

Local Market Segment Code

Unique alphanumeric code assigned to the local market segment (e.g., A, B, C, D, F, G, H, I, J, K, L, M, N, O, P, Q, S, T, U, V, W, Y, Z).

Market Segment Setup Master

N/A

Revenue

Gross base room revenue generated by the local market segment on the business date.

SUM(Segment Room Charges)

❌ No

Stays

Total occupied room nights generated by the local market segment on the business date.

SUM(Segment Occupied Rooms)

N/A

Adults

Registered adult guests occupying rooms within the local market segment.

Reservation > Occupancy

N/A

Children

Registered child guests occupying rooms within the local 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 (Revenue / Stays).

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 (Revenue / Total Available Rooms).

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 | Local Market Segment Code | Local Market Segment

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

    • Revenue Stream (Col 9): Revenue

    • Rate Yield & Contribution Metrics (Cols 10–12): 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: The Local Market Segment report features an interactive pie chart to help analyze segment performance and market mix distributions. Users can group market records on the fly by Local Market Segment or Date to evaluate segment mix performance trends over time. By selecting either Revenue or Stays from the Select Base Column dropdown menu, the chart dynamically renders percentage share breakdowns accompanied by an interactive color-coded segment legend.

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

  • Bar Chart Visualizer: The Local Market Segment report includes an interactive bar chart to help analyze 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 (Revenue) or room night volumes (Stays) chronologically alongside the detailed segment data grid.

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

Advanced Controls

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

  • Filtering: Filter data by specific date ranges or local market segment codes (e.g., isolate corporate segments G, L, P vs. leisure segments K, U).

  • 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 Summary – Deep dive into primary market segment revenue breakdowns, transient vs. group splits, and ADR performance.

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

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 transactions driving market segment revenue, review All Transactions.