Response reports

Response reports display respondent answers in a sheet format.

To create Response reports, go to Analyze > Reports > Response in the survey navigation menu.

Overview

Response reports work with both draft and publish versions of the survey. 

• Open-end fields display the respondent's input as written, while closed-end fields display the selected option IDs.
• Response reports can display either the option IDs or the option descriptions (text) for closed-end fields.
• The first column in a report remains locked by default. Right-click a column header to open display options for sorting and "freezing" columns. Frozen columns can be fixed to the left or right side of the report.
• Double-click a column to auto-fit its width. Right-click the column header to restore the original size.
• To copy all or a portion of a table, use your keyboard shortcuts (e.g., Ctrl+C for PC and ⌘+C for Macs).
• Response reports provide access to Individual response reports.
• All saved reports are accessible in Deliverables. They're available to survey Makers and users from the same organization. See User access for reports for more information.

Creating a Response report

To create a new report, use the Settings on the right side of the screen. Customize your report by selecting respondent statuses, applying filters, and choosing the relevant survey fields to focus on the specific data you need.

Fields

Click Select All to include all survey fields or click in the Fields box to select only the fields you need. The report displays the survey fields in the order they are selected, but they can be reordered at any time by dragging and dropping them within the box or click the to reorder them by dragging the handles.

Configurations

Use the Records dropdown to define which respondent statuses should be included in the report. Choose whether to display all data with the option ID (e.g., 1) or the option text (e.g., Yes).

Filters

Use the Filters dropdown to select previously created data cuts (found in the Pre-Built dropdown) or to build a new one. Date/Time and ID filters are also found here. For more information on creating data cuts, see Expression Builder.

Advanced

Use the Field Type dropdown to filter by question type (e.g., text or numeric) to limit the export to specific fields. Use the Display Draft Version toggle to pull data from either the most recent draft or published version of the survey. This toggle is only available when the latest version of the survey hasn't been published.

Showing option descriptions

Response reports can display either the option IDs or the option descriptions (text) for closed-end fields. Expand the Show dropdown menu to switch between these options. The selected option will also determine what is downloaded.

Option ID

Description

Editing a saved report

Editing a saved report is similar to creating a new one. If the saved report is not open, find it in Deliverables and double-click to open it. Make your necessary changes in Settings.

Once the changes have been applied, the Save button will become active and include a dropdown menu. You can either overwrite the previous report by selecting Save Changes or create a new report by selecting Save As New.

Report vs. export

Although Response reports and deliverable exports are similar, there are some notable differences.

Data display for checkbox questions:

• Response reports display the data for checkbox questions in a single column. If multiple options are checked, they appear as a comma-separated list.
• Exports display the data for checkbox questions in multiple columns, with each option having its own column. Columns contain '1' for selected options and '0' for unselected ones.

Questions tab:

• Exports have a second tab called "Questions" which maps question and option IDs to the values in the column headers
• Response reports do not include this tab.