Breadcrumbs

Source Summary .ng

Source Summary Report Overview

Parent Hub: 📈 Revenue & Analytics

Category: 🥧 Market & Segmentation

Target Roles: Directors of Sales & Marketing, Directors of Revenue Management, General Managers, Asset Managers, E-Commerce & Distribution Managers

Key Value: Evaluate reservation channel production mix, track net room revenue generated by direct versus third-party booking sources, benchmark Average Daily Rates (ADR) across booking origins, and optimize multi-channel sales distribution strategies.

Executive Summary

The Source Summary Report is a primary channel segmentation and booking origin yield document within the 🥧 Market & Segmentation category of the 📈 Revenue & Analytics hub. Designed to deliver granular financial intelligence based on reservation booking origin, it aggregates room night stays, net room revenue, Average Daily Rates (ADR), occupancy contribution, and RevPAR contribution for every configured source code.

  • By mapping reservation source attributes (Source Code, Source Name like WB Brand Web, PH Voice/Phone, EH Expedia/OTA, RO Desk Direct, AA Brand Mobile App, BK Booking.com) to stay production and monetary performance metrics (Date, Net Revenue, Stays, ADR, Occupancy Contribution, RevPAR Contribution), this report enables sales directors, revenue managers, and asset management teams to evaluate distribution channel profitability, identify high-ADR booking paths, audit channel cost efficiencies, and align channel-specific marketing investments.

Key Capabilities

  • Channel Revenue & Yield Audit: Itemizes room stay volume (Stays), net room revenue (Net Revenue), and Average Daily Rate (ADR) across all active and inactive booking source profiles.

  • Source Code Standard Alignment: Pairs official reservation source codes (Code) with full channel titles (Source) for uniform corporate and property-level channel reporting.

  • Direct vs. Third-Party ADR Benchmarking: Compares rate realization across direct digital (Brand Web/App), direct voice/property (Phone/Front Desk), and third-party intermediary channels (OTAs/GDS) to identify yield premium sources.

  • Daily & Monthly Production Tracking: Evaluates daily channel performance alongside monthly aggregated production to monitor channel contribution trends and revenue contribution share.

Report Views & Functional Breakdown

The Source Summary Report presents channel financial performance in a unified single-table ledger that supports three key analytical perspectives:

┌────────────────────────────────────────────────────────────────────────┐
│                   SOURCE SUMMARY REPORT                                │
├────────────────────────────────────────────────────────────────────────┤
│                         Unified Matrix View                            │
├──────────────────────────┬──────────────────────────┬──────────────────┤
│ 1. Booking Channel Revenue│ 2. Stay Volume & Yield   │ 3. Channel       │
│    & Rate Yield          │    Performance           │    Contribution  │
└──────────────────────────┴──────────────────────────┴──────────────────┘
1. Booking Channel Revenue & Rate Yield

Monitors net room revenue generation and Average Daily Rates across individual booking sources.

  • Primary Use: Evaluating which booking channels generate the highest total accommodation revenue (Net Revenue), auditing rate premium realizations (ADR), and ranking top reservation feeder channels.

  • Key Metrics: Code, Source, Net Revenue, ADR.

2. Stay Volume & Yield Performance

Tracks room night sales volume and realized rate performance by source origin over daily timeframes.

  • Primary Use: Measuring total stay production (Stays), evaluating daily booking volume fluctuations, and analyzing channel-specific length-of-stay and yield patterns.

  • Key Metrics: Date, Day Of Week, Code, Source, Stays, ADR.

3. Channel Contribution Analysis

Identifies channel-level contribution to overall property occupancy and RevPAR.

  • Primary Use: Auditing channel occupancy share (Occupancy Contribution), measuring channel impact on RevPAR (RevPAR Contribution), and evaluating optimal channel mix strategy.

  • Key Metrics: Code, Source, Occupancy Contribution, RevPAR Contribution, Net Revenue.

Image 10-8-26 at 8.42 AM.png
Source Summary 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: Net Revenue and ADR represent Net Base Room Revenue (Excludes Taxes & Non-Room Charges). ADR is calculated as ADR=Net Revenue÷Stays.

Column Name

Description

Data Source / System Mapping

Includes Taxes & Fees?

Date

Calendar date of the reported stay production (e.g., 2026-09-01).

Reservation System > Stay Date

N/A

Day Of Week

Corresponding day of the week for the stay date (e.g., Tue, Wed).

System Calendar > Day Of Week

N/A

Code

Official alphanumeric code assigned to the booking source (e.g., WB, PH, EH, RO, AA, BK).

CRS / PMS > Source Code Map

N/A

Source

Full official title of the reservation booking source (e.g., WB, PHONE, EH, RO, AA, BOOKING.COM).

CRS / PMS > Source Name

N/A

Net Revenue

Net base room revenue generated by stays originating from the source.

SUM(Source Base Room Revenue)

❌ No

Stays

Total physical room stays / room nights produced by the booking source.

SUM(Occupied Stays by Source)

N/A

ADR

Average Daily Rate earned per room stay for the source (Net Revenue÷Stays).

Net Revenue / Stays

❌ No

Occupancy Contribution

Proportion of total available room capacity contributed by the source on the date.

Stays / Total Available Rooms

N/A

RevPAR Contribution

Revenue Per Available Room contributed by the source on the date.

Net Revenue / Total Available 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 & Channel Source Anchors (Cols 1–4): Date | Day Of Week | Code | Source

    • Volume & Revenue Performance (Cols 5–6): Stays | Net Revenue

    • Channel Yield & Contribution Metrics (Cols 7–9): 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 Source Summary report features an interactive pie chart to help analyze reservation channel production and source share distributions. Users can group source records on the fly by Code, Name, or Day of Week to evaluate channel performance over weekly or monthly periods. By selecting either Net Revenue or Stays from the Select Base Column dropdown menu, the chart dynamically renders percentage share breakdowns accompanied by an interactive color-coded legend.

Image 10-8-26 at 8.44 AM.png
Group By & Pie Chart Visualization

  • Bar Chart Visualizer: The Source Summary report includes an interactive bar chart to help analyze reservation channel 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 (Net Revenue) or room night volumes (Stays) chronologically alongside the detailed summary data grid.

Image 10-8-26 at 8.46 AM.png
Bar Chart Visualizer
Advanced Controls

  • Exporting & Channel Strategy Analysis: Download in Excel or PDF format to support revenue strategy meetings, OTA commission audits, and digital marketing campaign reviews.

  • Filtering: Filter data by specific Source Code or isolate zero-production codes.

  • Highlighting (Conditional Formatting): Apply custom rules to automatically highlight top revenue channels or low-ADR distribution paths.

Within 📈 Revenue & Analytics & 🥧 Market & Segmentation:

  • Market Segment Overview – Executive-level report tracking daily, MTD, and YTD market segment performance and contribution share.

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

  • Revenue Summary – Comprehensive property revenue breakdown across room types, charge categories, and ledger codes.

Cross-Pillar Deep Dives:

  • ⚖️ Ledgers & Trial Balance: Reconcile total room revenue realizations against General Ledger control accounts in Trial Balance or Day End Summary.

  • 💳 Payments & Transactions: Inspect payment settlements and transaction details associated with direct and OTA channels in Settlement By Payment Type.