Most independent hoteliers I talk to track upsells the way you’d check a slot machine. They run a “spring upgrade promo,” look at the total a month later, decide it either worked or it didn’t, and move on. Then six months pass before anyone looks again.
That’s not measurement. That’s vibes with a spreadsheet attached.
I want to walk you through the one number I actually watch to know whether the merchandising on a hotel’s booking engine is doing its job: upsell attachment rate, tracked as an ongoing report alongside incremental revenue per booking. Not a one-off promo autopsy. A living dashboard line you check every month, the same way you check ADR or occupancy.
What attachment rate actually is
Attachment rate is dead simple to define and weirdly easy to get wrong.
Attachment rate is the percentage of your bookings that include at least one paid add-on or upgrade. That’s it. Bookings with an upsell, divided by total bookings.
If 200 people booked last month and 38 of them added something paid — an early check-in, a room upgrade, a parking package, a bottle of wine on arrival — your attachment rate is 19%.
The reason it gets mangled is that people quietly change the denominator. One month they count “guests who saw an offer.” The next month they count “all bookings.” Then they compare the two and convince themselves something changed. Nothing changed except the math.
So rule one, and I mean this: lock your definition and never move it. I write it at the top of the sheet in plain English so future-me can’t cheat. Mine reads: attachment rate = bookings containing one or more paid ancillary items, divided by all confirmed bookings, same period.
The single most common reason a hotel “can’t tell if upselling works” is that the numerator and denominator drifted between reports. Pick one definition, write it down, and audit yourself against it every month.
Why one rate isn’t enough — bring in revenue per booking
Attachment rate alone can lie to you in a friendly way.
Imagine you start pushing a cheap add-on hard — a $6 late checkout. Attachment rate shoots up. Looks like a win. But you’ve trained guests to attach a near-worthless item while ignoring the $80 suite upgrade that actually moves your P&L. The headline number went up and your revenue barely twitched.
That’s why I always pair attachment rate with incremental revenue per booking: the total ancillary revenue divided by total bookings (not just the bookings that converted). This tells you what the average booking is now worth beyond the room.
Two numbers, read together:
- Attachment rate answers: are people saying yes to anything?
- Incremental revenue per booking answers: is “yes” actually worth money?
When both climb together, your merchandising is genuinely healthier. When attachment climbs but revenue-per-booking is flat, you’re attaching junk. When attachment is flat but revenue-per-booking climbs, you’ve gotten better at selling fewer, bigger things. All three of those are useful stories — and you only see them if you track both.
The monthly report I actually keep
Here’s the skeleton. It fits on one tab. You don’t need a fancy revenue-management platform to start — a clean monthly export from your booking engine or PMS and a spreadsheet will carry you a long way.
| Metric | Month 1 | Month 2 | Month 3 |
|---|---|---|---|
| Total confirmed bookings | 200 | 215 | 224 |
| Bookings with a paid add-on | 38 | 48 | 59 |
| Attachment rate | 19.0% | 22.3% | 26.3% |
| Total ancillary revenue | $2,090 | $2,880 | $4,012 |
| Incremental revenue per booking | $10.45 | $13.40 | $17.91 |
| Top add-on by revenue | Upgrade | Upgrade | Parking pkg |
Those numbers are illustrative — made-up to show the shape of the report, not a real hotel’s results. But the shape is the point. In three rows you can see attachment climbing, revenue-per-booking climbing faster, and a shift in which product is carrying the load. That last row matters more than people expect.
Track the mix, not just the total
The “top add-on by revenue” line is where the strategy lives. If parking suddenly overtakes room upgrades, that’s telling you something about who’s booking and what they value. Maybe you’re getting more drive-market guests. Maybe your upgrade pricing got out of step with the OTA rate and guests are doing the math and passing.
I like to keep a small breakdown underneath the main table — each add-on, its attachment rate, and its revenue contribution — so a category dying in silence doesn’t hide inside a healthy-looking total.
Where the data comes from (and the traps)
You’ll pull this from one of three places, and each has a gotcha.
The booking engine. Cleanest source for direct bookings, because that’s usually where the upsell modules live. But it only sees direct. Anything booked through an OTA is invisible here, which actually understates your true total bookings if you use booking-engine counts as your denominator. Be deliberate: report direct attachment rate separately from blended.
The PMS. Sees everything that resolves into a stay, including front-desk upsells at check-in. The trap is timing — a folio add-on posted at checkout lands in a different period than the booking. Decide whether you’re measuring at time of booking or time of stay and, again, never mix the two in one trend line.
Manual front-desk logs. Some of the best upselling at independents happens in person — “we have a room with the courtyard view for $40 more tonight.” That revenue is real and often unrecorded. If your team does this, get it into the report even if it’s a clipboard tally for now. Uncounted revenue can’t be optimized.
If you only measure upsells inside the booking engine, you’re blind to every dollar your front desk earns at check-in. For most independents, in-person upselling is a meaningful slice — count it, even crudely, before you optimize anything.
How I read the trend (what each move means)
Once you’ve got three or four months stacked up, the report starts talking to you. Here’s my cheat sheet for what the movements mean:
- Attachment up, revenue-per-booking up. Healthiest signal. Keep doing what you’re doing and push the highest-margin item harder.
- Attachment up, revenue-per-booking flat or down. You’re selling cheap stuff. Re-price or re-order your offers so the bigger-ticket items get prime placement.
- Attachment down, revenue-per-booking up. Fewer yeses but bigger ones. Often fine — but check you haven’t quietly buried a popular cheap add-on that was a nice on-ramp.
- Both down. Something broke. A booking-engine layout change, a pricing mistake, a seasonal shift, or an offer that’s gone stale. Go find it.
The discipline is looking every month, so a slow three-month slide doesn’t masquerade as “just a soft quarter.”
How this connects to your direct-booking fight
Here’s the part that ties back to everything else I bang on about. Upsell attachment rate is, quietly, a direct-booking metric.
When a guest books through an OTA, you usually don’t get to merchandise much of anything. The OTA owns the path. They take their cut — typically around 15 to 25% of the room rate — and the add-on real estate is mostly theirs, not yours. When a guest books direct, you own the screen. You decide what upgrade shows, at what price, in what order.
So every point of direct-booking share you win back from search and AI assistants isn’t just a commission saved on the room. It’s a fresh opportunity to attach a $60 upgrade you’d never have gotten on the OTA path. Direct demand and attachment rate compound on each other. That’s why I treat them as part of the same scoreboard.
If your hotel still ranks below the OTAs for its own name, or you’re invisible to ChatGPT when someone asks for a hotel like yours, you’re losing the bookings and the upsell that would have ridden along with them. The merchandising work and the visibility work are the same fight from two ends.
A simple way to start this month
You don’t need to boil the ocean. Here’s the minimum viable version I’d hand a hotelier today:
- Write the definition. One sentence. Numerator and denominator, in plain words, at the top of the sheet.
- Pull last three months of bookings and ancillary revenue from your booking engine or PMS, using that exact definition.
- Compute two numbers per month: attachment rate and incremental revenue per booking.
- Add one breakdown row: top add-on by revenue, so you can watch the mix.
- Put a recurring 30-minute hold on your calendar, monthly, to update it. The cadence is the whole game.
That’s a report you can keep forever. It’ll outlive every “promo” you ever run, because it measures the system — your merchandising — not a single campaign.
And once you’re watching it, you’ll start asking better questions. Why did parking spike in March? Why does early check-in convert on weekends but not weekdays? Should the suite upgrade lead the page in shoulder season? Those questions are where the real money is, and you can only ask them when you’ve got a clean trend line in front of you instead of a one-off promo total.
If you want help wiring this into your booking engine so the upsell experience actually earns its placement — and capturing more of the direct bookings that make upselling possible in the first place — that’s exactly the kind of work we do at HotelSEO Lab. Take a look at our book-direct CRO service, see how we win back bookings the OTAs are skimming, and when you’re ready, book a call and we’ll map it out for your property.