UPCOMING WEBINAR: From Chat to Agents: The New Phase of AI in Market Research This article outlines how to export from Alchemer (formerly SurveyGizmo) as an SPSS file, and how this is read in Displayr.
Method
When exporting from Alchemer, it is important to export an SPSS data file. Alchemer users must be on a Full Access License level to create, download, and leverage SPSS exports.
- Login to your Alchemer (formerly SurveyGizmo) account and select your project.
- Click Report > Data Analysis > SPSS Export. (You must have at least one report.)
- Click Settings, ensure Enable shown, unanswered questions to be distinguished from unshown questions is checked.
- Also ensure that Automatically increment labeled values numerically for questions with non-numeric reporting values is checked, and then click Save.
Note: It is generally better not to change any of the other settings under Settings, as this information will be used to set up your data.
Wait until the export completes. Then click Download Export and save the file. The SPSS (.sav) data file is in the downloaded zip file.
Alchemer (formerly SurveyGizmo) question types mapping in Displayr
The below table clarifies how the various Alchemer (formerly SurveyGizmo) question types are set up by Displayr upon data file import. See the Alchemer (formerly SurveyGizmo) documentation on how to import questions that repeat or use piping.
| Alchemer (formerly SurveyGizmo) Question type | How it appears in Displayr | Notes |
| Checkbox Grid | Binary - Grid | |
| Checkboxes | Binary - Multi | |
| Contact Form | Text | |
| Continuous Sum | Numeric - Multi | |
| Custom Table | As above | Depends on which grid types are included. |
| Date | Date | |
| Drag-and-drop ranking | Nominal - Multi | |
| Dropdown menu | Nominal | |
| Dropdown Menu Grid | Nominal - Multi | |
| Dropdown Menu List | Nominal - Multi | |
| Text | ||
| Essay | Text | |
| Grouping (Closed Card Sort) | Nominal - Multi | |
| Grouping (Open Card Sort) | Text | |
| Image | Nominal | |
| MaxDiff | Text | Returns the results of the experiment and is not appropriate for use in Displayr's Experiment variable set type. Change Structure in Displayr to Numeric. |
| NPS | Nominal | |
| Number | Numeric | |
| Open | Text | |
| Other (specify) | Text | |
| Percent | Numeric | |
| Quick Sort | Nominal - Multi | |
| Radio Button Grid | Nominal - Multi | |
| Radio Buttons | Nominal | |
| Ranking Grid | Nominal - Multi | |
| Rating (Likert Scale) | Nominal | |
| Semantic Differential | Nominal - Multi | See notes below |
| Signature | Text | |
| Slider | Numeric | |
| Slider List | Text | Change Structure in Displayr to Numeric. |
| Star Rating Grid | Numeric - Grid | |
| Textbox Grid | Text | |
| Textbox List | Text |
Semantic Differential Questions
A Semantic Differential question in Alchemer appears as a Nominal - Multi variable set in Displayr where the meaning of the scale is shown in the row labels rather than the columns. To split these up, do the following:
- Highlight the variables for the Semantic Differential question in the Data Sources tree.
- Right-click and select Split.
- For each of the variables, note the text in the Label column (which describes the scale), then click Properties
> Data > Values & Labels and modify the entries in the Label column appropriately for the scale.
- Update the Variable Set Label text to reflect the scale.