
Data is daunting and tracking it can be exhausting and sometimes over complicated, but honestly if you aren't tracking your business you are potentially running blind. And by that I mean, how on earth can you…

Data is daunting and tracking it can be exhausting and sometimes over complicated, but honestly if you aren't tracking your business you are potentially running blind. And by that I mean, how on earth can you possibly understand where your business is coming from; how much it is costing you and how each booking impacts your profitability?Too often I see hotels looking only at the number of hotel rooms they sold last night, last week or last month and the revenue they generated. They look only at 'whole house' believing that if the rooms are coming in and the revenue is good that is enough, but is it?Worse than that, many look at the revenue in their bars and restaurants in isolation which of course encourages that 'working in silo's' mentality. Definitely content for another blog but for now I would like to demonstrate the importance of tracking Market Segmentation and the impact it could have on your business.Market Segmentation is of course only one metric and strong revenue focused hotels will also measure by Source/Room Type/Length of Stay/Country of Origin etc but the goal in all of this is to understand the impact that our customers are having on our business and which customers actually add the most to our bottom line. Remember of course that we can't and shouldn't be all-things-to-all-people, so by having an understanding of where, why and when you business is coming should impact all business decisions.Imagine if you understood exactly how many rooms to expect from your Leisure Sector; how many days in advance they will book; which days they actually impact; the price they pay; the cost of bringing that business to your hotel and best of all, how much they will spend in your outlets. To get all of this information and to make that information useful, you need to start to track.I hope this example gives you a starting point:
| Jan | Feb | Mar | Apr | ||
| LEISURE SEG | |||||
| Room Nights | 200 | 281 | 322 | 387 | |
| Nett Rev | £15,100.00 | £21,988.00 | £25,277.00 | £31,443.00 | |
| ADR | £75.50 | £78.25 | £78.50 | £81.25 | |
| Nett of Room Cost(38.00) | £37.50 | £40.25 | £40.50 | £43.25 | |
| Nett of COMM (11.50) | £26.00 | £28.75 | £29.00 | £31.75 | |
| Nett of CPA (4.00) | £22.00 | £24.75 | £25.00 | £27.75 | |
| Nett Profitability | £4,400.00 | £6,954.75 | £8,050.00 | £10,739.25 | |
| Average Nett Spend Per Room (12.00) | £2,400.00 | £3,372.00 | £3,864.00 | £4,644.00 | |
| Nett ADJ Profitability | £6,800.00 | £10,326.75 | £11,914.00 | £15,383.25 | |
| Nett ADJADR | £34.00 | £36.75 | £37.00 | £39.75 |
In this example, we are looking at only one segment and over the period of 4 months. I would urge you to break your business down and include all segments but remember that 6 or 8 major market segments should be enough to give you a high level. For example brand website or booking.com are not segments, they are Sources. So start by having a look at your PMS and making sure that the information you are asking your team to store is actually useful! As an example:1 - Leisure2 - CorpNeg3 - CorpNonNeg4 - Wedding5 - Tour6 - FIT7 - EventThese are just some examples and you will have to tailor to your own business but ask yourself what data is useful and only track what you are going to use.So if we look at the example above, I am tracking:
If you use a similar metic and plot how each of your segments behave over time, you will see exactly how each piece of business impacts your bottom line.What I haven't added here is lead time or length of stay but even if we started revenue and profitability as a first step, this will give you a much better idea of how your business is performing.And don't forget that metrics don't lie. This will take all the fluff of 'we are corporate midweek and leisure at the weekend' or 'we are predominately a wedding based hotel' or 'our most profitable months are July and August' out of the equation and give you pure facts to work with.Whilst your PMS will probably not allow you reporting on this level, your Revenue Management system should do, so get tracking!(and for all things revenue just ask@rightrevenue.wpengine.com)
Latest from the blog

1 min read
What makes guests travel further and pay more for a hotel experience? In this episode of Revenue Rocks , Adrienne Hanna talks to Michael Beare from Finn Lough about creating demand, communicating value and turning…

4 min read
Learning revenue management in theory is one thing. Seeing how it actually works within a live hotel is where it really starts to come to life. That’s why we’re so pleased to be working with Edge Hotel School and…

6 min read
There’s been plenty of noise around England’s proposed tourist tax, but for hotels the bigger question is simple: what will it do to the final price the guest sees? With different areas potentially setting different…