How do I analyse the data from my PMS?

Analysis, quick and easy

In the free plan, happyhotel also offers analyses of the various performance indicators that measure day-to-day operations as a pillar of all revenue management. You can find more information about revenue management itself in our lexicon. There you will find the indicators listed, along with a brief description and explanation of how the analysis should be understood.



  1. Dashboard
  2. Pick-Up Report
  3. Revenue analysis
  4. RevPAR, ADR, Occupancy and Units sold
  5. Pickup
  6. Booking curve & cancellations
  7. User-defined


1.) Dashboard

The dashboard sums up all important key figures in an overview over the current year. Instead of the usual Excel list, everything that might be interesting at first glance can be displayed in a clear and graphically appealing manner.

The booking curve in particular is of course interesting, as this is one of the main factors when programming the algorithm. Using the curve, he or she is currently orienting himself every day on what he expects to increase in the coming days, weeks and months.

Another newly developed aspect will be special events, such as newly generated price proposals, public holidays or the start of certain holidays.

With the dashboard you, as a hotelier, revenue manager or not, are well informed about what results are being achieved economically behind the scenes in your own business! Of course, this overview is just that, just an overview. More detailed analyses can be found in the analysis tab of the happyhotel software.


2.) Pick-Up Report

The pick-up report is probably one of the traditionally confusing reports, as it is usually presented in an extremely complex Excel list, if at all. While this of course allows a similar explanation of the success of the booking channels in the end, one is usually occupied with the analysis or the evaluation of the data for a while.

In the happyhotel analysis tool, the pick-up report is simply and neatly divided into bookings and nights and displayed over a period of time that you can define yourself. This way, each day you are always perfectly informed for which day how many bookings were made, or how many nights were booked.

That might sound like a complex sentence, but in practice the representation in a matrix table (coincidentally the only one where it still reminds us of an Excel lists) looks manageable and can be individually designed.

Be sure to read our blog post on the subject!

Click here to get to our happyhotel Blog!


3.) Revenue analysis

The sales analysis continues just as easily and clearly. In an illustration in which you can choose between column and curve charts and filter the period just as effectively as with the pick-up report, you can display the sales from the following sources:

  • Total
  • Room category (with or without code abbreviation, depending on the number of different categories)
  • Market segment
  • Booking channel
  • Status (to differentiate between future and existent sales)
  • Rate (clear rate configurations are essential for this)
  • Rate groups (the manual solution if you want to combine several different rates)

In the end, the whole thing looks similar to the diagram below and shows the corresponding subdivision according to, in this case, segments. You can hover over each individual column to get precise details, as here in the case of the "Individual Business" segment for April 2021.

All of this can be shown even more precisely if you click on the top right and switch views from the month to the week or even day or weekday view!


4.) RevPAR, ADR, Occupancy and Units sold

Similar to the sales analysis, the RevPAR can also be filtered, organised and scrutinised. The filter options are the same to standardise the analysis and make it easier to understand.

But what does RevPAR mean and how is that different from sales?

RevPAR - the "Revenue Per Available Room" describes the actual turnover per available room. That means it is a qualified sales measurement that takes into account how many rooms were actually available.

The formula is easy to understand once you understand that a room, whether it's empty or occupied, has an impact on sales. We have provided a detailed description in our lexicon, but here is a small excerpt in advance:

You can calculate the accommodation revenue in two different ways:

  1. RevPAR = Revenue / Sum of available rooms
  2. RevPAR = Daily rate x Occupancy in % 

The following sample hotel has 100 rooms, of which 50 are occupied at an average daily rate of 70 €. This results in a total revenue of 3.500 € at an occupancy rate of 50%. The RevPAR thus is calculated as:

  1. 3.500 € / 100 = 35 €
  2. 70 € x 0,5 = 35 €

The sample hotel thus has a RevPAR of 35 €.

Calculations are one thing, but once you understand the subject, you'll want to see the results above all. In the end, they look something like this (filtered using the room categories):

Together with the next tabs, the ADR (Average Daily Rate) and the occupancy (in%) or occupancy (absolute numbers), you can already make a lot of conclusions about the performance of your company. Regardless of which key figure is most helpful for you, with the help of the happyhotel analysis nothing stands in the way of you being able to make your decisions quickly and precisely.

5.) Pickup

In addition to the pick-up report, which is particularly helpful for the future in order to process and evaluate all previous data accordingly, the Pickup analysis is primarily a means of qualifying the bookings made according to the various factors such as booking channels or market segments. In addition to the pick-up report for strategic decisions, this gives you the necessary background information for operational decisions.

You can read here why the pick-up report and the associated key figures are important in the happyhotel pick-up analysis and how they can help you with your analysis.


6.) Booking curve and cancellations

As already mentioned, the booking curve is one of the most important factors for the algorithm. Depending on the expected booking situation and the current pick-up, it analyses the deviation between the actual booking status and the expected booking curve. This gives the algorithm the information it needs to generate precise price proposals.

But even without the full function of the algorithm, the booking curve is a useful means of anticipating any unusual changes or developments at an early stage.

The next tab, Cancellations, is also closely linked to the current booking status. As a common topic, it is of course desirable that this analysis remains at zero, but the analysis by happyhotel allows the exact clarification of the details behind it.


7.) User-Defined

For advanced use of the analysis tools, the "User-Defined" tab allows filtering according to exactly the desired data and details. Most of the time you end up here automatically if the entered parameters deviate from the standard settings, but with specific use you can of course query all the data that were illustrated in the previous tabs.


- Back to the table of contents -                                                    Click here to get to our lexicon