Downloading Data

To download response data from a survey, click the EXPORT button.

You will be directed to an export screen, which looks like this:

The options allow you to determine certain preprocessing steps to perform on the data before it is downloaded:

In a chatbot, respondents might answer a single question twice. This happens when the first answer they give is not valid for the question. For example, it might be a multiple-choice question but instead of using the buttons, they type out a response.

This option automatically removes all answers except the final answer for each question. It is necessary if you want the data in wide format (“pivot”).

This option is useful for removing anyone who took the survey multiple times, often test users or people who somehow found a way to cheat the system. This removes them entirely from the dataset. This is necessary to pivot to wide format, which creates a unique row per user / shortcode.

If you might want to keep their first or last go on a survey, you should leave this option unchecked and clean the data manually.

This option calculates some useful metadata for each user and adds it as columns. It is non-destructive.

This option is useful for removing test users. If there is a variable that is added to all real users (i.e. “creative” in the case of recruiting via Virtual Lab), you should add that variable here to remove other users.

This pivots the data from long to wide format, such that each row is a user/shortcode combination and the columns are variables.

Only useful when pivoting the data to wide format. This takes metadata from the user and adds it as a column. Very useful in conjunction with vlab for recruiting, for example:

1. For adding metadata like “creative” to know which ad the respondent came through.
2. Adding metadata associated with variables used for stratification. In that case, they take the name of the variable that you defined when setting up the study in vlab.