Hotel Rate Shop Analysis: How Revenue Managers Actually Use Comp Set Data

Rate intelligence tools have improved dramatically in the last five years. The data is more reliable, the coverage is broader, and the update frequency is faster than it used to be. But the rate shop analysis process inside most hotels hasn't changed much — someone opens the report, looks at a few dates, makes a mental note, and moves on. There's a more useful way to work with this data, and it's not complicated.

What rate shop data is actually telling you

Before getting into process, it's worth being precise about what rate shop data does and doesn't tell you. Your rate intelligence tool — whether that's Lighthouse, RateGain, or the built-in rate shop in your RMS — is showing you publicly available pricing from OTA channels. This is the BAR (best available rate) your competitors have set for a given date, typically across Booking.com, Expedia, and direct channel as a reference point.

What it isn't showing you: negotiated corporate rates, group blocks that are off the market, or private fenced rates behind logged-in accounts. The rate shop is a proxy for market positioning, not a complete picture of competitor revenue strategy. This distinction matters because it shapes how you should interpret what you see.

When a competitor's rate looks low, there are at least three possible explanations: they're trying to stimulate demand on a soft date, they have significant group or corporate volume already and are depressing their BAR to fill remaining rooms, or they have a different read on the market than you do. The rate shop alone can't tell you which one.

The daily rate shop analysis process — what it looks like when it works

The purpose of daily rate shop review isn't to match competitor prices. It's to catch positioning anomalies that require a decision. A well-designed rate shop analysis process takes 10–15 minutes and surfaces three things: dates where you're significantly under-positioned relative to the comp set, dates where you might be leaving occupancy on the table by pricing too aggressively high, and patterns that suggest competitors are reacting to something you should be aware of.

A representative rate shop view

In this view, the Monday the 28th is the date worth a decision. The property is priced $47 below the comp set median with only 44% occupancy — which suggests the low rate isn't working to stimulate bookings, the property is simply under-priced on a date where the market is pricing stronger. That's the kind of anomaly a good rate shop analysis catches immediately. Everything else in this view is within a manageable range.

The signals that actually matter — and what to do with them

How rate shop data integrates with the rest of morning reporting

The most useful thing you can do with rate shop data is get it in front of the decision-maker alongside the other morning figures — occupancy, pickup, forecast — rather than in a separate tool that requires a separate login.

A rate positioning column in the morning brief doesn't need to be comprehensive. It needs to answer one question: are there any dates in the next 14 days where the property's rate position needs attention? If the answer is no, the review takes 30 seconds. If the answer is yes, the column surfaces the specific dates.

The typical implementation looks like this: a daily export from the rate shop tool lands in a designated folder. The automation layer picks it up alongside the PMS daily close, calculates the gap between your BAR and the comp set median for each date in the next 14–21 days, flags dates where that gap exceeds a threshold (usually ±15% or ±$25, depending on the property), and includes a rate position column in the morning brief. Leadership sees one view that includes both the demand picture and the competitive rate picture without toggling between systems.

The manual version vs. the automated version

The manual version of this process is manageable at one property. Someone opens the rate shop dashboard, scans the next two weeks, makes a note of anything unusual, and incorporates their read into the morning brief or rate call. It takes 10–15 minutes if the person is disciplined. It takes longer if they get drawn into the tool's analysis features.

At multiple properties, the manual version doesn't scale. You can't have five revenue managers each doing 10 minutes of rate shop review and then synthesizing that into a portfolio view. The portfolio-level rate picture — which properties are well-positioned, which have anomalies, which need immediate attention — gets assembled inconsistently or not at all.

The automated version uses the same data. It just removes the human coordination step between the rate shop export and the consolidated morning view. The rate intelligence is still there; the manual assembly work is gone.

Choosing a rate shop tool — a practical note

If you're evaluating rate intelligence tools, the two questions that matter most for reporting automation are: does it produce a scheduled export, and is the export format documented and stable? A tool that requires a login and manual report generation every morning is much harder to integrate than one that drops a CSV to an email or shared folder on a schedule.

Lighthouse (formerly OTA Insight) and RateGain both support scheduled exports. Most RMS platforms that include a rate shop module — IDeaS, Duetto — also generate exportable data. If you're evaluating a tool that doesn't support scheduled exports or API access, that's a real friction point for a team trying to automate reporting. It's worth asking the vendor directly before you sign.