Data Quality Vital To Total Revenue Forecasting

By Michael McCartan - Managing Director Europe, the Middle East, and Africa at Duetto

Visit us at HITEC booth 2507
24 May 2019

Total Revenue Forecasting (TRF) enables hotels to get a better picture of both rooms revenue and ancillary revenue in order to plan more strategically. This may be in terms of resourcing. For example, anticipating demand before it arrives can enable you to spend marketing money more accurately. It can show where demand is weak, not only in rooms but also in other revenue-generating areas of your hotel.

Any hotels with ancillary revenue streams can be doing TRF, whether that is a manual or automated process.

There are many areas of ancillary revenue hotels can focus on, but here are two examples:

Breakfasts - How many people are booking rooms without breakfast but are actually buying breakfast? And how many people are coming to the hotel for breakfast who haven't booked a room? If you can see the occupancy of the hotel and what percentage are having breakfast then you know what the conversation rate will be. From there, you can accurately anticipate what your breakfast revenues will be. This data can then also be used to more accurately manage staffing levels and food and beverage costs.

Group forecasting - This is inherently difficult, because it doesn't always follow a pattern. However, if you are able to analyse pipeline and see what the characteristics of the groups are then you can calculate the likelihood of those groups to convert or wash.

TRF can also be used to forecast revenue for spas, car parks, meeting space, golf tee times - anything that can generate additional revenue and on which data can be collected.

Why Data Is The Oxygen

However, as with all areas of revenue management, TRF requires good quality data. This is where the hotel industry, with its current data stack, lags behind.

I think of data as oxygen - without it you can't perform at the top of your game. For rooms we now have a consistent flow of data from the PMS. However, for the other revenue areas of the hotel that data, that oxygen, doesn't always exist so you can't perform to the same level.

At Duetto, we can get good folio data out of some PMS'. Using this data, we can see how much is being spent in different revenue categories. A PMS that can capture and then share folio data is essential.

Is that data enough? No, it's not.

Folio data only shows us the final spend for those revenue streams but there is a lot that happened before the buying decision. Unfortunately, a lot of the processes capturing that data are still manual.

One of the biggest constraints in hotel revenue management is this lack of data and the ability to share data through different applications. I liken it to puddles. Historically some technology providers have created walled gardens, with puddles of data only they can use. But in order to provide a good service to the hotels we need to create a data lake - then you can do really interesting things, such as TRF. New technology entrants recognise this problem and there is a freer exchange of data now, but it's still not enough. We have to share information.

Duetto operates with an open API. This means any of our customers can get any one of their technology providers to extract a forecast from our application. For example, that could be linked to a marketing system in order to trigger campaigns for low demand periods. The information we provide can feed into and get other applications working more effectively, driving more profitable business for the hotel.

Opportunities are endless

The opportunity for hotels to define other revenue categories is endless, but you have to understand the conversion rate and characteristics of these categories.

Total revenue forecasting can help hotels understand these other revenue streams in order to better predict what will happen.

From there, it's just a stepping stone to total revenue management.

The technology isn't there yet, but if you can align your thinking towards total revenue management, at some point the technology will be available and allow you to execute your strategy in a more automated fashion.

Technology can make more decisions more rapidly that any human can. To try and compete with the machines will be an impossible task. To ignore it and stick your head in the sand would be detrimental. Align your thinking and organisation around these lines and you will be ready for the future.

Michael McCartan recently participated in a podcast on Total Revenue Forecasting hosted by Revenue Hub. Listen to what he had to say here.

Click here to view the original version of this release.

Return to overview


250 Sutter St, Suite 400
San Francisco, CA 94108
United States
Phone: 1.415.968.9389

Michael McCartan

An expert in the fields of hospitality and electronic distribution, Michael McCartan joined Duetto as Managing Director for Europe, the Middle East and Africa in 2014 to spearhead the rollout of the company's products and development of Customer Success teams throughout the EMEA region. Since joining Duetto, he has grown the European headquarters of Duetto in London, as well as establishing teams in Germany and Dubai. Mr. McCartan is adept at engineering creative solutions and then executing their delivery, understanding the exact needs of the client and the challenges surrounding the market. He is a valued member of the HSMAI Europe Revenue Management Advisory Board, contributing to articles and leading seminars and keynote sessions for the association. He is also a frequent speaker and panellist at major travel industry events across EMEA. Mr. McCartan previously served as Chief Executive Officer of eRevMax, a travel technology service provider, where he grew the operations to serve more than 8,000 customers, and capturing data benefitting more than 40,000 hotels worldwide. He directed product development, business development, and customer and hotel relationship management in more than 100 countries, managing offices and research development in the U.S., UK, Poland, Singapore and India, and sales representatives globally. Prior to eRevMax, Mr. McCartan held senior management positions at Pegasus Solutions and at UK-based Computer and Design Services, where he managed sales of software solutions for the civil engineering industry. Mr. McCartan has an engineering degree from the University of Cape Town and a business degree from the Open University.