Checking competitors' prices by hand: a weekly rate-shopping routine for a small hotel

Rate shopping is the routine of recording what named rival hotels ask for the same room, dates and conditions, then comparing them with your own price. Done by hand once a week, it shows your position in the market. It does not show demand, rival bookings, or what a rival will charge tomorrow.

For example, a reservations manager might open three rival websites on Monday morning, write down the lowest number she sees and cut her own rate for the weekend. By Wednesday the rival may be back at its old price, and the risk is that her rooms sell below what the week would have carried. The problem was not the checking; it was the method. This article gives you a hotel rate shopping routine that fits in one half hour a week: which rivals to watch, which dates, how to compare like with like, what to write down, and when a reading justifies a rate change.

What can a manual price check tell you, and what can it not?#

It tells you the asking price one rival displayed for one room, one set of dates and one set of conditions, at the moment you looked. It tells you nothing about how many rooms that rival has sold, what it will charge tomorrow, or why it chose that number.

A published rate is an offer, not a transaction. You see what the hotel is willing to sell at, never what guests actually paid. A rival can display a low price on a page and still sell most of its rooms at higher, flexible rates through other channels.

The page you see is one cell of a grid. Room type, date, length of stay, board, cancellation terms and number of guests all move the number. That is why a bare price, written down without its conditions, is close to useless.

Availability is information too. A rival showing sold out for a date tells you more than a low price does: it says the date is carrying demand in your segment and location. A sold-out rival is also, for that date, no longer a price reference at all.

One week's reading is a data point. Three or four weeks of the same reading is a trend, and only a trend is worth a rate change.

Which rivals and which dates should you check?#

Six rivals and five dates. A small hotel does not need sixty comparisons; it needs the same small set, checked the same way, every week. The value of the routine comes entirely from repetition, because only a fixed set produces a series you can read.

Choosing the six#

Choose rivals by the guest, not by the logo. The right question is not "who do we consider prestigious" but "which hotels does a guest actually compare us with": same location, same segment, similar size and star level, similar board offer. A guest booking a small breakfast-included hotel in one district is not comparing it with a large resort across the bay.

Include one property slightly above you and one slightly below. A set of exact peers tells you little when you want to move up or need to defend price. The property above shows you what the segment tolerates at the top; the one below shows you where the floor of the market sits.

Write one line saying why each rival is in the set. If you cannot write the line, it should not be in the set. Revisit the set at the start of a season, not every week: swapping rivals mid-season breaks the series and the trend disappears. If you are building the set for the first time, how to choose a competitive set and compare rates fairly is the fuller guide.

Choosing the five dates#

Five dates cover the decisions you actually face:

• The coming weekend, because it is where this week's revenue lives.
• A date two to four weeks out, where a rate change still has time to work.
• A shoulder date, where you most often misprice.
• A date with a known local event, where the market moves as one.
• A quiet midweek date, which shows the floor of demand.

Keep the five dates defined by rule, not by mood: "the coming Friday to Saturday", "the Friday three weeks out", and so on. If the rule is fixed, the readings are comparable. If you pick a different kind of date each week, you are back to one-off comparisons.

How do you compare like with like?#

You compare the same room, the same board, the same cancellation terms, the same number of guests and the same tax treatment. If any of those differ, you are comparing two different products and the number means nothing.

The most common error in manual rate shopping is comparing a standard room against a deluxe, or a flexible rate against a non-refundable one, and reading the gap as a pricing decision. A flexible rate and a non-refundable rate differ by more than most hotels assume, so never mix them in one comparison. Record which one you saw, and compare flexible with flexible the following week.

Taxes and fees matter just as much. Some pages show prices with tax included, some without, and some add fees at a later step. Record which display you were looking at, or your sheet will contain silent differences large enough to change the decision. The same discipline applies to currency: record the currency shown and the date, never a converted figure you calculated later from memory.

One more habit: record the public rate, and note separately if the only price you could see was a member or closed-group rate. A member-only price is a marketing message, not a market price.

Why check at the same time each week, and why keep a screenshot?#

Because rates move. A rival checked on Monday morning and another checked on Friday evening are two different readings, and the gap between them may be the calendar rather than the market.

Fix one slot: same day, same hour, one sitting. Monday morning before the week's arrivals is a common choice for a small hotel, because the reading is close enough to the weekend to matter and early enough to act on. Record the timestamp with every reading, not just the date, so that next month you know whether two readings were taken under comparable conditions.

Save a screenshot or the page as a file named by date and rival. It is the only record you will have when someone asks, months later, why a rate was changed. Write down what the page showed, not what you remember it showing: memory smooths numbers toward what you expected to see.

If a page shows a price you cannot explain, record it as seen and look again next week before acting on it. Odd readings are usually a released group block, a loading mistake, or a rate attached to a different room type.

What should the weekly sheet contain?#

One row per rival, date and room type, with your own price in the same row so the comparison is visible without opening a second file. The sheet is a record first and an analysis second; design it so that a stranger could reconstruct what you saw.

The columns#

The columns are: date checked, check-in date, nights, room type, board, guests, rival, rate seen, currency, tax included yes or no, cancellation terms, screenshot file name, and your own rate for the same cell. Add a short note column for what the page actually said: sold out, member rate only, price jumped since last week.

One workbook per season, one tab per month. A new file every week produces twelve files nobody reads, and no trend either. Keep the sheet readable by one other person: if only you can read it, it stops the week you take a holiday.

Never average across different room types or board bases. Average only cells that are genuinely comparable, or your "average market rate" is a number that describes nothing.

The weekly half hour#

Review in a fixed half hour. Read the sheet, mark the cells where you differ from the middle of the set, and decide nothing else in that sitting. Separating the reading from the deciding is what stops the Monday-morning rate cut from the opening story: you look this week, and you act only when a pattern has formed.

How do you act on the sheet without chasing every move?#

You set the rules before you look, and most weeks the correct action is none. A rate change should follow a pattern in the sheet, not a single reading.

Decide in advance what would make you move. For example, three consecutive weeks sitting above the middle of the set on a date that is still selling. A rule written before you look cannot be flattered by one alarming Monday reading; a rule invented while looking at one always can.

A single rival drop may be a released group block, a loading mistake, or a rate attached to a different room type. Check it again next week before matching it. Never match below your rate floor: the floor comes from your costs and your strategy, not from a rival's page. How a hotel sets its rate floor covers that calculation.

Run your own parity check in the same sitting: your direct price against your OTA prices for the same date and room. A weekly parity check is a separate routine, and a weekly rate parity check for direct and OTA prices describes it in full.

A price cut only pays if occupancy rises enough to cover it. Work the trade through in ADR and RevPAR terms before you touch the rate; the formulas and the common mistakes are in RevPAR, ADR and occupancy: the formulas behind a rate cut. Write one line each week saying what you did and why. Next season that line is worth more than the numbers beside it.

When is a paid rate-shopping tool worth it?#

When the manual routine has become the bottleneck: too many rivals, too many dates or too many room types to read by hand in the time you actually have. Until then, the spreadsheet does the same job for free.

Tools collect and store history automatically. The value is the history, not today's number, because history is what turns readings into trends. A tool still needs your competitive set and your room-type mapping: a wrong mapping produces confident nonsense that looks like data, which is worse than an honest gap in a hand-kept sheet.

Count your hours first. If the manual routine costs one person two hours a week, that is the budget a tool has to beat. Keep a monthly manual check as an audit: if the tool and your own reading disagree, find out why before trusting either.

A tool does not set your price. It gives you the same sheet, faster and with more history behind it. No tool, paid or manual, removes the need to know your floor and what your segment will pay.

What to do next#

Build the sheet this week with six rivals and five dates, fill it in for four weeks without changing a single rate, and only then read the pattern. The routine is the point: one fixed set, one fixed hour, one screenshot per reading, and a written reason for every move you make afterwards.