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