Hotel Direct vs OTA Prices: How to Read the Data
When a hotel's own website shows a price, the data compares it with the lowest offer from an online travel agency for the same hotel. This guide explains what that comparison column means, what the free sample shows, and the caveats that keep the numbers honest.
Rates are indicative nightly offers captured for the search dates at the time of capture, not contracted rates.
The columns involved
Every month, offers are captured for each hotel from a fixed list of known booking sites. Four columns carry the comparison:
hotel_rates_by_site: the nightly offer on each booking site that listed the hotel;lowest_offer_latest: the lowest of those offers in the latest release;direct_offer_latest: the offer on the hotel's own (official) website, where one was shown;direct_vs_lowest_ota_pct: the difference between the direct offer and the lowest OTA offer, in percent.
As the column name says, the comparison is with online travel agencies, the sites listed in booking_otas_latest. The exact definition of each column is in the Column guide sheet of the sample and in the data dictionary.
How to read the value
direct_vs_lowest_ota_pct is signed:
- Positive: the hotel's own website was more expensive than the cheapest OTA. A value of +5 means the direct price was about 5% higher.
- Zero: the direct price matched the lowest OTA offer: rate parity.
- Negative: the direct price was lower than every OTA offer, which is what many hotels aim for when they push direct bookings.
- Empty: no direct offer was shown, so there is nothing to compare. Empty does not mean the hotel has no website; it means no bookable price was captured from it.
Read one value as a snapshot of one capture, not as the hotel's pricing policy. Patterns become meaningful when you look across many hotels, or across months for one hotel.
What the sample shows
Of the 250 hotels in the free sample, 209 have rates by site. They were offered on 105 distinct booking sites in all, with a median of 22 sites per hotel and a maximum of 42.
135 hotels had an official-site (direct) offer. Of those, 63% had a direct price above the lowest OTA offer, and the median gap was +5%. In other words, in this sample the cheapest place to book was more often an OTA than the hotel itself, and the typical difference was small.
This is a sample of 250 hotels chosen to show the columns, not a market study. Treat it as an illustration of what the full data lets you measure for your own countries, cities and segments.
Why a direct price can be higher
A positive gap is not automatically a parity breach. Common reasons include:
- Different products. The cheapest OTA offer may be a non-refundable rate or a smaller room, while the hotel's site shows a flexible rate first.
- Member or package prices. Some OTA offers are discounted for logged-in members or bundled with other travel.
- Taxes and fees. Sites differ in whether the headline price includes taxes and fees.
- Timing. Offers were captured for given search dates at a given moment; prices move during the day.
When the gap matters to you, look at the offers per site in hotel_rates_by_site rather than at the summary column alone.
Working with it in Excel
- Open the Hotels sheet and turn the data into a table (Ctrl+T) so filters and formulas follow the columns.
- Filter
direct_vs_lowest_ota_pctto exclude blanks. The remaining rows are the hotels with a comparison. - Share of hotels priced above the lowest OTA:
=COUNTIF(Table1[direct_vs_lowest_ota_pct],">0")/COUNT(Table1[direct_vs_lowest_ota_pct]). - Median gap:
=MEDIAN(Table1[direct_vs_lowest_ota_pct]). Use the median rather than the average, because a few large gaps can pull the average a long way. - Break it down with a pivot table: rows
country_nameorhotel_class, values the count and median of the gap.
Adding booking_sites_latest to the pivot shows whether hotels sold on many sites behave differently from those on a few. rate_history_by_month lets you check whether a hotel's gap is a one-month event or a habit.
Caveats
- Rates are indicative nightly offers captured for the search dates at the time of capture, not contracted rates.
- Offers come from a fixed list of known booking sites. An offer on a site outside that list is not seen.
- Booking links are not exported; the data records the site and its offer.
- The direct offer is only present when the hotel's own site showed a bookable price at capture time.
- Booking-site names are trademarks of their owners. Lodgingeo is not affiliated with the booking sites listed.
Where to go next
The prices by booking site page lists every price column and the booking sites seen in the sample. For revenue-management uses, see revenue management and rate intelligence.