The Response pivot table report provides you a detailed table of all responses to an activity or group of activities. Pivot tables may not be the most glamorous reports, but they give you the most data. Of all the report types, the response pivot table is the most granular. It is particularly useful for exporting into a file usable by Excel (or your favorite spreadsheet app). From there you can use the data for grouping, crosstabs, computing sums and averages, etc.
Helpful tip: If any of the activities in your run allow anonymous responses then you will not be able to create a Response pivot table 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.
Below the name and date lies the response pivot table itself. Each row lists the following data for a single response:
- Received at (EST): The date and time the response was received
- First name: If the participant is registered with your account you’ll see their first name.
- Last name: If the participant is registered with your account you’ll see their last name.
- Email: If the participant is registered with your account you’ll see their email address.
- Custom report ID: If your organization uses this feature, you’ll see the participant’s custom report ID.
- Screen name
- Participant 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.
- Response method: Shows the method used to respond to the activity (web, text, etc.).
- Poll title: The title of the activity or question asked.
- Correct: If you elected to mark an answer as correct (e.g. on a multiple choice activity), this field will display if the response given was correct.
- Approved: This field is used by the moderation feature. If the moderation feature is active it will display if the response was approved.
- Poll type: Which type of activity was responded to (e.g. multiple choice, clickable image, etc.)
- Poll owner: Which presenter account owns the activity.
- Poll owner ID: The user ID number which corresponds to the presenter which owns the activity.
- Poll group/survey name: The name of the group or survey the activity belongs to.
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. This is where the usefulness of the Pivot response table really shines.
The CSV file is laid out the same, with the same data in the same order, as you see on the web.
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. Visit the article on report options for more details.