Skip to main content
New Idea

True NPS calculation and NPS Widget

Related products:None
david_rogers
elizabeth
christopher_sanderson
monique_steele
+14
  • david_rogers
    david_rogers
  • hitesh_sharma
  • elizabeth
    elizabeth
  • christopher_sanderson
    christopher_sanderson
  • monique_steele
    monique_steele
  • russell_gray
    russell_gray
  • elaine_cleary
    elaine_cleary
  • alex_legay
    alex_legay
  • spencer_engel
    spencer_engel
  • dan_ahrens
    dan_ahrens
  • jeffrey_coleman
    jeffrey_coleman
  • elizabeth_siami
    elizabeth_siami
  • chelsea_ecd189
    chelsea_ecd189
  • jared_block
    jared_block
  • devin_stevens
    devin_stevens
  • shannon
    shannon
  • chuen_moschetti_1466d2
    chuen_moschetti_1466d2
  • nicole_mendonca_6a33dc
    nicole_mendonca_6a33dc
  • CurtisValentine
    CurtisValentine

Show first post

41 replies

praneet
  • Helper ⭐️⭐️⭐️
  • 203 replies
  • April 7, 2017
To have this capability we need to have reporting enhancement to support formula fields at column level.

andrea_weisz_171687
Can you customize the NPS meter widget? Your meter says 20 is green. We think 30+ is green?

tzundelgainsightcom
Forum|alt.badge.img
Praneet, I know that customers can now configure the Summary section of the C360 to show actual NPS, as opposed to the score average, if they so chose.

Does that configuration also allow for the actual NPS to be displayed in the Surveys section of the C360? Or would the "NPS" number in the Surveys section still be an average of the scores given to the NPS question in that survey, as shown below? 


ben
Forum|alt.badge.img
  • Helper ⭐️⭐️⭐️
  • 314 replies
  • September 12, 2017
Jeff this is great! I am trying to implement this and cannot seem to find the "NPS Response" object. I tried going to Administration >> Data Management but I am not seeing any objects listed there relating to surveys, NPS, or responses.

Can you point me in the right direction?

jeffrey_coleman
Forum|alt.badge.img
Ben -- looks to me like you're looking at the MDA objects. At least currently, the NPS Response object I was referencing is in Salesforce. I do know from a conversation a couple of weeks ago that surveys will likely shift to MDA in an upcoming release. Including this as a default feature would be great.

seth
Forum|alt.badge.img+7
  • Gainsight Employee ⭐️⭐️⭐️
  • 550 replies
  • November 21, 2017
I am adoring this idea. The one change I made is to use -100 and 100, so that the report shows the NPS score as an integer instead of a decimal.

FYI, for those who like a copy-paste situation, this is the formula I used for the custom field:
IF(JBCXM__NPSScore__c<=6,-100,IF(JBCXM__NPSScore__c>=9,100,0))

jeffrey_coleman
Forum|alt.badge.img
Nice tweak, Seth! I've just been dealing with the decimal point. This is much better! :-)

Since you're throwing around terms like "genius," I think should be sure to give credit to the team at SurveyMonkey who built our Salesforce integration. They're the ones who implemented this and that's where I first saw it.

seth
Forum|alt.badge.img+7
  • Gainsight Employee ⭐️⭐️⭐️
  • 550 replies
  • November 22, 2017
Mostly I'm beating myself up over not being able to creatively deploy basic algebra 

meenal_shukla
Forum|alt.badge.img+5
  • Gainsight Employee ⭐️⭐️
  • 208 replies
  • July 13, 2018
Hi, any plans of making the true NPS calculation available in reporting and analytics with Survey 2.0?

bill_davis
  • Contributor ⭐️⭐️⭐️
  • 22 replies
  • December 18, 2018
This thing has been getting kicked around like a dead cat on the side of the highway.

Was anyone able to make this work?

I am currently calculating overall NPS by spend tier outside of Gainsight in Power BI, but would prefer to calculate this in an Executive Dashboard.

Overall NPS = 67

NPS for Tech Touch = 43

NPS for Enterprise = 71


jake_ellis
Forum|alt.badge.img+4
  • Gainsight Employee ⭐️⭐️
  • 59 replies
  • March 7, 2019
@denise_stokowski @praneet I'm wondering if there has been any movement on calculating true NPS and not just the average or sum of NPS responses in Reports and Dashboards. I think it would be valuable to show NPS on Dashboards and allow for filtering based upon segment, cohort, etc.


dan_ahrens
Forum|alt.badge.img+2
  • Expert ⭐️⭐️⭐️
  • 1984 replies
  • March 7, 2019
@jake_ellis - we are currently developing formula fields for reporting which will allow for this kind of inline NPS calculation. It's a complex problem to solve for, but you'll be happy to know that it's in development as we speak.


seth
Forum|alt.badge.img+7
  • Gainsight Employee ⭐️⭐️⭐️
  • 550 replies
  • April 10, 2019
@jake_ellis If you expand all the comments on Scott Morris' comment above (beginning, "Totally understand the need to see the true NPS score on the 360."), you'll find a workaround that's available today! If you're skeptical, one of our Solution Architects ( @jessie_brainerd ) was a math major and couldn't wait to prove it out 🙂 See: https://cl.ly/c1758b0e6751


Hi All,

Thanks for you comments!

A column has been added in the to get the True NPS score.

Please follow the thread.

https://community.gainsight.com/conversations/true-nps-field-5cc0bc7fe4b03400e5c4f1eb


seth
Forum|alt.badge.img+7
  • Gainsight Employee ⭐️⭐️⭐️
  • 550 replies
  • June 11, 2019
Nice! Thank you, @piyushmadhukar !


sai_ram
Forum|alt.badge.img+1
  • Expert ⭐️⭐️
  • 3727 replies
  • June 18, 2019
@christopher_sanderson calculatiton of True NPS score is possbile now.

Admins can build a report on True NPS in Gainsight Reports and Dashboards which allows for dynamic filtering categorized by Participant, Company, Region, Product, Segment, CSM, etc. True NPS is a standard field in the application object NPS Survey Response. This field helps admins to calculate True NPS for various segments of responses.

This field stores the value :

100 for Promoters (Response values of 9 or 10)

0 for Passives (Response values of 7 or 8)

-100 for detractors (Response values of 0 to 6)

To find the True NPS of all the responses that you have filtered, you must apply an aggregation of average on this field.

Follow this article for more information


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings