This report consolidates Analytics Suite data for multiple properties into one Excel file. Below you will find a guide to interpreting the data in each column.
The following columns are included on every tab to facilitate sorting by regions/cities/campaigns:
|
Property Name |
Name of hotel, as it appears on Tripadvisor |
|
TA Property ID |
Tripadvisor Location ID. This is the number after the “d” in the hotel’s Tripadvisor URL |
|
Subscription ID |
Business Advantage Subscription ID. Some chains may have multiple subscription IDs – e.g. one per brand. This enables filtering at campaign level. |
|
City |
Geo of the hotel |
|
Country |
Country of the hotel |
|
Bubble Rating |
Hotel’s current overall bubble rating, as per the date the report is run. |
|
Total Reviews |
Total review count, all time. |
|
Special Offer Active? |
Does this hotel have an active special offer? Y/N |
|
Evergreen Offer Active? |
Does this hotel have an active Evergreen offer? Y/N |
|
Announcement Active? |
Does this hotel have an active Announcement? Y/N |
|
Hotel Favorite Review Active? |
Does this hotel have an active Favorite Review? Y/N |
|
Hotel Favorite Photos Active? |
Does this hotel have a active Favorite Photos? Y/N |
| Cover Photos Active? | Does this hotel have an active Cover Photos? Y/N |
| Storyboard Active? | Does this hotel have an active Storyboard? Y/N |
| Property Video Active? | Has this hotel uploaded Property Videos? Y/N |
| Sponsored Placement Campaign Active? | Does this hotel have an active Sponsored Placement campaign? Y/N |
Note: “Special offers” refer to those visible in the Analytics Suite itself. Evergreen offers do not appear anywhere in the Management Center/Analytics Suite, so an extra column has been added to distinguish between the two. Contact your Tripadvisor Sales Representative if you have questions about Evergreen offers.
The “previous period” data on this tab will be different depending on whether the report is a standard monthly subscription report based on the month just gone, or whether it’s a manually generated one-off report for a historical, multi-month period.
Let’s say for example this one was run on March 1st, 2017, for the month of February:
|
Ranking (current) |
Hotel’s ranking, as per March 1st, 2017. |
|
Out of (current) |
Number of properties in same Geo as the hotel, as per March 1st, 2017. |
|
Ranking (previous period start) |
Hotel’s ranking one month prior. In this case it will be taken as of January, 2017 (since the report overall is for February data). |
|
Out of (previous period start) |
Number of properties in same Geo as the hotel, one month prior. In this case it will be taken as of January, 2017. |
|
Ranking (previous period end) |
Since we are only looking at one month of data, the data in this column will be exactly the same as in the Ranking (previous period start) column. |
|
Out of (previous period end) |
Since we are only looking at one month of data, the data in this column will be exactly the same as in the Out of (previous period start) column. |
Let’s take another example of a one-off report for a historical period of July to August 2016 (this report was also run on March 1st, 2017):
|
Ranking (current) |
Hotel’s ranking, as per March 1st, 2017. |
|
Out of (current) |
Number of properties in same Geo as the hotel, as per March 1st, 2017. |
|
Ranking (previous period start) |
Hotel’s ranking at the beginning of the historical period (July 2016) |
|
Out of (previous period start) |
Number of properties in same Geo as the hotel at the beginning of the historical period (July 2016) |
|
Ranking (previous period end) |
Hotel’s ranking at the end of the historical period (August 2016) |
|
Out of (previous period end) |
Number of properties in same Geo as the hotel at the end of the historical period (August 2016) |
*Note: when historical rankings are shown, they are given as month-end values.
|
Reviews this period |
Total number of reviews published during the reporting period |
|
Average rating this period |
Average rating of reviews published during this period (Sum of rating divided by total number of reviews) |
|
Business Travelers |
Number of reviews written by Business Travelers this period |
|
Family Travelers |
Number of reviews written by Family Travelers this period |
|
Couples Travelers |
Number of reviews written by Couples Travelers this period |
|
Solo Travelers |
Number of reviews written by Solo Travelers this period |
|
Friends Travelers |
Number of reviews written by Friends Travelers this period |
|
5-bubble reviews |
Number of 5-bubble reviews received this period |
|
4-bubble reviews |
Number of 4-bubble reviews received this period |
|
3-bubble reviews |
Number of 3-bubble reviews received this period |
|
2-bubble reviews |
Number of 2-bubble reviews received this period |
|
1-bubble reviews |
Number of 1-bubble reviews received this period |
|
Average rating: Rooms |
Average rating for subcategory “Rooms” this period |
|
Average rating: Sleep Quality |
Average rating for subcategory “Sleep Quality” this period |
|
Average rating: Service |
Average rating for subcategory “Service” this period |
|
Average rating: Location |
Average rating for subcategory “Location” this period |
|
Average rating: Cleanliness |
Average rating for subcategory “Cleanliness” this period |
|
Average rating: Value |
Average rating for subcategory “Value” this period |
|
Management response rate |
Percentage of reviews that have received a management response during this period |
|
Average response time (days) |
Length of time in days between a review being published and a management response being published |
|
5-bubble reviews responded % |
Percentage of 5-bubble reviews that have received a management response |
|
4-bubble reviews responded % |
Percentage of 4-bubble reviews that have received a management response |
|
3-bubble reviews responded % |
Percentage of 3-bubble reviews that have received a management response |
|
2-bubble reviews responded % |
Percentage of 2-bubble reviews that have received a management response |
|
1-bubble reviews responded % |
Percentage of 1-bubble reviews that have received a management response |
|
Unique visits total |
Total number of unique visits this period |
|
Unique visits mobile |
Number of unique visits on mobile this period (includes Tripadvisor app) |
|
Unique visits tablet |
Number of unique visits on tablet this period |
|
Unique visits desktop |
Number of unique visits on desktop this period |
|
Direct referral clicks total |
Total number of clicks on your hotel contact details this period |
|
Direct referral clicks mobile |
Number of clicks on your hotel contact details via mobile this period (includes Tripadvisor app) |
|
Direct referral clicks tablet |
Number of clicks on your hotel contact details via tablet this period |
|
Direct referral clicks desktop |
Number of clicks on your hotel contact details via desktop this period |
|
Direct referral clicks Hotel website |
Breakdown of traveler clicks by link type – % Hotel website |
|
Direct referral clicks Email to hotel |
Breakdown of traveler clicks by link type – % Email to hotel |
|
Direct referral clicks URL deals |
Breakdown of traveler clicks by link type – % URL deals |
|
Direct referral clicks Special offer |
Breakdown of traveler clicks by link type – % Special offer |
|
Direct referral clicks URL packages |
Breakdown of traveler clicks by link type – % URL packages |
|
Direct referral clicks Virtual tour |
Breakdown of traveler clicks by link type – % Virtual tour |
|
Direct referral clicks URL affiliate |
Breakdown of traveler clicks by link type – % URL affiliate |
|
Top Performing Special Offer |
Name of Special offer with the highest redemption rate (how often travelers click on the offer and then click “redeem” in the popup window) |
|
Special offer clicks |
Total clicks on Special offer this period |
|
Special offer redemption rate |
How often travelers click on the Special offer and then click “redeem” in the popup window. Note that sometimes travelers click more than once, so this can be more than 100%. |
|
Telephone Lead Management Active Y/N |
Does this property have Telephone Lead Management active – yes or no |
|
Phone calls |
Number of phone calls received via Telephone Lead Management system this period Note: If no calls received via TLM this period, this field will show “No Data” If TLM not activated for this hotel, this field will show “No Access” |
|
Phone call answer rate % |
% of calls via Telephone Lead Management system that were answered this period Note: If no calls received via TLM this period, this field will show “No Data” If TLM not activated for this hotel, this field will show “No Access” |
Note that due to rounding, some % values may show as zero if there have been very few clicks on this link type relative to the total number of clicks.
|
Photo engagement rate |
Percentage of travelers who have interacted with the photos on the hotel listing this period |
|
Average photo views per traveler |
Average number of photos viewed per traveler this period |
|
Traveler photo uploads |
Total number of photos uploaded by Travelers – all time |
|
Management photo uploads |
Total number of photos uploaded by Management – all time |
|
Date of last Management photo upload |
Date last photo uploaded by Management |
Note that only Preferred Access subscribers will see data on this tab.
Standard Access subscribers will see “No Data” appear in all fields.
|
Average booking lead time |
Average lead time in days (based on dated searches made during this period) |
|
Average length of stay |
Average length of stay in days (based on dated searches made during this period) |
|
Top international visitor city 1 |
Most popular international city from which travellers are viewing your property this period |
|
Top international visitor city 2 |
2nd most popular international city from which travellers are viewing your property this period |
|
Top international visitor city 3 |
3rd most popular international city from which travellers are viewing your property this period |
|
Top domestic visitor city 1 |
Most popular domestic city from which travellers are viewing your property this period |
|
Top domestic visitor city 2 |
2nd most popular domestic city from which travellers are viewing your property this period |
|
Top domestic visitor city 3 |
3rd most popular domestic city from which travellers are viewing your property this period |
|
Top visitor country 1 |
Most popular country from which travellers are viewing your property this period |
|
Top visitor country 2 |
2nd most popular country from which travellers are viewing your property this period |
|
Top visitor country 3 |
3rd most popular country from which travellers are viewing your property this period |