Breadcrumbs

Nationality .ng

Nationality Report Overview

Parent Hub: 📈 Revenue & Analytics

Category: 🥧 Market & Segmentation

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

Key Value: Evaluate international versus domestic guest origin mix, track geographical guest demographics, verify profile country data compliance, and optimize global marketing and language strategy.

Executive Summary

The Nationality Report is a primary demographic audit and geographic segmentation document within the 🥧 Market & Segmentation category of the 📈 Revenue & Analytics hub. Designed to deliver clear visibility into guest origin trends, it aggregates registered in-house and historical guest counts by country of origin over a selected date range.

By mapping geographic profile attributes (Country Name, Country Code like CA - Canada, FR - France, CH - Switzerland, GB - United Kingdom, US - United States) to guest volume totals (Number of Guests), this report enables sales directors, revenue managers, and hotel executives to measure international market penetration, evaluate domestic feeder markets, identify unassigned profile data gaps, and align front office multilingual staffing and guest services.

Key Capabilities

  • Geographic Origin Segmentation: Itemizes registered guest volumes across domestic and international countries of origin.

  • ISO Country Code Standardization: Displays standard country titles (Country Name) alongside official two-letter ISO country codes (Country Code).

  • Demographic Volume Tracking: Aggregates cumulative guest occupant headcounts (Number of Guests) for each geographic market.

  • Profile Completeness Audit: Identifies unassigned guest origin profiles (None) to enforce front office registration desk data collection standards.

Report Views & Functional Breakdown

The Nationality Report presents geographic guest demographic data in a unified single-table ledger that supports three key analytical perspectives:

┌────────────────────────────────────────────────────────────────────────┐
│                        NATIONALITY REPORT                              │
├────────────────────────────────────────────────────────────────────────┤
│                         Unified Matrix View                            │
├──────────────────────────┬──────────────────────────┬──────────────────┤
│ 1. Geographical Origin & │ 2. Guest Volume & Market │ 3. Profile Data  │
│    Country Mapping       │    Feeder Share          │    Integrity     │
└──────────────────────────┴──────────────────────────┴──────────────────┘

1. Geographical Origin & Country Mapping

Audits guest country of origin classifications and verifies standard country code mappings.

  • Primary Use: Mapping primary international feeder markets (Country Name), tracking official country codes (Country Code), and supporting international sales campaigns.

  • Key Metrics: Country Name, Country Code.

2. Guest Volume & Market Feeder Share

Monitors guest occupant volumes by nationality to evaluate market source concentration.

  • Primary Use: Ranking primary domestic and international guest feeder countries by total volume (Number of Guests), analyzing inbound tourist market shifts, and planning language translation services.

  • Key Metrics: Country Name, Country Code, Number of Guests.

3. Profile Data Integrity

Identifies unassigned guest nationality profiles to monitor front desk profile completion rates.

  • Primary Use: Auditing unassigned country records (Country Name = None), enforcing passport/ID capture protocols during check-in, and ensuring compliance with municipal guest registration laws.

  • Key Metrics: Country Name, Country Code, Number of Guests.

Image 10-7-26 at 7.12 PM.png
Nationality Repot

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:

💡 Demographic Calculation Note: Number of Guests represents the total registered adult and child guest occupant headcount associated with guest profiles originating from the corresponding country.

Column Name

Description

Data Source / System Mapping

Includes Taxes & Fees?

Country Name

Full official title of the guest's registered country of origin (e.g., Canada, France, Switzerland, United Kingdom, United States, or None for unassigned profiles).

Guest Profile > Country

N/A

Country Code

Official two-letter ISO country code assigned to the country (e.g., CA, FR, CH, GB, US).

Guest Profile > ISO Country Code

N/A

Number of Guests

Total registered guest occupant headcount originating from the specific country during the reporting period.

SUM(Registered Guests by Country)

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:

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

    • Demographic Guest Volume (Col 3): Number of Guests

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.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 & Market Strategy Analysis: Download in Excel or PDF format to support global marketing campaigns, tourism board reporting, and front office staffing schedules.

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

  • Highlighting (Conditional Formatting): Apply custom rules to automatically highlight primary international feeder markets or high unassigned profile counts.

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.

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

Cross-Pillar Deep Dives:

  • 🛎️ Front Desk & Guest Services: Cross-reference active international guest stays with In-House Guest List.

  • 💳 Payments & Transactions: To inspect payment methods and currency settlements associated with international guest stays, review Settlement By Payment Type.