Breadcrumbs

Local Market Segment Details .ng

Local Market Segment Details Report Overview

Parent Hub: 📈 Revenue & Analytics

Category: 🥧 Market & Segmentation

Target Roles: Directors of Revenue Management, General Managers, Directors of Sales, Reservation Supervisors, Operations Analysts

Key Value: Provide complete guest-level and reservation-level auditability across localized market segment classifications, verify rate plan to market segment mapping accuracy, and analyze stay parameters for segment-specific bookings.

Executive Summary

The Local Market Segment Details Report is an operational audit and guest-level intelligence document within the 🥧 Market & Segmentation category of the 📈 Revenue & Analytics hub. Designed to complement high-level market summary reports, it itemizes every individual reservation mapped to a local market segment code over a selected operational period.

By pairing primary guest demographics (Guest Name, First Name, Last Name) and stay parameters (Confirmation Number, Check In Date, Check Out Date, Reservation Status) with market classification codes (Local Market Segment Code, Local Market Segment) and contracted pricing structures (Rate Code), this report enables revenue managers, front office supervisors, and sales directors to audit rate plan mapping integrity, verify guest eligibility for segment-specific promotions, and inspect individual stay timelines across localized market categories.

Key Capabilities

  • Reservation-Level Market Audit: Itemizes individual guest stays mapped to local market segment codes across active operational reservation statuses (CHECKED OUT, IN HOUSE).

  • Rate Plan & Segment Mapping Verification: Links specific contracted rate codes (e.g., BEST FLEXIBLE RATE, HOTEL KEY GROUP RATE, BOOK EARLY ADVANCE PURCHASE) directly to their assigned local market segment descriptions.

  • Stay Timeline & Guest Identification: Captures guest full names, confirmation reference numbers, arrival dates, and departure dates to verify length of stay and profile data.

Report Views & Functional Breakdown

The Local Market Segment Details Report presents guest reservation entries in a unified operational ledger that supports three key analytical perspectives:

┌────────────────────────────────────────────────────────────────────────┐
│               LOCAL MARKET SEGMENT DETAILS REPORT                      │
├────────────────────────────────────────────────────────────────────────┤
│                       Unified Operational Ledger                       │
├──────────────────────────┬──────────────────────────┬──────────────────┤
│ 1. Guest & Reservation   │ 2. Market Segment & Rate │ 3. Stay Timeline &│
│    Identification        │    Plan Alignment        │    Fulfillment   │
└──────────────────────────┴──────────────────────────┴──────────────────┘

1. Guest & Reservation Identification

Monitors individual guest profiles and system booking identifiers mapped to localized market categories.

  • Primary Use: Verifying guest identity (Guest Name, First Name, Last Name) and tracking unique system confirmation numbers (Confirmation Number).

  • Key Metrics: Guest Name, First Name, Last Name, Confirmation Number.

2. Market Segment & Rate Plan Alignment

Audits the mapping alignment between contracted rate codes and local market segment classifications.

  • Primary Use: Ensuring rate plans (Rate Code) route to the correct local market segment (Local Market Segment Code, Local Market Segment) such as Association Meeting, Business Products, Corporate Regular, Airline, or Leisure Group.

  • Key Metrics: Local Market Segment Code, Local Market Segment, Rate Code.

3. Stay Timeline & Fulfillment

Tracks reservation arrival dates, departure dates, and live operational fulfillment states.

  • Primary Use: Inspecting guest stay durations (Check In Date, Check Out Date) and confirming reservation completion states (Reservation Status).

  • Key Metrics: Check In Date, Check Out Date, Reservation Status.

Image 10-7-26 at 1.52 PM.png
Local Market Segment Details 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:

Column Name

Description

Data Source / System Mapping

Includes Taxes & Fees?

Guest Name

Combined primary guest full name (Last Name / First Name).

Guest Profile > Full Name

N/A

First Name

Primary guest registered first name.

Guest Profile > First Name

N/A

Last Name

Primary guest registered last name.

Guest Profile > Last Name

N/A

Confirmation Number

Unique reference code assigned to the guest reservation (e.g., 67949631, 40970023, 61380154).

System Reservation ID

N/A

Local Market Segment Code

Alphanumeric code identifying the local market segment (e.g., A - Association Meeting, B - Business Products, G - Corporate Regular, O - Airline, U - Leisure Group).

Market Segment Setup Master

N/A

Local Market Segment

Full description of the assigned local market segment classification.

Market Segment Setup Master

N/A

Rate Code

Rate plan or pricing code governing the booking (e.g., BEST FLEXIBLE RATE, HOTEL KEY GROUP RATE, BOOK EARLY ADVANCE PURCHASE).

Rate Code Configuration

N/A

Check In Date

Official arrival date of the guest reservation.

Reservation > Check In Date

N/A

Check Out Date

Official departure date of the guest reservation.

Reservation > Check Out Date

N/A

Reservation Status

Current operational state of the reservation (e.g., CHECKED OUT, IN HOUSE).

System Reservation 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:

    • Confirmation Anchor (Col 1): Confirmation Number

    • Guest Profile Context (Cols 2–4): Guest Name | First Name | Last Name

    • Market Segment Metadata (Cols 5–6): Local Market Segment Code | Local Market Segment

    • Stay Window Parameters (Cols 7–8): Check In Date | Check Out Date

    • Rate Plan Control (Col 9): Rate Code

    • Lifecycle Operational Status (Col 10): Reservation Status

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.

Advanced Controls

  • Exporting & Auditing: Download in Excel or PDF format to support weekly sales segment audits, rate plan setup verification, and corporate account tracking.

  • Filtering: Filter data by specific Local Market Segment Code (e.g., isolate A - Association Meeting or B - Business Products), Rate Code, or Reservation Status.

  • Highlighting (Conditional Formatting): Apply custom rules to automatically highlight long-stay reservations, specific rate codes, or active in-house stays (Reservation Status = IN HOUSE).

Within 📈 Revenue & Analytics & 🥧 Market & Segmentation:

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

  • Market Segment Revenue Overview – Deep dive into primary market segment revenue breakdowns, transient vs. group splits, and ADR performance.

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

Cross-Pillar Deep Dives:

  • 🛎️ Front Desk & Guest Services: Cross-reference active segment stays with In-House Guest List.

  • 💳 Payments & Transactions: To inspect specific guest payments and folio charges for segment bookings, review All Transactions.