Can Mixpanel calculate my NPS score? I have: NPS Detractor = -1, NPS Passive = 0, NPS Promoter = +1. I have the absolute values of these occurrence, but I would like to calculate the NPS score as a metric.
Hi Janine, Please stand by as I search the Mixpanel knowledge base for an AI-powered answer. I normally take about 15 seconds or so. In case AI cannot answer your question, feel free to reach out to Mixpanel support at mixpanel.com/get-support. If you have follow-up questions for this thread, please tag me again with your question: @kapa.ai <follow-up question> đ
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
Yes, Mixpanel can help you calculate your NPS score using Formulas. Based on the knowledge sources, Mixpanel supports creating formulas with basic arithmetic operators that can be used to calculate metrics like NPS.
To calculate your NPS score, you would need to:
1. Track your NPS responses (detractors, passives, promoters) as events in Mixpanel 2. Use the Formula feature to create the NPS calculation
The standard NPS formula is: (% of Promoters - % of Detractors) Ã 100
In Mixpanel's Formula feature, you can: - Set up variables for your promoters, passives, and detractors - Create the calculation using the arithmetic operators supported by Mixpanel (addition, subtraction, multiplication, division) - Save this formula for reuse if you're on an Enterprise or Growth plan
As mentioned in the documentation:
Use Formulas to make calculations using simple arithmetic operators... Mixpanel supports the following operators: +, -, *, /, and () for order of operations. Insights: Visualize trends and compositions within your data
Additionally, Mixpanel integrates with tools like Sprig for collecting NPS data:
Leverage the Sprig and Mixpanel integration to understand how you can retain cohorts that are likely to churn... Build a cohort in Mixpanel defined by a metric representing low usage and a low Sprig NPS score. 4 ways Sprig and Mixpanel work together to give a full picture of your product users
This integration allows you to not only calculate your NPS score but also analyze it alongside other user behavior data to gain deeper insights.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
âšī¸Â Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.
Let me check the knowledge base for you again. One moment! đ
I can help you fix your NPS formula in Mixpanel. The error you're encountering with the "unexpected token: (" is likely due to syntax issues in how Mixpanel's Formula feature expects expressions to be formatted.
Based on the documentation, Mixpanel's Formula feature supports basic arithmetic operators, but the syntax needs to be simplified. Here's how you can correct your NPS formula:
Instead of:
((COUNT(A) / COUNT()) ** 100) - ((COUNT(C) / COUNT()) ** 100)
Try using:
(A / (A+B+C)) ** 100 - (C / (A+B+C)) ** 100
Or even simpler:
(A - C) / (A+B+C) * 100
Where: - A represents your Promoters - B represents your Passives (which I assume you have, even though not mentioned in your formula) - C represents your Detractors
In Mixpanel's Formula interface, each event in your query is assigned a letter variable (A, B, C, etc.), which you can use directly in your calculations without needing to use functions like COUNT().
As mentioned in the documentation:
Each event in the query shows a letter next to it, which indicates its variable name. Use these letters in combination with the operators to calculate a more advanced query. Insights: Visualize trends and compositions within your data
The formula should calculate the percentage of promoters minus the percentage of detractors, which gives you your NPS score.
Kapa AI
kapa.ai is still learning and improving, please let me know how I did by reacting below.
âšī¸Â Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.
Let me check the knowledge base for you again. One moment! đ
Based on your question about the NPS score calculation showing 4.06 instead of a value between 38-45, there seems to be a misunderstanding about the NPS formula implementation in Mixpanel.
The standard NPS calculation should result in a score between -100 to +100, not 1-100. If you're expecting a score between 38-45, but getting 4.06, there are a few possible issues:
1. Formula scaling issue: Your formula might be calculating percentages incorrectly. The NPS formula should be:
(% of Promoters - % of Detractors) ** 100
2. Decimal vs. percentage representation: Your result of 4.06 might actually be 4.06%, which would need to be multiplied by 100 to get the proper scale.
3. Data discrepancies: As mentioned in the Mixpanel documentation, there could be discrepancies in how data is being calculated:
"With discrepancies within the Mixpanel interface, it's important to look out for: Comparisons between unique user count vs. total event count" Debugging: Validate your data and troubleshoot your implementation
To fix this issue, try modifying your formula to ensure proper percentage calculation:
((A - C) / (A + B + C)) ** 100
This formula takes the difference between promoters and detractors, divides by the total responses, and multiplies by 100 to get the proper NPS scale.
If you're still seeing unexpected results, check if your data is being filtered unexpectedly or if there are any caching issues. Mixpanel does cache query results, and you might need to refresh your data:
"To refresh the query results cache, navigate to the report, click the three dots overflow menu at the top of the report, select Refresh Data." Query Result Caching
kapa.ai is still learning and improving, please let me know how I did by reacting below.
âšī¸Â Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.