Using the possibilities offered by exporting results, we can save data from the survey completions on the hard disk of our computer. The export also allows us to analyze these data using our own, extensive tools.
It is also a way to access the results of the study aby time – even after the termination of the subscription.
SPSS:
SPSS is a statistical package that allows you to create a detailed regression analysis, analysis of variance or correlation in the set of collected data. It is an advanced computer program used for detailed analysis of the results of a given study.
Raw data:
Data collected in the survey are entered into a statistical package or other computer program in which they are cleaned, supplemented and static analyzed. These are all the answers received from each of the respondents to the questions contained in the entire questionnaire.
The most convenient way to view and analyze raw data is a spreadsheet. These include Microsoft Excel, Number or Open Office Calc.
In order to facilitate the analysis of the results collected in the form of raw data, we have prepared some additional information. The first one explains what columns are in the raw data. These are:
Basic information about the fill and respondent:
- ID
- Nr.
- start date
- end date
- total filling time
- actual filling time
- time to fill page X
- points earned (test only)
- maximum number of points to get (test only)
- percentage (test only)
- external ID (only if there are fills with external_key)
- token (only if the security level is the highest and the survey is not anonymous)
- date of generating the token (only if the security level is the highest and the survey is not anonymous)
- user token / e-mail (only when the security level is the highest and the survey is not anonymous) – the column depends on the way tokens are generated
- contact labels (fields – label)
- verification code (only if verification is enabled after completion).
- Questions with answers (and custom answers / your own answers).
- Weights, features and feedback (test only):
- list of features
- feedback
- the result of the weights of all questions.
- Information on completion (only if the survey has different settings than the highest security level and anonymous survey):
- IP address
- referer
- browser
- operating system
- filled – PC / mobile
You should also know about the data types in the columns:
- number (only integers),
- date – in the format Y-m-d,
- datetime – in the format Y-m-d H: i: s,
- string – text format – that is all data that has a format other than any above.
Aggregate results:
This is data obtained from all respondents, collected in one file. They represent the percentage distribution of responses in the surveyed sample.
How to export aggregate results?
- After the first respondents filled in your survey, click on the Results tab (1), and then click Aggregated Results (2) to export the all the data.
- When aggregate results are loaded, click Export (3), then select the recording format you are interested in and the type of data you need – aggregated results, raw data or raw data for SPSS (4). Approving the appropriate form field will start downloading the file.
How to export a specific respondent’s sheet?
- Go to the Results tab (1), and then click Individual sheets (2).
- Select the sheet that interests you by clicking Previous / Next (3), or by expanding the form field and selecting the appropriate sheet number (the numbers correspond to the order in which the questionnaire is completed).
- In the next step, click Export (4), and then select the recording format – XLSX, CSV or PDF (5). Approving the appropriate form field will start downloading the file.
Worth to remember:
- The results of the research can be downloaded in XLSX or CSV format as well as SPSS (for aggregate results), or XLSX, CSV and PDF (in the case of exporting the results of a single sheet).
- The export of survey results enables, for example, their subsequent analysis using complex statistical packages.