NPS Calculation on Mixpanel

Mixpanel can be used to calculate the Net Promoter Score, an important metric with numerous benefits. In today's blog post, we'll go over what exactly the NPS is, how it can be of great advantage, and the steps of creating an NPS calculator in Mixpanel. #mixpanel #netpromoterscore #nps

What is the Net Promoter Score?

Customer loyalty is important to businesses because it can help indicate how likely customers are to continue using a product or service. The NPS, or "recommendation score", is one way to measure customer loyalty. The Net Promoter Score (NPS) is a customer satisfaction metric that gives businesses insights about customer loyalty. The NPS method measures customers' willingness to recommend a business to others, giving businesses a clear understanding of where they stand with their customers.

Net Promoter Score (NPS) is a widely used customer satisfaction metric, but it does have some limitations:

  1. Simplicity: NPS is based on a single question, which may not provide a comprehensive understanding of customer satisfaction. Businesses may want to consider supplementing NPS with additional questions or surveys to gain a more in-depth understanding of customer feedback.
  2. Limited Demographic Information: NPS surveys typically only collect basic demographic information, such as age and gender. This can make it difficult to segment the data and understand how different demographic groups feel about the business.
  3. Skewed Results: NPS results can be skewed by a small number of very satisfied or very dissatisfied customers. This can make it difficult to get an accurate picture of overall customer satisfaction.
  4. Doesn’t measure loyalty: NPS only measures willingness to recommend the brand, it doesn’t provide any insight on how loyal the customers are.
  5. Doesn’t measure other aspects of customer satisfaction: NPS only measures one aspect of customer satisfaction, which is the willingness to recommend. It does not measure other aspects such as product quality, price, or service quality.
  6. Doesn’t measure the reasons behind the score: NPS only measures the score, it doesn’t provide any insight on the reasons behind the score, it could be due to different factors such as price, product, service, etc.

Despite these limitations, NPS can still provide valuable insights for businesses. It’s important to use NPS in conjunction with other metrics and surveys to gain a more complete understanding of customer satisfaction. Additionally, it’s important to keep in mind the limitations of NPS and to interpret the results accordingly.

What type of industries is NPS a relevant metric?

Net Promoter Score (NPS) is a widely used customer satisfaction metric that can be applied to a wide range of industries. Some of the most common industries that use NPS include:

  1. Retail: NPS can be used to measure the satisfaction of shoppers in physical stores and online.
  2. Banking and Financial Services: NPS can be used to measure the satisfaction of customers with their banks, credit card companies, and other financial institutions.
  3. Telecommunications: NPS can be used to measure the satisfaction of customers with their mobile phone providers, internet service providers, and cable companies.
  4. Hospitality and Tourism: NPS can be used to measure the satisfaction of hotel guests, restaurant customers, and tourists.
  5. Software and Technology: NPS can be used to measure the satisfaction of software users, and customers who use technology products and services.
  6. Healthcare: NPS can be used to measure the satisfaction of patients and their families with hospitals, clinics, and other healthcare providers.
  7. Services: NPS can be used to measure the satisfaction of customers with service providers such as consultants, contractors, and other professional services.

In general, any industry that has direct customer interactions and where customer satisfaction is important can benefit from using NPS as a metric. This metric can help businesses understand how satisfied their customers are and identify areas for improvement, which in turn can help them improve their profitability.

How can businesses improve their profitability by measuring and acting on NPS feedback?

Net Promoter Score (NPS) is a measure of customer loyalty and satisfaction that can be used to help businesses improve their profitability. To use NPS effectively, businesses should regularly measure their NPS by surveying customers and ask them to rate their likelihood of recommending the business to others on a scale of 0-10.Once businesses have collected NPS data, they can use it to identify areas of their operations that need improvement and to track progress over time. For example, if the NPS is low in a particular department or location, the business can take steps to address the issues that are causing dissatisfaction among customers.To act on NPS feedback, businesses can also use the data to segment their customer base and target specific groups with tailored marketing and service campaigns. Additionally, by tracking NPS over time, businesses can see which changes have the most impact on customer loyalty and satisfaction.Finally, businesses can also use NPS to motivate employees by linking their performance evaluations to the NPS scores in their department or location. By making NPS a key metric, businesses can create a culture of continuous improvement and customer focus.

Who is responsible for measuring NPS at companies?

In most companies, the responsibility for measuring NPS falls on the customer experience or customer service team. These teams are responsible for collecting NPS data by surveying customers and analyzing the results. They may also be responsible for creating and implementing action plans to improve NPS scores and for communicating the results to other departments and senior management.However, measuring NPS and acting on its feedback is not only the responsibility of customer service team, it should be a cross-functional effort. The success of NPS depends on a company-wide commitment to customer satisfaction and it should be incorporated into the overall business strategy.For example, departments such as product development, marketing, and sales should also be involved in using NPS data to inform their decisions, and they should be held accountable for their impact on customer satisfaction. Additionally, senior management should be aware of NPS scores and use them to set goals and track progress.

#mixpanel #netpromoterscore #nps

How to Calculate NPS on Mixpanel

Author: soumya bhatt

Source: Tango

1. Select NPS submitted event and breakdown by NPS

https://images.tango.us/workflows/130a14f7-a288-4ebe-99da-8ff5b758c79c/steps/3500ef90-9bdd-4cf4-b0c8-8a065f0606ff/c88ccf70-bc5b-4ef4-803c-a652c3d49198.png?fm=png&crop=focalpoint&fit=crop&fp-x=0.1142&fp-y=0.4722&fp-z=1.1964&w=1200&mark-w=0.2&mark-pad=0&mark64=aHR0cHM6Ly9pbWFnZXMudGFuZ28udXMvc3RhdGljL21hZGUtd2l0aC10YW5nby13YXRlcm1hcmsucG5n&ar=2880%3A1474

2. Click on the NPS and select custom property as shown

https://images.tango.us/workflows/130a14f7-a288-4ebe-99da-8ff5b758c79c/steps/3e0653d9-708c-4576-8475-3a0ea42bce4c/c3f9c396-ba30-470c-91d3-9f2bf38e3d9d.png?fm=png&crop=focalpoint&fit=crop&fp-x=0.5000&fp-y=0.5000&fp-z=1.0000&w=1200&mark-w=0.2&mark-pad=0&mark64=aHR0cHM6Ly9pbWFnZXMudGFuZ28udXMvc3RhdGljL21hZGUtd2l0aC10YW5nby13YXRlcm1hcmsucG5n&ar=2316%3A1214

3. Select event property to create a new custom event property

https://images.tango.us/workflows/130a14f7-a288-4ebe-99da-8ff5b758c79c/steps/42b51065-ad3c-40b4-88ef-5d60201b387e/eb0aee30-e066-426c-a4b6-b5bd5852a303.png?fm=png&crop=focalpoint&fit=crop&fp-x=0.5000&fp-y=0.5000&fp-z=1.0000&w=1200&mark-w=0.2&mark-pad=0&mark64=aHR0cHM6Ly9pbWFnZXMudGFuZ28udXMvc3RhdGljL21hZGUtd2l0aC10YW5nby13YXRlcm1hcmsucG5n&ar=2880%3A1474

4. Type "if" to include that function in the code

https://images.tango.us/workflows/130a14f7-a288-4ebe-99da-8ff5b758c79c/steps/e554a923-1270-4fb7-b049-3e7419cc64dd/c079b36c-806a-4966-9872-921c7425d54a.png?fm=png&crop=focalpoint&fit=crop&fp-x=0.5000&fp-y=0.5000&fp-z=1.0000&w=1200&mark-w=0.2&mark-pad=0&mark64=aHR0cHM6Ly9pbWFnZXMudGFuZ28udXMvc3RhdGljL21hZGUtd2l0aC10YW5nby13YXRlcm1hcmsucG5n&ar=2504%3A1329

5. Merge the values of NPS by using the formula shown and save the property as "NPS Calculated"

👍 Copied to Clipboard
    

IFS(npsScore <=6,-1, npsScore >=7 and npsScore<=8,0, npsScore >=9,1)

https://images.tango.us/workflows/130a14f7-a288-4ebe-99da-8ff5b758c79c/steps/16ea11a7-6812-421e-a949-2ef9379a7052/6f64cb48-464e-48ea-b94b-caadf491fb7c.png?fm=png&crop=focalpoint&fit=crop&fp-x=0.5000&fp-y=0.5000&fp-z=1.0000&w=1200&mark-w=0.2&mark-pad=0&mark64=aHR0cHM6Ly9pbWFnZXMudGFuZ28udXMvc3RhdGljL21hZGUtd2l0aC10YW5nby13YXRlcm1hcmsucG5n&ar=1954%3A1354

6. Select NPS submitted event and filter by new custom property as NPS Calculated equals 1

https://images.tango.us/workflows/130a14f7-a288-4ebe-99da-8ff5b758c79c/steps/1aaac8ed-688b-4ede-87ac-01d453533d56/18dacbc1-7e98-4c7c-84a0-4711db22ecbf.png?fm=png&crop=focalpoint&fit=crop&fp-x=0.5000&fp-y=0.5000&fp-z=1.0000&w=1200&mark-w=0.2&mark-pad=0&mark64=aHR0cHM6Ly9pbWFnZXMudGFuZ28udXMvc3RhdGljL21hZGUtd2l0aC10YW5nby13YXRlcm1hcmsucG5n&ar=2880%3A1474

7. Rename the event as Promoters

https://images.tango.us/workflows/130a14f7-a288-4ebe-99da-8ff5b758c79c/steps/583425ef-b3dc-4356-8e66-cac716665d4e/01fd1e0a-def4-45f1-9296-419a546df632.png?fm=png&crop=focalpoint&fit=crop&fp-x=0.5000&fp-y=0.5000&fp-z=1.0000&w=1200&mark-w=0.2&mark-pad=0&mark64=aHR0cHM6Ly9pbWFnZXMudGFuZ28udXMvc3RhdGljL21hZGUtd2l0aC10YW5nby13YXRlcm1hcmsucG5n&ar=2310%3A1202

8. Repeat the step with Detractors

https://images.tango.us/workflows/130a14f7-a288-4ebe-99da-8ff5b758c79c/steps/46c2a403-22ba-458b-a78e-0e67330d0779/785772d8-36d3-43eb-a7a1-5e2a62a100fc.png?fm=png&crop=focalpoint&fit=crop&fp-x=0.5000&fp-y=0.5000&fp-z=1.0000&w=1200&mark-w=0.2&mark-pad=0&mark64=aHR0cHM6Ly9pbWFnZXMudGFuZ28udXMvc3RhdGljL21hZGUtd2l0aC10YW5nby13YXRlcm1hcmsucG5n&ar=2316%3A1134

9. Click on the + sign to include a formula

https://images.tango.us/workflows/130a14f7-a288-4ebe-99da-8ff5b758c79c/steps/2d1a177d-b1fb-42fd-94cf-f179618f8787/3b17fdc7-e26e-4f87-9103-e47aecbdaea0.png?fm=png&crop=focalpoint&fit=crop&fp-x=0.5000&fp-y=0.5000&fp-z=1.0000&w=1200&mark-w=0.2&mark-pad=0&mark64=aHR0cHM6Ly9pbWFnZXMudGFuZ28udXMvc3RhdGljL21hZGUtd2l0aC10YW5nby13YXRlcm1hcmsucG5n&ar=2880%3A1474

10. Insert the NPS Formula as shown below and click on apply formula

(A+B)/C*100

https://images.tango.us/workflows/130a14f7-a288-4ebe-99da-8ff5b758c79c/steps/5d341168-63f6-421e-b67d-e8a5c8771657/bd63a294-98ff-4bbd-803b-65e0fde2db64.png?fm=png&crop=focalpoint&fit=crop&fp-x=0.5000&fp-y=0.5000&fp-z=1.0000&w=1200&mark-w=0.2&mark-pad=0&mark64=aHR0cHM6Ly9pbWFnZXMudGFuZ28udXMvc3RhdGljL21hZGUtd2l0aC10YW5nby13YXRlcm1hcmsucG5n&ar=2880%3A1474

11. The NPS will be calculated according to the formula. Save the report.

https://images.tango.us/workflows/130a14f7-a288-4ebe-99da-8ff5b758c79c/steps/7d1b6aa5-cdb8-4eab-b9ac-3ee5cd75ade1/7730fbfc-77db-4514-b7b5-6fc29db791f9.png?fm=png&crop=focalpoint&fit=crop&fp-x=0.5000&fp-y=0.5000&fp-z=1.0000&w=1200&mark-w=0.2&mark-pad=0&mark64=aHR0cHM6Ly9pbWFnZXMudGFuZ28udXMvc3RhdGljL21hZGUtd2l0aC10YW5nby13YXRlcm1hcmsucG5n&ar=2350%3A1232

Search

Subscribe

Keep in the Loop

Implore user action with this attractive form.

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.