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:

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:

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:

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

  1. Open the Hotels sheet and turn the data into a table (Ctrl+T) so filters and formulas follow the columns.
  2. Filter direct_vs_lowest_ota_pct to exclude blanks. The remaining rows are the hotels with a comparison.
  3. Share of hotels priced above the lowest OTA: =COUNTIF(Table1[direct_vs_lowest_ota_pct],">0")/COUNT(Table1[direct_vs_lowest_ota_pct]).
  4. 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.
  5. Break it down with a pivot table: rows country_name or hotel_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

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.

Get the data

Download the free Excel sample to see every column with real rows, or tell us the countries and fields you need for counts and a quote. We reply within 24 hours.

Download free sample Contact us