Gallery
Share
Explore

icon picker
Get started with the Net Promoter Score® Pack for Coda

Quickly calculate an NPS value for a range of responses.
Eric Koleda
⁠
Loading
coda.io
⁠
⁠

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.
⁠
Net promoter score
Net promoter score (NPS) is a market research metric that is based on a single survey question asking respondents to rate the likelihood that they would recommend a company, product, or a service to a friend or colleague.[1] The NPS is a proprietary instrument developed by Fred Reichheld, who owns the registered NPS trademark in conjunction with Bain & Company and Satmetrix.[2] Its popularity and broad use have been attributed to its simplicity and transparent methodology.[3]
en.wikipedia.org
⁠
⁠

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.
Net Promoter Score:
30
⁠
⁠

Formula used:
⁠
image.png
⁠
⁠
It also includes a Category() formula that you can use to display the category for a given score.
Survey Results
1
2
3
4
5
6
7
8
9
10
Name
Score
Category
Alexia Hood
9
Promoter
Umer Irwin
10
Promoter
Jevon Hicks
8
Passive
Everett Charles
8
Passive
Olivia-Rose Pugh
3
Detractor
Aamir Hills
9
Promoter
Angus West
7
Passive
Alessandra Lawson
6
Detractor
Muskaan Barnett
9
Promoter
Layla Tait
10
Promoter
There are no rows in this table
⁠
Formula used:
⁠
image.png
⁠
⁠

⁠
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.
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.