Survey Results V2 Export Format
When a participant completes a survey, it generates a Survey Result. In addition to the incremental Survey Results Data Exports, MyDataHelps also offers a full nightly export of all survey results.
Survey Results V2 data is exported in multiple files with prefixes as follows:
- Survey Results - Combined:
SurveyResultsV2_YYYYMMDD- Contains the high level information for all survey results. In JSON format, also includes Survey Answers data.
- Survey Answers - Combined (CSV only):
SurveyResultsV2_Answers_YYYYMMDD- Contains all answers for all survey results.
- Survey Results - Per Survey:
SurveyResultsV2_{SurveyName}_YYYYMMDD- Contains all survey results and answers for the survey specified.
Data Fields
| Field | Description |
|---|---|
SurveyID |
The stable, automatically generated identifier of the survey viewed. Can be cross referenced with SurveyKey. |
SurveyName |
The name of the survey this result was for. |
ParticipantID |
The stable, automatically generated, internal system identifier for this participant. Universally unique identifier (UUID). |
ParticipantIdentifier |
The identifier of the participant this survey was for. Can be used to cross reference with Participants. |
Event |
The event associated with the survey result. Events are an optional feature, and this column is only present in CSV format if events are configured for the project and there is an event assigned to the result. See Tracking Survey Completion with Events for more information. |
Instance |
The instance number of this particular survey for this participant, if a survey is not configured as "Single Instance" in Survey Settings. For example, if this is the third time a participant has completed this particular survey, the If a survey is set to "Single Instance", this column will not be present in Per Survey CSV files. If all surveys are set as "Single Instance", this column will not be present in Combined survey answer CSV files. |
SurveyTaskID |
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. |
InsertedDate |
The initial completion date of the result, in ISO 8601 format. Includes timezone offset information. |
InsertedByUserType |
The type of user that submitted the survey, for example Participant or Coordinator. |
InsertedByUser |
The user that submitted the survey. For a survey submitted by a Coordinator, this will be the coordinator’s email address. For a survey submitted by the Participant, this will be empty. |
ModifiedDate |
When the result was modified, in ISO 8601 format. Includes timezone offset information. |
ModifiedByUserType |
The type of user that modified the survey result, for example Participant or Coordinator. |
ModifiedByUser |
The user that modified the survey result. For a result modified by a Coordinator, this will be the coordinator’s email address. For a result modified by the Participant, this will be empty. |
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. |
Answers |
The answer(s) the participant provided for the question(s). Answer values are stored in the Default language, except text answer formats which store as the participant entered them. |
{ResultIdentifier} |
In CSV format, Per Survey answer files will include each unique result identifier as its own column. |
Sample CSV Exports
Survey Results - Combined
SurveyID,SurveyName,ParticipantID,ParticipantIdentifier,Event,Instance,SurveyTaskID,InsertedDate,InsertedByUserType,InsertedByUser,ModifiedDate,ModifiedByUserType,ModifiedByUser
8e3cfec8-a1f0-ef11-acbb-0affe8573173,PROMIS Cognitive Function 4a,d5ecad6e-5e1b-498e-ab5d-40ee6c5d355c,SOS-9541-8814,1 Week Post-Surgery,,29aaa889-4eeb-f011-ad3e-0affd98fb193,2026-01-06T15:09:37-08:00,Participant,,2026-01-06T15:09:48-08:00,Participant,
8e3cfec8-a1f0-ef11-acbb-0affe8573173,PROMIS Cognitive Function 4a,d5ecad6e-5e1b-498e-ab5d-40ee6c5d355c,SOS-9541-8814,,,2a89aec9-d36c-f011-ad38-0afff357b117,2025-07-29T16:29:26-07:00,Participant,,2025-12-22T11:54:15-07:00,Participant,
8f3cfec8-a1f0-ef11-acbb-0affe8573173,PROMIS Global 10 SF,d5ecad6e-5e1b-498e-ab5d-40ee6c5d355c,SOS-9541-8814,Pre-Surgery Baseline,,2e89aec9-d36c-f011-ad38-0afff357b117,2025-07-29T16:30:18-07:00,Admin,example@careevolution.com,2025-12-22T11:54:15-07:00,Admin,example@careevolution.com
8c3cfec8-a1f0-ef11-acbb-0affe8573173,BODY PAIN,d5ecad6e-5e1b-498e-ab5d-40ee6c5d355c,SOS-9541-8814,,,60b8b7bb-de7d-f011-ad38-0afff357b117,2025-08-21T10:53:34-07:00,Admin,example@careevolution.com,2026-10-02T11:56:29-07:00,Admin,example@careevolution.com
933cfec8-a1f0-ef11-acbb-0affe8573173,Update Date of Surgery,d5ecad6e-5e1b-498e-ab5d-40ee6c5d355c,SOS-9541-8814,,1,,2025-08-01T12:59:27-07:00,Admin,example@careevolution.com,2025-12-22T11:54:15-07:00,Admin,example@careevolution.com
923cfec8-a1f0-ef11-acbb-0affe8573173,Surgical Outcomes Study Consent,d5ecad6e-5e1b-498e-ab5d-40ee6c5d355c,SOS-9541-8814,,1,,2025-07-29T16:28:37-07:00,Participant,,2025-07-29T16:28:57-07:00,Participant,
Survey Answers - Combined
SurveyID,SurveyName,ParticipantID,ParticipantIdentifier,Event,Instance,ResultIdentifier,Answers
8e3cfec8-a1f0-ef11-acbb-0affe8573173,PROMIS Cognitive Function 4a,d5ecad6e-5e1b-498e-ab5d-40ee6c5d355c,SOS-9541-8814,1 Week Post-Surgery,,PC2r,5
8e3cfec8-a1f0-ef11-acbb-0affe8573173,PROMIS Cognitive Function 4a,d5ecad6e-5e1b-498e-ab5d-40ee6c5d355c,SOS-9541-8814,1 Week Post-Surgery,,PC35r,5
8e3cfec8-a1f0-ef11-acbb-0affe8573173,PROMIS Cognitive Function 4a,d5ecad6e-5e1b-498e-ab5d-40ee6c5d355c,SOS-9541-8814,1 Week Post-Surgery,,PC36r,5
8e3cfec8-a1f0-ef11-acbb-0affe8573173,PROMIS Cognitive Function 4a,d5ecad6e-5e1b-498e-ab5d-40ee6c5d355c,SOS-9541-8814,1 Week Post-Surgery,,PC42r,5
8e3cfec8-a1f0-ef11-acbb-0affe8573173,PROMIS Cognitive Function 4a,d5ecad6e-5e1b-498e-ab5d-40ee6c5d355c,SOS-9541-8814,,,PC2r,5
8e3cfec8-a1f0-ef11-acbb-0affe8573173,PROMIS Cognitive Function 4a,d5ecad6e-5e1b-498e-ab5d-40ee6c5d355c,SOS-9541-8814,,,PC35r,5
8e3cfec8-a1f0-ef11-acbb-0affe8573173,PROMIS Cognitive Function 4a,d5ecad6e-5e1b-498e-ab5d-40ee6c5d355c,SOS-9541-8814,,,PC36r,5
8e3cfec8-a1f0-ef11-acbb-0affe8573173,PROMIS Cognitive Function 4a,d5ecad6e-5e1b-498e-ab5d-40ee6c5d355c,SOS-9541-8814,,,PC42r,5
8f3cfec8-a1f0-ef11-acbb-0affe8573173,PROMIS Global 10 SF,d5ecad6e-5e1b-498e-ab5d-40ee6c5d355c,SOS-9541-8814,Pre-Surgery Baseline,,PROMISGlobal01,3
8f3cfec8-a1f0-ef11-acbb-0affe8573173,PROMIS Global 10 SF,d5ecad6e-5e1b-498e-ab5d-40ee6c5d355c,SOS-9541-8814,Pre-Surgery Baseline,,PROMISGlobal02,4
8f3cfec8-a1f0-ef11-acbb-0affe8573173,PROMIS Global 10 SF,d5ecad6e-5e1b-498e-ab5d-40ee6c5d355c,SOS-9541-8814,Pre-Surgery Baseline,,PROMISGlobal03,4
8f3cfec8-a1f0-ef11-acbb-0affe8573173,PROMIS Global 10 SF,d5ecad6e-5e1b-498e-ab5d-40ee6c5d355c,SOS-9541-8814,Pre-Surgery Baseline,,PROMISGlobal04,4
8f3cfec8-a1f0-ef11-acbb-0affe8573173,PROMIS Global 10 SF,d5ecad6e-5e1b-498e-ab5d-40ee6c5d355c,SOS-9541-8814,Pre-Surgery Baseline,,PROMISGlobal05,4
8f3cfec8-a1f0-ef11-acbb-0affe8573173,PROMIS Global 10 SF,d5ecad6e-5e1b-498e-ab5d-40ee6c5d355c,SOS-9541-8814,Pre-Surgery Baseline,,PROMISGlobal06,5
8f3cfec8-a1f0-ef11-acbb-0affe8573173,PROMIS Global 10 SF,d5ecad6e-5e1b-498e-ab5d-40ee6c5d355c,SOS-9541-8814,Pre-Surgery Baseline,,PROMISGlobal09,3
8f3cfec8-a1f0-ef11-acbb-0affe8573173,PROMIS Global 10 SF,d5ecad6e-5e1b-498e-ab5d-40ee6c5d355c,SOS-9541-8814,Pre-Surgery Baseline,,PROMISGlobal10,3
8f3cfec8-a1f0-ef11-acbb-0affe8573173,PROMIS Global 10 SF,d5ecad6e-5e1b-498e-ab5d-40ee6c5d355c,SOS-9541-8814,Pre-Surgery Baseline,,PROMISGlobal08,3
8f3cfec8-a1f0-ef11-acbb-0affe8573173,PROMIS Global 10 SF,d5ecad6e-5e1b-498e-ab5d-40ee6c5d355c,SOS-9541-8814,Pre-Surgery Baseline,,PROMISGlobal07,5
8c3cfec8-a1f0-ef11-acbb-0affe8573173,BODY PAIN,d5ecad6e-5e1b-498e-ab5d-40ee6c5d355c,SOS-9541-8814,,,SURGPAIN_d1,True
8c3cfec8-a1f0-ef11-acbb-0affe8573173,BODY PAIN,d5ecad6e-5e1b-498e-ab5d-40ee6c5d355c,SOS-9541-8814,,,SURGBPI3_d1,3
8c3cfec8-a1f0-ef11-acbb-0affe8573173,BODY PAIN,d5ecad6e-5e1b-498e-ab5d-40ee6c5d355c,SOS-9541-8814,,,SURGBPI5_d1,4
8c3cfec8-a1f0-ef11-acbb-0affe8573173,BODY PAIN,d5ecad6e-5e1b-498e-ab5d-40ee6c5d355c,SOS-9541-8814,,,BPI3_d1,5
8c3cfec8-a1f0-ef11-acbb-0affe8573173,BODY PAIN,d5ecad6e-5e1b-498e-ab5d-40ee6c5d355c,SOS-9541-8814,,,BPI5_d1,4
8c3cfec8-a1f0-ef11-acbb-0affe8573173,BODY PAIN,d5ecad6e-5e1b-498e-ab5d-40ee6c5d355c,SOS-9541-8814,,,MBM_d1,"Face,Lt jaw,Rt jaw,Neck,Head"
933cfec8-a1f0-ef11-acbb-0affe8573173,Update Date of Surgery,d5ecad6e-5e1b-498e-ab5d-40ee6c5d355c,SOS-9541-8814,,1,CoordinatorDateOfSurgery,2025-07-30
923cfec8-a1f0-ef11-acbb-0affe8573173,Surgical Outcomes Study Consent,d5ecad6e-5e1b-498e-ab5d-40ee6c5d355c,SOS-9541-8814,,1,Intro,Yes
923cfec8-a1f0-ef11-acbb-0affe8573173,Surgical Outcomes Study Consent,d5ecad6e-5e1b-498e-ab5d-40ee6c5d355c,SOS-9541-8814,,1,Info_WhatToExpect,Yes
923cfec8-a1f0-ef11-acbb-0affe8573173,Surgical Outcomes Study Consent,d5ecad6e-5e1b-498e-ab5d-40ee6c5d355c,SOS-9541-8814,,1,Info_KeepInMind,Yes
923cfec8-a1f0-ef11-acbb-0affe8573173,Surgical Outcomes Study Consent,d5ecad6e-5e1b-498e-ab5d-40ee6c5d355c,SOS-9541-8814,,1,DateOfSurgery,2025-07-30
Survey Results - Per Survey
Update Date of Surgery
This survey is not associated with any events and is not listed as single entry, so the Instance column is present, but Event is not.
SurveyID,SurveyName,ParticipantID,ParticipantIdentifier,Instance,SurveyTaskID,CoordinatorDateOfSurgery,InsertedDate,InsertedByUserType,InsertedByUser,ModifiedDate,ModifiedByUserType,ModifiedByUser
933cfec8-a1f0-ef11-acbb-0affe8573173,Update Date of Surgery,d5ecad6e-5e1b-498e-ab5d-40ee6c5d355c,SOS-9541-8814,1,,2025-07-30,2025-08-01T12:59:27-07:00,Admin,example@careevolution.com,2025-12-22T11:54:15-07:00,Admin,example@careevolution.com
PROMIS Cognitive Function 4a Survey
This survey is associated with events and is listed as single entry, so here the Event column is present, but Instance is not.
SurveyID,SurveyName,ParticipantID,ParticipantIdentifier,Event,SurveyTaskID,PC2r,PC35r,PC36r,PC42r,InsertedDate,InsertedByUserType,InsertedByUser,ModifiedDate,ModifiedByUserType,ModifiedByUser
8e3cfec8-a1f0-ef11-acbb-0affe8573173,PROMIS Cognitive Function 4a,d5ecad6e-5e1b-498e-ab5d-40ee6c5d355c,SOS-9541-8814,1 Week Post-Surgery,29aaa889-4eeb-f011-ad3e-0affd98fb193,5,5,5,5,2026-01-06T15:09:37-08:00,Participant,,2026-01-06T15:09:48-08:00,Participant,
8e3cfec8-a1f0-ef11-acbb-0affe8573173,PROMIS Cognitive Function 4a,d5ecad6e-5e1b-498e-ab5d-40ee6c5d355c,SOS-9541-8814,,2a89aec9-d36c-f011-ad38-0afff357b117,5,5,5,5,2025-07-29T16:29:26-07:00,Participant,,2025-12-22T11:54:15-07:00,Participant,
Sample JSON Exports
Survey Results - Combined
{
"SurveyID": "8c3cfec8-a1f0-ef11-acbb-0affe8573173",
"SurveyName": "BODY PAIN",
"ParticipantID": "d5ecad6e-5e1b-498e-ab5d-40ee6c5d355c",
"ParticipantIdentifier": "SOS-9541-8814",
"Event": null,
"Instance": null,
"SurveyTaskID": "60b8b7bb-de7d-f011-ad38-0afff357b117",
"Answers": {
"SURGPAIN_d1": ["True"],
"SURGBPI3_d1": ["3"],
"SURGBPI5_d1": ["4"],
"BPI3_d1": ["5"],
"BPI5_d1": ["4"],
"MBM_d1": ["Face,Lt jaw,Rt jaw,Neck,Head"]
},
"InsertedDate": "2025-08-21T10:53:34-07:00",
"InsertedByUserType": "Admin",
"InsertedByUser": "example@careevolution.com",
"ModifiedDate": "2026-10-02T11:56:29-07:00",
"ModifiedByUserType": "Admin",
"ModifiedByUser": "example@careevolution.com"
}
{
"SurveyID": "8f3cfec8-a1f0-ef11-acbb-0affe8573173",
"SurveyName": "PROMIS Global 10 SF",
"ParticipantID": "d5ecad6e-5e1b-498e-ab5d-40ee6c5d355c",
"ParticipantIdentifier": "SOS-9541-8814",
"Event": "Pre-Surgery Baseline",
"Instance": null,
"SurveyTaskID": "2e89aec9-d36c-f011-ad38-0afff357b117",
"Answers": {
"PROMISGlobal01": ["3"],
"PROMISGlobal02": ["4"],
"PROMISGlobal03": ["4"],
"PROMISGlobal04": ["4"],
"PROMISGlobal05": ["4"],
"PROMISGlobal06": ["5"],
"PROMISGlobal09": ["3"],
"PROMISGlobal10": ["3"],
"PROMISGlobal08": ["3"],
"PROMISGlobal07": ["5"]
},
"InsertedDate": "2025-07-29T16:30:18-07:00",
"InsertedByUserType": "Admin",
"InsertedByUser": "example@careevolution.com",
"ModifiedDate": "2025-12-22T11:54:15-07:00",
"ModifiedByUserType": "Admin",
"ModifiedByUser": "example@careevolution.com"
}
{
"SurveyID": "923cfec8-a1f0-ef11-acbb-0affe8573173",
"SurveyName": "Surgical Outcomes Study Consent",
"ParticipantID": "d5ecad6e-5e1b-498e-ab5d-40ee6c5d355c",
"ParticipantIdentifier": "SOS-9541-8814",
"Event": null,
"Instance": "1",
"SurveyTaskID": null,
"Answers": {
"Intro": ["Yes"],
"Info_WhatToExpect": ["Yes"],
"Info_KeepInMind": ["Yes"],
"DateOfSurgery": ["2025-07-30"]
},
"InsertedDate": "2025-07-29T16:28:37-07:00",
"InsertedByUserType": "Participant",
"InsertedByUser": null,
"ModifiedDate": "2025-07-29T16:28:57-07:00",
"ModifiedByUserType": "Participant",
"ModifiedByUser": null
}
{
"SurveyID": "933cfec8-a1f0-ef11-acbb-0affe8573173",
"SurveyName": "Update Date of Surgery",
"ParticipantID": "d5ecad6e-5e1b-498e-ab5d-40ee6c5d355c",
"ParticipantIdentifier": "SOS-9541-8814",
"Event": null,
"Instance": "1",
"SurveyTaskID": null,
"Answers": {
"CoordinatorDateOfSurgery": ["2025-07-30"]
},
"InsertedDate": "2025-08-01T12:59:27-07:00",
"InsertedByUserType": "Admin",
"InsertedByUser": "example@careevolution.com",
"ModifiedDate": "2025-12-22T11:54:15-07:00",
"ModifiedByUserType": "Admin",
"ModifiedByUser": "example@careevolution.com"
}
{
"SurveyID": "8e3cfec8-a1f0-ef11-acbb-0affe8573173",
"SurveyName": "PROMIS Cognitive Function 4a",
"ParticipantID": "d5ecad6e-5e1b-498e-ab5d-40ee6c5d355c",
"ParticipantIdentifier": "SOS-9541-8814",
"Event": "1 Week Post-Surgery",
"Instance": null,
"SurveyTaskID": "29aaa889-4eeb-f011-ad3e-0affd98fb193",
"Answers": {
"PC2r": ["5"],
"PC35r": ["5"],
"PC36r": ["5"],
"PC42r": ["5"]
},
"InsertedDate": "2026-01-06T15:09:37-08:00",
"InsertedByUserType": "Participant",
"InsertedByUser": null,
"ModifiedDate": "2026-01-06T15:09:48-08:00",
"ModifiedByUserType": "Participant",
"ModifiedByUser": null
}
{
"SurveyID": "8e3cfec8-a1f0-ef11-acbb-0affe8573173",
"SurveyName": "PROMIS Cognitive Function 4a",
"ParticipantID": "d5ecad6e-5e1b-498e-ab5d-40ee6c5d355c",
"ParticipantIdentifier": "SOS-9541-8814",
"Event": "",
"Instance": null,
"SurveyTaskID": "2a89aec9-d36c-f011-ad38-0afff357b117",
"Answers": {
"PC2r": ["5"],
"PC35r": ["5"],
"PC36r": ["5"],
"PC42r": ["5"]
},
"InsertedDate": "2025-07-29T16:29:26-07:00",
"InsertedByUserType": "Participant",
"InsertedByUser": null,
"ModifiedDate": "2025-12-22T11:54:15-07:00",
"ModifiedByUserType": "Participant",
"ModifiedByUser": null
}
Survey Results - Per Survey
Update Date of Surgery
{
"SurveyID": "933cfec8-a1f0-ef11-acbb-0affe8573173",
"SurveyName": "Update Date of Surgery",
"ParticipantID": "d5ecad6e-5e1b-498e-ab5d-40ee6c5d355c",
"ParticipantIdentifier": "SOS-9541-8814",
"Event": null,
"Instance": "1",
"SurveyTaskID": null,
"Answers": {
"CoordinatorDateOfSurgery": ["2025-07-30"]
},
"InsertedDate": "2025-08-01T12:59:27-07:00",
"InsertedByUserType": "Admin",
"InsertedByUser": "example@careevolution.com",
"ModifiedDate": "2025-12-22T11:54:15-07:00",
"ModifiedByUserType": "Admin",
"ModifiedByUser": "example@careevolution.com"
}
PROMIS Cognitive Function 4a Survey
{
"SurveyID": "8e3cfec8-a1f0-ef11-acbb-0affe8573173",
"SurveyName": "PROMIS Cognitive Function 4a",
"ParticipantID": "d5ecad6e-5e1b-498e-ab5d-40ee6c5d355c",
"ParticipantIdentifier": "SOS-9541-8814",
"Event": "1 Week Post-Surgery",
"Instance": null,
"SurveyTaskID": "29aaa889-4eeb-f011-ad3e-0affd98fb193",
"Answers": {
"PC2r": ["5"],
"PC35r": ["5"],
"PC36r": ["5"],
"PC42r": ["5"]
},
"InsertedDate": "2026-01-06T15:09:37-08:00",
"InsertedByUserType": "Participant",
"InsertedByUser": null,
"ModifiedDate": "2026-01-06T15:09:48-08:00",
"ModifiedByUserType": "Participant",
"ModifiedByUser": null
}
{
"SurveyID": "8e3cfec8-a1f0-ef11-acbb-0affe8573173",
"SurveyName": "PROMIS Cognitive Function 4a",
"ParticipantID": "d5ecad6e-5e1b-498e-ab5d-40ee6c5d355c",
"ParticipantIdentifier": "SOS-9541-8814",
"Event": "",
"Instance": null,
"SurveyTaskID": "2a89aec9-d36c-f011-ad38-0afff357b117",
"Answers": {
"PC2r": ["5"],
"PC35r": ["5"],
"PC36r": ["5"],
"PC42r": ["5"]
},
"InsertedDate": "2025-07-29T16:29:26-07:00",
"InsertedByUserType": "Participant",
"InsertedByUser": null,
"ModifiedDate": "2025-12-22T11:54:15-07:00",
"ModifiedByUserType": "Participant",
"ModifiedByUser": null
}