Skip to main content

Hotel Level Performance Dashboard (v2)

Written by Zhafran

The Hotel Performance Dashboard gives you a modern, hotel‑level view of your upsell performance directly inside your Oaky Dashboard environment. It centralises revenue, email, deal and rejection metrics, and lets you filter, compare periods and export data for deeper analysis.

Accessing the Hotel Performance Dashboard

You can open the dashboard from your Oaky hotel environment:

  1. Log in to your Oaky dashboard.

  2. Go to the Reports section (hotel level).

From here you can:

  • Switch between multiple views (Overview, Over time, Deal level performance, Rejections).

  • Adjust filters such as date range, request status and product type to focus on specific periods or parts of your upsell programme.

Using filters and comparisons:

Across the different views, you can refine the data shown using filters such as:

  • Date range – focus on a specific month, custom range, quarter or year.

  • Product type – see only room upgrades, only services, or both combined.

  • Other filters – depending on configuration, you may see additional filters (e.g. booking source or segment) to slice results further.

When comparing periods (for example, This month vs Previous month or This year vs Same period last year), the charts and KPIs will show both periods so you can quickly spot improvements or drops.

Understanding the main views

The Hotel Performance Dashboard is organised into 5 key views:

  1. Overview

  2. Over time

  3. Deal Level Performance

  4. Rejections

Each view uses the same underlying data, but focuses on different questions.

  1. Overview & Revenue / KPIs

See your overall upsell contribution and which products drive the most value.

Typical elements you’ll see:

  • Total upsell revenue

    • The total approved revenue generated by upsell requests (room upgrades and services) for the selected period.

    • Revenue is shown in your hotel’s configured currency.

  • Revenue by product / category

    • Breaks down revenue into room upgrades vs services, and into individual deal categories (e.g. F&B, spa, early check‑in, late check‑out).

  • Approved revenue by type

    • Shows how much revenue comes from room upgrades vs services so you can see which part of your programme contributes most.

  • Approved room nights & deals

    • Approved room nights: how many nights were upgraded via Oaky in the selected period.

    • Approved deals: how many individual deal requests were approved.

Email metrics:

  • Guests emailed

    • Total guests with a check‑in date in the selected period who were sent at least one Oaky pre‑arrival email.

    • This is compared to Total imported guests to give you an email rate (share of imported reservations Oaky successfully emailed).

  • Email send rate (email rate)

    • % of total imported guests who actually received a pre‑arrival email.

    • Reservations without an email address, or addresses that are blocked, invalid or excluded by your segmentation rules, still count towards Total imported guests, but will not be emailed.

  • Email open rate

    • Percentage of guests emailed who opened at least one pre‑arrival email.

    • This is a unique metric: if a guest opens the same email multiple times, they are still counted once.

  • Login rate

    • Percentage of guests emailed who clicked the call‑to‑action in your pre‑arrival email and landed on the Oaky guest app (logged into the upsell page).

    • Also unique per guest: multiple logins from the same guest do not increase the rate.

  • Unsubscribes (where available)

    • Number or percentage of guests who unsubscribed from Oaky emails in the selected period.

2. Over time

Track trends and compare performance across time periods. An over-time performance view that tracks key metrics such as trends, and rejections across days, weeks, and months, allowing our partners to visualise trends and seasonality.

What you can do:

  • View revenue, approvals and rejections over time (e.g. by day, week or month).

  • Compare performance between periods (for example: this month vs last month, or this year vs last year).

  • Combine with product or category filters to see how a specific part of your programme performs over time.

3. Deal Level Performance

See which specific deals and room‑type upgrades convert best so you can optimise your offer mix.

You’ll typically see:

  • Deals by type and category

    • Breakdown of deals into types (room upgrades, services) and categories (e.g. wellness, dining, parking).

    • Metrics can include number of requests, approval rate and revenue per deal or category.

4. Rejection analytics

Identify where potential revenue is being lost and why guests decline offers.

Typical metrics include:

  • Total rejected revenue

    • Revenue associated with requests that guests rejected or that were not approved.

  • Rejected revenue by type

    • Split into room upgrades vs services to highlight where you lose most revenue.

  • Rejections by category

    • Shows which deal categories (e.g. spa, F&B, early check‑in) have the highest rejected revenue or number of rejections.

  • Rejected room nights & rejected services

    • Count of room nights and services that were rejected in the selected period.

Exporting data from the Hotel Performance Dashboard

You can export data from the Hotel Performance Dashboard for offline analysis.

How to export

  1. Go to Report -> Overview page

  2. You may use the date range to select dates

  3. Scroll down click the 'Detailed Request' located at the bottom of the page.

  4. A .csv file will be downloaded. The file can be opened in Excel, Google Sheets or another spreadsheet/BI tool.

Depending on the amount of data in your selection, generating the export may take some time. The file can be opened in Excel, Google Sheets or another spreadsheet/BI tool.

Important notes about how data is calculated

To interpret the numbers correctly, keep these points in mind:

  • Hotel currency

    • All revenue values in the dashboard use your hotel’s configured currency.

  • Data freshness

    • Data is refreshed whenever you open or reload the dashboard, using the latest information available.

  • Check‑in–based grouping

    • Metrics are grouped by the month of the guest’s check‑in date.

    • If a guest’s stay spans multiple months, revenue is counted in the month of check‑in.

    • If stay dates are modified, the associated metrics move to the new check‑in month.

  • Cancelled reservations

    • When a reservation is cancelled, it is removed from the calculation. Metrics such as Guests emailed, Total imported guests, Email open rate, Login rate and Total revenue are updated accordingly.

  • Conversion and status

    • Conversion metrics track whether a guest made any request (service or upgrade), regardless of whether it is pending, approved or rejected.

    • Detailed dashboards and exports then break this down by status and revenue (won vs lost).

Added feature: If you are looking to use the Exported reports from previous version of Report Dashboard. The 'Old Dashboard' button has been added on the Overview page. Click on the button and you will be able to use the export feature to retrieve the multi tabs report.

By using the Overview, Over time, Deal Level Performance, Rejections views together, the new Hotel Performance Dashboard gives you a complete, hotel‑level picture of how your upsell is performing and where to focus next.

Did this answer your question?