When a participant completes a survey, it generates a Survey Result. Each survey result contains multiple step results (corresponding to each step of the survey), and each step result can contain multiple child results (answers to questions, results produced by active tasks, etc.). In some cases (e.g., instruction steps, or if a step was skipped)—a step result may not have any child results.
In the CSV export, multiple data files are produced for survey results for each of these concepts, with keys that can be used for cross referencing. In the JSON export, all of the results are contained in a single data structure.
Contents
The survey results export includes high-level information about the survey result.
Field | Description |
---|---|
SurveyResultKey |
A unique, auto-generated key for this result. Can be used to cross reference with Step Results, Question Results, and Consent Signature Results. |
SurveyKey |
A unique, auto-generated key for the survey which will not change if the survey name changes. |
SurveyName |
The name of the survey this result was for. |
SurveyVersion |
Identifies which version of the survey was active at the time the data was collected. This allows you to adapt data processing if your survey changes. |
ParticipantIdentifier |
The identifier of the participant this task was for. Can be used to cross reference with Study Participants. |
SurveyTaskKey |
The key for the task used to deliver this survey. Can be used to cross reference with Survey Tasks. Will be empty for “Consent” survey results - results captured during the consent process do not have a survey task. |
Type |
One of “Survey” or “Consent.” |
StartDate |
The timestamp for when the participant began taking the survey, in ISO 8601 format. Includes timezone offset information. |
EndDate |
The timestamp for when the participant finished taking the survey, in ISO 8601 format. Includes timezone offset information. |
DevicePlatform |
The platform the survey was completed on, e.g. “iOS”, “Android.” |
DeviceName |
The name of the device used to complete the survey, e.g. “iPhone 8,2.” |
DeviceOSVersion |
The operating system version running on the device used to complete the version, e.g. “11.2.5.” |
InsertedDate |
The creation date of the result, in ISO 8601 format. Is always in UTC. |
The survey step results export contains information about each step the participant completed in a particular survey, including introduction steps and other step types that might not have any actual answers.
Field | Description |
---|---|
SurveyStepResultKey |
A unique, auto-generated key for this result. Can be used to cross reference with Question Results or Consent Signature Results. |
SurveyResultKey |
The key for the survey result which this step result is contained in. Can be used to cross reference with Survey Results. |
ParticipantIdentifier |
The identifier of the participant this task was for. Can be used to cross reference with Study Participants. |
StepIdentifier |
The identifier of this step, determined when the survey was created. |
StartDate |
The timestamp for when the participant arrived at this step, in ISO 8601 format. Includes timezone offset information. |
EndDate |
The timestamp for when the participant finished this step, in ISO 8601 format. Includes timezone offset information. |
The survey question results export contains the results produced by Question Steps and Form Steps.
Field | Description |
---|---|
SurveyQuestionResultKey |
A unique, auto-generated key for this question result. |
SurveyStepResultKey |
The key for the step result which this result is contained in. Can be used to cross reference with Step Results. |
SurveyResultKey |
The key for the survey result which this result is contained in. Can be used to cross reference with Survey Results. |
ParticipantIdentifier |
The identifier of the participant this task was for. Can be used to cross reference with Study Participants. |
ResultIdentifier |
The identifier of the result, determined when the survey was created. For Question Steps, this will be the same as the StepIdentifier . For Form Steps, this will be the name of the Form Item. |
Answer(s) |
The answer(s) the participant provided for the question. |
StartDate |
The timestamp for when the participant started answering the question, in ISO 8601 format. Includes timezone offset information. |
EndDate |
The timestamp for when the participant finished answering the question, in ISO 8601 format. Includes timezone offset information. |
The survey consent signature results export contains the results of Consent Review Steps.
Field | Description |
---|---|
SurveyConsentSignatureResultKey |
A unique, auto-generated key for this consent signature result. |
SurveyStepResultKey |
The key for the step result which this result is contained in. Can be used to cross reference with Step Results. |
SurveyResultKey |
The key for the survey result which this result is contained in. Can be used to cross reference with Survey Results. |
ParticipantIdentifier |
The identifier of the participant this task was for. Can be used to cross reference with Study Participants. |
ResultIdentifier |
The identifier of the result, determined when the survey was created. For Question Steps, this will be the same as the StepIdentifier . For Form Steps, this will be the name of the Form Item. |
Consented |
Whether the participant hit “agree” (true) or “disagree” (false). |
SignatureIdentifier |
The identifier of the signature from the Consent Document. |
SignatureTitle |
The title of the signature from the Consent Document. |
SignatureGivenName |
The given name entered by the participant. |
SignatureFamilyName |
The family name entered by the participant. |
SignatureDate |
The date of the signature, in DD/MM/YYYY format. |
StartDate |
The timestamp for when the participant started answering the question, in ISO 8601 format. Includes timezone offset information. |
EndDate |
The timestamp for when the participant finished answering the question, in ISO 8601 format. Includes timezone offset information. |
Survey Results
SurveyResultKey,SurveyKey,SurveyName,SurveyVersion,ParticipantIdentifier,SurveyTaskKey,Type,StartDate,EndDate,DevicePlatform,DeviceName,DeviceOSVersion,InsertedDate 73b25dbd-e9d9-e711-815b-b9576bf93116,dcbede15-67c9-e711-815a-a2abfc96a420,Consent,0,81a5ca06-6bdb-423e-9ed7-49d81aa4be2a,,Consent,2017-12-05T13:25:47-05:00,2017-12-05T13:25:58-05:00,iOS,"iPhone7,1",10.0,2017-12-05T18:25:59Z 9ada96e5-e9d9-e711-815b-b9576bf93116,75a665cb-e3a7-e711-8159-cb0f82935acb,SF-12,5,81a5ca06-6bdb-423e-9ed7-49d81aa4be2a,a6b25dbd-e9d9-e711-815b-b9576bf93116,Survey,2017-12-05T13:26:58-05:00,2017-12-05T13:27:12-05:00,iOS,"iPhone7,1",10.0,2017-12-05T18:27:12Z 0d684d39-0d05-e811-815d-8bcb67ef5edd,dcbede15-67c9-e711-815a-a2abfc96a420,Consent,0,8d87da94-ed15-4be3-a69a-41f6c6cfcfef,,Consent,2018-01-29T10:58:05-05:00,2018-01-29T10:58:19-05:00,iOS,"iPhone7,1",10.0,2018-01-29T15:58:20Z
Survey Step Results
SurveyStepResultKey,SurveyResultKey,ParticipantIdentifier,StepIdentifier,StartDate,EndDate 79b25dbd-e9d9-e711-815b-b9576bf93116,73b25dbd-e9d9-e711-815b-b9576bf93116,81a5ca06-6bdb-423e-9ed7-49d81aa4be2a,CONSENT,2017-12-05T13:25:47-05:00,2017-12-05T13:25:57-05:00 7ab25dbd-e9d9-e711-815b-b9576bf93116,73b25dbd-e9d9-e711-815b-b9576bf93116,81a5ca06-6bdb-423e-9ed7-49d81aa4be2a,END,2017-12-05T13:25:57-05:00,2017-12-05T13:25:58-05:00 a0da96e5-e9d9-e711-815b-b9576bf93116,9ada96e5-e9d9-e711-815b-b9576bf93116,81a5ca06-6bdb-423e-9ed7-49d81aa4be2a,INSTRUCTION_SF12,2017-12-05T13:26:58-05:00,2017-12-05T13:26:59-05:00
Survey Question Results
SurveyQuestionResultKey,SurveyStepResultKey,SurveyResultKey,ParticipantIdentifier,ResultIdentifier,Answers,StartDate,EndDate b7da96e5-e9d9-e711-815b-b9576bf93116,a1da96e5-e9d9-e711-815b-b9576bf93116,9ada96e5-e9d9-e711-815b-b9576bf93116,81a5ca06-6bdb-423e-9ed7-49d81aa4be2a,E_HEALTH,,2017-12-05T13:26:59-05:00,2017-12-05T13:27:00-05:00 bada96e5-e9d9-e711-815b-b9576bf93116,a2da96e5-e9d9-e711-815b-b9576bf93116,9ada96e5-e9d9-e711-815b-b9576bf93116,81a5ca06-6bdb-423e-9ed7-49d81aa4be2a,E_ACTIVITY,,2017-12-05T13:27:01-05:00,2017-12-05T13:27:01-05:00 bdda96e5-e9d9-e711-815b-b9576bf93116,a3da96e5-e9d9-e711-815b-b9576bf93116,9ada96e5-e9d9-e711-815b-b9576bf93116,81a5ca06-6bdb-423e-9ed7-49d81aa4be2a,E_STAIRS,,2017-12-05T13:27:01-05:00,2017-12-05T13:27:02-05:00
Survey Consent Signature Results
SurveyConsentSignatureResultKey,SurveyStepResultKey,SurveyResultKey,ParticipantIdentifier,ResultIdentifier,Consented,SignatureIdentifier,SignatureTitle,SignatureGivenName,SignatureFamilyName,SignatureDate,StartDate,EndDate 7fb25dbd-e9d9-e711-815b-b9576bf93116,79b25dbd-e9d9-e711-815b-b9576bf93116,73b25dbd-e9d9-e711-815b-b9576bf93116,81a5ca06-6bdb-423e-9ed7-49d81aa4be2a,Participant,True,Participant,Participant,Chris,Nksak,12/5/17,2017-12-05T13:25:47-05:00,2017-12-05T13:25:57-05:00 1a684d39-0d05-e811-815d-8bcb67ef5edd,14684d39-0d05-e811-815d-8bcb67ef5edd,0d684d39-0d05-e811-815d-8bcb67ef5edd,8d87da94-ed15-4be3-a69a-41f6c6cfcfef,Participant,True,Participant,Participant,Chris,Smith,1/29/18,2018-01-29T10:58:05-05:00,2018-01-29T10:58:18-05:00 6c959ec6-192e-e811-815d-8bcb67ef5edd,66959ec6-192e-e811-815d-8bcb67ef5edd,5f959ec6-192e-e811-815d-8bcb67ef5edd,f5e23bf1-29d6-437e-b7e0-4d9bbeea4eaa,Participant,True,Participant,Participant,Chris,Smith,3/22/18,2018-03-22T17:41:19-04:00,2018-03-22T17:41:27-04:00
{ "SurveyResultKey": "73b25dbd-e9d9-e711-815b-b9576bf93116", "SurveyKey": "dcbede15-67c9-e711-815a-a2abfc96a420", "SurveyName": "Consent", "ParticipantIdentifier": "81a5ca06-6bdb-423e-9ed7-49d81aa4be2a", "Type": "Consent", "SurveyVersion": 0, "StartDate": "2017-12-05T13:25:47-05:00", "EndDate": "2017-12-05T13:25:58-05:00", "DevicePlatform": "iOS", "DeviceName": "iPhone7,1", "DeviceOSVersion": "10.0", "InsertedDate": "2017-12-05T18:25:59Z", "StepResults": [ { "SurveyStepResultKey": "79b25dbd-e9d9-e711-815b-b9576bf93116", "StepIdentifier": "CONSENT", "StartDate": "2017-12-05T13:25:47-05:00", "EndDate": "2017-12-05T13:25:57-05:00", "Results": [ { "Type": "ConsentSignatureResult", "ConsentSignatureResultKey": "7fb25dbd-e9d9-e711-815b-b9576bf93116", "ResultIdentifier": "Participant", "Consented": true, "Signature": { "Identifier": "Participant", "Title": "Participant", "GivenName": "Chris", "FamilyName": "Nksak", "Date": "12/5/17" }, "StartDate": "2017-12-05T13:25:47-05:00", "EndDate": "2017-12-05T13:25:57-05:00" } ] }, { "SurveyStepResultKey": "7ab25dbd-e9d9-e711-815b-b9576bf93116", "StepIdentifier": "END", "StartDate": "2017-12-05T13:25:57-05:00", "EndDate": "2017-12-05T13:25:58-05:00", "Results": [] } ] } { "SurveyResultKey": "9ada96e5-e9d9-e711-815b-b9576bf93116", "SurveyKey": "75a665cb-e3a7-e711-8159-cb0f82935acb", "SurveyName": "SF-12", "ParticipantIdentifier": "81a5ca06-6bdb-423e-9ed7-49d81aa4be2a", "SurveyTaskKey": "a6b25dbd-e9d9-e711-815b-b9576bf93116", "Type": "Survey", "SurveyVersion": 5, "StartDate": "2017-12-05T13:26:58-05:00", "EndDate": "2017-12-05T13:27:12-05:00", "DevicePlatform": "iOS", "DeviceName": "iPhone7,1", "DeviceOSVersion": "10.0", "InsertedDate": "2017-12-05T18:27:12Z", "StepResults": [ { "SurveyStepResultKey": "a0da96e5-e9d9-e711-815b-b9576bf93116", "StepIdentifier": "INSTRUCTION_SF12", "StartDate": "2017-12-05T13:26:58-05:00", "EndDate": "2017-12-05T13:26:59-05:00", "Results": [] }, { "SurveyStepResultKey": "a1da96e5-e9d9-e711-815b-b9576bf93116", "StepIdentifier": "E_HEALTH", "StartDate": "2017-12-05T13:26:59-05:00", "EndDate": "2017-12-05T13:27:00-05:00", "Results": [ { "Type": "QuestionResult", "QuestionResultKey": "b7da96e5-e9d9-e711-815b-b9576bf93116", "ResultIdentifier": "E_HEALTH", "Answers": [ "" ], "StartDate": "2017-12-05T13:26:59-05:00", "EndDate": "2017-12-05T13:27:00-05:00" } ] }, { "SurveyStepResultKey": "a2da96e5-e9d9-e711-815b-b9576bf93116", "StepIdentifier": "E_ACTIVITY", "StartDate": "2017-12-05T13:27:01-05:00", "EndDate": "2017-12-05T13:27:01-05:00", "Results": [ { "Type": "QuestionResult", "QuestionResultKey": "bada96e5-e9d9-e711-815b-b9576bf93116", "ResultIdentifier": "E_ACTIVITY", "Answers": [ "" ], "StartDate": "2017-12-05T13:27:01-05:00", "EndDate": "2017-12-05T13:27:01-05:00" } ] }, { "SurveyStepResultKey": "a3da96e5-e9d9-e711-815b-b9576bf93116", "StepIdentifier": "E_STAIRS", "StartDate": "2017-12-05T13:27:01-05:00", "EndDate": "2017-12-05T13:27:02-05:00", "Results": [ { "Type": "QuestionResult", "QuestionResultKey": "bdda96e5-e9d9-e711-815b-b9576bf93116", "ResultIdentifier": "E_STAIRS", "Answers": [ "" ], "StartDate": "2017-12-05T13:27:01-05:00", "EndDate": "2017-12-05T13:27:02-05:00" } ] }, { "SurveyStepResultKey": "a4da96e5-e9d9-e711-815b-b9576bf93116", "StepIdentifier": "E_ACCOMP_PH", "StartDate": "2017-12-05T13:27:02-05:00", "EndDate": "2017-12-05T13:27:02-05:00", "Results": [ { "Type": "QuestionResult", "QuestionResultKey": "c0da96e5-e9d9-e711-815b-b9576bf93116", "ResultIdentifier": "E_ACCOMP_PH", "Answers": [ "" ], "StartDate": "2017-12-05T13:27:02-05:00", "EndDate": "2017-12-05T13:27:02-05:00" } ] }, { "SurveyStepResultKey": "a5da96e5-e9d9-e711-815b-b9576bf93116", "StepIdentifier": "E_LIMIT", "StartDate": "2017-12-05T13:27:02-05:00", "EndDate": "2017-12-05T13:27:03-05:00", "Results": [ { "Type": "QuestionResult", "QuestionResultKey": "c3da96e5-e9d9-e711-815b-b9576bf93116", "ResultIdentifier": "E_LIMIT", "Answers": [ "" ], "StartDate": "2017-12-05T13:27:02-05:00", "EndDate": "2017-12-05T13:27:03-05:00" } ] }, { "SurveyStepResultKey": "a6da96e5-e9d9-e711-815b-b9576bf93116", "StepIdentifier": "E_ACCOMP_MH", "StartDate": "2017-12-05T13:27:03-05:00", "EndDate": "2017-12-05T13:27:03-05:00", "Results": [ { "Type": "QuestionResult", "QuestionResultKey": "c6da96e5-e9d9-e711-815b-b9576bf93116", "ResultIdentifier": "E_ACCOMP_MH", "Answers": [ "" ], "StartDate": "2017-12-05T13:27:03-05:00", "EndDate": "2017-12-05T13:27:03-05:00" } ] }, { "SurveyStepResultKey": "a7da96e5-e9d9-e711-815b-b9576bf93116", "StepIdentifier": "E_CAREFUL", "StartDate": "2017-12-05T13:27:03-05:00", "EndDate": "2017-12-05T13:27:04-05:00", "Results": [ { "Type": "QuestionResult", "QuestionResultKey": "c9da96e5-e9d9-e711-815b-b9576bf93116", "ResultIdentifier": "E_CAREFUL", "Answers": [ "" ], "StartDate": "2017-12-05T13:27:03-05:00", "EndDate": "2017-12-05T13:27:04-05:00" } ] }, { "SurveyStepResultKey": "a8da96e5-e9d9-e711-815b-b9576bf93116", "StepIdentifier": "E_PAIN", "StartDate": "2017-12-05T13:27:04-05:00", "EndDate": "2017-12-05T13:27:04-05:00", "Results": [ { "Type": "QuestionResult", "QuestionResultKey": "ccda96e5-e9d9-e711-815b-b9576bf93116", "ResultIdentifier": "E_PAIN", "Answers": [ "" ], "StartDate": "2017-12-05T13:27:04-05:00", "EndDate": "2017-12-05T13:27:04-05:00" } ] }, { "SurveyStepResultKey": "a9da96e5-e9d9-e711-815b-b9576bf93116", "StepIdentifier": "INSTRUCTION_FEELING", "StartDate": "2017-12-05T13:27:04-05:00", "EndDate": "2017-12-05T13:27:05-05:00", "Results": [] }, { "SurveyStepResultKey": "aada96e5-e9d9-e711-815b-b9576bf93116", "StepIdentifier": "E_CALM", "StartDate": "2017-12-05T13:27:05-05:00", "EndDate": "2017-12-05T13:27:06-05:00", "Results": [ { "Type": "QuestionResult", "QuestionResultKey": "d1da96e5-e9d9-e711-815b-b9576bf93116", "ResultIdentifier": "E_CALM", "Answers": [ "" ], "StartDate": "2017-12-05T13:27:05-05:00", "EndDate": "2017-12-05T13:27:06-05:00" } ] }, { "SurveyStepResultKey": "abda96e5-e9d9-e711-815b-b9576bf93116", "StepIdentifier": "E_ENERGY", "StartDate": "2017-12-05T13:27:06-05:00", "EndDate": "2017-12-05T13:27:07-05:00", "Results": [ { "Type": "QuestionResult", "QuestionResultKey": "d4da96e5-e9d9-e711-815b-b9576bf93116", "ResultIdentifier": "E_ENERGY", "Answers": [ "" ], "StartDate": "2017-12-05T13:27:06-05:00", "EndDate": "2017-12-05T13:27:07-05:00" } ] }, { "SurveyStepResultKey": "acda96e5-e9d9-e711-815b-b9576bf93116", "StepIdentifier": "E_BLUE", "StartDate": "2017-12-05T13:27:07-05:00", "EndDate": "2017-12-05T13:27:07-05:00", "Results": [ { "Type": "QuestionResult", "QuestionResultKey": "d7da96e5-e9d9-e711-815b-b9576bf93116", "ResultIdentifier": "E_BLUE", "Answers": [ "" ], "StartDate": "2017-12-05T13:27:07-05:00", "EndDate": "2017-12-05T13:27:07-05:00" } ] }, { "SurveyStepResultKey": "adda96e5-e9d9-e711-815b-b9576bf93116", "StepIdentifier": "E_SOCIAL", "StartDate": "2017-12-05T13:27:07-05:00", "EndDate": "2017-12-05T13:27:08-05:00", "Results": [ { "Type": "QuestionResult", "QuestionResultKey": "dada96e5-e9d9-e711-815b-b9576bf93116", "ResultIdentifier": "E_SOCIAL", "Answers": [ "" ], "StartDate": "2017-12-05T13:27:07-05:00", "EndDate": "2017-12-05T13:27:08-05:00" } ] }, { "SurveyStepResultKey": "aeda96e5-e9d9-e711-815b-b9576bf93116", "StepIdentifier": "INSTRUCTION_THANKYOU", "StartDate": "2017-12-05T13:27:08-05:00", "EndDate": "2017-12-05T13:27:10-05:00", "Results": [] }, { "SurveyStepResultKey": "afda96e5-e9d9-e711-815b-b9576bf93116", "StepIdentifier": "New Step 16", "StartDate": "2017-12-05T13:27:10-05:00", "EndDate": "2017-12-05T13:27:12-05:00", "Results": [] } ] } { "SurveyResultKey": "5f959ec6-192e-e811-815d-8bcb67ef5edd", "SurveyKey": "dcbede15-67c9-e711-815a-a2abfc96a420", "SurveyName": "Consent", "ParticipantIdentifier": "f5e23bf1-29d6-437e-b7e0-4d9bbeea4eaa", "Type": "Consent", "SurveyVersion": 0, "StartDate": "2018-03-22T17:41:19-04:00", "EndDate": "2018-03-22T17:41:28-04:00", "DevicePlatform": "iOS", "DeviceName": "iPhone8,2", "DeviceOSVersion": "11.3", "InsertedDate": "2018-03-22T21:41:28Z", "StepResults": [ { "SurveyStepResultKey": "66959ec6-192e-e811-815d-8bcb67ef5edd", "StepIdentifier": "CONSENT", "StartDate": "2018-03-22T17:41:19-04:00", "EndDate": "2018-03-22T17:41:27-04:00", "Results": [ { "Type": "ConsentSignatureResult", "ConsentSignatureResultKey": "6c959ec6-192e-e811-815d-8bcb67ef5edd", "ResultIdentifier": "Participant", "Consented": true, "Signature": { "Identifier": "Participant", "Title": "Participant", "GivenName": "Chris", "FamilyName": "Smith", "Date": "3/22/18" }, "StartDate": "2018-03-22T17:41:19-04:00", "EndDate": "2018-03-22T17:41:27-04:00" } ] }, { "SurveyStepResultKey": "67959ec6-192e-e811-815d-8bcb67ef5edd", "StepIdentifier": "END", "StartDate": "2018-03-22T17:41:27-04:00", "EndDate": "2018-03-22T17:41:28-04:00", "Results": [] } ] }