ADR

ADR Dashboard tracks Average Daily Rate performance, year-over-year comparisons, and rate variations by segment, room type, and booking channel. Essential for revenue management and pricing strategy optimization.

Bills and invoices

Bills and Invoices Dashboard analyzes guest billing and folio activity, invoice status, payment collection, and accounts receivable aging. Critical for financial operations and credit management.

Card payments

Card Payments Dashboard monitors credit card transactions, processing fees, payment methods distribution, and settlement status. Used for payment operations and fee management.

Daily summary

Daily Summary Dashboard provides operations overview for property managers showing today's arrivals, departures, in-house guests, occupancy snapshot, and key performance indicators. Primary tool for daily operational management.

Multiproperty

Multiproperty Dashboard aggregates performance across multiple properties in the portfolio. Displays comparative metrics, chain-wide KPIs, and property rankings. Essential for regional and corporate management oversight.

Occupancy

Occupancy Dashboard tracks room nights, occupancy percentage, available inventory, and occupancy trends by segment and room type. Core dashboard for demand analysis and inventory management.

Payments

Payments Dashboard shows payment transactions, payment methods mix, collection rates, and outstanding balances. Critical for cash flow monitoring and accounts receivable management.

Pickup

Pickup Dashboard compares booking pace and on-the-books position versus prior periods. Shows reservation velocity, booking trends, and forecast accuracy. Essential for revenue management and demand forecasting.

Reservations

The Reservations Dashboard displays booking patterns, cancellation rates, lead times, length of stay, and source of business. Comprehensive tool for understanding booking behavior and channel performance.

RevPAR

RevPAR Dashboard tracks Revenue Per Available Room performance, market penetration, and profitability analysis. Primary dashboard for overall revenue performance and competitive positioning.

Revenue

Revenue Dashboard shows revenue breakdown by department (rooms, F&B, other), revenue trends, budget variance, and revenue composition. Comprehensive financial performance monitoring tool.

Accounting Categories

Accounting Categories classify revenue and expenses in MEWS. Maps services and products to financial reporting categories (e.g., Room Revenue, F&B, Spa). Essential for P&L reporting and financial analysis.

Bills

Bills contain guest folios with all charges during a stay. Includes bill header information, customer details, payment status, and billing address. Core dataset for revenue reconciliation and accounts receivable.

Segments

Segments categorize reservations by market type (e.g., Corporate, Leisure, Group, Government). Critical for revenue management, rate strategy analysis, and market mix reporting.

Guests

Guests dataset contains customer master data including profile information, contact details, preferences, and classification. Central entity for CRM, guest recognition programs, and marketing analysis.

Property

Property entity contains hotel configuration, location, currency, and operating parameters. Each property represents a single hotel in MEWS Operations system.

Property Groups

Property Group contains multiple properties within a chain or portfolio. Used for multi-property reporting, chain-wide analysis, and portfolio management.

Rooms

Guest Capacity Daily tracks maximum and available guest capacity by date. Used for guest-based occupancy calculations and capacity planning analysis.

Guest classifications

Guest classifications dataset contains custom classification tags or categories assigned to guest profiles. Classifications enable property-specific guest segmentation for marketing campaigns, service personalization, and relationship management. Supports multiple classifications per guest, allowing flexible categorization for loyalty programs, corporate accounts, special guest types, and marketing segments.

Guest options

Guest options dataset contains Guest Preferencess and selected options stored in guest profiles. Options represent property-configurable preferences, special requests, and service choices that enable personalized guest experiences. Common option categories include room preferences (room type, floor level, view), bed configurations, amenities and services (cribs, rollaway beds, minibar preferences), dietary requirements, accessibility needs, and communication preferences. Options are customizable per property to match specific offerings. Supports multiple options per guest, allowing comprehensive preference tracking for personalized service delivery. Essential for guest recognition programs, pre-arrival preparation, and operational planning.

Guest preferred space features

Guest preferred space features dataset contains room and space feature preferences stored in guest profiles. Space features represent specific room characteristics, amenities, or attributes that guests prefer for their stay, such as room location, view type, amenities, or accessibility features. Supports multiple preferences per guest, enabling room assignment optimization and personalized inventory allocation. Critical for guest satisfaction, operational efficiency, and preference-based revenue management.

Last Updated

Last Data Update tracks data synchronization and ETL process information. Records the last successful data refresh timestamp for each property. Critical for data freshness monitoring and operational dashboards.

Billing Details

Bill Items contain individual charges posted to guest bills. Includes room nights, F&B items, ancillary services, and products. Fundamental dataset for detailed revenue analysis and service consumption patterns.

Cancellations

Cancelled Bill Items track service items and reversed charges. Essential for cancellation analysis, refund tracking, and understanding booking modification patterns.

Outlets

Outlet Items contain point-of-sale transactions from F&B outlets and other revenue centers. Detailed transaction-level data for restaurant, bar, and outlet performance analysis.

Companies

Companies include travel agencies, corporate accounts, and partner organizations that generate bookings. Includes commission agreements and payment terms. Key for distribution channel analysis and partner performance.

Payments

Payments include all payment transactions such as credit cards, cash, bank transfers, and other payment methods. Contains payment amounts, methods, settlement status, and processing fees. Core for cash management and payment reconciliation.

Product

Products are services available for sale including packages, add-ons, and ancillary items. Contains pricing, descriptions, and categorization. Used for product performance and upselling analysis.

Rates

Rates define pricing structures including BAR (Best Available Rate), corporate rates, packages, and promotional rates. Central to rate strategy analysis and pricing optimization.

Spaces

Spaces are individual rooms or bookable units in the property. Contains room numbers, names, and assignment to space categories. Foundation for room-level reporting and maintenance tracking.

Space Category

Space Categories define room types and space classifications (e.g., Standard Room, Deluxe Suite, Meeting Room). Defines room type hierarchy, capacity, and base configuration. Essential for inventory management and rate parity analysis.

Daily Spaces Overview

Space Daily tracks daily room status and occupancy at the individual room level. Tracks room state, housekeeping status, maintenance blocks, and daily availability. Core for operational reporting and housekeeping management.

Daily Spaces by Segment

Space Segment Daily aggregates daily metrics by room type and market segment. Provides occupancy, revenue, and booking statistics by segment. Critical for segment performance analysis and revenue optimization.

Services

Services are offerings provided by the property including accommodation (Stay), F&B, spa, and ancillary services. Defines service types, categories, and operational parameters.

Reservation

Reservations represent bookings and service orders. Contains reservation details, guest information, rates, and booking channel. Primary dataset for reservation analysis and booking patterns.

Reservation Product List

Reservation Products link add-ons and packages to reservations. Associates optional products and packages with bookings. Used for package analysis and ancillary revenue tracking.

Space Occupancy

Space Occupancy tracks utilization metrics for meeting rooms, conference spaces, and other bookable spaces beyond accommodation. Used for space yield management and event revenue analysis.

Travel Agencies

Travel Agencies include travel agencies and OTAs (Online Travel Agencies) with commission rates, contact details, and contract terms. Essential for distribution channel management and commission reconciliation.

Voucher

Vouchers are prepaid certificates that can be redeemed for services. Includes voucher codes, values, validity periods, and redemption status. Used for voucher program management and prepaid revenue tracking.

Voucher assigned rate

Voucher Assignments link vouchers to specific service orders or bills. Tracks voucher utilization and redemption against bookings. Used for voucher redemption analysis and prepaid revenue recognition.

Bills and invoices created time

Date and time when bills and invoices were created in the system. Used for financial reporting and accounting period analysis.

Bills close & inv. issue time

Date and time when bills were closed and invoices issued to guests. Critical for revenue recognition and billing cycle tracking.

Guest birth date

Date instance description to be added

Invoices due date

Due date for invoice payment. Used for accounts receivable aging and payment tracking analysis.

Invoices paid date

Date and time when invoices were paid. Essential for cash flow analysis and accounts receivable reconciliation.

Last data update time

Most recent date when data was processed and synchronized from MEWS Operations. Used for data freshness monitoring and ETL tracking.

Bill item cancelled time

Local date when bill items were cancelled. Used for cancellation analysis and revenue leakage tracking.

Business day item consumed time

Local date when bill items were consumed by guests. Used for actual service delivery and consumption pattern analysis.

Bill item created time

Local date when bill items were created. Used for booking pace analysis and advance purchase tracking.

Pickup intersection time

Local date of the scheduled service or event. Used for service scheduling and operational planning analysis.

Payments created time

Date and time when payment transactions were recorded in the system. Used for payment processing analysis and cash management.

Reservation actual departure time

Actual departure date in local property time. Used for length of stay analysis and occupancy calculations based on actual guest behavior.

Reservation cancelled time

Local date when reservations were cancelled. Critical for cancellation analysis, pickup tracking, and forecast accuracy.

Reservation created time

Local date when reservations were made (booking date). Essential for booking pace analysis, lead time calculations, and demand forecasting.

Reservation departure time

Scheduled checkout date in local property time. Used for expected departure analysis, length of stay planning, and occupancy forecasting.

Reservation arrival time

Scheduled check-in date in local property time (arrival date). Primary date dimension for occupancy analysis, on-the-books reporting, and stay patterns.

Voucher end date

Date instance description to be added

Voucher start date

Date instance description to be added

Accounting Categories

Accounting category code

Internal system code used to reference accounting categories in financial reporting. Links revenue and expense items to general ledger accounts for P&L statement preparation.

Accounting Categories

Accounting category ID (accountingCategory)

Unique identifier for each accounting category. Primary key used to classify all revenue and expense transactions across the property management system.

Accounting Categories

Accounting category classification name

High-level classification grouping accounting categories (e.g., Accommodation, Food & Beverage, Spa, Other Operating Departments). Used for departmental P&L reporting and USALI-compliant financial statements.

Accounting Categories

Deleted accounting category

Flag indicating whether the accounting category is deleted in Mews. Deleted accounting categories remain in the system for history. Corresponds to `IsActive` in the Mews Connector API.

Accounting Categories

Accounting category name

Descriptive name of the accounting category (e.g., Room Revenue, Restaurant Sales, Minibar, Laundry). Used to categorize all revenue and expense items for financial reporting and analysis.

Bills

Customer country name (bill)

Country name of the customer associated with the bill. Used for geographic revenue analysis, VAT/tax reporting, and international guest statistics.

Bills

Customer name (bill)

Name of the customer or guest associated with the bill folio. Primary billing contact for payment collection and accounts receivable management.

Bills

Customer type (bill)

Classification of the customer account type (e.g., Individual, Company, Travel Agency). Used for customer segmentation and accounts receivable aging analysis.

Bills

Bill ID

Unique identifier for each bill or folio. Primary key linking all charges, payments, and financial transactions to a specific guest bill.

Bills

Bill type

Enhanced classification of bill types including invoice status and billing arrangement. Distinguishes between guest folios, master accounts, and special billing arrangements.

Bills

Bill name

Descriptive name or reference for the bill. Often includes guest name, company name, or billing reference for easy identification in financial reports.

Bills

Bill number

Sequential bill number assigned to each folio or invoice. Used for bill tracking, financial audits, and accounts receivable reference.

Bills

Bill item currency code (bill)

Currency code for bill item charges (ISO 4217 format). Essential for multi-currency properties and foreign exchange gain/loss calculations.

Bills

Bill item gross amount (bill)

Gross amount of bill item charges including all taxes and fees. Total charge amount posted to the guest folio before any payments or adjustments.

Bills

Bill item net amount (bill)

Net amount of bill item charges excluding taxes. Used for revenue recognition, tax reporting, and financial statement preparation.

Bills

Owner name (bill)

Name of the bill owner or responsible party. May differ from account name in case of third-party billing or split folio arrangements.

Bills

Payment amount currency code (bill)

Currency code for payment transactions on the bill. Used for foreign currency payment tracking and exchange rate variance analysis.

Bills

Payment amount gross (bill)

Total gross amount of payments received against the bill including all payment methods. Used for cash management and accounts receivable reconciliation.

Bills

Payment amount net (bill)

Net payment amount after deducting processing fees and adjustments. Actual cash received amount for revenue recognition purposes.

Bills

Bill state

Current state of the bill (e.g., Open, Closed, Reviewed, Invoiced). Indicates billing status for accounts receivable management and financial close processes.

Segments

Segment ID

Unique identifier for each market segment. Primary key for segmentation analysis and revenue management reporting.

Segments

Segment name

Name of the market segment (e.g., Corporate, Leisure, Group, Government, Wholesale). Core dimension for revenue strategy, rate positioning, and market mix analysis.

Segments

Deleted segment

Flag indicating whether the segment is deleted in Mews. Deleted segments remain in the system for history. Corresponds to `IsActive` in the Mews Connector API.

Guests

Address city (guest)

City where the guest's address is located. Used for geographic segmentation, local market analysis, and location-based marketing campaigns. Essential for understanding guest origin markets and regional travel patterns.

Guests

Address country code (guest)

ISO 3166-1 alpha-2 country code of the guest's address (e.g., 'US', 'GB', 'DE'). Used for geographic segmentation, international market analysis, and regulatory compliance. Essential for understanding guest address locations and cross-border travel patterns. Corresponds to the CountryCode field in Mews Connector API.

Guests

Address country subdivision code (guest)

ISO 3166-2 country subdivision code (state, province, or region code) of the guest's address (e.g., 'US-CA', 'GB-ENG', 'DE-BE'). Used for regional analysis, state/province-level segmentation, and geographic reporting. Enables detailed location insights within countries. Corresponds to the CountrySubdivisionCode field in Mews Connector API.

Guests

Address postal code (guest)

Postal or ZIP code of the guest's address. Used for geographic analysis, postal code-based segmentation, and regional marketing targeting. Enables precise location-based insights and delivery address validation.

Guests

Age (guest)

Calculated age of the guest in years based on birth date. Used for demographic analysis, age-based segmentation, and marketing targeting. Important for understanding guest demographics, family travel patterns, and age-appropriate service offerings. Returns -1 when birth date is not available.

Guests

VIP guest

VIP classification flag identifying high-value or important guests. Triggers special service protocols, upgrade preferences, and executive attention.

Guests

Guest nationality

Nationality or country of origin of the guest. Essential for feeder market analysis, international tourism statistics, and regulatory reporting requirements.

Guests

Guest ID (guest)

Unique identifier for each guest profile in the system. Primary key for guest history, preferences, loyalty tracking, and marketing analytics.

Guests

Guest property ID (guest)

Unique identifier for each guest profile by the property it's used in. Property-specific guest identifier enabling multi-property guest tracking and property-level guest recognition. Essential for linking guest profiles to specific properties within a chain or portfolio.

Guests

Email (guest)

Email address of the guest. Primary contact method for booking confirmations, pre-arrival communications, marketing campaigns, and guest service. Essential for email marketing analytics, communication preferences, and guest engagement tracking.

Guests

Gender (guest)

Gender identity of the guest. Used for demographic analysis, market segmentation, and personalization. Important for understanding guest demographics and tailoring marketing communications and service offerings.

Guests

Language code (guest)

Preferred language code of the guest (ISO 639-1 format, e.g., 'en', 'de', 'fr'). Used for personalizing communications, guest-facing interfaces, and service delivery. Critical for multilingual properties and international guest experience management.

Guests

Guest name

Full name of the guest. Primary identification field for guest recognition, personalization, and customer relationship management.

Guests

Nationality code (guest)

Nationality code of the guest (ISO 3166-1 alpha-2 format, e.g., 'US', 'GB', 'DE'). Used for feeder market analysis, visa requirements tracking, and international tourism statistics. Essential for understanding guest origin markets and regulatory compliance.

Guests

Phone (guest)

Primary phone number of the guest. Contact method for urgent communications, booking confirmations, and guest service. Used for SMS marketing campaigns, pre-arrival contact, and operational communications.

Guests

Customer type (guest)

Classification of the customer account type (e.g., Individual, Company, Travel Agency, Group). Used for customer segmentation, rate eligibility, billing arrangements, and relationship management. Essential for distinguishing between B2C and B2B guest relationships.

Property Groups

Property ID (propertyGroup)

Property identifier within a property group or chain. Links individual properties to enterprise-level reporting and portfolio management.

Property Groups

Property group name

Name of the property group, chain, or portfolio. Used for multi-property consolidated reporting and brand-level performance analysis.

Property

Chain ID (property)

Chain or brand identifier for the property. Links property to chain-wide reporting, standards, and loyalty programs.

Property

Property city

City location of the property. Used for geographic market analysis, competitive set comparisons, and regional performance reporting.

Property

Property ID (property)

Unique identifier for each property in the MEWS system. Primary key for all property-level reporting and multi-property analytics.

Property

Property name

Official name of the property or hotel. Primary identification for all reporting, invoicing, and guest communications.

Property

Property external identifier

External system identifier for API integrations and third-party system connections (e.g., CRS, channel manager, RMS).

Rooms

Total rooms

Total number of rooms or bookable units at the property. Foundation for occupancy calculations and capacity planning. Note: This may represent guest capacity rather than room count depending on property configuration.

Guest classifications

Guest classification

Name of the guest classification or category assigned to the guest profile. Classifications are custom tags or categories used to segment guests for marketing, service delivery, and relationship management. Examples include VIP status, loyalty tier, corporate account type, or special guest categories. Enables targeted marketing campaigns, personalized service delivery, and guest segmentation analysis.

Guest options

Guest option

Name of the guest option or preference selected by the guest. Options represent customizable Guest Preferencess, special requests, or service choices stored in the guest profile. Common option types include room preferences (room type, floor level, proximity to amenities), bed configurations (king, queen, twin, extra beds), amenities and services (cribs, rollaway beds, in-room dining), dietary preferences, accessibility requirements, and communication preferences. Options are property-configurable and can be customized to match property-specific offerings. Used for personalizing guest experiences, pre-arrival preparation, and service delivery optimization.

Guest preferred space features

Guest preferred space feature

Name of the preferred space or room feature requested by the guest. Space features represent specific room characteristics, amenities, or attributes that guests prefer, such as room location (high floor, near elevator), view type (ocean view, city view), room amenities (balcony, jacuzzi), or accessibility features. Used for room assignment optimization, guest satisfaction improvement, and preference-based inventory management.

Last Updated

Property ID (lastUpdated)

Property identifier for data synchronization tracking. Used to monitor data freshness and ETL process status for each property.

Cancellations

Cancellation accounting category classification

Accounting classification of cancelled revenue items (e.g., Accommodation, F&B). Used to analyze cancellation patterns by revenue department and adjust forecasts.

Cancellations

Cancellation accounting status

Accounting state of the cancelled transaction (e.g., Pending, Invoiced, Closed). Indicates how cancelled revenue is treated in financial reporting and revenue recognition.

Cancellations

Gross revenue from cancellation

Gross amount of cancelled revenue including taxes. Represents total potential revenue lost due to cancellations. Critical for cancellation policy analysis and revenue leakage assessment.

Cancellations

Net revenue from cancellation

Net amount of cancelled revenue excluding taxes. Used to calculate actual revenue impact of cancellations and assess cancellation policy effectiveness.

Cancellations

Cancellation event type

Type of billing event that was cancelled (e.g., Service Charged, Adjustment, Rebate). Provides detail on the nature of cancelled transactions.

Cancellations

Cancellation bill item type

Type of item that was cancelled (e.g., Room Night, Product, Service Fee). Essential for understanding which services have highest cancellation rates.

Cancellations

Number of canceled room nights

Count of room nights lost to cancellations. Key metric for measuring booking attrition and its impact on occupancy and RevPAR.

Cancellations

Number of canceled items

Total quantity of cancelled items across all product types. Used to measure cancellation volume and assess impact on revenue and operations.

Billing Details

Accounting category classification (billItem)

High-level accounting classification of billed items (e.g., Accommodation, Food & Beverage, Other). Primary dimension for departmental revenue reporting and P&L analysis.

Billing Details

Accounting status (billItem)

Current accounting state of the billed item (e.g., Open, Invoiced, Paid, Cancelled). Critical for revenue recognition, accounts receivable, and financial close processes.

Billing Details

Gross amount (billItem)

Gross revenue amount of the billed item including all taxes and service charges. Total charge posted to guest folio for revenue reporting.

Billing Details

Net amount (billItem)

Net revenue amount excluding taxes and fees. Core metric for revenue recognition, financial reporting, and profitability analysis.

Billing Details

Rebated item

Indicates if the billed item has been rebated or refunded. Used to track adjustments, corrections, and customer service compensations affecting net revenue.

Billing Details

Length of stay

Duration of the guest stay measured in nights. Critical metric for stay pattern analysis, rate optimization, and minimum length of stay restrictions.

Billing Details

Bill item type

Classification of billed item type (e.g., Room Night, Product, Service Fee, Cancellation Fee). Essential for detailed revenue analysis and product performance tracking.

Billing Details

Number of guests

Total number of guests on the reservation including adults and children. Used for occupancy by guest calculations and per-guest revenue analysis.

Billing Details

Product ID (billItem)

Unique identifier linking the billed item to a specific product or service. Enables detailed product-level revenue analysis and package tracking.

Billing Details

Product revenue

Net revenue from product sales excluding rebates and cancellations. Pure product revenue for ancillary revenue analysis and upselling effectiveness.

Billing Details

Product volume

Total quantity of products sold excluding rebates and cancellations. Volume metric for inventory management and product popularity analysis.

Billing Details

Early check in

Indicates if early check-in affects occupancy calculation on the day before scheduled arrival. Important for accurate day-use and occupancy reporting.

Billing Details

Late check out

Indicates if late checkout affects occupancy on the day after departure. Critical for housekeeping planning and accurate occupancy calculations.

Billing Details

Number of room nights

Total room nights consumed and billed. Core metric for occupancy calculations, RevPAR analysis, and inventory management. Foundation of all room revenue reporting.

Billing Details

Number of occupied rooms

Count of rooms occupied during the stay period. Primary metric for occupancy percentage calculations and rooms inventory utilization.

Billing Details

Number of units sold

Total quantity of units sold across all product and service types. Volume metric for product sales analysis and inventory tracking.

Outlets

Amount gross (Outlets)

Gross revenue from outlet sales including taxes. Total revenue generated from F&B outlets, spa, retail shops, and other revenue centers.

Outlets

Amount net (Outlets)

Net outlet revenue excluding taxes. Core revenue metric for outlet profitability analysis and departmental performance reporting.

Outlets

Outlet bill notes

Additional notes or comments associated with the outlet bill. Used for transaction documentation, special instructions, and billing reference tracking.

Outlets

Outlet bill number

Unique identifier or reference number for the outlet bill. Essential for bill tracking, reconciliation, and linking transactions to specific outlet orders or receipts.

Outlets

Outlet item name

Name of the specific item sold through outlets (e.g., menu items, spa treatments, retail products). Enables item-level sales analysis and menu engineering.

Outlets

Outlet name

Name of the outlet where the transaction occurred (e.g., Main Restaurant, Pool Bar, Spa Reception). Primary attribute for outlet-level performance analysis, departmental reporting, and outlet comparison.

Outlets

Outlet type

Type or category of the outlet (e.g., Restaurant, Bar, Spa, Gift Shop, Pool Bar). Primary classification for outlet performance analysis and departmental reporting.

Outlets

Gross price per unit (Outlets)

Unit price of outlet items including taxes and service charges. Used for price point analysis and menu pricing optimization.

Outlets

Net price per unit (Outlets)

Unit price excluding taxes. Net price point for margin analysis and profitability calculations at the item level.

Outlets

Number of units sold (Outlets)

Quantity of outlet items sold. Volume metric for popularity analysis, inventory management, and sales performance tracking.

Companies

Company name

Name of the partner company (e.g., corporate account, event organizer). Primary identification for B2B relationships and group business.

Companies

Company ID (company)

Unique identifier for each partner company. Key for tracking corporate accounts, negotiated rates, and commission arrangements.

Companies

Company property ID (company)

Unique identifier for each partner company and property it’s used in.

Payments

Customer country name (payment)

Country of the payment account holder. Used for international payment analysis, fraud prevention, and tax jurisdiction determination.

Payments

Customer name (payment)

Name of the account holder making the payment. Primary identification for payment reconciliation and accounts receivable matching.

Payments

Customer type (payment)

Classification of the paying account (e.g., Individual, Company, Third Party). Used for payment source analysis and credit risk assessment.

Payments

Accounting state (payment)

Accounting status of the payment transaction (e.g., Pending, Posted, Reconciled). Critical for cash management and financial close processes.

Payments

Amount gross (payment)

Total gross payment amount including all fees. Face value of the payment received from the guest or payer.

Payments

Amount net (payment)

Net payment amount after deducting processing fees. Actual cash received amount for cash flow analysis and revenue recognition.

Payments

CCT adjusted fee gross (payment)

Adjusted credit card transaction fee including all gross charges. Total cost of payment processing for margin analysis.

Payments

CCT adjusted fee net (payment)

Net credit card processing fee after adjustments. Actual processing cost for payment cost analysis and payment method profitability.

Payments

CCT charged amount gross (payment)

Gross amount charged to the credit card including authorization holds. Total authorized amount for payment security and settlement tracking.

Payments

CCT charged amount net (payment)

Net amount charged after fees and adjustments. Actual charged amount for payment reconciliation and settlement analysis.

Payments

CCT settled amount gross (payment)

Gross credit card settlement amount received from the processor. Total deposited amount for cash flow forecasting and bank reconciliation.

Payments

CCT settled amount net (payment)

Net settled amount after all processing fees. Final cash received amount for cash management and liquidity analysis.

Payments

Credit card owner country name (payment)

Country of the credit card holder. Used for international payment analysis, fraud detection, and risk assessment.

Payments

Credit card owner name (payment)

Name on the credit card. Primary verification field for payment authorization and fraud prevention.

Payments

Credit card expiration (payment)

Expiration date of the credit card. Used for payment validation, guaranteed reservation management, and expired card alerts.

Payments

Credit card format (payment)

Format classification of the credit card (e.g., Physical, Virtual). Important for online vs. in-person transaction analysis and fraud risk assessment.

Payments

Credit card kind (payment)

Kind or category of the credit card (e.g., Credit, Debit, Prepaid). Used for payment method analysis and processing fee optimization.

Payments

Credit card obfuscated number (payment)

Masked credit card number showing last 4 digits for secure reference. PCI-compliant card identification for audit trails and payment tracking.

Payments

Credit card state (payment)

Current status of the credit card (e.g., Active, Expired, Enabled, Disabled). Used for payment validity checks and authorization management.

Payments

Credit card type (payment)

Card brand or type (e.g., Visa, MasterCard, American Express, Discover). Essential for processing fee analysis and payment gateway optimization.

Payments

Discriminator (payment)

Payment classification discriminator distinguishing payment types in the system. Technical field for payment method categorization and reporting logic.

Payments

External identifier (payment)

External reference or transaction ID from payment gateways or processors. Links MEWS payments to external financial systems for reconciliation.

Payments

Identifier (payment)

Internal unique identifier for the payment transaction. Primary key for payment tracking, reconciliation, and audit trail purposes.

Payments

Invoice Id (payment)

Invoice identifier linking the payment to a specific invoice. Essential for accounts receivable matching and aged balance analysis.

Payments

Kind (payment)

Payment kind or category classification (e.g., Payment, Refund, Chargeback). Distinguishes transaction types for cash flow and dispute management.

Payments

Notes (payment)

Free-text notes or comments about the payment. Contains additional context for exceptions, special arrangements, or payment instructions.

Payments

Original amount gross (payment)

Original gross payment amount before any adjustments or exchanges. Base amount for foreign currency transactions and payment modification tracking.

Payments

Original amount net (payment)

Original net payment amount before modifications. Used for payment adjustment analysis and audit trail of payment changes.

Payments

Payment origin (payment)

Origin or source of the payment (e.g., Terminal, Online, Manual Entry). Important for payment channel analysis and fraud pattern detection.

Payments

State (payment)

Current state of the payment (e.g., Charged, Pending, Failed, Cancelled). Critical for payment status monitoring and failed transaction analysis.

Payments

Type (payment)

Payment method type (e.g., Credit Card, Cash, Bank Transfer, Invoice). Primary classification for payment mix analysis and cash management.

Product

Deleted product

Flag indicating whether the product is deleted in Mews. Deleted products remain in the system for history. Corresponds to `IsActive` in the Mews Connector API.

Product

Product category name (product)

Category classification of the product (e.g., Packages, Add-ons, Experiences, Amenities). Used for product portfolio analysis and upselling strategy.

Product

Product ID (product)

Unique identifier for each product or service offering. Primary key for product revenue tracking and inventory management.

Product

Product name (product)

Name of the product or service (e.g., Breakfast Buffet, Airport Transfer, Spa Package). Primary identification for product sales analysis and menu management.

Rates

External ID (rate)

External identifier used to link the rate with external or third-party systems (for example channel managers, CRS, or custom integrations). Mirrors the `ExternalIdentifier` field of the Mews Connector API Rate.

Rates

Deleted rate

Flag indicating whether the rate is deleted in Mews. Deleted rates remain in the system for history but are not considered for new pricing or availability. Corresponds to `IsActive` in the Mews Connector API.

Rates

Enabled rate

Flag indicating whether the rate is enabled and can be used for selling (subject to other conditions such as restrictions). Corresponds to `IsEnabled` in the Mews Connector API.

Rates

Public rate

Flag specifying whether the rate is public and visible on public sales channels (for example Mews Distributor). Non-public rates are usually available only via internal or contracted channels. Corresponds to `IsPublic` in the Mews Connector API.

Rates

Rate group name

Name of the rate group or rate family (e.g., Standard Rates, Corporate Rates, Package Rates). Organizes related rates for pricing strategy and revenue management.

Rates

Rate ID (rate)

Unique identifier for each rate plan. Primary key for rate performance analysis, pricing optimization, and revenue management reporting.

Rates

Rate name

Name of the rate plan (e.g., Best Available Rate, Advance Purchase 14, Corporate Negotiated). Primary identification for rate strategy analysis and distribution management.

Rates

Rate type

Classification of rate type (e.g., Public, Private, Negotiated, Package, Availability Block). Critical for rate strategy, channel management, and contract compliance.

Rates

Rate short name

Short code or abbreviation for the rate (for example BAR, CORP). Used as a concise, human-friendly identifier in Mews UI and external channels instead of the full rate name. Mirrors the `ShortName` field in the Mews Connector API Rate.

Space Category

Deleted space category

Flag indicating whether the space category is deleted in Mews. Deleted space categories remain in the system for history. Corresponds to `IsActive` in the Mews Connector API.

Space Category

Space category ID

Unique identifier for each space or room type category. Primary key for room type analysis and inventory segmentation.

Space Category

Space category name

Name of the space category or room type (e.g., Standard Room, Deluxe Suite, Executive Floor, Meeting Room). Core dimension for revenue management and inventory optimization.

Space Category

Space type

High-level type classification (e.g., Room, Bed, Dorm, Parking, Meeting Space). Distinguishes different types of bookable inventory beyond traditional rooms.

Daily Spaces Overview

Available spaces

Number of spaces available for sale each day. Critical for availability analysis, revenue optimization, and overbooking strategy.

Daily Spaces Overview

House use spaces (spaceDaily)

Count of spaces used internally for staff, maintenance, or hotel operations. Reduces available inventory and affects occupancy percentage calculations.

Daily Spaces Overview

Out of order spaces

Number of spaces unavailable due to maintenance, renovations, or operational issues. Critical for capacity planning and revenue opportunity analysis.

Daily Spaces Overview

Number of spaces

Total count of all spaces regardless of status. Foundation for occupancy calculations and capacity analysis.

Daily Spaces by Segment

House use spaces (spaceSegmentDaily)

Daily count of spaces for internal use broken down by segment. Detailed tracking of house use rooms for operational analysis.

Daily Spaces by Segment

Out of order spaces (spaceSegmentDaily)

Daily count of out-of-order spaces by segment and room type. Granular view of unavailable inventory for maintenance planning.

Daily Spaces by Segment

Total spaces (spaceSegmentDaily)

Daily total of spaces by segment and room type. Detailed inventory tracking for segment-level revenue management.

Spaces

Property ID (space)

Property identifier linking the space to a specific hotel. Essential for multi-property space tracking and portfolio inventory management.

Spaces

Deleted space

Flag indicating whether the space is deleted in Mews. Deleted spaces remain in the system for history. Corresponds to `IsActive` in the Mews Connector API.

Spaces

Space name

Individual space or room identifier (e.g., Room 101, Suite 205, Ballroom A). Unique name for room-level tracking and housekeeping management.

Spaces

Space ID

Unique system identifier for each individual space or room. Primary key for room-level analysis, assignment tracking, and maintenance history.

Reservation Product List

Property ID (products)

Property identifier for products associated with reservations. Links product sales to specific properties in multi-property environments.

Reservation Product List

Product name (products)

Name of the product included with the service order. Identifies add-ons, packages, and ancillary items attached to reservations.

Reservation Product List

Reservation ID (products)

Reservation identifier linking products to specific bookings. Connects product sales to room reservations for package analysis.

Reservation

Booking lead time ranges

Bucketed ranges of booking lead time (e.g., 0-7 days, 8-14 days, 15-30 days). Used for booking pace analysis and pickup reporting.

Reservation

Segment ID (reservations)

Market segment identifier for the reservation. Critical link for segment performance analysis and revenue management strategy.

Reservation

Cancellation reason

Reason provided when a reservation is cancelled (e.g., No Show, Guest Request, Pricing, Property Issue). Essential for cancellation analysis and service improvement.

Reservation

Channel manager number

Unique reservation number within the channel manager system. Used for two-way communication with channel managers and OTA reconciliation.

Reservation

Channel number

Confirmation number from the booking channel or OTA (e.g., Booking.com reference, Expedia itinerary). Critical for channel reconciliation and commission tracking.

Reservation

In-house booking source

Source of bookings created by property staff in MEWS (e.g., Phone, Email, Walk-in, Call Center). Tracks direct booking channels and staff performance.

Reservation

Commission

Commission percentage or amount paid to the booking source. Essential for distribution cost analysis and net revenue calculations.

Reservation

Commission included

Indicates if commission is included in the rate or paid separately. Critical for accurate revenue recognition and commission liability tracking.

Reservation

Service type (reservation)

Service discriminator classifying bookable vs. additional services. Technical field distinguishing primary services from ancillary offerings.

Reservation

Group name (reservation)

Name of the group or event associated with the reservation. Used for group business tracking, event management, and group pickup analysis.

Reservation

Reservation number

Unique sequential reservation number assigned by MEWS. Primary reference number for guest communications and reservation lookup.

Reservation

Reservation origin

High-level origin category of the booking (e.g., Direct, OTA, GDS, Channel Manager). Primary dimension for channel mix analysis and distribution strategy.

Reservation

Number of guests (reservation)

Total number of guests on the reservation including all occupants. Used for occupancy by guest calculations and per-capita revenue analysis.

Reservation

Number of adults (reservation)

Count of adult guests on the reservation. Important for rate validation, amenity planning, and demographic analysis.

Reservation

Number of children (reservation)

Count of child guests on the reservation. Used for family segment analysis, amenity planning, and special service requirements.

Reservation

Reservation ID (reservation)

Unique system identifier for each reservation. Primary key linking all reservation data, charges, and guest information.

Reservation

Reservation source

Detailed source of the reservation (e.g., Booking.com, HotelBeds, Direct Website, Phone). Granular channel for detailed distribution analysis.

Reservation

Source (reservation)

Booking source or channel identifier. Alternative source field for compatibility and legacy reporting purposes.

Reservation

Reservation status

Current state of the reservation (e.g., Confirmed, Checked In, Checked Out, Cancelled, No Show). Critical for reservation flow analysis and operational reporting.

Reservation

Voucher name (reservation)

Name of the voucher applied to the reservation. Tracks voucher redemption and prepaid booking programs.

Services

Service type (service)

Discriminator field classifying service types. Technical classification distinguishing bookable accommodation from additional services.

Services

External ID (service)

External reference identifier for API integrations. Enables service mapping with channel managers, RMS, and distribution systems.

Services

Deleted service

Flag indicating whether the service is deleted in Mews. Deleted services remain in the system for history. Corresponds to `IsActive` in the Mews Connector API.

Services

Service name (service)

Name of the service offering (e.g., Accommodation, Meeting Room, Spa Treatment). Primary service identification for revenue segmentation.

Services

Service ID (service)

Unique identifier for each service type. Primary key for service-level revenue analysis and configuration management.

Services

Bookable period

Time unit for service booking (e.g., Night, Hour, Day, Event). Defines billing period for different service types and rate calculations.

Space Occupancy

Occupied

Binary indicator showing if a space is occupied. Used for real-time occupancy tracking and room status management.

Space Occupancy

spaceOccupancy_resourceId

Space identifier for occupancy tracking. Links occupancy status to individual rooms for operational reporting.

Travel Agencies

Travel agency name

Name of the travel agency or tour operator. Primary identification for agency business tracking and commission management.

Travel Agencies

Travel agency ID (travel agency)

Unique identifier for each travel agency. Key for tracking travel accounts, rate agreements.

Travel Agencies

Travel agency property ID (travel agency)

Unique identifier for each travel agency and property it’s used in.

Voucher assigned rate

Active voucher rate assignments

Active voucher rate assignments

Voucher

Voucher activity state

Current activity status of the voucher (e.g., Active, Expired, Redeemed, Cancelled). Tracks voucher lifecycle and redemption status.

Voucher

Voucher external identifier

External reference code for the voucher. Enables voucher tracking across systems and third-party voucher programs.

Voucher

Voucher id

Unique system identifier for each voucher. Primary key for voucher tracking, redemption analysis, and prepaid revenue management.

Voucher

Voucher name

Descriptive name of the voucher or certificate. Identifies voucher programs and promotional offerings for marketing analysis.

Voucher

Voucher type

Classification of voucher type (e.g., Gift Certificate, Promotional, Package, Experience). Used for voucher program segmentation and performance tracking.

ADR

Average Daily Rate (ADR) - The average rental income per occupied room. Calculated as total room revenue divided by rooms occupied. Key performance indicator for pricing strategy.

ADR excl. comp and house

Average Daily Rate excluding complimentary and house use rooms - ADR calculation that excludes non-revenue generating rooms for a more accurate picture of paying guest rates.

ADR only positive

Average Daily Rate (positive values only) - ADR calculation including only positive revenue values, excluding zero or negative adjustments.

ADR (pickup based)

ADR Pickup - The change in Average Daily Rate compared to a previous period, showing rate momentum and pricing trends.

ADR 2 year ago

ADR Same Time 2 Years Ago - Average Daily Rate comparison to the same period two years ago for long-term trend analysis.

ADR 2 year ago weekday offset

ADR ST2Y with Weekday Offset - Two-year ADR comparison adjusted for weekday alignment to account for calendar variations.

ADR 1 year ago

ADR Same Time Last Year - Average Daily Rate comparison to the same period last year for year-over-year performance analysis.

ADR 1 year ago weekday offset

ADR STLY with Weekday Offset - Year-over-year ADR comparison adjusted for weekday alignment to account for calendar variations.

Available rooms

Available Rooms - Rooms that are available to be sold.

Available rooms excl. OOO rooms

Available Rooms excluding Out of Order - Sellable inventory excluding OOO rooms.

Avg. cancelled revenue

Average Cancelled Revenue - Mean revenue amount per cancelled reservation.

Avg. cancelled revenue STLY

Average Cancelled Revenue STLY - Year-over-year comparison of average cancelled revenue.

Avg. cancelled room revenue

Average Cancelled Room Revenue - Mean room revenue lost per cancellation.

Average daily guest spend

Average Daily Guest Spend - Mean amount spent by guests per day including all services.

Average occupancy

Average Occupancy Rate - Mean occupancy percentage over a specified time period.

Avg. price per room

Average Price Per Room - Mean price charged per room across all bookings.

Avg. revenue per Booking

Average Revenue Per Booking - Mean total revenue generated per reservation.

Avg. revenue per Booking STLY

Average Revenue Per Booking STLY - Year-over-year comparison of revenue per booking.

Avg. room nights

Average Room Nights - Mean number of room nights per booking.

Avg. room nights STLY

Average Room Nights STLY - Year-over-year comparison of average room nights per booking.

Billing item unit count

Billing Item Unit Count - Total number of billable items/units charged to guests.

Cancellation age

Cancellation Age - Time elapsed since cancellation occurred.

Cancellation fee

Cancellation Fee - Fees charged for cancelled reservations per cancellation policy.

Cancellation lead time

Cancellation Lead Time - Number of days between booking and cancellation.

Check-ins

Check-Ins - Number of guests who checked into the property.

Check-outs

Check-Outs - Number of guests who checked out of the property.

Commission

Commission - Total commission paid to travel agents, OTAs, and other booking sources.

Complimentary rooms

Complimentary Rooms - Number of rooms provided free of charge (comp rooms).

Early departure rooms

Early Departure Rooms - Count of guests who checked out before their scheduled departure date.

Nº of families

Family Bookings - Number of reservations identified as family stays.

Nº of families STLY

Family Bookings STLY - Year-over-year comparison of family bookings.

F&B Revenue

Food & Beverage Revenue - Total revenue from restaurant, bar, room service, and catering operations.

House use rooms

House Use Rooms - Rooms occupied by staff or used for hotel operations.

Last processed TS - Enterprise

Last Processed Timestamp by Enterprise - Most recent data update timestamp for each property.

Average length of stay

Length of Stay (LOS) - Average number of nights guests stay at the property.

Maximum time passed since data updated per property

Maximum Time Since Data Updated Per Property - Time elapsed since last data refresh, used for data freshness monitoring.

Miscellaneous revenue

Miscellaneous Revenue - Revenue from other sources not classified in main categories.

Nº of no families

Non-Family Bookings - Reservations not classified as family stays.

Nº of no families STLY

Non-Family Bookings STLY - Year-over-year comparison of non-family bookings.

No show rooms

No-Show Rooms - Rooms reserved but where the guest did not arrive or check in.

Number of guests (by day of stay)

Number of Guests - Total guest count for a given period.

Occupancy

Occupancy Rate - Percentage of available rooms that are occupied. Calculated as occupied rooms divided by total available rooms.

Occupancy excl. comp, house and OOO

Occupancy excluding Complimentary, House Use and Out of Order - Occupancy rate for revenue-generating inventory only.

Occupancy excl. OOO

Occupancy excluding Out of Order - Occupancy rate calculation excluding rooms out of service.

Occupancy (pickup based)

Occupancy Pickup - Change in occupancy rate compared to a previous period.

Occupancy ST2Y

Occupancy Same Time 2 Years Ago - Two-year occupancy comparison.

Occupancy STLY

Occupancy Same Time Last Year - Year-over-year occupancy comparison.

Other operated departments revenue

Other Operated Departments Revenue - Revenue from additional hotel-operated services and amenities.

Out of order rooms

Out of Order Rooms - Rooms unavailable due to maintenance, repairs, or other issues.

Outlet revenue

Outlet Revenue - Revenue from property outlets like gift shops, spa, or other ancillary services.

Payments

Payments - Total payment transactions processed.

Person count

Person Count - Total number of individuals, including adults and children.

Pickup

Pickup - The change in bookings or revenue over a specific period, showing booking pace.

Pickup STLY

Pickup Same Time Last Year - Year-over-year comparison of booking pace changes.

Post-stay revenue

Metric description to be added

Pre-stay revenue

Metric description to be added

Product type count

Product Count - Number of different products or services sold.

Product revenue

Product Revenue - Revenue from specific products or services sold.

Product volume

Product Volume - Total quantity of products or services sold.

Reservations (by day of creation)

Reservations Created - Total number of new bookings made.

Reservations Incl. Cancelled (by day of creation)

Reservations Created including Cancelled - All reservations made, including those later cancelled.

Reservations Incl. Cancelled (by day of creation) STLY

Reservations Created including Cancelled STLY - Year-over-year comparison of all reservations made.

Reservations (by day of stay)

Reservations Stay - Number of active stay reservations.

RevPAG

Revenue Per Available Guest - Total revenue divided by available guest capacity, useful for properties tracking guest capacity rather than rooms.

RevPAR

Revenue Per Available Room (RevPAR) - Total room revenue divided by total available rooms. Critical KPI combining occupancy and rate performance.

RevPAR excl. comp, house and OOO

RevPAR excluding Complimentary, House Use and Out of Order - RevPAR focusing only on revenue-generating available inventory.

RevPAR excl. OOO

RevPAR excluding Out of Order rooms - RevPAR calculation excluding rooms that are out of service for maintenance or repairs.

RevPAR occupancy based

RevPAR based on Occupancy - Alternative RevPAR calculation using occupancy metrics as the basis.

RevPAR occupancy based excl. comp, house and OOO

RevPAR Occupancy-Based excluding Comp, House and OOO - Occupancy-based RevPAR for revenue-generating inventory only.

RevPAR occupancy based excl. OOO

RevPAR Occupancy-Based excluding Out of Order - Occupancy-based RevPAR calculation excluding OOO rooms.

RevPAR only positive

RevPAR (positive values only) - RevPAR calculation including only positive revenue values.

RevPAR only positive (by segment)

RevPAR by Segment (positive only) - RevPAR broken down by market segment, including only positive values.

RevPAR (pickup based)

RevPAR Pickup - The change in RevPAR compared to a previous period, indicating revenue momentum.

RevPAR 2 year ago

RevPAR Same Time 2 Years Ago - Two-year RevPAR comparison for long-term trend analysis.

RevPAR 1 year ago

RevPAR Same Time Last Year - Year-over-year RevPAR comparison for performance tracking.

Room cancelled revenue

Cancelled Room Revenue - Total revenue lost from cancelled reservations.

Room nights (by day of stay)

Room Nights by Day of Stay - Total number of nights rooms are occupied, measured by the actual stay date.

Room night percentage by segment

Room Nights by Market Segment - Room nights broken down by business segment (corporate, leisure, group, etc.).

Room nights cumulative

Cumulative Room Nights - Running total of room nights over a period.

Room revenue

Room Revenue - Total revenue generated from room sales, excluding taxes and fees.

Room revenue (pickup based)

Room Revenue Pickup - Change in room revenue compared to a previous period or forecast.

Rooms occupied

Rooms Occupied - Total count of occupied rooms for a given period.

Rooms occupied excl. comp and house use

Rooms Occupied excluding Complimentary and House Use - Count of occupied rooms excluding non-revenue rooms.

Rooms occupied excl. comp, house and OOO

Rooms Occupied excluding Comp, House and OOO - Count of revenue-generating occupied rooms only.

Taxes

Taxes - Total tax amount collected on bookings and services.

Total Available Rooms

Total Available Rooms - Number of rooms available for sale in a given period.

Total credit card fee percentage gross

Credit card processing fees as a percentage of revenue gross.

Total credit card fee percentage net

Credit card processing fees as a percentage of revenue net.

Total gross credit card fees

Total Gross Credit Card Fees - Total fees charged by credit card processors.

Total group bookings

Total Group Bookings - Number of group reservations (typically 10+ rooms).

Total group bookings STLY

Total Group Bookings STLY - Year-over-year comparison of group bookings.

Total in-house guests

Total In-House Guests - Current number of guests staying at the property.

Total net credit card fees

Total Net Credit Card Fees - Total fees charged by credit card processors.

Total operating cancelled revenue

Total Operating Cancelled Revenue - Revenue lost from all cancelled bookings across departments.

Total operating cancelled revenue STLY

Total Operating Cancelled Revenue STLY - Year-over-year comparison of cancelled revenue.

Total operating revenue

Total Operating Revenue - Combined revenue from all operating departments (rooms, F&B, other).

Total rooms

Total Rooms - Total count of all rooms in the property regardless of status.

Total rooms by segment

Total Rooms by Segment - Room count broken down by market segment.

Total rooms excl. comp, house and OOO rooms

Total Rooms excluding Comp, House and OOO - Revenue-generating room inventory only.

Total rooms excl. OOO rooms

Total Rooms excluding Out of Order - Available room inventory excluding rooms out of service.

Total spaces

Total Spaces - Total number of accommodation units (rooms/spaces) in the property.

Unassigned revenue

Unassigned Revenue - Revenue not yet allocated to a specific category or department.

VIP in-house guests

VIP In-House Guests - Number of VIP or high-value guests currently staying at the property.

Top 5 segments by ADR

Chart displaying the top 5 market segments ranked by Average Daily Rate performance.

ADR Over Days

Trend chart showing Average Daily Rate performance across days for daily ADR tracking.

ADR Over Months

Trend chart displaying Average Daily Rate trends across months for seasonal pattern analysis.

Top 5 space categories by ADR

Chart showing the top 5 room types or space categories ranked by Average Daily Rate.

ADR by segment

Breakdown chart displaying Average Daily Rate performance segmented by market segment.

Bills and Invoices

Table or visualization displaying bill and invoice details, status, and amounts.

Payment origin

Chart showing the distribution of payment transactions by origin or source.

Card type vs card owner country

Cross-analysis visualization comparing credit card types against card owner countries.

Credit card fees %

Metric or chart displaying credit card processing fees as a percentage of revenue.

Total operational revenue next monyh OTB

KPI showing total operational revenue on-the-books for next month.

ADR Today

Filter or selector for property selection on the Daily Summary Dashboard.

Check-ins Tomorrow

KPI displaying total operational revenue on-the-books for the current month.

ADR Yesterday

Visualization showing reservations grouped by relevant dimension such as status or segment.

ADR Tomorrow

KPI metric showing total revenue on-the-books across all future dates.

Total operation revenue previous month

Snapshot visualization showing today's on-the-books position and key metrics.

Check-outs Yesterday

Summary visualization of bills and invoices for daily operations monitoring.

Month-by-Month operating performance overview

List or count of departures scheduled for today or the selected period.

Upcoming 7 Days: ADR, RevPAR & Occupancy (OTB vs. STLY)

Current count or list of in-house guests staying at the property.

Pickup for next 6 month

Date selector or filter for pickup analysis time period intersection.

Year to Date: Room nights

Date filter for reservations by arrival time for arrival analysis.

Check-outs Today

Visualization showing cancelled reservations for the selected period.

Check-outs Tomorrow

List or count of arrivals scheduled for today or the selected period.

Check-ins Today

Visualization or metric related to stay reservations and current occupancy.

Total operational revenue this month OTB

KPI showing total operational revenue generated or expected for today.

Check-ins Yesterday

List or count of VIP guests currently in-house at the property.

Average occupancy

Filter or visualization for market segment selection and analysis across properties.

Room revenue vs ADR per property

Date filter for multi-property reservation arrival analysis.

Total operating revenue across property groups

Date selector for pickup comparison time period across multiple properties.

Total number of guests

Property selector or filter for multi-property analysis and comparison.

Property performance

Matrix or table showing occupancy percentages by month and property for comparative analysis.

Room revenue vs RevPAR per property

Scatter plot or dual-axis chart comparing room revenue against Revenue Per Available Room for each property in the portfolio.

Room revenue vs. ADR per property

Drill-down visualization analyzing the relationship between room revenue and Average Daily Rate for each property.

Room revenue vs. RevPAR per property

Drill-down chart showing detailed room revenue performance against RevPAR for individual properties.

Average daily guest spend

KPI or chart showing average per-guest daily spending across all properties for guest revenue analysis.

Total operating revenue

Aggregate KPI displaying total operating revenue across all properties in the portfolio.

Occupancy over time

Time-series chart displaying occupancy percentage trends over a selected time period.

Detailed performance by space type: ADR, RevPAR, and Occupancy

Comprehensive table showing key performance metrics (ADR, RevPAR, Occupancy) broken down by each room type or space category.

Average length of stay

KPI or trend chart showing the average number of nights guests stay at the property.

Occupancy

Primary occupancy percentage KPI visualization showing current or period occupancy rate.

Occupied spaces

Count metric showing the total number of occupied rooms or spaces for the selected period.

Top 10 space categories: ADR, RevPAR, and Occupancy

Ranked table displaying the top 10 room types with their ADR, RevPAR, and occupancy metrics for comprehensive performance comparison.

Room nights

KPI showing total room nights sold or consumed during the selected period.

Number of guests

Guest count metric showing total number of guests staying at the property.

Payments

Detailed table or list visualization showing individual payment transactions with amounts, methods, and status.

Occupancy

Occupancy percentage KPI showing on-the-books occupancy for pickup comparison analysis.

Top 5 segments in room night volume

Chart ranking the top 5 market segments by total room nights booked for volume analysis.

Booking window

Distribution chart showing booking lead time patterns and when guests make reservations relative to arrival.

ADR

Average Daily Rate KPI showing current ADR on-the-books for pickup tracking.

RevPAR

Revenue Per Available Room KPI displaying current RevPAR for pickup performance monitoring.

Pickup details

Detailed table or breakdown showing granular pickup metrics by date, segment, or room type.

Pickup

Primary pickup variance metric showing the change in bookings between current and comparison periods.

Pickup overview

Summary visualization providing high-level pickup metrics including total bookings, revenue, and key performance indicators.

Pickup by segment

Drill-down visualization breaking down pickup performance by individual market segments.

Room nights

KPI or trend showing total room nights from reservations in the selected period.

Reservation distribution by segment

Pie chart or breakdown showing how reservations are distributed across different market segments.

Reservations

Primary KPI or count showing total number of reservations for the selected period.

Number of guests

Guest count metric from reservation data showing total guests expected or in-house.

Reservation status

Breakdown visualization showing reservation counts by status (confirmed, checked-in, checked-out, cancelled, no-show).

Reservations

Detailed table or list view showing individual reservation records with key details.

Top 5 space categories by RevPAR

Chart ranking the top 5 room types or space categories by Revenue Per Available Room performance.

ADR by space category

Breakdown showing Average Daily Rate performance for each room type or space category.

RevPAR Over Days

Alternative daily RevPAR trend visualization showing daily revenue performance.

RevPAR Over Months

Alternative monthly RevPAR trend chart for long-term revenue tracking.

RevPAR by space category

Table or chart showing Revenue Per Available Room broken down by each room type or space category.

Top 5 segments by RevPAR

Chart displaying the top 5 market segments ranked by Revenue Per Available Room performance.

Total operation revenue overview

Comprehensive summary visualization showing total operational revenue with key breakdowns and trends.

Top 10 public rates by total operating revenue

Ranked table showing the top 10 rate plans by total revenue contribution for rate performance analysis.

Average daily guest spend

KPI showing the average amount spent per guest per day across all revenue departments.

Pre-stay revenue

Visualization showing total operating revenue generated before guest arrival, including room, F&B, upsell, and add-on revenue, with a focus on pre-stay sales performance and trends.

F&B revenue

Food & Beverage revenue KPI or trend showing total F&B department revenue performance.

Room Revenue

Accommodation revenue KPI or trend chart showing total room revenue performance over time.

Post-stay revenue

Visualization showing total operating revenue generated after guest departure (including room, F&B, upsell, and add-on revenue), highlighting post-stay sales performance and trends.

Revenue by Service

Revenue breakdown showing contribution from each service type (Stay, F&B, Spa, etc.).

RevPAR

Revenue Per Available Room KPI showing overall revenue efficiency and performance.

Other operated departments revenue

Revenue from other hotel-operated departments like spa, golf, retail, and additional services.

RevPAG

Revenue Per Available Guest metric showing revenue efficiency per guest capacity unit.

Total operation revenue by segment

Breakdown chart showing total operational revenue distributed across market segments.

Miscellaneous revenue

Revenue from miscellaneous sources not categorized in main revenue departments.

Total operating revenue

Primary KPI showing aggregate total operating revenue from all departments and sources.

ADR

Average Daily Rate KPI showing overall rate performance on the Revenue Dashboard.

Revenue by public rate

Drill-down visualization breaking down revenue by individual public rate plans for detailed rate analysis.

Revenue by segment

Drill-down chart providing detailed revenue breakdown by each market segment.