Calculating Net Promoter Score from survey results to analyze customer satisfaction

Updated 

How calculating net promoter score is helpful for your brand to see how your customer service is perceived and where improvements might be made.

The Net Promoter Score is calculated based on responses to a single question.

Net Promoter Score or NPS = % Promoters - % Detractors

or

NPS = (Number of Promoters / Total Survey Results) - (Number of Detractors / Total Survey Results)

Where,

Number of Promoters = Number of people who chose 9 or 10

Number of Detractors = Number of people who chose 0 to 6

So, you have to create two custom metrics, i.e., % promoters and % detractors, which in turn are calculated from the number of promoters and the number of detractors.

Before you begin

Create an NPS Rating survey in Survey Builder.

To create Number of Promoters and Number of Detractors metrics

  1. Click the New Tab icon Screen Shot 2017-09-25 at 1.52.25 PM.png. Under the Sprinklr Service tab, click Care Reporting within Analyze.

  2. On the Reporting Home window, click the Options icon in the top-right corner and select Custom Metrics.

    If you are on a Reporting Dashboard, click the Options icon in the top-right corner and scroll down to Settings. Hover over Settings and select Custom Metrics.

  3. On the Custom Metrics window, click Add Custom Metric in the top right corner.

  4. On the Custom Metrics pop-up window, enter a Name and an optional Description for the custom metric.

  5. Select Social Analytics from the Data Source dropdown and Numeric from the Metric Type dropdown.

  6. Select Survey Response Count from the Metric dropdown.

  7. Next, under Filters, select the NPS Rating survey question that you have created in the Survey Builder from the Dimension dropdown, and its values as 9 and 10 for Number of Promoters.Creating Number of Promoters Custom Metric

    For Number of Detractors, select the NPS Rating survey question from the Dimension dropdown, and its values as 012345, and 6.Creating number of detractors custom metric

  8. Click Create.

To create % Promoters and % Detractors metrics

  1. Follow steps 1-5 mentioned above.

  2. For % Promoters, select Number of Promoters / Survey Response Count from the Metric dropdown.Creating %Promoters Custom Metric

    For % Detractors, select Number of Detractors / Survey Response Count from the Metric dropdown.Creating %Detractors Custom Metric

  3. Click Create.

To create NPS custom metric

  1. Follow the steps 1-5 mentioned above.

  2. Select % Promoters - % Detractors from the Metric dropdown.Creating NPS Custom Metric

  3. Click Create.
    You can now use the NPS custom metric to view reporting on NPS Rating surveys.