PMI Knowledge base

Back to Knowledge base

More results...

Generic filters
Exact matches only
Search in title
Search in content
Search in excerpt
Filter by Custom Post Type
PMI Knowledge Base
Article contents (TOC)
Print

Data elements required for hotel market report

May 31, 2020
UpdatedAugust 3, 2023
ByAndreas Engkvist
Views1693
Please Share Your Feedback
How Can We Improve This Article?
In GM daily digest PMI can display the competitor benchmarking KPIs such as ranking of the property in the comp set, RGI, MPI and ARI.

To be able to do this PMI needs a daily import from the hotel’s provider of this data.

Below is a description of what data is needed to calculate the KPI’s in PMI as well as a description of different transfer methods at the bottom of the article.

The competitor data is reported as collective data.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
PMI data element
Property ID
Property name
Comparison group
Currency
Date TY
Date LY
Property max. no. rooms TY
Property no. sold rooms TY
Property room rev. TY
Property max. no. rooms LY
Property no. sold rooms LY
Property room rev. LY
Compset max. no. rooms TY
Compset sold rooms TY
Compset room rev. TY
Compset max. no. rooms LY
Copset sold rooms Compset LY
Compset room rev. LY
Ranking TY
Ranking LY
Completeness TY
Completeness LY
Description
ID of the property (hotel, restaurant)
Name of the property (hotel, restaurant)
Name of the comparison group
Currency
Date this year
Date last year
Maximum no. rooms for the property this year
No. rooms sold for the property this year
Room revenue for the property this year
Maximum no. rooms for the property last year
No. rooms sold for the property last year
Room revenue for the property last year
Maximum no. rooms for the compset this year
No. rooms sold for the compset this year
Room revenue for the compset this year
Maximum no. rooms for the compset last year
No. rooms sold for the compset last year
Room revenue for the compset last year
Ranking this year
Ranking last year
Completeness this yea
Completeness last year
Mandatory / Optional
Mandatory
Mandatory
Mandatory
Mandatory
Mandatory
Mandatory
Mandatory
Mandatory
Mandatory
Mandatory
Mandatory
Mandatory
Mandatory
Mandatory
Mandatory
Mandatory
Mandatory
Mandatory
Mandatory
Optional
Optional
Comment
Property id (abbreviation)
Name of property
Name of the comparison group
Currency being used for the monetary values
The date on which information is applicable this year
The date on which information is appliable last year
Maximum number of rooms available for sales for the property on the date this year
The number of rooms sold for the property on the date this year
Room revenue excl. mva. for the property on the date this year
Maximum number of rooms available for sales for the property on the date last year
The number of rooms sold for the property on the date last year
Room revenue excl. mva. for the property on the date last year
Maximum number of rooms available for sales for the competitive set on the date this year
The number of rooms sold for the competitive set on the date this year
Room revenue excl. mva. for the competitive set on the date this year
Maximum number of rooms available for sales for the competitive set on the date last year
The number of rooms sold for the competitive set on the date last year
Room revenue excl. mva. for the competitive set on the date last year
The property’s position in the ranking within the competitive set for the date concerned this year
The property’s position in the ranking within the competitive set for the date concerned this year
The number of respondents in the competitive set complied who provided data input: 100% signifies that all in the set provided input for the date concerned this year.
The number of respondents in the competitive set complied who provided data input: 100% signifies that all in the set provided input for the date concerned last year.

For more information, please see the article Transfer methods.

Tags: