The general consensus in business intelligence circles is that you shouldn’t wait for your business to have perfect data to undertake a business intelligence initiative. However, it’s still important to understand that really good, actionable hotel business intelligence depends on complete and accurate data. The “garbage in, garbage out” axiom is as true now as it ever was. Let’s take a look at some common areas where hotels and hotel companies frequently have room to improve their data quality.
Geographic source markets
Where does your hotel’s business come from? Not just anecdotally, but factually. With this information you can create more accurate forecasts, time the launch of promotions into specific marketplaces and spot emerging trends that may shape your hotel’s products or services. Yet all too often, the data that would provide this critical information is incomplete and inaccurate. Your hotel’s data is really just a residual of your hotel’s business processes. When a gap in processes leaves the guest address blank on a folio (and as that failure is repeated day after day and shift
after shift) the resultant data set is “full of holes.”
And even complete data sets can be misleading. You might have addresses for 100% of guest folios, but how comfortable are you with their accuracy? For instance, frequently a hotel’s percentage of domestic business is overstated. This is because property management systems are often configured with the hotel’s own country as a default on folios. The result is that folios left at the default value are indistinguishable from accurate, properly updated guest records. A simple tweak to PMS configuration specifying a null value as the geographic default will help this situation considerably. We get a taste here of the importance of solid, audited business processes and the need for careful system configuration to support these practices.
Selling channels
Selling channels are important because these are the virtual “shelves” upon which your product is viewed and purchased. Understanding production and trends by selling channel allows you to properly allocate and position your inventory on all the right shelves. A frequently disregarded but critical element in tracking sales channel production is the configuration of the interface between the hotel’s PMS and the hotel’s central reservations system. The CRS is the lifeline of a hotel, placing its inventory on important shelves such as the global distribution system, the hotel’s website and online travel agencies such as Expedia, Travelocity and countless others.
The CRS provides full detail on each booking’s selling channel, down to the individual system that a GDS booking originated from (Amadeus, Galileo, Sabre, Worldspan) or on which of the OTA sites the booking was made. Yet frequently, such important detail on bookings is lost (due to improper interface configuration) as the bookings flow into the hotel’s PMS. As the system of record and the most likely source of data for beginning a business intelligence initiative, it’s critical that this information is captured and retained in the PMS itself. Therefore, it’s a great investment in time to ensure that your hotel’s CRS/PMS interface is configured to best support detailed tracking by sales channel in the PMS itself.
Company profiles
How you track the production of accounts in your hotel’s PMS can have a significant bearing on the accuracy of your account-level data.
In many hotels, a choice is made to consolidate the number of “rate codes” in the PMS, assigning multiple negotiated accounts to a single rate code. The premise in these situations is to track individual account production through unique “company profiles” that must be manually attached to each booking. While there is nothing wrong in theory about this setup, in practice it is open to inaccuracies in tracking. Becuase a profile in this setup must be manually attached to each booking, the tracking is only as good as the weakest link in business processes. When a reservationist forgets to make that association (or associates the booking to the incorrect company profile), then your hotel’s data is compromised.
A more solid method of tracking (if a bit labor-intensive to set up initially) is to create unique rate codes in the PMS for every negotiated account. Since an account’s negotiated rate is tied to its rate code, the rate code must be placed into the reservation at the time of booking.
If your hotel or hotel company would like to reap the benefits that business intelligence has to offer, an advised first step down that path is to have a realistic look at the state of your hotel’s data. While perfect data is not required, a thoughtful and diligent approach toward data and the business processes and systems configurations that shape it most certainly is. That’s an investment worth making if you have aspirations in the realm of hotel business intelligence.
Kevin Coleman is Partner & COO of Intelligent Hospitality. At Intelligent Hospitality, we're out to change hotel reporting and analytics, one mind at a time. With a goal to evolve decision-making in the hotel industry, we've developed HotelIQ Business Intelligence®. Built by hoteliers for hoteliers and specifically designed to support revenue generation, HotelIQ is a one-of-a-kind business intelligence platform for hotels, hotel management companies, brands, real estate investors and anyone else vested in the performance of hotel assets. Intelligent Hospitality is headquartered in Atlanta, Georgia. For more information, visit: www.intelligent-hospitality.com.
The opinions expressed in this column do not necessarily reflect the opinions of Hotel News Now or its parent company, STR and its affiliated companies. Columnists published on this site are given the freedom to express views that may be controversial, but our goal is to provoke thought and constructive discussion within our reader community. Please feel free to comment or contact an editor with any questions or concerns.