NPS Score Calculation on Mixpanel

soumya bhatt

Created Nov 07, 2022

NPS Score Calculation on Mixpanel

39
    m

Mixpanel

10 Steps
1

Select NPS Score submitted event and breakdown by nps scores

Select NPS Score submitted event and breakdown by nps scores
2

Click on the nps score and select custom property as shown

Click on the nps score and select custom property as shown
3

Select event property to create a new custom event property

Select event property to create a new custom event property
4

Type "if" to include that function in the code

Type "if" to include that function in the code
5

Merge the values of nps score by using the formula shown and save the property as "NPS Calculated"

Merge the values of nps score by using the formula shown and save the property as "NPS Calculated"
6

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

Select NPS Score submitted event and filter by new custom property as NPS Calculated equals 1
7

Rename the event as Promoters

Rename the event as Promoters
8

Repeat the step with Detractors

Repeat the step with Detractors
9

Click on the + sign to include a formula

Click on the + sign to include a formula
10

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

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

Mixpanel

1 Step
11

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

The NPS Score will be calculated according to the formula. Save the report.
Well done!
Create how-to guides like this in a snap. Get Tango now.