Analyze Your Responses
Learning Objectives
After completing this unit, you’ll be able to:
- Create a report type for survey responses.
- Create a report for scored responses.
Analyze Survey Responses
Gabriela, the sales operations specialist, wants to view the responses for the Customer Satisfaction survey and share it with her management. She asks Maria, Ursa Major Solar’s Salesforce admin, to create a report.
Create a Report Type for Survey Results
Before running a survey response report, Maria needs to first create a report type. Maria decides to use Survey Question Scores as the primary object because this object stores responses for every question type apart from text question type. She can use this report type down the line for other surveys.
- Click
and select Setup.
- In the Quick Find box, enter
Report Types
. - Click Report Types.
- Click New Custom Report Type.
- For the Primary Object, select Survey Question Scores.
- Set the report type label. Maria enters
All Survey Question Responses
. - Set the report type name. Maria enters
All_Survey_Question_Responses
. - Enter a description. Maria enters
Use to review responses for all survey question types apart from text.
- Choose the Report Type Category. Gabriela chooses Other Reports.
- Click Next.
- Click Save.
Here’s what the report type looks like.

Create a Report for Survey Responses
Maria uses the All Survey Question Responses report type she just created to run a report that contains responses for the Help Us Serve You Better (Case Closed) survey. She also customizes the report by adding fields to help Gabriela better analyze the responses for scored questions.
- From the App Launcher, find and select Reports.
- Click New Report.
- From the Other Reports section, select All Survey Question Responses.
- Name the report. Maria enters:
Customer Satisfaction
. - Click the Outline tab.
- On the Columns field, remove the Name field and add the following fields:
- Survey Invitation : Name
- Question Name
- Question Score Type
- Survey Question Choice : Name
- Response Count
- Response Value
- Score
- Question Skipped Count
- Click the Filters tab.
- On the Filters field, add the Survey : Name filter and provide the following filter by conditions:
- Operator: Equals
- In the next field, enter the survey name. Maria enters
Customer Satisfaction
.
- Click Apply.
- Click Save & Run.
- Add a description for the report. Maria enters:
Responses to the Customer Satisfaction survey for Gabriela Livingston and her team
. - Click Select Folder.
- Select the folder where you want to save the report. Because Maria needs to share it with Gabriela and her management, she selects Public Reports.
- Click Save.
Understand Reports with Responses to Scored Question Types
Maria shows off the new report to Gabriela and explains it to her. Here’s how it looks.

Gabriela learns that reports based on the Survey Question Score object are either tracked at the version-level or at the invitation-level. Since the Customer Satisfaction survey has only one version, Maria has already filtered the responses by invitation. Maria explains to Gabriela what each column in the report means.
Gabriela learns something very unique about the report. Each column in the report must be interpreted differently based on the question type. The question types can be categorized as follows.
- Score: Net Promoter Score (NPS), rating, score, and slider
- Answer choice: Multiple choice, picklist, and radio
- Ranking
- Date
Maria conducts a quick knowledge transfer session for Gabriela and explains what the important columns mean for each question type. Maria is using a sample report containing responses from two participants for a survey containing all the question types, apart from text. This information will help Gabirela when she creates reports for other surveys.
Score
Here's an invitation-level report with questions of the types: NPS, rating, score, and slider.
Question Name | Question Type |
---|---|
How likely are you to recommend our service to a friend or colleague? | NPS |
How would you rate our service? | Rating |
How would you score our customer support agent's knowledge about your case? | Score |
What overall score would you give our customer support process? | Slider |

Field Name | Description |
---|---|
Question Score Type (1) |
|
Response Value (2) | I = Score one or more participants select for a question. |
Response Count (3) |
|
Score (4) |
For rating, score, and slider question types:
For NPS question type:
|
Answer Choice
Here's an invitation-level report with questions of the types: multiple choice, picklist, and radio.
Question Name | Question Type |
---|---|
Why did you raise the customer support case? | Multiple Choice |
How did our customer support agent contact you? | Picklist |
How many days did it take to resolve your case? | Radio |

Field Name | Description |
---|---|
Question Score Type (1) |
|
Survey Question Choice: Name (2) | I = Answer choice one or more participants select for a question. |
Response Count (3) |
|
Score (4) |
|
Ranking
This invitation-level report contains a ranking type question.
Question Name | Answer Choices |
---|---|
Rank what you liked about our customer support agent. |
|

Field Name | Description |
---|---|
Question Score Type (1) |
|
Survey Question Choice: Name (2) | I = Ranking item of a question. |
Response Value (3) | I = Rank that one or more participants select for a ranking item. |
Response Count (4) |
|
Score (5) |
|
Date
This invitation-level report contains a date type question.
Question Name | Question Type |
---|---|
When did our customer support agent first contact you? | Date |

Field Name | Description |
---|---|
Question Score Type (1) |
|
Date Response (2) | I = Date selected in a question |
Response Count (3) |
|
Score (4) |
|
Gabriela feels like she just received a perfect score now that some of her key concerns about tracking customer feedback have been resolved by Maria and Salesforce Surveys. She can now understand what non-English customers think about Ursa Major Solar’s support team. She doesn’t need to worry about manually generating invitations for each closed case. And finally, she is all set to impress her bosses further with the new report to track customer feedback.