Metric | Definition |
|---|
LYTD Next Year Stay | The four metrics below are all related to reservations made before today's date of previous year, for the entire current year. These four metrics can be compared to YTD Next Year Stay.
| LYTD ADR Next Year Stay | | LYTD Occupany Next Year Stay | | LYTD RevPAR Next Year Stay | | LYTD Turnover Next Year Stay |
|
LYTD Same Year Stay | The four metrics below are all related to reservations made before today's date of previous year, for the entire previous year. These four metrics can be compared to YTD Same Year Stay. | LYTD ADR Same Year Stay | | LYTD Occupany Same Year Stay | | LYTD RevPAR Same Year Stay | | LYTD Turnover Same Year Stay |
|
YTD Next Year Stay | The four metrics below are all related to reservations made before today's date, for the entire next year. These four metrics can be compared to LYTD Next Year Stay. | YTD ADR Next Year Stay | | YTD Occupany Next Year Stay | | YTD RevPAR Next Year Stay | | YTD Turnover Next Year Stay |
|
YTD Same Year Stay | The four metrics below are all related to reservations made before today's date, for the entire current year. These four metrics can be compared to LYTD Same Year Stay. | YTD ADR Same Year Stay | | YTD Occupany Same Year Stay | | YTD RevPAR Same Year Stay | | YTD Turnover Same Year Stay |
|
Accommodation Turnover | Net turnover of the booked accommodation, meaning the gross price of the booked accommodation minus specials and included reservedresources. |
ADR | Average Daily Rate is calculated from two other metrics: Accommodation Turnover / Occupied, i.e. the average price per night paid by customers for the accommodations that are actually occupied. |
Available | Number of available accommodations per day including occupied accommodations. This takes into account if there is rentabiilty configured.
If client use reservations at Accommodation Type level then it is always 0 at the level of grain (i.e. accommodation aka unit). |
Occupancy | Occupancy is calculated from two other metrics: Occupied / Available. If client use only Accommodation level reservations, then in that case following examples shows Available, Occupied and Occupancy on any particular calendar date Accommodation Type | Accommodation Level-5 | Accommodation | Calendar Date | Reservation Id | Occupied | Available | Occupancy |
|---|
Accommodation | Apartment-A | appt-1 | 01-01-2019 | 1234 | 1 | 1 | 100.00% | Accommodation | Apartment-A | appt-1 | 02-01-2019 | 1234 | 1 | 1 | 100.00% | Accommodation | Apartment-A | appt-1 | 03-01-2019 | 1234 | 1 | 1 | 100.00% | Accommodation | Apartment-A | appt-1 | 04-01-2019 | 1234 | 1 | 1 | 100.00% | Accommodation | Apartment-A | appt-1 | 05-01-2019 |
| 0 | 1 | 0.00% | Accommodation | Apartment-A | appt-1 | 06-01-2019 |
| 0 | 1 | 0.00% | Accommodation | Apartment-A | appt-1 | 07-01-2019 |
| 0 | 1 | 0.00% | Accommodation | Apartment-A | appt-1 | 08-01-2019 |
| 0 | 1 | 0.00% | Accommodation | Apartment-A | appt-1 | 09-01-2019 |
| 0 | 1 | 0.00% | Accommodation | Apartment-A | appt-1 | 10-01-2019 |
| 0 | 1 | 0.00% |
Note: Reservation Id is not available in Microstrategy as an attribute in Accommodation Daily Cube. It is used in the example in order to explain the concept. Empty Reservation Id indicates that there is no reservation made on that object on a particular date.
If the client use Accommodation and Accommodation Type level reservations, then in that case following examples shows Available, Occupied and Occupancy on any particular calendar date Accommodation Type | Accommodation Level-5 | Accommodation | Calendar Date | Reservation Id | Occupied | Available | Occupancy |
|---|
Accommodation | Apartment-A | appt-1 | 01-01-2019 | 1234 | 1 | 1 | 100.00% | Accommodation | Apartment-A | appt-1 | 02-01-2019 | 1234 | 1 | 1 | 100.00% | Accommodation | Apartment-A | appt-1 | 03-01-2019 | 1234 | 1 | 1 | 100.00% | Accommodation | Apartment-A | appt-1 | 04-01-2019 | 1234 | 1 | 1 | 100.00% | Accommodation | Apartment-A | appt-1 | 05-01-2019 |
| 0 | 1 | 0.00% | Accommodation | Apartment-A | appt-1 | 06-01-2019 |
| 0 | 1 | 0.00% | Accommodation | Apartment-A | appt-1 | 07-01-2019 |
| 0 | 1 | 0.00% | Accommodation Type | Apartment-A | Apartment-A | 07-01-2019 | 6789 | 1 | 0 |
| Accommodation | Apartment-A | appt-1 | 08-01-2019 |
| 0 | 1 | 0.00% | Accommodation Type | Apartment-A | Apartment-A | 08-01-2019 | 6789 | 1 | 0 |
| Accommodation Type | Apartment-A | Apartment-A | 08-01-2019 | 9876 | 1 | 0 |
| Accommodation | Apartment-A | appt-1 | 09-01-2019 |
| 0 | 1 | 0.00% | Accommodation Type | Apartment-A | Apartment-A | 09-01-2019 | 6789 | 1 | 0 |
| Accommodation Type | Apartment-A | Apartment-A | 09-01-2019 | 9876 | 1 | 0 |
| Accommodation | Apartment-A | appt-1 | 10-01-2019 |
| 0 | 1 | 0.00% |
Occupancy at level of Accommodation Type : Accommodation Level-5 | Calendar Date | Occupied | Available | Occupancy |
|---|
Apartment-A | 01-01-2019 | 1 | 1 | 100.00% | Apartment-A | 02-01-2019 | 1 | 1 | 100.00% | Apartment-A | 03-01-2019 | 1 | 1 | 100.00% | Apartment-A | 04-01-2019 | 1 | 1 | 100.00% | Apartment-A | 05-01-2019 | 0 | 1 | 0.00% | Apartment-A | 06-01-2019 | 0 | 1 | 0.00% | Apartment-A | 07-01-2019 | 1 | 1 | 100.00% | Apartment-A | 08-01-2019 | 2 | 1 | 200.00% | Apartment-A | 09-01-2019 | 2 | 1 | 200.00% | Apartment-A | 10-01-2019 | 0 | 1 | 0.00% |
|
Occupied | Number of occupied units per day.
At the level of grain, Occupied is 1, if Reservation is made on Accommodation/Accommodation Type and status is Provisional, Definitive, Checked-In or Checked-out.
Note that it does not include Cancelled reservation, to analyze them we have Reservation & Reservedresource cubes.
|
| Preference bookings | Number of occupied units that have been booked by a preference. Possible to calculate the preference booking percentage by: Preference bookings / Occupied |
RevPAR | Revenue Per Available Room is calculated from two other metrics: Revenue / Available, i.e. the average price per night paid by customers for all the available accommodations. |
| Turnover Budget | Turnover budget per object per calendar date |
Unit Days | Number of total units per day, it includes available, final locked and archived units.
At the level of grain, It is always 1 for accommodation and 0 for accommodation Type on a particular calendar date. |