How to Recode Net Promoter Score (NPS) Variable(s)

The Net Promoter Score is most people's go-to measure for evaluating companies, brands, and business units. However, the standard way of computing the NPS - subtracting the promoters from the detractors - is a bit of a pain. This article describes how to automatically recode the data so that you can compute the NPS by computing the average, and you get exactly the same answer as you do when recoding manually.

For example, the table below shows data for a particular campsite. If we add up the first 7 categories, so 0 through to 6, 18.13% of people in this data set are Detractors. Adding up categories 7 and 8 gives us 28.94% Passives and the remaining 52.94% are Promoters. So, in this data set, the NPS score is 34.81 which is OK.

This QScript looks for likelihood to recommend questions in your project and creates new variables that are recoded to display the NPS score. 

Requirements

• A raw data set that contains a Nominal or Ordinal variable (or variable set if using a -Multi structure) with NPS data. NPS data are questions that contain the words likely or likelihood in the question name, or whose value labels contain the string likely, and which are 11-point scales.
• The Value Attributes in Values for the variables must have the complete 10-point or 11-point scale (note, NPS scores strictly only apply to 11-point scales).

Method

1. Select the variable set(s) containing the likelihood to recommend data from the Data Sources tree. If multiple variable sets are selected, a new NPS variable will be created for each.
2. Hover and click Plus (+) > Ready-Made New Variable(s) > Recode Net Promoter Score (NPS) Variable(s).
3. A new numeric variable will appear in the Data Sources tree with the recoded values for the selected variable set(s).

Recoding is conducted based on numbers found in the category labels. Those categories whose labels contain numbers less than or equal to 6, Detractors, will be recoded with a value of -100, those categories whose labels contain a 7 or 8, Passives, will be recoded to a value of 0, and categories with labels 9 or 10, Promoters, will be recoded to a value of 100. Categories that look like standard Don't Know questionnaire options will be set as missing and will not be included in the calculation of the NPS.

Drag the variable set onto the page, so that it creates a summary table of the average for each variable in the variable set. This produces a table that shows the Average which is the NPS score.

Next

How to Recode Variables Using Category Midpoints

How to Recode Numeric Variable(s) from Code/Category Midpoints