Channel analytics: where the money is really won and lost

There is a question that sounds simple and almost never gets an honest answer inside a hotel: which of your sales channels actually makes you the most money? Most people answer with whichever channel sits at the top of the room-nights report. And they are almost always wrong. The loudest channel, the one that fills the most rooms, is rarely the one that leaves the most margin in the bank. That gap between “selling a lot” and “truly earning” is, quite possibly, the most expensive blind spot in hotel operations.

Why volume misleads

Volume is seductive because it is visible. A channel that brings a hundred reservations feels more important than one that brings twenty. The dashboard confirms it, the meeting celebrates it, and the sales team defends it. But volume describes how many rooms got filled, not how much was left after paying to fill them. And that is where the real analysis begins.

Every channel charges differently to bring you a guest. An online travel agency (OTA) might take a commission somewhere between fifteen and twenty percent of the reservation value, use those numbers only as an illustrative example, not as a fixed fact. Your direct website charges no commission, but it carries a different cost: the advertising that gets people there, the payment gateway, your team’s time. Phone and front desk cost almost nothing in distribution, but they depend on someone deciding to call or walk in. No channel is free; they simply charge in different ways, and some of those ways never show up on the room-nights report.

Net margin: the only metric that pays the payroll

Net margin by channel is what remains from a reservation after subtracting everything it cost to get it through that channel: the commission, the payment gateway cost, the attributable advertising, and any discount tied to that channel’s program. It is not the price you see on screen. It is what actually arrives and stays.

To build it, you need to cross several things that almost never live in the same table. That is why many hotels never calculate it: the reservation is in one system, the commission in another, the payment cost in a third, and whether the guest returned lives nowhere at all. Spider Data exists, in large part, so that this cross stops being a month-end project and becomes just another column in the report. The no-code builder lets you drag reservation, channel and payment into the same view; a calculated field turns rate minus commission minus cost into net margin; and a total by channel (a ROLLUP) tells you, without adding anything by hand, how much each one leaves.

Gross revenue tells you how much you sold. Net margin tells you how much you kept. Payroll, suppliers and debt only understand the second number.A principle of financial reading

The cross that truly matters: channel × rate × commission × guest

A channel’s profitability is not a flat number; it is the result of four forces that multiply each other. Looking at them separately hides the truth; looking at them together reveals it.

Channel

The origin of the reservation: direct (your site, phone, front desk) or intermediated (an OTA, a wholesaler, an agency). It defines who charges to bring you the guest, and how much.

Rate

Not every reservation from the same channel is worth the same. A flexible rate leaves more than a non-refundable deal rate. The average price per room sold (ADR) by channel tells part of the story; the mix of rates within the channel tells the other.

Commission and distribution cost

The percentage the intermediary takes, plus the silent costs: payment gateway, advertising for the direct channel, management tools. It is the part most often forgotten, and the one that most changes the result.

Guest type

Here lies the factor almost no one crosses, and it is enormous. The guest who books once and disappears is not worth the same as the one who returns three times a year. A channel that mostly brings returning guests builds a value its commission does not capture: that guest’s second booking may come through your direct channel, with no commission. A channel that only brings one-time guests charges you again for every single stay. Measuring guest type by channel, returning versus first-time, direct versus intermediated, completely changes the reading of which channel is truly valuable over time.

• Direct + returning guest: the silent ideal. Low acquisition cost and a guest who comes back on their own.
• Intermediated + returning guest: expensive the first time, but if you turn the second booking direct, the channel “seeded” a profitable customer.
• Intermediated + one-time guest: the most expensive in the long run. You pay full commission on every stay and build no relationship.
• Direct + one-time guest: cheap, but fleeting. Healthy volume worth converting into recurrence.

Volume versus net margin: same hotel, two stories

The table below is an illustrative example, the numbers are invented to explain the idea, not data from any real hotel. Imagine four channels in one month. If you only look at the nights column, the order of importance is one thing. If you look at the net margin each one leaves, the order flips.

Read the table slowly. The large OTA is, without doubt, the queen of volume: 420 nights against the direct site’s 180. But after commission, its margin per night is noticeably lower, and only one in eight of those guests returns. The direct site, with less than half the nights, leaves a net margin surprisingly close behind, and almost four in ten of its guests come back, often directly, without you paying commission again. The front desk, the “small” channel no one celebrates, is the most profitable per night and the one that builds the most loyalty. The story volume tells and the story net margin tells do not look alike.

Channel dependency: a risk that never shows up in revenue

There is a cost no sales report shows and that is worth watching like a vital sign: how much you depend on a single channel. If most of your nights come through one intermediary, that intermediary holds power over you. It can raise its commission, change its visibility algorithm, or push you down its results, and you feel it in the bank account without having done anything different.

Channel dependency is to distribution what having a single client is to a business: comfortable while it lasts, fragile when it changes. Measuring the percentage of nights and of margin that comes through each channel, month after month, tells you whether you are concentrating risk or spreading it. This is not about declaring war on the OTAs, they are a legitimate, valuable source of demand that did not know you existed. It is about knowing, with live numbers, how exposed you are, so that the decision of how hard to push each channel is yours and not a surprise.

How Spider Data reads the channel (and what it deliberately does not do)

Spider Data crosses eight sources of your operation, reservations, cash, channels, payments, guests, orders, shifts and cash movements, into a single structure. That lets net margin by channel, guest type by channel, and channel dependency live in the same report, in plain language, without anyone exporting spreadsheets at midnight.

• No-code builder: drag reservation, channel, commission and payment into the same view; no programming required.
• Calculated fields: ADR by channel, net margin, booking lead time, and reconciliations, computed by the system, not by hand.
• Crosses and totals: join tables (JOINs) and get totals by channel (ROLLUPs) without writing fragile formulas.
• AI to ask in words: “which channel left the least net margin this quarter, and why?”, plus summaries, anomaly detection, and hidden patterns the eye misses.
• Live data, not last night’s close: what you see is what is happening now.
• Open connectors: if you prefer Power BI, Tableau or Looker, the data goes out through an interface (API) with an access key (Bearer token). It is not a cage.

And here is the boundary, said plainly: Spider Data measures and explains channel performance, what happened and why, but it does not set your prices or decide your distribution strategy. It is not a revenue management system (RMS). It will not tell you to “raise the OTA rate” or close a channel for you. It hands you the clear, live truth so that you, who know your market and your brand, decide better. The decision is yours; our job is to make it a decision made with eyes open.

Measuring against yourself and against the market

Knowing your net margin by channel is valuable on its own, but it takes on another dimension when you can compare it. The R2-Index lets you contrast your performance against a reference index: not to copy anyone, but to know whether your dependency on a certain channel or your direct margin sit within reason for similar hotels, or whether there is an opportunity you are leaving on the table. And because Spider Data is part of R2 OS, that reading is not an isolated report: it talks to the rest of your operation, with human support in Spanish behind it when something does not add up.

Do not chase the loudest channel

A hotelier’s intuition tends to reward the channel that fills rooms, because filling rooms feels like winning. But the bank account does not hear the noise; it hears the margin. The channel that sells the most is almost never the one that keeps the most, and confusing them leads you to push exactly the origin that costs you most and to neglect the one that earns you the most loyal guests.

The good news is that this is no mystery: it is a cross of data your own operation already generates, waiting to be read honestly. When you see channel, rate, commission and guest type in the same view, live, you stop deciding by feeling and start deciding by evidence. Do not chase the loudest channel. Chase the one that keeps the most, the one that brings guests who return, the one that does not hold you hostage. That channel is almost always there, in your own data, waiting for you to finally see it clearly.