There are tons of topics based on calculation of NPS score and the challenges in various parts of Gainsight, but I haven't come across an answer for this specific question (feel free to drop link if I missed it!)...
We're looking to run a transactional NPSx on our support scores over a period of x months. Ideally we'd like to create a rule that sets a support score off of these metrics, however I cannot find a way to calculate true NPS.
1) Has there been a solution implemented to help this issue that I'm missing?
2) Are there any best practice workarounds for transactional NPSx scores? i.e. if sum of detractors > promoters = red?
Solved
Create rules based on TRUE NPS score within set time period (transactional)
Best answer by jitin_mehndiratta
Hi Jake,
Below is another way you can fetch the true NPS score (%Promoters - % Detractors) over a period of time using Bionic Rules.
Step 1: Create a Data set task to fetch Account and NPS Scores for a period of time.
Step 2: Pivot on NPS Score, Show: Account, Group By Account as shown in the screenshot below.
Step 3: Add a Transformation task, use formula field to add expression and calculate true NPS Score.
Output is as below:
View originalBelow is another way you can fetch the true NPS score (%Promoters - % Detractors) over a period of time using Bionic Rules.
Step 1: Create a Data set task to fetch Account and NPS Scores for a period of time.
Step 2: Pivot on NPS Score, Show: Account, Group By Account as shown in the screenshot below.
Step 3: Add a Transformation task, use formula field to add expression and calculate true NPS Score.
Output is as below:
+2Hi Jake,
You could do this using rules and MDA. Here's how:
1 - Create a custom MDA object with fields for Account ID, Account Name, Promoters, Detractors, Passives & NPS Score
2 - Promoters, Detractors and Passives would be populated via rules that count the number of responses in the previous x months of each type
3 - NPS score field would be a formula field in MDA that performs the NPS calculation. Here is a sample (Pro=promoters, Det=detractors, Pas=passives):
( ( Pro__gc / (Det__gc+Pas__gc+Pro__gc) ) - ( Det__gc / (Det__gc+Pro__gc+Pas__gc) ) )* 100
This would give you a row of data for each of your customers with the calculated NPS for the time period in question and you could then use that MDA table for reporting or other purposes.
Hope this helps!
You could do this using rules and MDA. Here's how:
1 - Create a custom MDA object with fields for Account ID, Account Name, Promoters, Detractors, Passives & NPS Score
2 - Promoters, Detractors and Passives would be populated via rules that count the number of responses in the previous x months of each type
3 - NPS score field would be a formula field in MDA that performs the NPS calculation. Here is a sample (Pro=promoters, Det=detractors, Pas=passives):
( ( Pro__gc / (Det__gc+Pas__gc+Pro__gc) ) - ( Det__gc / (Det__gc+Pro__gc+Pas__gc) ) )* 100
This would give you a row of data for each of your customers with the calculated NPS for the time period in question and you could then use that MDA table for reporting or other purposes.
Hope this helps!
VP of Customer Success at Forcepoint
1 person likes this
Hi Jake,
Below is another way you can fetch the true NPS score (%Promoters - % Detractors) over a period of time using Bionic Rules.
Step 1: Create a Data set task to fetch Account and NPS Scores for a period of time.
Step 2: Pivot on NPS Score, Show: Account, Group By Account as shown in the screenshot below.
Step 3: Add a Transformation task, use formula field to add expression and calculate true NPS Score.
Output is as below:
Below is another way you can fetch the true NPS score (%Promoters - % Detractors) over a period of time using Bionic Rules.
Step 1: Create a Data set task to fetch Account and NPS Scores for a period of time.
Step 2: Pivot on NPS Score, Show: Account, Group By Account as shown in the screenshot below.
Step 3: Add a Transformation task, use formula field to add expression and calculate true NPS Score.
Output is as below:
+5We also wrote this up as a formal tutorial.
Lila Krutel, Dir. Global Education Services
1 person likes this
Reply
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.