Hotel analytics for multi-property portfolios: revenue, RevPAR, ADR and occupancy side by side

HAYP's analytics are for revenue and operations leads who run several properties. They calculate the key figures from your Apaleo reservations for the whole portfolio and for each property, using the same definitions. You see which property carries the portfolio and which one needs attention, without stitching exports together.

Portfolio analysis: room revenue, RevPAR, ADR and occupancy per property compared with the previous period
The real HAYP interface, shown with sample data.

The hotel KPIs and how HAYP calculates them

All values refer to the selected period. Revenue and nights are counted by stay, not by booking date. By default, confirmed reservations, in-house guests and departed guests are included.

KPIHow HAYP calculates it
Room revenue (net)Net room revenue for the nights stayed in the period
CommissionCommission on the reservations in the period
Available room nightsUnits × days, minus blocked nights (out of order, out of inventory)
OccupancySold ÷ available room nights
ADRRoom revenue ÷ sold room nights
RevPARRoom revenue ÷ available room nights
Avg. length of stayNights ÷ bookings
Avg. lead timeDays between booking and arrival
Cancellation rateCanceled ÷ all reservations arriving in the period

Revenue analysis: trend, channels and commission

The Revenue page shows the KPIs at the top, then occupancy with sold and available room nights, and room revenue over time by day, week, month, quarter or year. Two breakdowns show revenue by channel and by source, a third shows commission by source. That tells you what a channel brings in and what it costs. How the platforms calculate their commission is explained in the guide to Booking.com commission and Airbnb fees.

The Analysis tab lists each period as a row: sold and available nights, bookings, length of stay, ADR net, average rate gross and commission.

You can filter by period, property, unit group, unit, channel, source and reservation status. How RevPAR and ADR relate is explained in the guide to the RevPAR formula.

Revenue

Room revenue, commission, RevPAR and ADR, occupancy and revenue by channel and source for the chosen period.

Revenue page with key figures, occupancy, revenue trend and revenue by channel

Period analysis

The same figures per day, week, month, quarter or year, here 13 calendar weeks.

Period analysis with key figures per calendar week

Portfolio analysis: every property against your own portfolio

The Properties tab puts every property in one table: share of portfolio revenue and number of units, plus room revenue, RevPAR, ADR, occupancy and sold nights, each for the current and the comparison period with the change. You choose the comparison period yourself.

Three more tabs each give a different angle:

  • Ranking: every property against the portfolio average, by RevPAR, room revenue, ADR or occupancy.
  • Efficiency: ADR against occupancy for each property; the size of the bubble shows revenue.
  • Revenue mix: each property's share of revenue, and with it how much you depend on a few locations.

Ranking

RevPAR per property against the portfolio average.

Benchmark ranking of the properties by RevPAR with the portfolio average

Efficiency

ADR against occupancy: which property earns through price and which through occupancy.

Scatter chart of price against occupancy per property

Revenue mix

The share each property has in the portfolio's revenue.

Share of each property in revenue as an area chart

Four reports for the revenue meeting

Typical questions from the weekly routine, and the view that holds the answer.

01

Properties falling behind

In the Properties table, the Δ % column shows which property is losing against the comparison period and which is gaining.

02

Cost per channel

Revenue by channel and commission by source sit next to each other, so you see which channel brings revenue and how much commission it costs.

03

Price or occupancy

The Efficiency tab shows at a glance which properties combine high occupancy with a low ADR. That is where rates deserve a look.

04

Booking behavior

Lead time and length of stay show how early and how long guests book; the cancellation rate shows how many bookings fall away again. Filter by channel to compare the platforms.

Analyzing reservations and reviews

Under Reservations you see booking volume over time, bookings by channel and source, and the breakdown by status.

Portfolio analysis also has a Reviews mode next to Revenue: a property table with comparison period, a ranking by average rating, category scores and review mix. What lies behind the ratings is covered by review management, with its AI analysis by topic.

Reviews per property

Number of reviews, average rating, share of very good reviews and response rate per property.

Review figures per property compared with the previous period

Trend

Reviews and average rating over time, split by platform.

Review analytics with figures and trend per platform

Platform and property

Average rating per platform and per property side by side.

Average rating per platform and per property

FAQ

Frequently asked questions about hotel analytics and KPIs

How do you calculate RevPAR?

RevPAR is room revenue divided by available room nights or, equivalently, ADR multiplied by occupancy. A property with an ADR of €100 and 70% occupancy has a RevPAR of €70. The guide to the RevPAR formula walks through it with examples.

What is the difference between ADR and RevPAR?

ADR divides room revenue by the room nights sold and shows the average price. RevPAR divides the same revenue by all available nights, so empty rooms pull it down. Only the two together show whether a property earns through price or through occupancy. The guide to the ADR formula has the calculation and a worked example.

Which hotel KPIs matter most?

For comparing properties, occupancy, ADR and RevPAR are regarded as the three most important metrics. HAYP shows them per property and adds room revenue, commission, length of stay, lead time and cancellation rate.

How do I compare RevPAR, ADR and occupancy across properties?

In portfolio analysis. The Properties tab shows each KPI per property for the current and the comparison period, and the ranking shows the gap to the portfolio average. Because every property is calculated with the same definitions, the values are comparable.

Where does the data for the reports come from?

From the reservations in your PMS. HAYP is integrated directly with Apaleo and reads reservations, properties, unit groups and units. The cancellation rate is counted the same way as in Apaleo's General Manager report. HAYP's analytics engine currently holds more than 100,000 reservations.

How much does the Analytics module cost?

€2 net per unit per month, €1.50 from the 201st unit, for revenue analytics, portfolio analysis and review analytics. Analytics needs no setup and has no minimum term, and the scope can change for the following month. See pricing for details.

Is a home-built dashboard for hotel KPIs worth it?

For a one-off analysis from an export, often yes. Run continuously, a home-built version has to keep PMS reservations up to date, count cancellations and commission consistently and be adjusted whenever the data structure changes. HAYP's analytics calculate every property by the same definitions from your Apaleo data. When building pays off is covered under build or buy.

See portfolio analysis in a demo

We show revenue analysis and portfolio analysis and work out how your Apaleo data is connected.