Data elements required for hotel market report

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.

#PMI data elementDescription Mandatory / OptionalComment
1Property IDID of the property (hotel, restaurant)MProperty id (abbreviation)
2Property name Name of the property (hotel, restaurant) MName of property
3Comparison group Name of the comparison group MName of the  comparison group
4CurrencyCurrencyMCurrency being used for the monetary values
5Date TY Date this yearMThe date on which information is applicable this year 
6Date LYDate last yearMThe date on which information is appliable last year
7Property max. no. rooms TY Maximum no. rooms for the property this year MMaximum number of rooms available for sales for the property on the date this year 
8Property no. sold rooms TY No. rooms sold for the property this year MThe number of rooms sold for the property on the date this year 
9Property room rev. TY Room revenue for the property this year MRoom revenue excl. mva. for the property on the date this year
10Property max. no. rooms LY Maximum no. rooms for the property last year MMaximum number of rooms available for sales for the property on the date last year 
11Property no. sold rooms LY No. rooms sold for the property last yearMThe number of rooms sold for the property on the date last year 
12Property room rev. LY Room revenue for the property last yearMRoom revenue excl. mva. for the property on the date last year 
13Compset max. no. rooms TY Maximum no. rooms for the compset this yearMMaximum number of rooms available for sales for the competitive set on the date this year 
14Compset sold rooms TY No. rooms sold for the compset this year MThe number of rooms sold for the competitive set on the date this year 
15Compset room rev. TY Room revenue for the compset this yearMRoom revenue excl. mva. for the competitive set on the date this year 
16Compset max. no. rooms LY Maximum no. rooms for the compset last year MMaximum number of rooms available for sales for the competitive set on the date last year 
17Copset sold rooms Compset LY No. rooms sold for the compset last yearMThe number of rooms sold for the competitive set on the date last year
18Compset room rev. LY Room revenue for the compset last yearMRoom revenue excl. mva. for the competitive set on the date last year 
19Ranking TY Ranking this year MThe property’s position in the ranking within the competitive set for the date concerned this year 
20Ranking LY Ranking last year MThe property’s position in the ranking within the competitive set for the date concerned this year 
21Completeness TY Completeness this year OThe 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.
22Completeness LY Completeness last year OThe 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. 

Read more about transfer methods in this article – Transfer Methods.

Was this article helpful?

Related Articles