What is NPS®?
Net Promoter Score, or NPS, is a popular way of quantifying how users feel about a given product or service. They are asked to fill out a survey question in the following format:
How likely is it that you would recommend [product/service/etc.] to a friend or colleague?
They are asked to provide a rating from 0 (Not at all likely) to 10 (Extremely likely). Ratings are then categorized into Promoters (9-10), Detractors (0-6) and Passives (7-8). These are used to calculate the final score, using the formula:
Scores range from -100 to 100, and are typically shown as rounded whole numbers.
Introducing the NPS Pack
While it’s fairly straightforward to calculate the NPS in native Coda Formula Language, if you aren’t doing it regularly it can take some time to remember the categories and equations. The NPS Pack solves that for you.
To find the Pack, simply type /NPS into your Coda doc and click to install.
This Pack adds a new NPS() formula you can use to calculate the Net Promoter Score for a set of survey results. Simply pass in the column containing the ratings and it will do the math for you.
It also includes a Category() formula that you can use to display the category for a given score.
Net Promoter®, NPS®, NPS Prism®, and the NPS-related emoticons are registered trademarks of Bain & Company, Inc., Satmetrix Systems, Inc., and Fred Reichheld. Net Promoter Score℠ and Net Promoter System℠ are service marks of Bain & Company, Inc., Satmetrix Systems, Inc., and Fred Reichheld.