SurveyMonkey

SurveyMonkey for Salesforce: Measuring Net Promoter® Score

Get the integration! SurveyMonkey for Salesforce is an Enterprise add-on. Contact Sales or your Customer Success Manager (CSM). Limitation: The integration setup is only available in English.

If you use our Salesforce integration, you can create Net Promoter® Score (NPS) surveys and map the survey responses directly into Salesforce. You can use Salesforce reporting to calculate NPS and create dashboards to display key customer feedback.

This is just one way to set up NPS tracking in Salesforce – your NPS program should be customized to fit your organization’s needs.

SurveyMonkey can’t consult on coding issues in your Salesforce environment. Reach out to your Salesforce administrator for help implementing these features. These examples help you get started with our Salesforce integration, and you may need to make changes for your organization.

This article walks you through the following steps to set up NPS reporting in Salesforce:

  1. Map NPS scores to Salesforce
  2. Build your report

In SurveyMonkey, open the Salesforce integration, then map your response data to the corresponding Salesforce fields. For example, you can map the survey name, NPS score, and any comments to your custom Salesforce fields.

Our managed package makes NPS reporting simple and efficient. The managed package maps the following items from the NPS question type:

  • Label: whether the score is Promoter, Passive, or Detractor.
  • Normalized score: a numerical score. -1 is Detractor, 0 is Passive, and 1 is Promoter.
  • Response: the actual number the respondent chose.

If you already have a response object for NPS scores, skip this step.

If you don’t use our managed package or have a response object, you can create a new custom object in Salesforce. In this case, we've named our object NPS Responses.

Your custom response object should contain the following fields:

  • Survey Name (Text)
  • Contact (Lookup relationship – Contact)
  • Account (Lookup Relationship - Account)
  • Net Promoter Score (Number)
  • Comments (Long Text)
  • NPS Grouping/Label (Text)
  • NPS Normalized (Number, Length 1, Decimal Places 0)

Build a Salesforce report for your NPS scores. These steps vary slightly if you use the managed package.

Here is an example NPS report where we will group responses by Account, and roll up the score to the Account:

  1. Create a new summary report:
    1. If you use the managed package, select the "SurveyMonkey Responses with Account" report type.
    2. If you're using custom objects, you can either create a new report type or use an existing one.
  2. Group responses by Account Name or another field.
  3. Add the following columns:
    • NPS Normalized
    • Response Name (optional)
    • Contact (optional)
    • Response (optional)
    • NPS Label (optional)
  4. Create a summary formula. Set the Output to Number, 0 decimal points.
    1. If you use the managed package, use this formula: (SurveyMonkeyApp__Response__c.SurveyMonkeyApp__NPS_Normalized__c:SUM/RowCount*100)
    2. If you're using custom objects and fields, replace SurveyMonkeyApp__Response__c.SurveyMonkeyApp__NPS_Normalized__c in the formula above with the object and field name that hold your NPS Normalized scores.
  5. Add the Summary formula as a column in your report
  6. Make sure to filter your report to only show responses that contain an NPS score/value.
  7. Save and run your report.

If you use the managed package, SurveyMonkey already maps the normalized NPS scores for you. If you don't map the normalized scores from SurveyMonkey, you can build a formula to calculate NPS scores in your Salesforce reports.

To calculate NPS scores in Salesforce:

  1. Create a new Salesforce summary report using your NPS report type. You can choose to summarize NPS by Survey Name, or filter the report to only show specific Surveys.
  2. Write a summary formula in your report to calculate your score. The formula below is an example of an NPS calculation formula. Make sure to update the formula with the correct object name and field names based on how it’s been set up in your environment.
    We recommend selecting Grand Total Only when applying the formula.
(NPS_Responses__c.Promoter__c:SUM/RowCount*100) - 
(NPS_Responses__c.Detractor__c:SUM/RowCount*100)