The Responses by participant report gives you a handy snapshot of all the responses to your activities. Though designed for Surveys, it can be used for all activity types.
Helpful tip: If any of the questions in your survey allow anonymous responses then you will not be able to create a Responses by participant report. The Executive summary report is the only report type which works with anonymous activities.
Title and date
At the top of the report you’ll find the report title. Directly below the title is the date the report was run. The links to the right of the title and date allow you to edit the title and update the report anytime you wish.
Directly below the title and date are the engagement summary stats. They show you the total number of participants, number of activities in the report, average number of responses, and average participant engagement in the activities reported.
Below the engagement summary is a list of the questions asked in your survey.
Following the survey question list are the response details. This section provides the name of the participant, when they started the survey, and their answers to each question.
Download a CSV
Near the bottom right of the report is a Download .CSV button (check out the Downloading a report CSV article if you need detailed instructions.
CSV stands for Comma Separated Value. A CSV file is a text file which stores tabular data in plain text. If you open a CSV file in a text editor (e.g. NotePad, WordPad, TextEdit, etc.) you’ll see a string of values (words, numbers, etc.) separated by commas, like this:
CSV files can also be opened up and edited in a spreadsheet application such as Excel. You can then format, run calculations, and create charts as with any other spreadsheet.
It might be helpful to take a look at the layout and formatting of the Survey report CSV file at this point.
- Column A provides the order in which the response was received.
- Column B tells you when the survey was started.
- If you have registration data for your participants, Columns C, D, E, and F will list the participant’s first name, last name, email address, and any custom reporting ID data you may have.
- Column G shows you the screen name the participant used to complete the survey.
- Column H lists the public ID. This is a temporary device ID which serves to identify a device within a session and doesn’t correspond to any participant or user ID.
- Columns I and following list the survey questions and responses.
To the right of the report body is the options menu. From here you can change report types and select several specific options for your report.