What the rate plan mix by channel shows
The rate plan mix by channel shows the percentage of guests on each sales channel who selected a specific rate plan, whether flexible, non-refundable, with breakfast, or another variant. This analysis reveals how your rate fences are working, or leaking, across channels. It is one of the few reports that tells you not just how many rooms each channel sold, but what kind of sale each one really was.
A hotel owner or revenue manager cannot fully understand which channel is more profitable by looking only at overall occupancy or average daily rate (ADR). Two channels can produce the same ADR, but one may take a large share of its guests with non-refundable plans while the other relies on flexible plans. The channel with the non-refundable mix keeps that revenue when the season turns soft; the other gives it back as cancellations.
Reading the rate plan mix directly affects your cancellation rates, cash flow, and guest loyalty. A high share of non-refundable plans makes cash flow more predictable, because the payment is collected upfront and the booking survives a schedule change. If that share climbs too high, though, you may lose bookings in periods when guests want cancellation flexibility, which risks lowering your conversion rate on that channel.
How to perform a channel-level reservation analysis
To perform a channel-level reservation analysis, pull all reservations for a specific date range from your property management system (PMS) or channel manager, broken down by channel and rate plan. Lay the data out so that each channel shows its total room nights and the percentage share of each rate plan. The export is a reservations report with a channel column and a rate plan column; the work is in grouping it correctly.
For example, say you are reviewing the last 30 days for a 40-room hotel. Total sales came to 600 room nights. Of these, 400 were booked through an online travel agency (OTA) and 200 through the direct website.
Say that of the 400 room nights from the OTA, 320 were sold on non-refundable plans and 80 on flexible plans. Of the 200 room nights from the website, 40 were non-refundable and 160 were flexible.
These calculations show that non-refundable plans account for 80% of your OTA channel but only 20% of your website. That single table tells you your rate fences are behaving differently by channel: the OTA guest is buying certainty at a discount, while the direct guest is buying the option to walk away. Neither number is good or bad on its own, but together they tell you where your pricing structure is exposed.
Why rate plan preferences differ between OTAs and direct sales
Guests behave differently depending on where they book. If your OTA mix shows a preference for flexible plans, one hypothesis to test is that guests searching on OTAs are in comparison mode: they have your hotel next to others on the same screen, and a plan they cannot cancel feels like a commitment made before they have finished shopping. Check if your data reflects a lean toward plans that offer cancellation flexibility, even at a higher rate.
Guests booking directly on your website are closer to a decision. Ask in your own guest profiles whether they are loyal to your hotel, or whether they are looking for a specific perk such as a membership discount or a loyalty program benefit. If your direct channel shows a higher share of non-refundable bookings, it may indicate these guests are more willing to accept cancellation risk in exchange for a lower price, which is why member-only and closed-group rates pull non-refundable bookings toward your direct channel.
When you read the rate plan mix by channel, keep these behavioral differences in mind before you change anything. Forcing a higher share of non-refundable plans onto an OTA can lower the conversion rate on that channel, a risk to monitor in your conversion data rather than a certainty. The mix is a signal to work with, not a target to force.
How to detect leaks in the rate plan mix
A leak in the rate plan mix occurs when a rate plan that is supposed to be exclusive to a specific channel or guest group is being sold on other channels or to everyone. This is the clearest sign that your rate fences are inadequate, and rate fences used to offer different prices across channels only hold if the plumbing behind them holds too. A leak costs you twice: the discounted plan sells where it should not, and the guest who would have paid the flexible rate may find the cheaper one anyway, a cannibalization risk to check in your booking data.
Hidden discounts in agency contracts
Hidden discounts in agency contracts can cause non-refundable plans to drop onto public channels automatically. Review your contracts before you blame your systems.
Check whether tour operators or agencies display the rates they receive under allotment agreements publicly on their own websites. If they do, a guest may not find your non-refundable rate on your own website, but can find it on an agency's site, sometimes below what you sell it for directly. Check the agency's live site against your own rate grid, and take the contract clause to the agency when the two do not match.
Channel manager synchronization errors
Channel manager synchronization errors can cause rate plans that should be closed to remain open on some channels. Check your reports daily, because a rate closed on one channel stays open on another until the channel manager pushes the change.
When you set a rate plan exclusively for your website, confirm that your channel manager does not push that plan to other OTAs. Synchronization errors can cause website-exclusive plans to appear on channels like Booking.com or Expedia, and once a guest has seen the lower plan there, you have lost the direct booking opportunity for that stay.
Which rate plan is more profitable on which channel
When you read the rate plan mix, focus not just on the room count but on the net profit of each plan on each channel. Non-refundable plans guarantee cash flow, while flexible plans may carry a higher cancellation risk, a hypothesis to test in your own cancellation data, which shows up later as empty rooms and re-sold nights at worse rates.
For example, say the cancellation rate for a non-refundable plan sold through your website is 2%, while the flexible plan on the same channel has a 15% cancellation rate. The non-refundable plan eliminates most of the cancellation risk because you collect the payment upfront, so the flexible plan has to sell at a meaningfully higher rate just to end up in the same place.
A high share of flexible plans on OTA channels can also waste agency commission on canceled reservations, depending on who collects the guest payment on Booking.com and Expedia. Payments collected through the guest folio may be refunded by the agency upon cancellation, so check your contract clauses regarding commission handling on cancellations.
When calculating profitability by channel, you must evaluate the agency commission, cancellation rate, and payment model together. Increasing the share of non-refundable plans on a high-commission channel can improve your overall profitability.
How to optimize the rate plan mix by channel
Optimizing the rate plan mix by channel requires understanding each channel's guest profile and setting up rate fences accordingly. This means moving away from a uniform pricing strategy toward a dynamic, channel-specific structure, where the same room earns its keep differently on each shelf.
- To increase the share of non-refundable plans, add exclusive perks such as late checkout or a room upgrade to those plans for specific channels or guest groups.
- Instead of tightening the cancellation terms of flexible plans, guide guests toward non-refundable plans by tying early booking discounts to them, which rewards commitment rather than punishing flexibility.
- Set up a reporting screen in your channel manager and PMS where you can monitor in real time which rate plan is visible on which channel, so a leak is caught the day it appears rather than at month-end.
- Increase the share of non-refundable plans on direct channels, such as your website and mobile app, by offering exclusive non-refundable rates to loyalty program members, a strategy to test rather than a guaranteed shift in the mix.
Common mistakes in rate plan mix analysis
One mistake to avoid in rate plan mix analysis is reading only the plan selected at the moment of booking and ignoring canceled reservations. Even if non-refundable plans show a high share on a channel, the net occupancy picture changes completely when the flexible plans behind them cancel out.
For example, say that on one OTA channel, 100 reservations were made, with 30 on non-refundable plans and 70 on flexible plans. By the end of the season, 30 of the flexible plans were canceled, a pattern covered in detail in how hotels manage cancellations and no-shows.
In that case, the share of non-refundable plans appears as 30% at the time of booking, but rises to 43% in net realized sales. Always base your analysis on net realized reservations, excluding cancellations, because that is the mix that actually produced revenue.
Evaluating the rate plan mix solely through ADR can be misleading. Plans that include extra services like breakfast or half-board produce a higher ADR but also increase your costs, so the plan that looks best on the rate card may not be the one that leaves the most money in the month. Read the mix next to the cost of what each plan delivers, not next to its headline rate.
Share this post
Frequently Asked Questions
How often should I check the rate plan mix by channel
Check the rate plan mix by channel weekly. Before entering the high season and again mid-season, this analysis helps see whether your rate fences are leaking, because a leak that starts in shoulder season costs far more once demand peaks and every mispriced room night matters.
How does a channel manager prevent rate plan leaks
A channel manager automatically applies the rules, known as rate mapping, that determine which channels each rate plan is visible on. When the rules are defined correctly, a website-exclusive plan is never pushed to the OTAs, and a closed plan stays closed everywhere until you decide otherwise.
Why are non-refundable plans sold on the website more profitable
Non-refundable plans sold on the website carry no agency commission, and because the guest's payment is collected as an advance payment, the cancellation risk is significantly lower, as explained in how prepayment, cancellation and withdrawal rights work on a hotel website. This directly raises the net profit margin, since every lira the guest pays upfront stays with the hotel instead of being split with an intermediary.