The star channel that wasn’t: optimizing a hotel’s channel mix

Hotel Las Jacarandas, a fictional property we’ll use as a mirror, held one belief no one questioned: its best channel was “that” big online travel agency, the one that filled the bookings panel with new reservations every morning. Healthy occupancy, full calendar, a relaxed management team. And yet, at month-end, profit didn’t keep pace with volume. Something was off. This is the journey, illustrative, not real data, of how it went from counting reservations to understanding how much it actually kept from each one.

The symptom: high volume, thin profit

The Las Jacarandas team watched a single number, and watched it fondly: the count of reservations per channel. Through that lens, the largest online agency was the undisputed queen. It delivered most of the nights sold, so it was “obviously” the channel to protect, to feed, to prioritize in every inventory decision.

The trouble is that volume is only half the story. A booking that comes in is not a booking that pays off. Between the price the guest sees and the money that truly lands in the hotel’s account sits a silent subtraction: the channel’s commission. And that subtraction isn’t the same everywhere. When closing profit didn’t match the calendar’s euphoria, the right question stopped being “how many bookings does each channel bring?” and became “how much, really, does each channel leave me?”.

The analysis: crossing channel, commission and margin

This is where Las Jacarandas stopped guessing. Instead of looking at a single table, it crossed three realities that usually live apart: where each booking came from (the channel), how much it cost to bring it (the commission) and how much was left after that subtraction (the net margin). It’s a simple cross to describe and, without the right tool, an exhausting one to do by hand every week.

What “net margin per channel” means

Picture a child counting coins. If a channel brings a hundred reservations of a thousand pesos each, that’s a hundred thousand pesos gross. But if that channel keeps eighteen of every hundred pesos in commission, only eighty-two thousand land at the hotel. Another channel, say direct, the booking that comes through the hotel’s own website or phone, might bring only twenty reservations, but it charges almost no commission, so of its twenty thousand gross, nineteen thousand land. Net margin per channel is, simply, what you actually keep after paying the channel for the sale.

To make it tangible, imagine, a clearly illustrative example, not real figures, an ordinary month at Las Jacarandas seen through both lenses at once:

The uncomfortable discovery jumps out in the last column. The big agency was still huge in gross, but its bite was also the largest. Direct, tiny in volume, kept almost everything it sold: its margin per booking was the healthiest of the three. The “star” channel shone for its size, not its relative profitability.

The risk no one had put in a table

The cross revealed a second discomfort, this one not about money but about fragility: an enormous slice of the business depended on a single intermediary. If that agency changed its terms, raised its commission, or simply pushed the hotel down in its search results, Las Jacarandas had no cushion. Concentration in one channel is a real operating risk, and until that moment it lived as a vague hunch in the manager’s head, never as a percentage in plain sight.

A booking that comes in is not a booking that pays off. Between the price the guest sees and what lands in your account sits a subtraction worth facing head-on.Margin-per-channel principle

The informed decision: rebalance toward what keeps more

With the cross in front of them, the Las Jacarandas conversation changed its tone. It was no longer “let’s sell more through the big channel,” but “let’s keep more of what we sell.” The decision, let’s underline this, was made by the hotel’s human team, not by the tool. Spider Data showed performance per channel clearly; the distribution strategy was designed by the people who know their market, their season and their guest.

One point deserves to be explicit: Spider Data is not an RMS. It doesn’t set rates or decide which channel to push inventory toward. It measures and explains, what happened and why, and leaves the pricing and distribution lever in the hands of whoever runs the hotel. That boundary is deliberate: the tool illuminates, the hotelier decides.

Steps of the rebalance

1. Rank channels by net margin, not by number of bookings: finally see how much each one leaves after commission.
2. Calculate what percentage of the total depends on the largest channel, to put concentration risk in black and white.
3. Strengthen the direct channel: the hotel’s own booking charges the least commission, so every point shifted toward it is margin that stays home.
4. Distribute commercial effort, campaigns, attention, featured inventory, with profitability in mind, without abruptly abandoning the volume that holds up occupancy.
5. Set a simple, measurable goal for the new mix (for example, “stop letting direct be a crumb”) and agree on how it will be reviewed.

The follow-up: measure the mix live

A decision without follow-up is a wish. The value of the rebalance isn’t the day it’s decided, but the weeks in which you check whether it worked. Here it matters that the data is alive: not last night’s close, but today’s pulse. A dashboard with cross-filters lets Las Jacarandas watch the mix move almost in real time, filter by month or room type, and notice early whether direct is gaining ground or stalling again.

The product’s AI adds another layer of quiet vigilance: it summarizes the evolution in plain language, raises its hand when something strays from its usual pattern, a commission that suddenly climbs, a channel that drops with no apparent reason, and lets you ask in plain words, no formulas, things like “how much did direct leave me this month versus last?”. Scheduled deliveries and alerts close the loop: the mix report arrives in the inbox on its own every Monday, with no one having to remember to build it.

• Live dashboards with cross-filters to watch the mix move, not wait for the month-end report.
• Natural-language questions to interrogate the data without knowing formulas or code.
• Anomaly detection that warns when a commission or a channel behaves differently than usual.
• Scheduled deliveries and alerts so follow-up happens on its own, week after week.

And if the hotel already lives in Power BI, Tableau or Looker, the same per-channel data flows out to those tools through an open connection (via API with a Bearer token). It’s not a cage: the cross that revealed the truth can keep feeding the dashboards management already uses. For anyone wanting context, R2-Index also lets you compare performance against a reference index, and put “I’m doing well” or “I’m doing poorly” in perspective.

The close: keep more of what you sell

Las Jacarandas didn’t sell more nights by doing this exercise. It probably sold about the same. What changed was how much it kept from each sale and how much it understood about its own dependence. The “star” channel remained large, but it stopped being the only criterion; direct, once a footnote, earned its own name in decisions.

That’s the lesson of this illustrative case, and it holds for any real hotel that recognizes itself in the mirror: optimizing the channel mix isn’t about selling more, it’s about keeping more of what you sell. Volume fills the calendar; margin fills the account. When you can see both at once, live and without jargon, you stop managing bookings blindly and start deciding with your eyes open, which, in the end, is the only thing that matters.