Breadcrumbs

Historical Arrivals Statistics .ng

Historical Arrivals Statistics Report Overview

Parent Hub: 📈 Revenue & Analytics

Category: 📊 Performance Summaries

Target Roles: Directors of Revenue Management, General Managers, Directors of Sales, Front Office Managers, Operations Analysts

Key Value: Audit historical arrival performance, track realized average room rates (ARR), evaluate booking channel sources, analyze front desk staff booking attribution, and review reservation fulfillment outcomes across realized stays, no-shows, and cancellations.

Executive Summary

The Historical Arrivals Statistics Report is a primary operational audit and arrival performance document within the 📊 Performance Summaries category of the 📈 Revenue & Analytics hub. Designed to provide complete post-arrival analysis, it logs all past arriving guest reservations across a selected historical operational period to track booking fulfillment and revenue yields.

By combining reservation identifiers (Confirmation Number, Group Number, Group Code) with guest profile details (Guest Name), stay parameters (Check In Date, Check Out Date, Room Type, Room Number), rate structures (Rate Code, Company, ARR), and operational audit tags (Current Reservation Status, Booked By, Balance), this report enables revenue managers, front office managers, and controllers to audit actualized room rates, evaluate group block pickups, analyze staff/user booking productivity, and measure no-show and cancellation impact.

Key Capabilities

  • Comprehensive Historical Arrival Audit: Itemizes all historical arrival entries within the selected date window across all booking statuses (Checked Out, No Show, Cancelled).

  • Realized Rate & Revenue Analysis: Captures actualized Average Room Rates (ARR) and outstanding guest balances (Balance) to evaluate rate plan profitability.

  • Group Block & Corporate Account Tracking: Links arrival records directly to group master identifiers (Group Number, Group Code) and contracting corporate profiles (Company).

  • Staff Productivity & Channel Attribution: Attributes every reservation directly to the user or agent who created the booking (Booked By) for internal commission and performance auditing.

Report Views & Functional Breakdown

The Historical Arrivals Statistics Report presents line-item arrival records in a unified operational ledger that supports three key analytical perspectives:

┌────────────────────────────────────────────────────────────────────────┐
│               HISTORICAL ARRIVALS STATISTICS REPORT                    │
├────────────────────────────────────────────────────────────────────────┤
│                       Unified Operational Ledger                       │
├──────────────────────────┬──────────────────────────┬──────────────────┤
│ 1. Arrival Fulfillment & │ 2. Rate & Revenue Yield  │ 3. Group, Corporate│
│    Status Audit          │    Analysis              │    & Channel      │
│                          │                          │    Attribution   │
└──────────────────────────┴──────────────────────────┴──────────────────┘

1. Arrival Fulfillment & Status Audit

Monitors reservation completion and front desk arrival outcomes across historical stay dates.

  • Primary Use: Evaluating check-in success rates, tracking non-arrival walkouts (Current Reservation Status = No Show), analyzing pre-arrival cancellations (Current Reservation Status = Cancelled), and auditing physical room assignments (Room Number).

  • Key Metrics: Confirmation Number, Guest Name, Room Number, Check In Date, Check Out Date, Current Reservation Status.

2. Rate & Revenue Yield Analysis

Evaluates financial yield performance across individual historical arrivals.

  • Primary Use: Comparing realized average room rates (ARR) across rate plans (Rate Code), verifying rate plan code performance, and checking outstanding folio balances (Balance).

  • Key Metrics: Confirmation Number, Guest Name, Room Type, Rate Code, ARR, Balance.

3. Group, Corporate & Channel Attribution

Tracks booking sources, corporate company profiles, group block contributions, and booking agent attributions.

  • Primary Use: Measuring group block room pickup (Group Code), auditing corporate direct-bill company stays (Company), and tracking front desk staff or reservation agent booking productivity (Booked By).

  • Key Metrics: Confirmation Number, Group Number, Group Code, Company, Booked By.

Image 10-6-26 at 10.34 AM.png
Historical Arrivals Statistics

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 Treatment Note: ARR (Average Room Rate) represents Gross Base Room Revenue (Excludes Taxes & Fees) posted per night. Balance represents the Gross Financial Amount (Includes Taxes & Fees) remaining unpaid on the folio.

Column Name

Description

Data Source / System Mapping

Includes Taxes & Fees?

Confirmation Number

Unique reference code assigned to the guest reservation.

System Reservation ID

N/A

Group Number

Master contract ID assigned to the linked convention group block (N.A. for transient stays).

System Group Block ID

N/A

Group Code

Alphanumeric master identifier code assigned to the group block (e.g., DTL, MXI, FAL, MCQ).

Group Profile > Group Code

N/A

Guest Name

Primary guest full name registered on the booking.

Guest Profile > Full Name

N/A

Room Type

Inventory room category code assigned to the stay (e.g., KBSN, KTPN, KZCN, DQAN, KQQN).

Room Type Setup

N/A

Room Number

Physical room number occupied during the stay (N.A. for unassigned, cancelled, or no-show bookings).

Reservation > Room Number

N/A

Rate Code

Contracted rate plan code assigned to the reservation (e.g., BEST FLEXIBLE RATE, HOTEL KEY GROUP RATE, BOOK EARLY ADVANCE PURCHASE).

Rate Code Configuration

N/A

Company

Contracting corporate company account or agency sponsoring the stay (N.A. if direct transient).

Company Profile > Name

N/A

Check In Date

Historical arrival date of the reservation.

Reservation > Arrival Date

N/A

Check Out Date

Historical departure date of the reservation.

Reservation > Departure Date

N/A

ARR

Realized Average Room Rate earned per night for the reservation stay.

Room Revenue / Nights

❌ No

Balance

Unpaid financial liability remaining on the guest folio at report run time.

SUM(Charges) - SUM(Payments)

🟢 Yes

Current Reservation Status

Final operational state of the historical booking (Checked Out, No Show, Cancelled).

System Reservation Engine

N/A

Booked By

Name or user ID of the staff member, agent, or system service account that created the reservation.

System Audit Log

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 6 logical blocks:

    • Primary Operational Identifiers (Cols 1–3): Room Number | Confirmation Number | Current Reservation Status

    • Guest & Group/Corporate Context (Cols 4–8): Guest Name | Group Code | Group Number | Company | Booked By

    • Stay Window & Booking Parameters (Cols 9–12): Check In Date | Check Out Date | Room Type | Rate Code

    • Financial Yield & Settlement Balances (Cols 13–14): ARR | Balance

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 & Post-Stay Auditing: Download in Excel or PDF format to support monthly sales pick-up audits, commission reviews, and no-show policy evaluations.

  • Filtering: Filter data by specific Current Reservation Status (No Show, Cancelled), Rate Code, Company, or Booked By staff member.

  • Highlighting (Conditional Formatting): Apply custom rules to automatically highlight high-ARR arrivals, no-show reservations, or non-zero balance entries.

Within 📈 Revenue & Analytics & 📊 Performance Summaries:

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

  • Daily Revenue Summary – Deep dive into daily line-item room, tax, fee, and outlet revenue breakdowns.

  • Market Segment Summary – Analyze how room revenue and ARR vary across corporate, group, and transient market segments.

Cross-Pillar Deep Dives:

  • 🛎️ Front Desk & Guest Services: Cross-reference historical arrivals against live operational records in Arrivals List.

  • 💳 Payments & Transactions: To inspect specific charges and payment collections posted against historical arrival folios, review All Transactions.