Accessing Responses via Dashboard

In this section we explain how you can review the responses submitted by each participant using the Researcher Dashboard. We will also describe the metadata stored with each survey response.

Total Response Report

You can use the Participation page to get a quick report on the number of surveys responded by each participant. To do so, navigate to the Participation page in the Researcher Dashboard. There you can see the list of all enrolled participants. The last column of this list, Survey Responses, shows the number of surveys each participant has responded, has canceled, or expired:

Accessing Survey Response Count via Participation
Page

For example, in the image above you can see the participant #31966 has responded to 282 survey sessions.

Viewing Responses

You can view participants' responses using the Responses page in the Researcher Dashboard. There you can choose one or more participant, and one or more survey:

Choose the Parameters to View Survey
Responses

Pressing Display will display these responses:

Viewing Survey
Responses

Note that if you choose more than one survey in the list, Ethica will not be able to display them on the screen. That's because the columns for each survey is different than the other ones. You only can download the responses for multiple surveys at once. Doing so will create a ZIP file that contains multiple CSV files, one for each of the surveys you have selected here.

In the Responses table, each column represents a question in the survey, each row shows a survey session completed by the participant, and each cell is for response to that particular question in that particular survey session. You can click on each cell to see more information about it.

For example, if you click on the column header, a dialog will open that shows the attributes for that question, as shown below:

View question
attributes

If you click on any cell below the Sessions column, i.e. the first cell of each row, a dialog appears that shows the details of that session, such as the survey version ID which this response belongs to, the time that this survey was scheduled and completed, or the device on which this survey was responded to:

View session
attributes

Similarly, if you click on each cell, you can see the attributes for the relevant response, such as the exact time that the response was provided, the location in which this response was provided (given that you have enabled Capture Location option for your survey), and the details of the media interaction:

View response
attributes

Survey Data Structure

When a survey is prompted to a given participant, Ethica opens a session which is associated to that survey and to that participant. When the session is concluded, either because of the participant completing the survey, or because of the survey becoming expired after a certain time, or for any other reason, the Ethica app collects all available responses, and uploads the session together with its responses to the Ethica servers. Each session has certain metadata which describes it. In turn, each response in a session also has certain metadata for itself. Below we describe these metadata in detail:

Session Metadata

The following describes the metadata stored with each session:

UUID:
A unique identifier of this session. Internally stored as uuid.

Participant ID:
The Ethica ID for the participant who this session belongs to. Internally stored as user_id.

Activity ID:
The ID of the survey activity which this session belongs to. The activity ID also indicates what questions and responses you should expect to find in this session. Internally stored as activity_id.

Device ID:
The ID of the device used by the participant to respond to this session. This is useful for cases where the participant is using more than one device to participate in the study. Internally stored as device_id.

Version ID:
The ID of the version of the survey. If you modify your survey while having active participants in the study, Ethica uses versions to track who responded to which version of your survey. Internally stored as version.

Scheduled Time:
The time when the survey was expected to be prompted to the participant. For surveys with Time-Triggered triggering logic, this time is known ahead of time. For surveys with other triggering logics, such as proximity triggered, this time is recorded when this session is initially created. Internally stored as scheduled_time.

Record Time:
The time when this session was concluded, either as completed, or expired, or any other status. Internally stored as record_time.

Status:
The status of the session. It can be one of the following values:

  • 1 - Completed: the survey was completed by the participant.
  • 2 - Canceled: the participant explicitly canceled responding to the survey.
  • 3 - Expired: the survey was not responded within the allocated time.
  • 4 - Blocked: the survey could not be triggered due to another active session for the same survey for this participant.

Internally stored as status_id.

Triggering Logic ID:
The ID of the survey's triggering logic which triggered this session. This is useful if you expect your survey to be triggered using multiple different triggering logics. It allows you to know which of your triggering logics led to triggering the current survey session.

Response Metadata

Each session includes a set of responses, one for each response provided by the participant. The list below covers the metadata stored with each response. Not all responses have all this information. You can read more about the structure of the responses, what each of these fields mean, and what is the expected hierarchy in the Survey Response schema.

Question ID:
The ID of the question that this response belongs to. Internally stored as q_id.

Question Type ID:
The ID of the type of the question that this response belongs to. It can be one of the following values:

  • 0 - Single Answer
  • 1 - Information
  • 2 - Multiple Answer
  • 3 - Text
  • 4 - Number
  • 5 - Image
  • 6 - Audio
  • 7 - Video
  • 8 - Visual Analog Scale
  • 9 - Mass
  • 10 - Length
  • 11 - Audio & Text
  • 12 - Barcode
  • 13 - Calendar

Internally stored as q_type_id.

Question Content:
The content of the question that was asked from the participant. This can be different for different sessions if the question uses dynamic content. In this case, the content of the question can dynamically change every time it's being asked from the participant. Internally stored as q_content.

Answer ID:
The ID of the answer that was selected by the participant. This is only available for single choice and multiple choice questions. Internally stored as answer_id.

Answer Content:
The content of the answer provided by the participant. This can be either a number (for number, mass, and length question), or a date (for calendar questions), or a text (for text and barcode questions). Internally stored as answer_content.

Answer URL:
The URL of the media uploaded by the participant as their response to this question. The URL can point to an image, audio, or video file, depending on the type of the question. Internally stored as answer_url.

Response Time:
The time the participant provided this response. It should be between sessions scheduled time and record time. Internally stored as response_time.

Loop Count:
The number of iterations the participant responded to this question. This is used if the question is part of a page which is located in a loop and therefore presented to the participant multiple times within the same session. Internally stored as loop_count.

Iteration:
The iteration number of which this response was provided. Should be more than 0 and less than the loop count. Similar to the loop count, it's used for the questions which are located in a loop page. Internally stored as iteration.

Location:
The latitude, longitude, speed, and accuracy value for the GPS coordinates of the participant, while responding to this question. This is only captured if the survey is set to geo-tag the responses. It also requires the participant to grant the Ethica app with necessary permissions to access GPS. Internally stored as location.

Media Interactions:
If the question content contains any video, this attribute presents how many times that video was watched, and what part of the video was watched. Internally stored as media_interactions.

Preferred Unit:
The unit selected by the participant while responding to this question. For mass questions it can be KG or Lbs, and for Length questions it can be cm or ft & in. It's not defined for other question types. Internally stored as preferred_unit.