Data connector details

  • Category: Hospitality
  • Connector type: Cached

Description

Use the TripAdvisor Hotel Review connector to retrieve and analyze hotel reviews.

Data limitations

This data connector works with any global TripAdvisor web site.

TripAdvisor.com 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 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, you can filter your results by date.

  • Hotel Name: Type the name of the hotel you want to analyze, and then select it when it appears in the list of suggestions.
  • Comment Limit: Specify a limit on the number of reviews to return. You can also control this with data range and recurrence settings.
  • Data Source: Enter a name for the data stream.

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. 

cache_id

  • Description: Returns a unique identifier for the record from Stratifyd's cache.
  • Category: meta
  • Example: 71687484dcce03af066e518cb49e731e

comment_content

  • Description: Returns the free-form text of the review.
  • Category: primary text index
  • Example: Antony the owner of Seaside Studio and houses is a truly gentleman and an amazing host . When I booked the studio he sent me the most detailed info how to get to his property. Then when we arrived he spent time to show us in the map the best beaches , restaurants, places to go in Mykonos . The second day we hai back at the studio and we found a beautiful basket full of fresh fruits and a bottle of wine . A gift from Mr. Antony . We booked a studio and it was a gem : very clean , with a kitchenette , with an amazing terrace overlooking Kalo Livadi beach . ( just few step and you at the beach ). The location is beautiful and very quiet , however Mykonos town is only 15 minutes away by car . We had an amazing stay ! Thank you Antony for your kindness ! You an amazing host !

comment_helpful_votes

  • Description: Returns the number of people who found this review helpful.
  • Category: meta
  • Example: 0

comment_lang

  • Description: Returns the two-letter language code for the review language.
  • Category: meta
  • Example: en

comment_machine_translatable

  • Description: Returns a value indicating whether the review is machine translatable.
  • Category: meta
  • Example: FALSE

comment_rating

  • Description: Returns the rating value left by the reviewer.
  • Category: KPI
  • Example: 5

comment_time

  • Description: Returns the date and time when the review was written in numeric format.
  • Category: primary date index
  • Example: 1563810341000

comment_title

  • Description: Returns the title of the review.
  • Category: text index
  • Example: Amazing Stay

comment_travel_date

  • Description: Returns the date and time when the reviewer visited the hotel.
  • Category: date index
  • Example: 43647

comment_url

contributions_attraction_reviews

  • Description: Returns the number of attractions the reviewer has reviewed.
  • Category: meta
  • Example: 13

contributions_badges_count

  • Description: Returns the number of badges the reviewer has received.
  • Category: meta
  • Example: 5

contributions_comment_city_count

  • Description: Returns the number of cities in which the reviewer has provided contributions.
  • Category: meta
  • Example: 21

contributions_comments

  • Description: Returns the number of comments on the reviewers contributions.
  • Category: meta
  • Example: 40

contributions_helpful_votes

  • Description: Returns the number of people who found the reviewers contributions helpful.
  • Category: meta
  • Example: 0

contributions_hotel_comments

  • Description: Returns the number of hotels the reviewer has reviewed.
  • Category: meta
  • Example: 13

contributions_restaurant_comments

  • Description: Returns the number of restaurants the reviewer has reviewed.
  • Category: meta
  • Example: 14

crawler_time_stamp

  • Description: Returns the date and time on which the review was crawled.
  • Category: meta
  • Example: 1570907707694

hotel_addr

  • Description: Returns the address of the hotel.
  • Category: geo index
  • Example: Kalo Livadi Beach, Kalo Livadi 864 00 Greece

hotel_category

  • Description: Returns the category of the hotel, e.g. Hotel, B&B.
  • Category: meta
  • Example: Hotel

hotel_email

hotel_id

  • Description: Returns the identification number of the hotel in TripAdvisor.
  • Category: meta
  • Example: 2153526

hotel_is_closed

  • Description: Returns a value indicating whether the hotel is closed.
  • Category: meta
  • Example: FALSE

hotel_latitude

  • Description: Returns the latitude of the hotel.
  • Category: geo index
  • Example: 37.434624

hotel_location_id

  • Description: Returns the identification number of the location of the hotel.
  • Category: meta
  • Example: 2153526

hotel_location_string

  • Description: Returns the location of the hotel (city and state).
  • Category: geo index
  • Example: Kalo Livadi, Mykonos, Cyclades, South Aegean

hotel_location_subtype

  • Description: Returns the subtype of the hotel location.
  • Category: meta

hotel_longitude

  • Description: Returns the longitude of the hotel.
  • Category: geo index
  • Example: 25.40848

hotel_name

  • Description: Returns the name of the hotel.
  • Category: meta
  • Example: Seaside Studios & Houses

#ERROR!hotel_ranking

  • Description: Returns the TripAdvisor ranking of the hotel, e.g. #35 of 64 hotels in Columbus.
  • Category: KPI
  • Example: #1 of 4 Speciality lodging in Kalo

Livadihotel_rating

  • Description: Returns the average rating of the hotel.
  • Category: KPI
  • Example: 4.5

hotel_url

hotel_website

response_connection

  • Description: Returns the job title of the person responding to the review.
  • Category: meta
  • Example: Owner

response_id

  • Description: Returns the identification number of the response to the review.
  • Category: meta
  • Example: 692011668

response_lang

  • Description: Returns the two-letter language code of the response language.
  • Category: meta
  • Example: en

response_published_date

  • Description: Returns the time and date of the response in numeric format.
  • Category: date index
  • Example: 1563871609000

response_responder

  • Description: Returns the name of the person responding to the review.
  • Category: user index
  • Example: SEASIDEMykonos

response_text

  • Description: Returns the free-form text of the response.
  • Category: text index
  • Example: I would like to thank you once again for your decision to stay at Sea Side Studios & Houses. I hope had a nice time at Mykonos. I wish you to have nice summertime and enjoying the rest of your vacations like in Mykonos. We will be more than happy to see you again in any future visit to Mykonos. Thank you very much once again for all. With kind regards, Bonis Antonis

response_title

  • Description: Returns the title of the response.
  • Category: text index
  • Example: Owner Response

save_time_stamp

  • Description: Returns the date and time when the review was saved in numeric format.
  • Category: date index
  • Example: 1570940699000

user_created_time

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

user_id

  • Description: Returns the unique identifier for the reviewer in TripAdvisor.
  • Category: user index
  • Example: 691683C8454C00641CD3955486758BCE

user_locale

  • Description: Returns the two-letter language and two-letter country code for the reviewer, e.g. en_US.
  • Category: meta
  • Example: en_UK

user_location_id

  • Description: Returns the identification number of the reviewer's location.
  • Category: meta
  • Example: 0

user_location_name

  • Description: Returns the name of the reviewer's location.
  • Category: geo index
  • Example: Miami, Florida

user_member_id

  • Description: Returns the member identification number of the reviewer.
  • Category: meta
  • Example: 0

user_name

  • Description: Returns the name of the reviewer.
  • Category: user index
  • Example: Raffaellaglemann

user_points

  • Description: Returns the number of points earned by the reviewer.
  • Category: meta
  • Example: 0

user_reviewer_type

  • Description: Returns the type of reviewer.
  • Category: meta
  • Example: Senior Contributor

Data

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

Did this answer your question?