Export Survey Responses

We've just seen in the previous chapter all the statistical analysis tools that the GA Sciences online insights platfom offers. Pimprenelle, our fictional user with her survey about the habits of the neighborhood's pets, already achieved a lot thanks to those. Let say that for some reason she now wants to export the raw responses of her survey. On GA Sciences it is totally possible and, of course, totally free. In the current chapter, again with the example of Pimprenelle's survey, we will see how to proceed and we will detail the format.

Download the Responses

For each of your surveys you can generate in a coupe of clicks a csv file that contains all the responses that were given to the corresponding survey. To do so, once logged in, you just have to click on the My Surveys item in your personnal menu, accessible either under the dropdown item in the navigation bar on the top of any GA Sciences webpage or directly from the left side menu in your Dashboard.

My surveys item in Pimprenelle's personnal menu
My Surveys button in Pimprenelle's personnal menu on the upper right corner of GA Sciences webpages.

On the "My Surveys" page you will see a table listing all your GA Sciences surveys, as in Pimprenelle's example below.

Pimprenelle My surveys table
Pimprenelle's My Surveys table.

In the "Export" column you will see a pictogram for each row. Click on the one that corresponds to the row of the survey you want to export and... that's it! The raw responses file has been generated and the download starts.

Data Format

Before we close this documentation, let's talk a little bit about how data is formated in the this raw export.

First of all, the file format is csv, which stands for "coma-separated values". It is a very basic serialization format that simply serialization format that can be easily read with any spreadsheet software. To learn more about this format, you can simply visit Wikipedia.

As far as encoding is concerned, the file is encoded in Unicode UTF-8.

Now let's tackle the way the file is structured. It is really easy: you can consider this file as a table, each row corresponds to one respondent. There are as many rows as the total number of respondents to your survey. They are sorted in reverse chronological order, that is that the last respondent appears first.

The first columns of the table are devoted to metadata, that is data that provides information about other data than the answers the respondent provided to the survey questions. In order you will find the date and time at which the respondent answered the survey, then the location (country and/or city) of the respondent (if available), the respondent's IP address (if available) and the type of terminal he used to answer the surey (e.g. Desktop, Mobile, Tablet) (if available). If the data is not available, the corresponding box in the table will simply remain empty.

The next columns corresponds to the questions asked in the survey: one column per question in the survey, with one exception that we'll see later.

Depending on the question type, the nature of content of the table boxes for a given row (i.e. respondent) and a given column (i.e. survey question) will vary.

The General Case

In the General case, the box will simply contain the answer provided for the respondent. That is the case of question of type Single Choice. For example, for the first question of Pimprenelle survey "To what species do you belong?" the content of the boxes of the column corresponding to this question will be simply either "Dog", "Cat" or "Other".The general case applies to most of the question types, that is:

Particular Cases

Multiple Choice Questions

Unlike Single Choice questions, Multiple Choice questions may receive more than one answer. In that case you probably wonder "do we need more than one box to store those multiple answers then?"... And the answer is: no we don't! Actually one box is enough, simply each provided answer in that box is separated with a coma ",". For instance in Pimprenelle's sample survey there is a multiple Choice question where she asks "What type of food do you usually eat?". The possible answers are "dry food", "Leftover food", "Mice" and "Bones". Let say I am a pet and I answer this question by "Dry food" and "Leftover food", then the box corresponding to my answer will be filled with "Dry food,Leftover food".

Ranking Questions

I am pretty sure that you already guessed how is structured a table box for a Ranking question. Indeed it will be exactly like the Multiple Choice case except that order matters for Ranking questions: the first item will have been choosen as the number one item by the respondent and so on an so forth.

Contact Questions

As you have seen in the Survey Design chapter, a question of type Contact is actually a set of sub-questions. In Pimprenelle's survey example she asks the respondent his name and email address. So instead of one single column every Contact question will be represented with as many columns as the number of sub-questions it contains. In the example of Pimprenelle's survey there will be two columns for the Contact question she asked: one containing the name of the respondent, one containing his email address.

And with this particular case ends this documentation. I hope that you found all the answers to your questions thanks to Pimprenelle's survey. If something is missing, do not hesitate to contact me.