When you create a "Raw Response Data" export, the "customise" section has four sub-sections, as follows:
Options
These contain overall content settings, controlled via on/off toggles.
- Include respondent details: This is information such as ID, start and end date and time of response, IP address and name/email details from the contact list, if relevant.
- Include contact list custom columns: Any data added as Custom Column data can be included or excluded.
- Include Respondent Status: Adds a column to track respondent status to make it easier to determine whether non-partial respondents have been disqualified.
- Include Text Analysis Categories: If any Text Analysis categories have been created for questions on the survey these will be included in the export. They categories for each question response will be listed in a single column after the column for that question. Multiple categories will be seperated in the column by a comma.
Appearance
Sets how the exported data will appear in the export.
- Split date and time: Separates the Date and Time elements of the "Start" and "Finish" data into seperate columns to aid processing.
- Column headings in one row: Some question types (Such as matrix questions) will be reported with the question details across two rows. This option forces them onto a single row.
- Column heading style: Sets the contents of the column headings. Question contents, question numbers, and question IDs can be chosen.
- Answer choice style: Set whether the answer text, option number, or option scoring is used. Has no effect on free-text questions.
Using these options, it’s possible to export completely anonymised data sets for ensuring totally unbiased processing.
Filters
This lets you select from a few standardised filters for your export.
- Select custom filter: Choose whether to apply a filter (defined in the filtering tool) to the responses that are exported.
- Date range: Apply a smart date range filter, calculated from when the export is run. Ideal for daily, weekly, monthly, or other regular reports.
- Partial responses only: Export only responses that are incomplete.
- Response range: Export only responses between two defined responses, numbered based on order of response.
Misc
Other settings.
- Custom file name: Create a custom file name for the export
- Translation: (Only on multi-language Surveys) Choose a translation for the survey content to use in the export.
- Empty cell value: Change the contents of any empty cells, such as for unanswered questions.