...
...
...
...
...
...
...
...
...
...
...
...
The analysis tool in RateBoard offers many options for you to assess your data. With a custom combination of filters, distribution and reference you can create your own analysis perspective on the individual KPI’s.
| Anchor | ||||
|---|---|---|---|---|
|
What you will find here
| Table of Contents |
|---|
Not what you were looking for? Search more topics
| Live Search | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
The analyse tool
...
offers a variety of
...
filters you can use to analyse
...
your hotel's performance, everything can be
...
customised according to your needs. The tool
...
has two options, Forecast and Market.
Forecast
...
Forecast analysis controls
...
For setting up your analysis, you can define KPIs, filters, distribution and reference. You can then take a look at the data in a chart or table view.
...
KPI: what will be
...
analysed.
Revenue, occupancy, ADR or RevPar.
Filter: particular information for which all available data will be displayed.
Pickup, room category, room type, segments, channels or countries.
Distribution: will split the available data into the selected distribution adding up to the total of your selected KPI.
Room category, room type, segments, channels or countries.
Reference: comparison with previous years.
Last year or 2 years ago.
...
KPI
To setup your analysis you first choose one of the given KPI which will be shown in the chart.
Revenue
Occupancy
ADR (Average Daily Rate): Average rate of all sold rooms.
How to calculate it:
(Total room revenue) / (Number of all sold rooms)
RevPAR (Revenue per available room): This KPI combines occupancy and ADR to see how the hotel was performing.
How to calculate it:
(total room revenue) / (total number of rooms)or(ADR) x (occupancy in %)
Once you chose the KPI, all the other controls will refer to it.
Filter
A filter is used to show all available data for one particular information.
e.g. The combination of the KPI “revenue” and the filter for the room type “ROOM A”, will show, in the chart or table, how much revenue (confirmed revenue - cancelled revenue) in each individual day is generated by this room type.
...
You can choose between the following filters:
Pickup: you can select
...
the pickup of the last 1, 3, 7, 14 or 30 days. It is recommended to always set the filter and pickup settings the same (e.g. both 7 days).
| Info |
|---|
We will show only the net-pickup, so rooms that were reserved and cancelled within the 1, 3 or 7 days will be deducted automatically. |
Room Categories: The room categories are the ones set in your inventory.
Room Types: The room types are the ones set in your inventory.
| Note |
|---|
To be able to use room category and room type filters, your inventory capacity must be set. |
Segments: The segments available for this analysis are the same segments you set up and use in your PMS.
Channels: The channels available for this analysis will equal the channels you set up and use in your PMS.
Countries: The countries available for this analysis will equal the countries you set up and use in your PMS.
Distribution
The distribution is different from the filter, because it shows all the available data for the selected option, adding up to the total of your selected KPI.
e.g. If you chose “revenue” as your KPI and “Room type” as your distribution, the chart will show all available room types and their relative proportion of the total occupancy.
You could use the following distributions:
Pickup: you can select if you would like to display the pickup of the last 1, 3, 7, 14 or 30 days. It is recommended to always set the filter and pickup settings the same (e.g. both 7 days).
| Info |
|---|
We will show only the net-pickup, so rooms that were reserved and cancelled within the 1, 3 or 7 days will be deducted automatically. |
Room Categories: The room categories are the ones set in your inventory.
Room Types: The room types are the ones set in your inventory.
| Note |
|---|
To be able to use room category and room type filters, your inventory capacitymust be set. |
Segments: The segments available for this analysis are the same segments you set up and use in your PMS.
Channels: The channels available for this analysis will equal the channels you set up and use in your PMS.
Countries: The countries available for this analysis will equal the countries you set up and use in your PMS.
Reference
The selection of the reference helps you to define the comparison data. You have the following options available to set up comparing periods:
Final last year
Same time last year (Year to Date)
Final 2 years ago
Same time 2 years ago (Year to Date)
You can also decide the format of the reference date.
Same date (e.g. 03/12/19 vs. 03/12/18)
Same day of week (e.g. Wednesday 03/12/19 vs. Wednesday 03/13/18).
Date picker
The assessed period
...
can be changed by the slide control below the chart. You can hold the slider (light blue) and move it left or right to your desired period, you can also narrow down or widen the period you want to assess, to a minimum of two weeks or maximum of 6 weeks.
Each gray bar in the date picker represents a week, once you defined a period to assess, the analysis chart will always start on Sunday and end on Saturday. You can also check the events that will be displayed on the top of the chart, in yellow are the current year events and in gray the last year events.
...
By clicking on the bar of any given day you will open the detail overview. See more about the detailed view.
| Anchor | ||||
|---|---|---|---|---|
|
Detailed view
...
You can access the detailed view by clicking on a specific day in the chart or by selecting a date manually. Once in the detailed view, you
...
can analyze a day individually or compare to last year or 2 years ago, this will depend on what you chose for “Reference”.
Per day
If “Reference” is set to “None chosen”, the detailed view will be displayed for the selected date only. You can select a date by clicking on a specific one in the chart, or by selecting it manually in the date picker.
In the detailed view, the table will display the KPI and distribution selected in the chart options.
In the “Characteristics” section you can assess the booking development or rate changes for every day individually. The current year development will be displayed in blue. If the arrival date is still in the future, the blue line will be dotted to show you the forecasted development.
You will notice that the booking curve can also go up and down, that's because the curve also shows the cancellations of the date you selected.
Comparing dates
If “Reference” is set to anything different from “None chosen”, the detailed view will display a comparison between the selected date and the corresponding date last year or 2 years ago. You can select the dates by clicking on a specific one in the chart, or by selecting it manually in the date picker.
That means that every comparison data will be related to what was set in the “Reference” option.
In the detailed view, the table will display the KPI and distribution selected in the chart options.
In the “Characteristics” section you can assess the booking development or rate changes for every day individually. The current
...
year's development will be displayed by a blue line and the reference date with a gray line. If the arriving date is still in the future, the blue line will be dotted to show you the forecasted development.
You will notice that the booking curve can also go up and down
...
, that's because the curve also shows
...
the cancellations of the date you selected
...
.
...
Market
Save Presets
By saving presets it gives the user the possibility to immediatly use custom filter settings.
Presets are useable in the index tab Analyse → Analyse in Forecast and Market or in Analyse → Budget.
...
At first the needed filters (KPI, Filter, Distribution, Reference, 2nd reference) are chosen. This configuration will be saved, with a custom name as a preset, by clicking on “New preset”.
...
Market
In the Market tab, inside the Analyse tool you will find the market data, like competitors price and market demand. In order to assess your competitors, you can customise the data displayed by selecting the filters.
Market analysis controls
All the market analyse controls work as a filter, that means that every time you select something you are narrowing down the results according to it. As a default configuration all filters are set to “Any” and “Show”. This means that the chart will display the absolute lowest prices available.
Filters
| Info |
|---|
≤ → less than or equal to | ≥ → greater than or equal to |
Room category: the room categories depend on what you set in “Settings → Competitors”. If you have several room types into one room category (e.g. Standard), the chart will always display the cheapest room type available.
MinLOS (Minimum length of stay): Any or ≤1 to ≤7.
Meal type: Any, breakfast, half board, full board or all inclusive.
Persons: Any or ≥1 to ≥5.
Cancellable: cancellable or non-cancellable.
Market Demand: show or hide.
Occupancy: show or hide.
| Tip |
|---|
Expert tipp: To make the double occupancy prices of all rooms visible set the “Persons” filter to ≥2. |
Date picker
The assessed period can be changed by the slide control below the chart. You can hold the slider (light blue) and move it left or right to your desired period, you can also narrow down or widen the period you want to assess, to a minimum of 2 weeks or maximum of 6 weeks.
Each gray bar in the date picker represents a week, once you defined a period to assess the analysis chart will always start on Sunday and end on Saturday. You can also check the events that will be displayed on the top of the chart, in yellow are the current year events and in gray the last year events.
Competitors
To take a better look at each competitor you can hover your mouse above one of them, this will highlight the rate development individually. You can also select or deselect a specific competitor, by clicking on it, to hide the information in the chart.
You can also access the information in table format, by changing the tab to “Table”, this will still preserve the set filters. The table can be exported as a CSV or PDF file.
| Info |
|---|
If you want to set general rules on the rates you want to shop (e.g. standard occupancy always per 2 persons) you can manage it on “Settings → Competitors”. |
| Tip |
|---|
Expert tipp: Set your general rules in the dedicated section inside the Settings, and manage the single shopping using the market analyses tool. |
Custom presets
You can create custom presets that will save the analysis options and make it easier to get to the visualization that makes more sense to your hotel. You can create separate presets for the forecast or market analysis.
Create new presets
Select the filter options you want to apply.
Once you are done, click on
NEW PRESETto create a new one.Add a unique name to your preset.
Click
"SAVE".
| Note |
|---|
Every preset needs to have a unique name, otherwise the preset will not be saved. |
...
If more than one preset is saved, switching between the preset can be done by clicking on the wanted preset.
Access or delete presets
Once you created your presets, you can switch between them by clicking on preset option or delete a preset, click on the respective waste paper bin
...
.
...
