In this article, you will get to know clear details about the Data view tab, which can be found under the projects section of the data garden.
The main purpose of the data view tab which is found in the widget under the projects is to provide you with an overview of all data that has been generated under a certain project.
When you open up the data view tab of the project for which you want to view the data, you will see the page as shown below.
The dataview includes the first 20 records that are connected to your project in any random order. By clicking on the arrow-like buttons next to the definitions (column headers) you will be able to sort and filter the information. By scrolling down, the next 20 records will be loaded, and so forth.
You are able to perfrom actions on the records that are displayed by selecting them and choosing the appropriate action from the dropdown menu in the top right corner.
Change status lets you put a status to new, active and completed
Add to blacklists tags the selected record to the column “sys_blacklist”. Based on this you will be able to sets rules on blacklisting records using the dynamic rule engine.
Export to Excel lets you run an export over the selected records. You will receive the excel file in the downloads folder of your computer.
The information you can find in the dataview can be divided into 3 types of definitions:
- Questionnaire data:
This contains all answers given by the respondent to your questions. The way this is displayed in your data view depends on the question type. For instance, the data of a single response question with 5 answer options will generate results as numbers 1-5. The data of a media question will generate a code, that matches the name of a file that gets generated in your media library. An open question will display a textual answer in the dataview, and a matrix question will consist of multiple columns, one for the result of each question. - Manually created definitions
These columns contain the data and labelled data that have been predefined in the data garden using imports or by using a rule that has this column automatically filled when meeting specific conditions using labelled data. - System data
These columns are predefined and the same for each project. Whether they will be filled depends on the type of project and setup you are using. These definitions represent the foundation of your dataset. A brief explanation of the system definitions follows below:
SYS_RESPONDENTID | A unique identifier code representing each respondent |
SYS_PROJECTID | The code representing the project the data belongs to |
SYS_SCHEDULERID | The number representing the scheduler the data belongs to |
SYS_GROUPNAME | The number representing the group the data belongs to |
SYS_GROUPHIERARCHY | Is the group the data belongs to a parent or a child? |
SYS_STARTED | The moment the respondent started the questionnaire |
SYS_UPDATED | The last moment the respondent edited the questionnaire |
SYS_SCHEDULERQUOTAID | The number representing the quota the data belongs to |
SYS_SCHEDULERSTARTDATE | The startdate of the scheduler this data belongs to |
SYS_SCHEDULERENDDATE | The enddate of the scheduler this data belongs to |
SYS_RESPONDENTSTATUS | The status of the questionnaire (new/active/complete) |
SYS_IMPORTINFO | Information on the import source/row, mapping etc. |
SYS_COMPLETEDDATE | The date and time the questionnaire changed status to completed |
SYS_SESSIONINFO | The moment the respondent started and ended answering the query |
SYS_VERSION | The questionnaire version number to which the respondent answered |
SYS_VERSION STATE | Was the data generated by using a test link or a live link? |
SYS_IMPORT BATCH | The number representing which import batch was used for the record |
SYS_ISBLACKLISTED | A label, created in order to set a blacklisting rule to the record |
SYS_CREATEDON | The time and date the record got created. |
SYS_EMAILSTATUS | Shows the date and time an invitation e-mail was sent |