Data connector details

  • Category: Hospitality
  • Connector type: Cached

Description

Use the Expedia connector to retrieve and analyze hotel reviews.

Data limitations

This data connector works with hotel reviews in all of Expedia's global web sites.

Expedia does not impose limitations on the amount of data that you can pull, but for very large hotels you may want to limit it yourself by narrowing the date range.

If you have issues with no data, try widening your date range on the second page of the wizard.

Input fields

When setting up the connector, you can filter your results by date.

  • Hotel URL*: On the Expedia web site, navigate to the hotel and from the address bar, copy the URL, then paste it into this field.
  • Add new search: To analyze multiple locations of the hotel or multiple hotels, click this as many times as needed to add more URLs.
  • Upload: Click to upload a file containing a list of product URLs. Takes a TXT file with one URL per line.
    (CSV is also acceptable, but it must have one URL per line.)

*required fields

You can change your date range on the second page of the wizard, or optionally Schedule data crawls to update your data stream periodically.

Data dictionary

This connector returns the following fields that you can use in analysis

crawler_time_stamp

  • Description: Date and time on which the review was crawled.
  • Category: meta
  • Example: 1578346374383

DataSource

  • Description: Data source of the review.
  • Category: meta
  • Example: expedia

Date

  • Description: Date and time when the review was written in numeric format.
  • Category: date index
  • Example: 1547480542000

HotelAddress

  • Description: The address of the hotel.
  • Category: meta
  • Example: 19 Phangnga Road, Tambon Talad Yai, Phuket, Phuket

HotelConditionRating

  • Description: The rating value for the hotel condition on a scale of one to five.
  • Category: KPI
  • Example: 4

HotelID

  • Description: The identification number of the hotel in Expedia.
  • Category: meta
  • Example: 5947522

HotelName

  • Description: The name of the hotel.
  • Category: meta
  • Example: The Memory at On On Hotel

HotelRating

  • Description: The overall average rating of the hotel on a scale of one to five.
  • Category: KPI
  • Example: 4

Location

  • Description: The language and locale of the review.
  • Category: meta
  • Example: en_US

NegReview

  • Description: The free-form text of Cons about the hotel, if provided.
  • Category: text index

PosReview

  • Description: The free-form text of Pros about the hotel, if provided.
  • Category: text index

Rating

  • Description: The rating value left by the reviewer on a scale of one to five.
  • Category: primary KPI
  • Example: 4

Review

  • Description: The free-form text of the review.
  • Category: primary text index
  • Example: This hotel is so pretty! Easily one of the prettiest in Phuket Town. The staff was also very attentive and helpful with making day-trips and excursions. The only drawback was at night while sleeping you can hear a lot of car traffic. It echoes due to the courtyard. I wouldn't be able to sleep an entire week there since I"m a light sleeper, but it was perfect for the one night I was there!

ReviewTitle

  • Description: The title of the review, if provided.
  • Category: text index

RoomCleanlinessRating

  • Description: The rating value for the cleanliness of the room on a scale of one to five.
  • Category: KPI
  • Example: 4

RoomComfortRating

  • Description: The rating value for the comfort of the room on a scale of one to five.
  • Category: KPI
  • Example: 4

ServiceRating

  • Description: The rating value for hotel services on a scale of one to five.
  • Category: KPI
  • Example: 4

UserName

  • Description: The name of the reviewer.
  • Category: user index
  • Example: Lauren

Data

  • Description: Returns all of the data collected by the connector.

Did this answer your question?