Crossing channel, rate and commission: your real margin

Ask almost any front desk which channel performs best and they will name the one that brings the most bookings. It is an honest answer and, almost always, the wrong one. The channel that “sells the most” may be the one that keeps you the least, because sales are gross and margin is net. Between the two sits a commission nobody sees until you put it in the same row as the rate. This essay is not about channel philosophy; it is a tactical guide to BUILD, with your own live data, the cross that reveals real margin: channel by rate by commission. Step by step, with the table at the end.

The problem: the sales report hides the commission

Almost every channel report out there adds up revenue. It tells you the big OTA brought, say, 40% of your room nights and 38% of your revenue, and it sounds splendid. The trouble is that number is gross: it is what the guest paid, not what reached your account. The intermediary commission lives somewhere else, sometimes on another sheet, sometimes only in the manager’s head, and as long as it lives apart, comparing channels means comparing pears painted to look like apples.

The cross fixes this by putting three things that used to live in separate worlds into the same row: how much you charged (rate or ADR), how much it cost to sell through that path (commission) and how many nights it moved (volume). When those three columns touch, a fourth appears that changes everything: the net. And the net rarely ranks channels the way the gross does.

Gross versus net: two plain words that cost money

It is worth pinning the vocabulary, because this is where the decision is won. Gross is what was charged. Net is what is left after subtracting what it cost to collect it through that channel. We are not talking about room costs or electricity or housekeeping, that is a different analysis, only about the sales commission, which is what sets one channel apart from another.

Put in kitchen terms: two dishes sell for the same menu price, but if one is collected by a delivery app taking 25% and the other is sold by your own server with no commission, they do not leave you the same even when the ticket reads identical. The hotel room is the same dish. The channel is who collected it for you.

Gross tells you how busy you were. Net tells you how well you did. They are not the same question, and they almost never give the same answer.A Spider Data principle

The four columns you need

The good news is the cross needs no new system and no consultant: it needs four columns your operation already generates and that Spider Data already holds from your eight live sources. In the no-code builder, by dragging and dropping, these are the ones to grab:

1. Channel: where the booking came from (direct, big OTA, niche OTA, agency, walk-in, phone). This is your column to group by.
2. Rate or ADR: how much was charged per night. If you have the total and the nights, the ADR calculated field comes from dividing one by the other.
3. Commission: what the intermediary took. It can arrive as an amount or as a percentage of the rate; either one works for the math.
4. Nights: how many nights that channel moved in the period. Without volume, a high margin on a single booking tells you nothing.

The calculated field: where net margin comes from

Here is the tactical heart. Net margin is not a figure you capture; it is a figure that is BORN from the cross. You build it as a calculated field, that is, a new column the report computes on its own from other columns. The formula, in plain words, is revenue minus commission.

Per booking

At the level of each booking, net per night is the rate minus the commission per night. If you store the commission as a percentage, the field first turns it into an amount (rate times the percentage) and then subtracts it. The result is what truly comes in for that night, sold by that channel.

Per channel

To decide, the single booking is no use; the whole channel is. That is where the ROLLUP comes in, which is the total of a group: you group by the channel column and the report adds up gross revenue, adds up commission and adds up net across every night of that channel. While at it, you can ask for the average ADR and the effective commission rate of the channel, which is total commission over total revenue. That effective rate tends to surprise, because it blends high and low rates and rarely matches the round number in the contract.

When the channel is the grouping column and the net is the calculated column, sorting the table by net descending finally gives you the honest ranking: who leaves you the most actual money, not who brings you the most guests.

An illustrative example: the same hotel, two different rankings

The numbers that follow are invented only to show the mechanics; they are no hotel’s real data. Imagine an ordinary month with four channels. Sort by gross revenue and the big OTA wins comfortably. Watch what happens when you subtract the commission and sort by net:

The reading is telling. The big OTA stays valuable for volume, but the direct channel, which looked modest in gross, jumps in the ranking because it pays no commission: every dollar charged is a dollar net. And the niche OTA, which boasted the highest ADR, turns out to be the worst relative deal: its 23% commission wipes out that edge. None of this shows in the sales report; it only appears when rate and commission sit in the same row.

What seeing the net lets you decide

The cross is not an analytical ornament; it changes concrete conversations. Seeing real margin per channel lets you, for example:

• Justify with numbers how much pushing the direct channel is worth: if every direct night is worth its full rate, you know exactly how much you can invest in getting the guest to book with you and not elsewhere.
• Weigh a niche channel by what it leaves, not by what it boasts: a high ADR with a high commission can leave you less than a “cheap” channel with no commission.
• Renegotiate with arguments: walking into a meeting with a channel’s real effective commission rate, not the contract figure, changes the tone of the conversation.
• Spot leaks: a channel whose effective commission crept up without notice stands out the moment you look at it month over month.

And because the data is live, you are not reading last night’s close: the cross breathes with the operation. You can keep it as a dashboard with cross filters, by season, by room type, by guest origin, or schedule it to land every Monday, and even ask the AI, in plain language, “which channel raised its effective commission this month?” or have it alert you when a channel crosses a margin threshold.

An important line: we measure, we do not set prices

It is worth being clear about what this cross does and does not do. Spider Data calculates and shows the real margin per channel: it tells you what happened and why it left you that. It is not a rate system; it does not raise or lower prices, nor decide which channel to send inventory to. That strategy, how hard to push direct, how to split across OTAs, which niche to keep, is yours to decide, with your business judgment. We put the truth on the table, clean and traceable; the move is yours.

The channel that suits you is not in your sales

Deciding better starts with measuring the right thing, and with channels the right thing is almost never revenue. The sales report shows you the storefront; the cross shows you the till. When channel, rate and commission sit together in a single row, your channel ranking stops being a hunch and becomes an arithmetic, and sometimes the channel you thought was the star turns out to be the one that costs you most. The one that truly suits you is not in the sales report. It is in the cross.