Location Insights helps in evaluating the experience of the customers based on a number score, i.e Experience Score. The experience score is calculated based on insight being derived from the consumer feedback. The following score is allocated to each customer sentiment:
Positive = 100

Neutral = 50
Negative = 0

Formula for creating experience score:-

(100 * "Positive Location Insights Count" + 50 * "Neutral Location Insights Count" + 0 * "Negative Location Insights Count") / ("Positive Location Insights Count" + "Neutral Location Insights Count" + "Negative Location Insights Count")
When you select Crosstab Widget, table etc, or widget containing custom metrics, and select Experience Score as a metric then the following color indications are displayed along with the score to provide visually paired insight score. The color-code is divided into 5 different sections. 

How to plot Color Coded Experience Score?

1. Click the New Tab, select Listening Dashboards under Sprinklr Insights Cloud.

   

2. Select Create Dashboard in the top right corner of the page

   

3. Under Add New Dashboard, inside the option Create New Dashboard, Click on Continue in the bottom right of the page

   

4. Add a Name for the Dashboard and click on Continue in the bottom right corner

   

5. Click Add Widget in the top right corner

   

6. In the Create widget window, select type and enter a name. Then in Visualization, select Crosstab, table etc. Select the values and Experience Score. Set the appropriate filters.

   

7. User will be able to see the Experience Score displayed with the different colors codes.

   

Customising Experience Score Color Code

1. Click the New Tab . Under Sprinklr Insights, click on Listening Settings under Listen Section

   

2. On the Listening Settings window, search in the search bar Custom Metrics under All settings.

   

3. Click on Add Custom Metric in the top right corner of the page

   

4. In the Create Custom Metric window, 

   1. Enter the name and description. 

   2. Then in Data Source, select Listening and Metric Type as Numeric. 

   3. In Metric Formula, type the following formula used for experience score calculation -
      (100 * "Positive Location Insights Count" + 50 * "Neutral Location Insights Count" + 0 * "Negative Location Insights Count") / ("Positive Location Insights Count" + "Neutral Location Insights Count" + "Negative Location Insights Count")

      

5. In the color coding section, enter the color scheme as per requirement.  

   1. Enter the metric start and end values and pick a suitable color from the color palette. Make sure to account for decimal values (for example - keep the end value for the first range as 27.999 instead of 27).

   2. Select a suitable color from the color palette.

   3. Select Average as the aggregation type in the drop-down menu.

   4. Repeat the same for all the score ranges

      

6. Click the Save metric button in the bottom right. The new Experience Score metric will now be available with custom color coding while creating widgets for reporting dashboards.