TripAdvisor report

The TripAdvisor report is based on sub-metrics collected regularly from TripAdvisor, and are stored as part of the units themselves. Unlike other sub-metrics, these are not calculations based on the records on Medallia Experience Cloud.

Sub-metrics are collected daily, whereas rival data is collected every two weeks, and they are visible from the TripAdvisor website. See TripAdvisor for a description of each sub-metric.

Sub-metrics in TripAdvisor.

TripAdvisor Popularity Index

The TripAdvisor Popularity Index dashboard, also known as TripAdvisor Rank Percentile, is dedicated solely to TripAdvisor data, shown in both a table and graph visualization. This sub-metric helps you track changes in popularity over time.

Popularity Index table

This table compares a custom group of hotels in the city of Macao. Experience Cloud calculates the TripAdvisor Rank Percentile ( a_trip_advisor_popularity_rank_index) based on two TripAdvisor metrics:

Popularity Rank
Market Size

In the formula for the calculation below, Popularity Rank and Market Size metrics are represented by the popularity_rank and market_size variables: TripAdvisor Rank Percentile = 100 - 100 * ((popularity_rank - 1) / (market_size -1)) . The rank position of Oasis Hotel Macao at Catai Strip is 4 out of 93 (making it property 90 out of 93). Based on that ranking, its Popularity Rank Percentile is 96.7%.

The Popularity Rank Percentile is based the property's score and how it ranks compared to the other properties in the market.

The TripAdvisor Popularity Index table includes the following properties:

TripAdvisor Overall Rating: Overall traveler rating for a location on a scale of 1 (terrible) to 5 (excellent).
TripAdvisor Review Count: The number of TripAdvisor reviews posted for the location.
TripAdvisor Primary Rank Position: The property's overall ranking within its ranking category and destination. The rank position for a location is based on multiple factors, including the quality, quantity, and age of reviews. See What is TripAdvisor's Popularity Index? on the TripAdvisor website for more information.
TripAdvisor Primary Rank Size: Total number of locations in the same ranking category and destination.
Popularity Rank Percentile: Percentage of properties the locations is ranked higher than.
Formula: 100% - (TripAdvisor Primary Rank Position - 1) / (TripAdvisor Primary Rank Size - 1)

Additional examples:


Popularity Rank	Market Size	TripAdvisor Popularity Percentile
4	6	40%
1	76	100%
75	76	6.4%

Popularity Index graph

Whereas the table is useful for comparing multiple locations, the graph helps you easily compare the overall average TripAdvisor rating for a location to its popularity over time.

In this graph, the bars indicate the TripAdvisor for each month. The dots (which are connected by lines) show the popularity percentile for each month.

When you hover over a point on the graph, the graph displays these properties:

TripAdvisor Score: Average of all the TripAdvisor scores submitted before and during the given month. For example, suppose the TripAdvisor score is 4.5 for September. In that case, 4.5 is the average score from all the TripAdvisor reviews submitted before September and during September.
Popularity Percentile: Percentage of locations the property is ranked higher than during the given month.
Formula: 100% - (TripAdvisor Primary Rank Position - 1) / (TripAdvisor Primary Rank Size - 1)

Report options

For a list of the available fields you can use in reports, see Source fields.

Since the TripAdvisor data that is imported daily creates a new survey record each time, all reports that include TripAdvisor data must filter out the irrelevant records. Usually, that means showing only the most recent record from the time period.

When using a trending report that needs to reflect the timeperiod on the filter dropdown, choose any of these JavaScript functions to find the most recent record from all the available records:

Use this function to generate a report from the Survey data type: <js-calculation eval="cube.max('e_responsedate')"/> .
Use this function to generate a report from the Social media review data type: <js-calculation eval="cube.max('contentdate')"/>.

When using trending report with a fixed Timeperiod, use the the following Feedback fields to filter the most recent record depending on the timeperiod grouping:

q_smm_last_metric_of_month_for_property
q_smm_last_metric_of_quarter_for_property
q_smm_last_metric_of_year_for_property

Important: Rival data is collected every two weeks. Do not use time intervals in a report that are smaller than the collection interval, that is, two weeks. Reports do not infer that reviews are equally spread out throughout a time period. A fraction of a period is not assumed to proportionally hold metrics of the whole period.

When generating a report only on the most recent record within a Timeperiod, use the following field to filter the report. This field has a value of 1 for only the most recent record and 0 for all others: <split field="q_smm_last_metric_for_property" values="1" filter="true"/>

Restriction: This filter doesn't work for reports that deal with historical data, as in that case none of the available records will be the most recent one for the property and will all be filtered out.

You can use the TripAdvisor Rank Percentile to report on individual properties, or aggregate data across multiple properties.

This example displays a month-by-month rank percentile in a table. For each month, Experience Cloud averages the available rank percentiles for all selected properties.

This report shows the TripAdvisor score and TripAdvisor Rank Percentile for four months.