RKStudio™
User Guide

Survey Results

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.

Survey Results

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.

Survey Step Results

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.

Survey Question Results

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.

Sample Export

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": []
    }
  ]
}