Revenue by Guest Country .ng

Revenue by Guest Country Report Overview

Parent Hub: 📈 Revenue & Analytics

Category: 🥧 Market & Segmentation

Target Roles: Directors of Sales & Marketing, Directors of Revenue Management, General Managers, Asset Managers, Market Research Analysts

Key Value: Evaluate geographical revenue origin mix, track gross room revenue generated by international versus domestic markets, benchmark Average Daily Rates (ADR) across nationalities, and optimize global sales distribution strategies.

Executive Summary

The Revenue By Guest Country is a primary geographical segmentation and international market yield document within the 🥧 Market & Segmentation category of the 📈 Revenue & Analytics hub. Designed to deliver granular financial intelligence based on guest origin, it aggregates room production, guest occupant headcounts, gross room revenue, and realized rate yield for every registered country of origin.

By mapping geographic profile attributes (Country Code, Country Name like CA - Canada, FR - France, CH - Switzerland, GB - United Kingdom, US - United States, NONE - Unassigned Profiles) to stay production and monetary performance metrics (Room Nights, Guests, Room Revenue, ADR), this report enables sales directors, revenue managers, and asset management teams to evaluate international source market profitability, identify high-ADR feeder regions, audit unassigned profile revenue gaps, and align global marketing investments.

Key Capabilities

• Geographical Revenue & Yield Audit: Itemizes room night production (Room Nights), guest occupant headcounts (Guests), gross room revenue (Room Revenue), and Average Daily Rate (ADR) across all active country profiles.

• ISO Country Standardization: Pairs official two-letter ISO country codes (Country Code) with full geographic titles (Country Name) for uniform global reporting.

• Feeder Market ADR Benchmarking: Compares rate realization across domestic versus international inbound markets to identify premium rate sources.

• Profile Revenue Completeness Control: Isolates unassigned guest origin profiles (NONE) to ensure front desk check-in teams capture mandatory geographic data.

Report Views & Functional Breakdown

The Revenue by Country Report presents geographic financial performance in a unified single-table ledger that supports three key analytical perspectives:

┌────────────────────────────────────────────────────────────────────────┐
│                   REVENUE BY COUNTRY REPORT                            │
├────────────────────────────────────────────────────────────────────────┤
│                         Unified Matrix View                            │
├──────────────────────────┬──────────────────────────┬──────────────────┤
│ 1. Feeder Market Revenue │ 2. Room Night & Guest    │ 3. Geographic    │
│    & Rate Yield          │    Production Volume     │    Data Governance│
└──────────────────────────┴──────────────────────────┴──────────────────┘

1. Feeder Market Revenue & Rate Yield

Monitors gross room revenue generation and Average Daily Rates across individual countries of origin.

• Primary Use: Evaluating which guest country origins generate the highest total accommodation revenue (Room Revenue), auditing rate premium realizations (ADR), and ranking top inbound feeder markets.

• Key Metrics: Country Code, Country Name, Room Revenue, ADR.

2. Room Night & Guest Production Volume

Tracks room night sales volume and registered guest occupant headcounts by nationality.

• Primary Use: Measuring total room night production (Room Nights), evaluating guest occupant density (Guests), and analyzing inbound international stay volume trends.

• Key Metrics: Country Code, Country Name, Room Nights, Guests.

3. Geographic Data Governance

Identifies unassigned guest origin profiles to monitor front desk profile completion rates and revenue attribution accuracy.

• Primary Use: Auditing unassigned country records (Country Code = NONE), enforcing passport/ID profile capture protocols during check-in, and ensuring complete revenue attribution across market origins.

• Key Metrics: Country Code, Country Name, Room Nights, Room Revenue.

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

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.

  • Geographic Country Identifiers (Cols 1–2): Country Code | Country Name

  • Production & Demographic Volumes (Cols 3–4): Room Nights | Guests

  • Accommodation Revenue & Rate Yields (Cols 5–6): Room Revenue | ADR

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
	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 & Market Strategy Analysis: Download in Excel or PDF format to support international sales strategy meetings, tourism board reporting, and global marketing campaign reviews.

• Filtering: Filter data by specific Country Code or isolate unassigned profile entries (Country Code = NONE).

• Highlighting (Conditional Formatting): Apply custom rules to automatically highlight high-ADR feeder countries or high unassigned profile revenue totals.

🔗 Related Reports & Next Steps

Within 📈 Revenue & Analytics & 🥧 Market & Segmentation:

• Nationality – Detailed guest occupant headcount breakdown by country of origin.

• 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.

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: To inspect payment methods and currency settlements associated with international guest stays, review Settlement By Payment Type.