creating a custom formula to compute NPS surveys in Gainsight
None
Hello- we use an outside source (CustomerGauge) to compute our NPS scores. We have successfully transferred these survey results into Gainsight but it seems to be averaging the NPS scores under the customer 360 view. Is there a way to compute the scores differently under the customer view? For example, we would like the score to be computed as - promoters MINUS detractors DIVIDED by number of survey results.
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 username or e-mail address. We'll send you an e-mail with instructions to reset your password.
1. Create 3 custom fields on the Customer Info object (# of Detractors, # of Promoters and # of Passives). You will populate those fields via the Rules Engine. Here's how the rule would be set up.
And the actions:
Once you have that, you could then make a formula field on the Customer Info object that calculates NPS. See below for what I did:
((of_Promoters__c /( of_Detractors__c + of_Passives__c + of_Promoters__c )) - (of_Detractors__c / (of_Detractors__c + of_Passives__c + of_Promoters__c)))*100
Let me know if this solves the use case you're looking to accomplish.
Hi,
You can now build reports on True NPS in Gainsight Reports and Dashboards. This field helps to calculate True NPS for various segments of responses. For more information, refer here.
Thank you!