Market Segment Details .ng | HotelKey Knowledge Base

Market Segment Details Report Overview

Parent Hub: 📈 Revenue & Analytics

Category: 🥧 Market & Segmentation

Target Roles: Directors of Revenue Management, General Managers, Directors of Sales, Night Auditors, Financial Analysts

Key Value: Evaluate commercial market mix yield performance, verify transaction-level revenue posting accuracy across market segments, audit individual guest stay rate plan routing, and reconcile daily segment summaries against transaction detail ledgers.

Executive Summary

The Market Segment Details Report is a primary commercial performance audit and transaction-level segmentation document within the 🥧 Market & Segmentation category of the 📈 Revenue & Analytics hub. Designed to bridge high-level market strategy with granular folio postings, it provides dual-section visibility into how different commercial market segments contribute to total property revenue.

By organizing market performance across two structured operational sections (Market Segment Transaction Summary and Market Segment Transaction Details), this report pairs market classification codes (Market Segment, Market Segment Code like C - Corporate Meeting and Groups, G - Corporate Regular, D - Discount and Transient Discount, U - Leisure Group, K - Leisure Other) with stay parameters (Date, Day Of Week, Confirmation Number, Guest Name, Room Number, Transaction Code, Transaction Description, Username, Remarks) and monetary yield metrics (Stays, Adults, Children, Total Guests, Room Revenue, Other Room Revenue, Total Revenue, ADR, Occupancy Contribution, RevPAR Contribution, Amount). This enables revenue managers and controllers to audit rate code mapping accuracy, track individual folio charge entries, investigate posting allowances/adjustments, and evaluate market mix profitability.

Key Capabilities

Dual-Section Market Governance: Combines a daily macro-level market segment performance rollup (Market Segment Transaction Summary) with an itemized, line-item guest folio transaction ledger (Market Segment Transaction Details).
Transaction-Level Auditability: Itemizes individual room charges (RR - Accommodation), no-show fees (NSFC - No Show Fee), early check-in/checkout fees, and rate type adjustments directly to the posting user ID (Username) and folio notes (Remarks).
Market Mix & Yield Penetration: Measures room night production (Stays), guest occupant headcounts (Adults, Children, Total Guests), Average Daily Rate (ADR), and proportional market contribution to property occupancy (Occupancy Contribution) and revenue (RevPAR Contribution).

Report Views & Functional Breakdown (All 2 Sections)

The Market Segment Details Report presents commercial performance across two structured operational sections:

┌────────────────────────────────────────────────────────────────────────┐
│                   MARKET SEGMENT DETAILS REPORT                        │
├────────────────────────────────────────────────────────────────────────┤
│ 1. Market Segment Transaction Summary Section                          │
│    (Daily Macro Rollup of Volume, Revenue, ADR, & Penetration by Segment)│
├────────────────────────────────────────────────────────────────────────┤
│ 2. Market Segment Transaction Details Section                          │
│    (Line-Item Guest Folio Ledger with Transaction Codes & Audit Notes) │
└────────────────────────────────────────────────────────────────────────┘

1. Market Segment Transaction Summary

Provides a daily macro rollup of market segment performance, tracking room night production, revenue generation, and yield penetration per market segment.

Primary Use: Evaluating daily market mix profitability, tracking segment volume trends (Stays), auditing Average Daily Rates (ADR), and measuring market segment contribution to total property capacity (Occupancy Contribution) and yield (RevPAR Contribution).
Key Metrics: Date, Day Of Week, Market Segment, Market Segment Code, Stays, Adults, Children, Total Guests, Room Revenue, Other Room Revenue, Total Revenue, ADR, Occupancy Contribution, RevPAR Contribution.

Image 10-7-26 at 2.27 PM.png — Market Segment Transaction Summary Section

2. Market Segment Transaction Details

Delivers an itemized transaction ledger logging every individual guest folio charge entry mapped to a market segment during the business date.

Primary Use: Inspecting individual guest charges, verifying transaction codes (Transaction Code = RR, NSFC, 1303, RTC), auditing user posting activity (Username), investigating service recovery write-offs (Remarks), and confirming rate plan segment routing.
Key Metrics: Date, Confirmation Number, Guest Name, First Name, Last Name, Room Number, Transaction Code, Transaction Description, Charge Type, Amount, Username, Market Segment, Market Segment Code, Revenue Category, Remarks.

Image 10-7-26 at 2.36 PM.png — Market Segment Transaction Details

Data Dictionary (Dynamic View Columns Across Both Sections)

Customize your default view using the Configure (⚙️) icon on the report page. Below is the full data dictionary representing every column available across both sections of this report:

💡 Monetary & Rate Calculation Note: All revenue columns (Room Revenue, Other Room Revenue, Total Revenue, Amount, ADR) represent Gross Financial Amounts (Includes Taxes & Fees) unless configured as net base revenue items. Total Revenue in the summary section is calculated as Total Revenue = Room Revenue + Other Room Revenue. Occupancy Contribution is rendered as a decimal ratio (e.g., 0.2744 = 27.44%).

Column Name	Section(s) Where Column Appears	Description	Data Source / System Mapping	Includes Taxes & Fees?
Date	Both Sections	Official business date associated with the market performance or transaction posting.	System Business Date	N/A
Day Of Week	Transaction Summary	Calendar day of the week corresponding to the business date (e.g., Tuesday, Wednesday).	System Calendar Engine	N/A
Market Segment	Both Sections	Full description of the commercial market segment classification (e.g., CORPORATE MEETING AND GROUPS, LEISURE GROUP, LEISURE OTHER, DISCOUNT AND TRANSIENT DISCOUNT, CORPORATE REGULAR).	Market Segment Setup Master	N/A
Market Segment Code	Both Sections	Unique alphanumeric code assigned to the market segment (e.g., `C`, `U`, `K`, `D`, `G`, `A`, `B`, `L`, `P`, `Q`, `S`, `T`, `V`, `W`, `Y`, `Z`).	Market Segment Setup Master	N/A
Stays	Transaction Summary	Total occupied room nights generated by the market segment on the business date.	`SUM(Segment Occupied Rooms)`	N/A
Adults / Children	Transaction Summary	Itemized adult and child occupant headcounts within the market segment.	`Reservation > Occupancy`	N/A
Total Guests	Transaction Summary	Total registered guest headcount within the segment (`Adults + Children`).	`SUM(Adults + Children)`	N/A
Room Revenue	Transaction Summary	Gross room accommodation revenue generated by the market segment.	`SUM(Segment Room Charges)`	🟢 Yes
Other Room Revenue	Transaction Summary	Additional room-adjacent incidental charges posted within the segment.	`SUM(Segment Other Charges)`	🟢 Yes
Total Revenue	Transaction Summary	Consolidated gross revenue generated by the market segment (`Room Revenue + Other Room Revenue`).	`SUM(Segment Gross Revenue)`	🟢 Yes
ADR	Transaction Summary	Average Daily Rate earned per occupied room night in the segment (`Total Revenue / Stays`).	`Total Revenue / Stays`	🟢 Yes
Occupancy Contribution	Transaction Summary	Proportional share of total property physical capacity occupied by the segment (`Stays / Total Available Rooms`).	`Stays / Property Total Rooms`	N/A
RevPAR Contribution	Transaction Summary	Revenue Per Available Room yield contributed specifically by the segment (`Total Revenue / Total Available Rooms`).	`Total Revenue / Property Total Rooms`	🟢 Yes
Confirmation Number	Transaction Details	Unique reference code assigned to the guest reservation (e.g., `22122850`, `82427414`, `49395946`).	System Reservation ID	N/A
Guest Name / First Name / Last Name	Transaction Details	Combined and itemized registered guest profile names on the folio.	`Guest Profile > Name`	N/A
Room Number	Transaction Details	Physical guest room assigned to the stay (e.g., `208`, `211`, `515`, `308`, `606`).	`Reservation > Room Number`	N/A
Transaction Code	Transaction Details	Unique transaction code posted to the folio (e.g., `RR` - Accommodation, `NSFC` - No Show Fee, `1303` - Early Check In, `RTC` - Room Type Change).	Transaction Code Master	N/A
Transaction Description	Transaction Details	Human-readable title of the posted transaction code.	Transaction Code Master	N/A
Charge Type	Transaction Details	Ledger charge type classification (e.g., `ROOM_RENT`).	General Ledger Setup	N/A
Amount	Transaction Details	Monetary value posted for the individual folio transaction entry.	Folio Transaction Ledger	🟢 Yes
Username	Transaction Details	User ID or system service account that executed the folio posting (e.g., `james.fuller@hotelkeyapp.com`, `systemuser`, `ina.mohan@hotelkeyapp.com`).	Audit Log Engine	N/A
Revenue Category	Transaction Details	Financial revenue category grouping (e.g., Room Revenue).	Financial Setup Master	N/A
Remarks	Transaction Details	Free-text operational audit notes, allowance justifications, or service recovery comments entered by staff (e.g., Room too cold, posted twice, Service Recovery, AC in room was having issues).	Folio Transaction Notes	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:
- Section 1: Market Segment Transaction Summary
  - Timeline & Market Segment Anchors (Cols 1–4): Date | Day Of Week | Market Segment Code | Market Segment
  - Volume & 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
- Section 2: Market Segment Transaction Details
  - Operational & Confirmation Anchors (Cols 1–2): Room Number | Confirmation Number
  - Guest Profile Context (Cols 3–5): Guest Name | First Name | Last Name
  - Posting Timeline & GL Identifiers (Cols 6–8): Date | Transaction Code | Transaction Description
  - Market Segment & Revenue Classification (Cols 9–12): Market Segment Code | Market Segment | Revenue Category | Charge Type
  - Transaction Financials & Audit Controls (Cols 13–15): Amount | Username | Remarks

Use the top-right toolbar icons on the report page to manage and export your data view:

Icon	Action / Feature	Description
	Knowledge Article	Opens the knowledge base article to learn how to interpret this report.
	Background Export	Allows users to download up to 365 days of data directly to their computer in CSV format.
	Saved Views	Saves your column filtering, sorting, and highlight preferences so you can easily reload your custom view later without reconfiguring the report.
	Bar Chart	Displays report data in a visual bar chart format.
	Filter	Opens filter controls to isolate specific data within a column based on your selected criteria.
	Highlight	Highlights column values in a designated color based on selected conditions.
	Export	Exports and downloads the report in various formats (Excel, PDF, CSV) for offline analysis or printing.
	Configure	Opens column selection controls to toggle visibility, reorder columns, or hide rows with all zeros.
	Additional Configuration	Provides advanced report configuration and display formatting options to customize data presentation.
	Group By	Summarize and group report data dynamically in real time.

Interactive Visualizations & Grouping Controls

Group By & Pie Chart Visualization: Within the Market Segment Transaction Summary sub-tab of the Market Segment Details report, users can utilize the interactive pie chart to analyze segment mix performance. Apply Dynamic Section Grouping to group detail entries on the fly by Market Segment or Day of Week and Market Segment to analyze posting patterns. By selecting a metric from the Select Base Column dropdown menu—such as Room Revenue, Stays, ADR, or RevPAR Contribution—the chart dynamically displays percentage contribution breakdowns alongside an interactive color-coded market segment legend.

Image 10-7-26 at 3.37 PM.png — *Group By & Pie Chart Visualization*

Bar Chart Visualizer: The Market Segment Details report includes an interactive bar chart to help visualize segment production and revenue trends 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 data grid across the Market Segment Transaction Summary.

Image 10-7-26 at 3.43 PM.png — *Bar Chart Visualizer*

Advanced Controls

Exporting & Auditing: Download in Excel or PDF format to support night audit balancing, market segment revenue reconciliations, and staff posting audits.
Filtering: Filter data by specific Market Segment Code, Transaction Code (RR, NSFC), or non-zero Amount entries.
Highlighting (Conditional Formatting): Apply custom rules to automatically highlight negative rate adjustments, service recovery write-offs in Remarks, or high-value group postings.

Within 📈 Revenue & Analytics & 🥧 Market & Segmentation:

Market Segment Summary – Deep dive into primary market segment revenue breakdowns, transient vs. group splits, and ADR performance.
Local Market Segment Details – Review reservation-level postings mapped to local market segment classifications.
General Manager Report – Review property-wide macro statistics, total room revenues, ADR, and RevPAR performance.

Cross-Pillar Deep Dives:

⚖️ Ledgers & Trial Balance: Reconcile room revenue transaction codes (RR) 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.