Data connector details

  • Category: Hospitality
  • Connector type: Standard

Description

Use the Google Hotel Review connector to retrieve and analyze hotel guest reviews on Google.

Data Limitations

This data connector supports all global Google hotel review web sites.

Google does not impose limitations on the amount of data that you can pull, but for hotels with a lot of reviews, you may want to limit it yourself using the Comment Limit option or 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, provide the URL of the hotel or hotels for which you want to analyze customer reviews.

  • Google Hotel URL (*required): On the Google Hotels 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 hotel URLs. Takes a TXT file with one URL per line.
    (CSV is also acceptable, but it must have one URL per line.)
  • Comment Limit: It is a good practice to set a limit on the number of comments returned.

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.

comment_rating

  • Description: Reviewer's rating for the hotel.
  • Category: KPI
  • Example: 5.0/5.0

comment_source

  • Description: External source of the comment, e.g. a travel web site.
  • Category: meta
  • Example: Google

context

  • Description: Free-form text of the review.
  • Category: text index
  • Example: Great hotel. Amazing location. Food is also great. But the staff is super friendly and helpful. Money exchange counter is right outside the hotel along with supermarket and a Pharmacy. Beach is just a mile away from the hotel. Room and washroom are 5/5 and I recommend it for everyone.

crawler_time_stamp

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

data_source

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

hotel_id

  • Description: Google ID of the hotel reviewed.
  • Category: meta
  • Example: ChkI9dqXtrj87ZEyGg0vZy8xMWc5cXR5NG05EAE

hotel_location

  • Description: Street address of the hotel reviewed.
  • Category: geo index
  • Example: 240/9 Phangmuang Sai Kor Road, Patong, Kathu Patong Beach 83150, Thailand

hotel_name

  • Description: Name of the hotel reviewed.
  • Category: meta
  • Example: The Marina Phuket Hotel

#ERROR!hotel_price

  • Description: Price of the hotel reviewed.
  • Category: meta
  • Example: 54

hotel_rating

  • Description: Average rating for the hotel from all reviewers.
  • Category: KPI
  • Example: 4.4

hotel_star_rating

  • Description: Official rating for the hotel, for example, 4-star hotel.
  • Category: KPI
  • Example: 4-star hotel

hotel_url

time_stamp

  • Description: Date and time of the review.
  • Category: date index
  • Example: 1577634264000

user_name

  • Description: Name of the reviewer.
  • Category: user index
  • Example: Nidhi Pokhriyal

Data

  • Description: Adds all output fields to a list visualization.

Did this answer your question?