💡 Important to know:
The booking performance report allows you to evaluate the performance of your property by displaying key performance indicators (KPIs) across your property's reservations.
The data used in the booking performance report only includes Channel Manager reservations. It does not include reservations entered manually into your Front Desk.
To access the Booking performance report, go to My Apps > Insights > Booking performance
Summary
The summary at the top shows the performance metrics of your property at a glance for any selected time period and filters applied.
The metrics in the headline summary show:
Room revenue
Total revenue
Reservations
Room nights
Avg. lead time
Avg. daily rate (ADR)
Cancelled reservations
Avg. length of stay (ALOS)
💡 The metrics displayed are compared to the corresponding period of the previous year. The green or red arrow indicates the performance comparison between the previous and current year.
You have the option to filter reservation data using the following —
Show performance by:
Booked-on date: reservations created during the selected date range.
Check-in date: reservations checking in during the selected date range.
Stay date: reservations that have at least one night that falls within the selected date range.
Time period: select any of the available predefined options or enter custom dates.
Additional filters: if you would like to make your search more specific, you can use the predefined filters below:
Channels Countries
Room types
Rate plans
💡 Notes:
You can select more than one option in the filters.
The Countries drop-down menu will only show countries from where reservations have been made.
Metrics definitions and calculations
⚠️ Please note that if you receive reservations in multiple currencies, these reservations are converted to your default currency as of the booked-on date.
Our currency conversion rate is based on xe.com.
Room revenue: total room revenue (extras not included). If the report is based on the:
Stay date — the total room revenue for the room nights that fall within the chosen date range will be included.
➕ For example, a report for December would include the room revenue of stay nights between the 1st and 31st of December only.
Booked-on date —the total room revenue from reservations created during the chosen date range will be included.
➕ In this case, the report would include reservations booked between the 1st and the 31st of December.
Check-in date —the total room revenue from reservations where the check-in date falls within the chosen date range will be included.
➕ In this example, the report would include reservations where the check-in date falls between the 1st and the 31st of December.
Total revenue: total reservation revenue.
If the report is based on the:
Booked-on date —the total revenue from reservations created within the specified date range and revenue from any extras bought in reservations will be included.
Check-in date — the revenue from reservations checked in within the specified date range will be included.
💡 The total revenue report includes any revenue from extras that were bought at the time of booking
⚠️ The report does not show total revenue when filtered by Stay date.
Room nights: total number of room nights that are sold/occupied within the selected date range.
If the report is based on the:
Stay date — the sum of the room nights that fall within the specified date range will be included.
Booked-on date — the room nights from reservations booked on the specified date range will be included.
Reservations: number of reservations that meet the report criteria.
If the report is based on the:
Stay date — reservations that have at least a one-night stay that falls within the chosen date range will be counted.
Booked-on date — reservations that have been booked within the selected date range will be counted.
Average daily rate (ADR): average revenue earned for an occupied room per day. ADR will determine how much you make per room on average on any given day. So the higher the ADR, the better!
💡Calculation: total revenue ÷ number of rooms sold (or occupied).
The number of rooms sold will be in the formula if you searched by Booked-on date.
The number of rooms occupied will be in the formula if you searched by Stay or Check-in date.
⚠️ Some channels do not record the reservation revenue on a reservation. These reservations are still included in the booking performance report, but they are excluded from the ADR calculation.
Average length of stay: average length of time guests stay at your property.
💡Calculation: total length of stay ÷ total number of reservations
If the report is based on the:
Stay date — the average length of stay of all reservations that have at least a one-night stay that falls within the chosen date range is calculated.
Booked-on date — the average length of stay of all reservations booked during the specified date range is calculated.
Average lead time: shows, on average, how many days in advance your rooms are booked before the check-in date.
💡Calculation: total lead time ÷ total number of reservations.
If a report is based on the:
Stay date — it averages the number of days between the booking date and the check-in date for all the reservations with at least a one-night stay within the chosen date range.
Booked-on date — it averages the number of days between the booking date and the check-in date for all the reservations made during the specified date range.
Reservations cancelled: number of cancelled reservations that meet the report criteria. If the report is based on the:
Stay date — cancelled reservations with at least a one-night stay within the chosen date range are counted.
Booked-on date — all current cancelled reservations that were booked during the selected date range are counted.
Report types
The Booking performance tab contains the following predefined reports:
Source market
Channel mix
Room type
Rate plan
Source market
The Source market report contains three sections. Starting from the top:
Bookings by country
The world map indicates the countries from which you received reservations during the selected time period.
💡 Hover over any country to view a breakdown of room nights, revenue, and room revenue.
Trend by country
This graph allows you to identify trends by visualising, and comparing your performance based on which country your guests booked from.
You can select to view the graph based on Room nights or Room revenue.
💡 Use the Breakdown filter to identify trends quickly. The following options are available in the drop-down menu:
Daily
Weekly
Monthly
Overview by country
This report compiles performance statistics per country and grand totals/averages for each country for various metrics.
Channel mix report
The Channel mix report contains three sections. Starting from the top:
Room nights by channel and Room revenue by channel
These two graphs indicate your booking channels’ performance during the selected time period
💡 Hover over the coloured bars to view each room type's exact number of room nights or amount of room revenue generated.
Trend by channel
This graph allows you to identify trends by visualising and comparing your channels' performance metrics.
You can select to view the graph by Room nights or Room revenue.
💡 Use the Breakdown filter to identify trends. The following options are available in the drop-down menu:
Daily
Weekly
Monthly
Overview by channel
This report compiles the performance statistics per channel and grand totals/averages for various metrics.
Room type
The Rates mix report contains three sections. Starting from the top:
Room revenue by room type and Room nights by room type
These two graphs indicate how your rate plans performed during the selected time period.
💡 Hover over the coloured bars to view each room type's exact number of room nights or amount of room revenue generated.
Trend by room type
This graph allows you to identify trends by visualising and comparing the performance of the room types your guests have booked.
You can select to view the graph by Room nights or Room revenue.
💡 Use the Breakdown filter to identify trends. The following options are available in the drop-down menu:
Daily
Weekly
Monthly
Overview by room type
This report compiles statistics by room type and grand totals/averages for each room type for various metrics.
Rate plan
The Rate plan report contains three sections. Starting from the top:
Room revenue by rate plan and Room nights by rate plan. These two graphs indicate how your rate plans performed during the selected time period.
💡 Hover over the coloured bars to view each rate plan's exact number of room nights or amount of room revenue generated.
Trend by rate plan
This graph allows you to identify trends by visualising and comparing the performance of the rate plans your guests have booked.
You can select to view the graph by Room nights or Room revenue.
💡 Use the Breakdown filter to identify trends. The following options are available in the drop-down menu:
Daily
Weekly
Monthly
Download your report
All booking performance reports can be downloaded in a .csv file format that you can open in Microsoft Excel, Apple’s Numbers, or any other spreadsheet application.
Go to My Apps > Insights > Booking performance.
On the top of the page, select the date and filter ranges of your Booking performance report.
On the top-right of the page, click Download CSV.
A window will pop up where you can select the report type you want to download:
Source market
Channel mix
Room type
Rate plan
Select the reports as required.
Click Download CSV. The selected report/s will be downloaded to your computer in a .csv file.
💡 Are you having trouble importing the .csv file into .xlsx (Excel format)? You can search online for ‘How do I import a .csv file into a .xlsx file?’. You will find results with the next steps to follow.