Breadcrumbs

Source Forecast .ng

Source Forecast Report Overview

Parent Hub: 📈 Revenue & Analytics

Category: 🔭 Yield & Forecasting

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

Key Value: Evaluate forward-looking daily revenue and stay demand across booking sources and reservation origin channels, monitor source code stay volume and Average Daily Rates (ADR), analyze distribution channel contribution to projected property occupancy and RevPAR, and optimize channel mix dynamic pricing strategies.

Executive Summary

The Source Forecast Report is a primary distribution channel forward projection and channel yield document within the 🔭 Yield & Forecasting category of the 📈 Revenue & Analytics hub. Designed to deliver granular financial and volume foresight across booking sources, central reservation systems (CRS), global distribution systems (GDS), brand websites, online travel agencies (OTAs), and direct property voice channels, it projects daily room stay production, gross base room revenue, Average Daily Rate (ADR), occupancy contribution, and RevPAR contribution for every active booking source code across future stay dates.

  • By mapping reservation origin parameters (Date, Day Of Week, Source, Code) to forward performance metrics (Revenue, Stays, ADR, Occupancy Contribution, RevPAR Contribution), this report enables revenue managers, general managers, distribution directors, and sales teams to project channel profitability, evaluate OTA versus direct channel pickup, monitor GDS corporate production, and align dynamic channel yield and fee controls.

Key Capabilities

  • Booking Source Demand Forecasting: Projects daily stay volume (Stays), gross base room revenue (Revenue), and Average Daily Rate (ADR) across individual booking origin channels (e.g., brand web WB, OTAs BK, AG, GDS AM, UA, HR, EH, AA, CT, DS, RO, WW, PS, and direct phone PHONE).

  • Distribution Channel Mix Alignment: Correlates forward booking source codes (Source, Code) with master market segment classifications (Market Segment) for complete distribution channel attribution.

  • Forward Occupancy & RevPAR Contribution Tracking: Measures the exact contribution of each individual booking source toward projected total hotel capacity (Occupancy Contribution) and overall property RevPAR (RevPAR Contribution).

  • Channel Yield & Commission Optimization: Evaluates forward demand build across high-yield direct channels versus commissionable third-party intermediaries to guide channel fencing and displacement analysis.

  • Time-Series Demand Horizon Analysis: Tracks day-by-day forecasted production across specified date ranges to identify projected compression dates, weekday versus weekend channel demand shifts, and seasonal booking source patterns.

Report Views & Functional Breakdown

The Source Forecast Report presents booking source forward demand metrics in a unified single-table ledger that supports three key analytical perspectives:

┌────────────────────────────────────────────────────────────────────────┐
│                     SOURCE FORECAST REPORT                             │
├────────────────────────────────────────────────────────────────────────┤
│                         Unified Matrix View                            │
├──────────────────────────┬──────────────────────────┬──────────────────┤
│ 1. Channel Revenue &     │ 2. Market Segment &      │ 3. Daily Stay &  │
│    Yield Projection      │    Source Alignment      │    Contribution  │
└──────────────────────────┴──────────────────────────┴──────────────────┘
1. Channel Revenue & Yield Projection

Monitors projected base room revenue generation and Average Daily Rates across individual booking source codes.

  • Primary Use: Evaluating which booking origin channels are projected to generate the highest accommodation revenue (Revenue), auditing channel yield premiums (ADR), and identifying top-producing OTA or direct booking codes for future stay dates.

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

2. Market Segment & Source Alignment

Tracks how individual forward booking source codes map into market segment classifications.

  • Primary Use: Verifying channel-to-segment mapping, auditing corporate GDS rate code segmentation, and ensuring accurate revenue attribution across direct and third-party distribution channels.

  • Key Metrics: Source, Code, Market Segment, Revenue, Stays.

3. Daily Stay & Contribution Analysis

Tracks projected daily room night production and calculates booking source contribution to overall hotel capacity and RevPAR.

  • Primary Use: Measuring forward daily stay volume (Stays), analyzing day-of-week channel demand patterns, and evaluating booking source contribution to projected occupancy (Occupancy Contribution) and property yield (RevPAR Contribution).

  • Key Metrics: Date, Day Of Week, Source, Stays, Occupancy Contribution, RevPAR Contribution, Revenue.

Source Forecast.png
Source Forecast

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: Revenue and ADR represent Base Room Revenue (Excludes Taxes & Non-Room Charges). ADR is calculated as ADR = Revenue ÷ Stays.

Column Name

Description

Data Source / System Mapping

Includes Taxes & Fees?

Date

Projected calendar date of the reported stay production (e.g., 2026-10-09).

PMS / CRS > Target Stay Date

N/A

Day Of Week

Corresponding day of the week for the stay date (e.g., Friday, Saturday).

System Calendar > Day Of Week

N/A

Source

Alphanumeric code or abbreviation identifying the booking origin channel (e.g., WB, BK, AG, AM, PHONE).

CRS / PMS > Booking Source Code

N/A

Code

Secondary alphanumeric sub-code identifying specific channel distributors or travel agencies.

CRS / PMS > Sub-Source Code

N/A

Market Segment

Master market segment classification mapped to the booking source.

PMS > Market Segment Mapping

N/A

Revenue

Projected gross base room revenue generated by stays originating from the source on the date.

SUM(Projected Base Room Revenue)

❌ No

Stays

Total physical room nights / stays projected for the booking source on the date.

SUM(Projected Stays by Source)

N/A

ADR

Average Daily Rate projected per room stay for the booking source ($\text{Revenue} \div \text{Stays}$).

Revenue / Stays

❌ No

Occupancy Contribution

Proportion of total available room capacity projected to be contributed by the booking source on the date.

Stays / Total Available Rooms

N/A

RevPAR Contribution

Revenue Per Available Room projected to be contributed by the booking source on the date.

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.

    • Time & Date Tracking (Cols 1–2): Date | Day Of Week

    • Source & Channel Mapping (Cols 3–4): Code | Source

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

    • 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 Forecast report features an interactive pie chart to help analyze forward booking channel mix and projected source distributions. Users can group forward channel performance entries on the fly by Source or Day Of Week to evaluate booking source demand trends over future weekly or monthly horizons. By selecting either 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-9-26 at 5.41 PM.png
Group By & Pie Chart Visualization

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

Image 10-9-26 at 5.47 PM.png
Bar Chart Visualizer
Advanced Controls

  • Exporting & Channel Strategy Analysis: Download in Excel or PDF format to support weekly revenue strategy meetings, distribution channel cost-of-acquisition audits, and OTA commission evaluations.

  • Filtering: Filter data by specific Source (e.g., isolate WB for Direct Web or BK for Booking.com), or filter out zero-stay dates.

  • Highlighting (Conditional Formatting): Apply custom rules to automatically highlight high-revenue projected booking channels, zero-stay dates, or low-ADR performance periods.

Within 📈 Revenue & Analytics & 🔭 Yield & Forecasting:

  • Source Summary – Historical performance overview tracking month-to-date and year-to-date room night production and revenue by booking source.

  • Market Segment Details Forecast – Forward-looking demand forecast breakdown by master market segment and rate code.

  • Rate Plan Forecast – Granular rate-level forward projection evaluating daily revenue and stay demand across individual rate plans.

  • Booking Pace – Multi-section tracking report evaluating pickup velocity across Revenue, Rooms Sold, ADR, and Occupancy.

  • Occupancy Forecast and History – Comprehensive daily overview tracking historical and forecasted occupancy, revenue, and movement counters.

Cross-Pillar Deep Dives: