Rate Type Tracking .ng | HotelKey Knowledge Base

Rate Type Tracking Report Overview

Category: 🏷️ Rate Management

Target Roles: Directors of Revenue Management, Revenue Analysts, General Managers, Hotel Controllers, Sales & Marketing Directors

Key Value: Monitor year-over-year pricing and production performance across rate types, evaluate year-to-date and month-to-date room night production, track adult occupant headcounts and room revenue variances, and optimize rate category yield strategies.

Executive Summary

The Rate Type Tracking Report is a primary comparative performance and year-over-year rate strategy document within the 🏷️ Rate Management category of the 📈 Revenue & Analytics hub. Designed to deliver granular comparative intelligence across rate classifications, it organizes property performance into 3 defined time-horizon sections: Daily (Date), Month-to-Date (M-T-D), and Year-to-Date (Y-T-D).

By mapping rate classification categories (Rate Type) to year-over-year production and monetary metrics (Room Nights Current Year / Previous Year / Variance, Adult Count Current Year / Previous Year / Variance, Room Revenue Current Year / Previous Year / Variance, Average Daily Rate Current Year / Previous Year / Variance, and Volume Current Year / Previous Year / Variance), this report enables revenue managers, sales directors, and controllers to track rate strategy execution, analyze room night and revenue shifts, benchmark rate category growth, and optimize overall market segmentation yield.

Key Capabilities

3 Defined Time-Horizon Sections: Organizes comparative performance into Daily (Date), Month-to-Date (M-T-D), and Year-to-Date (Y-T-D) sections for multi-period trend auditing.
Year-over-Year Comparative Analysis: Benchmarks current year metrics directly against previous year historical performance across room nights, guest headcounts, room revenue, ADR, and volume contribution share.
Automatic Variance Calculation: Itemizes exact numerical differences between current and previous year figures to highlight growth, contraction, or shifting demand across rate types.
Rate Type Production Fencing: Evaluates specific rate plan categories (e.g., BEST AVAILABLE RATE, CORP30, ADVANCE PURCHASE, GROUP, MEMBER ONLY, MONTHLY, WEEKLY, SPECIAL) to measure rate fence effectiveness and pricing mix.
Volume Contribution Share Tracking: Quantifies the proportion of total property business generated by each rate type (Volume Current Year / Previous Year) to monitor channel and pricing reliance.

Report Views & Functional Breakdown

The Rate Type Tracking Report presents rate category comparative performance in a structured matrix across 3 defined sections:

┌────────────────────────────────────────────────────────────────────────┐
│                   RATE TYPE TRACKING REPORT                            │
├────────────────────────────────────────────────────────────────────────┤
│                       3 Defined Report Sections                        │
├──────────────────────────┬──────────────────────────┬──────────────────┤
│ 1. Daily Section (Date)  │ 2. Month-to-Date Section │ 3. Year-to-Date  │
│    (Single-Day Audit)    │    (M-T-D Cumulative)    │    Section (Y-T-D)│
└──────────────────────────┴──────────────────────────┴──────────────────┘

1. Daily Section (Date)

Monitors single-day rate type performance and year-over-year daily variance.

Primary Use: Evaluating immediate daily rate type production, auditing daily pricing strategy performance, and identifying short-term rate category shifts.
Key Metrics: Rate Type, Room Nights Current/Previous Year/Variance, Room Revenue Current/Previous Year/Variance, Average Daily Rate Current/Previous Year/Variance.

Image 10-9-26 at 9.02 AM.png — Date Section

2. Month-to-Date Section (M-T-D)

Aggregates cumulative month-to-date production by rate type and compares it against the same MTD period from the previous year.

Primary Use: Tracking monthly pace, evaluating active monthly marketing and promotional rate uptake, and measuring MTD volume contribution share.
Key Metrics: Rate Type, Room Nights MTD, Adult Count MTD, Room Revenue MTD, ADR MTD, Volume Current Year/Previous Year.

Image 10-9-26 at 9.05 AM.png — M-T-D Section

3. Year-to-Date Section (Y-T-D)

Evaluates long-term cumulative year-to-date rate type performance and annual year-over-year growth.

Primary Use: Assessing annual rate strategy success, auditing corporate contract and long-stay rate type production over time, and guiding future rate code configuration and budgeting.
Key Metrics: Rate Type, Room Nights YTD, Adult Count YTD, Room Revenue YTD, ADR YTD, Volume Current Year/Previous Year.

Image 10-9-26 at 9.08 AM.png — Rate Type Tracking

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 & Variance Calculation Note: Room Revenue and ADR represent base room revenue (Excludes Taxes & Fees). Variance columns reflect Current Year minus Previous Year (Variance = Current Year - Previous Year).

Column Name	Description	Data Source / System Mapping	Includes Taxes & Fees?
Rate Type	Name or classification category of the rate plan (e.g., BEST AVAILABLE RATE, CORP30, GROUP, MEMBER ONLY).	Rate Plan Setup > Rate Type Name	N/A
Room Nights Current Year	Physical room nights occupied under the rate type in the current period.	SUM(Current Year Occupied Nights)	N/A
Room Nights Previous Year	Physical room nights occupied under the rate type in the same period last year.	SUM(Previous Year Occupied Nights)	N/A
Room Nights Variance	Numerical difference in room nights (Current Year - Previous Year).	Current Year - Previous Year	N/A
Adult Count Current Year	Total registered adult headcount for stays under the rate type in the current period.	SUM(Current Year Adult Guests)	N/A
Adult Count Previous Year	Total registered adult headcount for stays under the rate type in the same period last year.	SUM(Previous Year Adult Guests)	N/A
Adult Count Variance	Numerical difference in adult guest headcount (Current Year - Previous Year).	Current Year - Previous Year	N/A
Room Revenue Current Year	Gross base room revenue generated by the rate type in the current period.	SUM(Current Year Base Room Revenue)	❌ No
Room Revenue Previous Year	Gross base room revenue generated by the rate type in the same period last year.	SUM(Previous Year Base Room Revenue)	❌ No
Room Revenue Variance	Monetary difference in room revenue (Current Year - Previous Year).	Current Year - Previous Year	❌ No
Average Daily Rate Current Year	Average rate earned per room night for the rate type in the current period (Revenue ÷ Nights).	Current Revenue / Current Nights	❌ No
Average Daily Rate Previous Year	Average rate earned per room night for the rate type in the previous year period.	Previous Revenue / Previous Nights	❌ No
Average Daily Variance	Variance in Average Daily Rate (Current ADR - Previous ADR).	Current ADR - Previous ADR	❌ No
Volume Current Year	Proportion of total hotel room night volume contributed by the rate type in the current period.	Rate Type Nights / Total Property Nights	N/A
Volume Previous Year	Proportion of total hotel room night volume contributed by the rate type in the previous year period.	Rate Type Nights / Total Property Nights	N/A
Volume Variance	Variance in volume contribution share (Current Volume - Previous Volume).	Current Volume - Previous Volume	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: Daily Production (Date)
  - Category Identification (Col 1): Rate Type
  - Room Night Production (Cols 2–4): Room Nights Current Year | Room Nights Previous Year | Room Nights Variance
  - Guest Occupancy Headcount (Cols 5–7): Adult Count Current Year | Adult Count Previous Year | Adult Count Variance
  - Financial Room Revenue (Cols 8–10): Room Revenue Current Year | Room Revenue Previous Year | Room Revenue Variance
  - Yield & Average Daily Rate (Cols 11–13): Average Daily Rate Current Year | Average Daily Rate Previous Year | Average Daily Variance
  - Volume Production (Cols 14–16): Volume Current Year | Volume Previous Year | Volume Variance
- Section 2: Month-To-Date Production (M-T-D)
  - Category Identification (Col 1): Rate Type
  - Room Night Production (Cols 2–4): Room Nights Current Year | Room Nights Previous Year | Room Nights Variance
  - Guest Occupancy Headcount (Cols 5–7): Adult Count Current Year | Adult Count Previous Year | Adult Count Variance
  - Financial Room Revenue (Cols 8–10): Room Revenue Current Year | Room Revenue Previous Year | Room Revenue Variance
  - Yield & Average Daily Rate (Cols 11–13): Average Daily Rate Current Year | Average Daily Rate Previous Year | Average Daily Variance
  - Volume Production (Cols 14–16): Volume Current Year | Volume Previous Year | Volume Variance
- Section 3: Year-To-Date Production (Y-T-D)
  - Category Identification (Col 1): Rate Type
  - Room Night Production (Cols 2–4): Room Nights Current Year | Room Nights Previous Year | Room Nights Variance
  - Guest Occupancy Headcount (Cols 5–7): Adult Count Current Year | Adult Count Previous Year | Adult Count Variance
  - Financial Room Revenue (Cols 8–10): Room Revenue Current Year | Room Revenue Previous Year | Room Revenue Variance
  - Yield & Average Daily Rate (Cols 11–13): Average Daily Rate Current Year | Average Daily Rate Previous Year | Average Daily Variance
  - Volume Production (Cols 14–16): Volume Current Year | Volume Previous Year | Volume Variance

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.
	Saved Views	Saves your column filtering, sorting, and highlight preferences so you can easily reload your custom view later without reconfiguring the report.
	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.

Advanced Controls

Exporting & Comparative Strategy Analysis: Download in Excel or PDF format to support budget planning meetings, yearly rate strategy reviews, and corporate contract renewals.
Filtering: Filter data by specific Rate Type (e.g., isolate BEST AVAILABLE RATE or GROUP), or filter for positive/negative revenue variances.
Highlighting (Conditional Formatting): Apply custom rules to automatically highlight rate types with significant positive or negative year-over-year revenue variances.

Within 📈 Revenue & Analytics & 🏷️ Rate Management:

Rate Plan Summary – Comprehensive overview evaluating daily and period-to-date revenue performance across individual rate plans.
Rate Code Configuration – Master system setup report detailing rate code parameters, lifecycle dates, and market mappings.
Rate Group Summary – High-level overview evaluating daily and cumulative revenue performance across HotelKey rate group buckets.
Discrepant Rates – Audit log comparing system-quoted benchmark rates against actual charged rates on guest folios.

Cross-Pillar Deep Dives:

🥧 Market & Segmentation: Reconcile rate type production against Market Segment Overview and Local Market Segment.
⚖️ Ledgers & Trial Balance: Reconcile room revenue postings by rate type against General Ledger control accounts in Trial Balance.