Skip to content
  • There are no suggestions because the search field is empty.

Survey Answer Change Log Export Format

MyDataHelps maintains a canonical, current-state copy of every survey answer—keyed by participant, survey, event, instance, step, and result identifier—separate from the more detailed, metadata-rich survey answer records described elsewhere. The Survey Answer Change Log records every update made to an answer in that canonical copy, capturing both the old and new value, so you can see exactly what a participant or coordinator changed and when.

A change log is only written when an answer's value actually changes. If a coordinator opens a result for editing but doesn't change a particular answer, that answer gets no log entry—so this export doubles as a clean record of exactly which answers were touched during an edit.

Each row also links back to the corresponding ChangeLogID in the Survey Result Change Log Export Format via SurveyResultChangeLogID, so you can tie an answer change back to the broader result-level change it was part of.

Data Fields

Field Description
ChangeLogID The stable, automically generated identifier for this change log entry.
SurveyResultChangeLogID The ChangeLogID of the corresponding entry in the Survey Result Change Log—the result-level change this answer change was part of.
ParticipantIdentifier The identifier of the participant this entry was recorded for. Can be used to cross reference with Participants.
ParticipantID The stable, automatically generated, internal system identifier for this participant. Universally unique identifier (UUID).
SurveyID The stable, automatically generated identifier of the survey viewed. Can be cross referenced with SurveyKey.
Event

The event associated with the survey result.

Events are an optional feature, and this field is only populated 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 For surveys that can be submitted more than once, distinguishes which submission this answer belongs to.
StepIdentifier The identifier of this step, determined when the survey was created.
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.
OldAnswers The answer value(s) before this change. Blank if the answer didn't previously exist.
NewAnswers The answer value(s) after this change. Blank if the answer was removed.
ChangeDate When this change was recorded, in ISO 8601 format. Includes timezone offset information.
ChangedByUserType The type of user who made this change, e.g., Participant or Coordinator.
ChangedByUser For a change made by a Coordinator, this will be the coordinator's email address.

Sample CSV Export

ChangeLogID,SurveyResultChangeLogID,ParticipantIdentifier,ParticipantID,SurveyID,Event,Instance,StepIdentifier,ResultIdentifier,OldAnswers,NewAnswers,ChangeDate,ChangedByUserType,ChangedByUser
76be1870-cd6a-4147-ad8c-b622b69c8b9e,fa349469-cf1a-4d09-ad59-82c23003cc82,PID-8081841,7d2aa315-d838-487b-9a21-83d2442b5fa8,6cb70619-06a1-ef11-bafb-0affe8024cad,,1,Morning,morning,,7:00 AM,2026-08-25T10:50:56-04:00,Coordinator,staff@careevolution.com
3c78dbed-b5dd-4a19-a5c3-442b7c94ffd4,fa349469-cf1a-4d09-ad59-82c23003cc82,PID-8081841,7d2aa315-d838-487b-9a21-83d2442b5fa8,6cb70619-06a1-ef11-bafb-0affe8024cad,,1,Evening,evening,,7:00 PM,2026-08-25T10:50:56-04:00,Coordinator,staff@careevolution.com
38d3b07c-fab6-4807-95ef-f42293ba6b94,37167545-5afb-483c-a783-07fdd30af486,PID-8081841,7d2aa315-d838-487b-9a21-83d2442b5fa8,32b932fc-78d7-ec11-aaba-0afb9334277d,,1,MBM-UPOU,MBM-UPOU,,Rt lower leg,2026-08-25T10:50:32-04:00,Coordinator,staff@careevolution.com
16f02869-bfe9-4da3-94e5-74e98de11096,37167545-5afb-483c-a783-07fdd30af486,PID-8081841,7d2aa315-d838-487b-9a21-83d2442b5fa8,32b932fc-78d7-ec11-aaba-0afb9334277d,,1,MBM-OPEN,MBM-OPEN,,"Rt upper arm,Lt upper leg",2026-08-25T10:50:32-04:00,Coordinator,staff@careevolution.com

Sample JSON Export

JSON files are NDJSON: one compact object per line.

{
 "ChangeLogID": "76be1870-cd6a-4147-ad8c-b622b69c8b9e",
 "SurveyResultChangeLogID": "fa349469-cf1a-4d09-ad59-82c23003cc82",
 "ParticipantIdentifier": "PID-8081841",
 "ParticipantID": "7d2aa315-d838-487b-9a21-83d2442b5fa8",
 "SurveyID": "6cb70619-06a1-ef11-bafb-0affe8024cad",
 "Event": "",
 "Instance": "1",
 "StepIdentifier": "Time",
 "ResultIdentifier": "morning",
 "OldAnswers": "",
 "NewAnswers": "07:00 AM",
 "ChangeDate": "2026-08-25T10:50:56-04:00",
 "ChangedByUserType": "Coordinator",
 "ChangedByUser": "staff@careevolution.com"
}
{
 "ChangeLogID": "3c78dbed-b5dd-4a19-a5c3-442b7c94ffd4",
 "SurveyResultChangeLogID": "fa349469-cf1a-4d09-ad59-82c23003cc82",
 "ParticipantIdentifier": "PID-8081841",
 "ParticipantID": "7d2aa315-d838-487b-9a21-83d2442b5fa8",
 "SurveyID": "6cb70619-06a1-ef11-bafb-0affe8024cad",
 "Event": "",
 "Instance": "1",
 "StepIdentifier": "Time",
 "ResultIdentifier": "evening",
 "OldAnswers": "",
 "NewAnswers": "07:00 PM",
 "ChangeDate": "2026-08-25T10:50:56-04:00",
 "ChangedByUserType": "Coordinator",
 "ChangedByUser": "staff@careevolution.com"
}
{
 "ChangeLogID": "38d3b07c-fab6-4807-95ef-f42293ba6b94",
 "SurveyResultChangeLogID": "37167545-5afb-483c-a783-07fdd30af486",
 "ParticipantIdentifier": "PID-8081841",
 "ParticipantID": "7d2aa315-d838-487b-9a21-83d2442b5fa8",
 "SurveyID": "32b932fc-78d7-ec11-aaba-0afb9334277d",
 "Event": "",
 "Instance": "1",
 "StepIdentifier": "MBM-UPOU",
 "ResultIdentifier": "MBM-UPOU",
 "OldAnswers": "",
 "NewAnswers": "Rt lower leg",
 "ChangeDate": "2026-08-25T10:50:32-04:00",
 "ChangedByUserType": "Coordinator",
 "ChangedByUser": "staff@careevolution.com"
}
{
 "ChangeLogID": "16f02869-bfe9-4da3-94e5-74e98de11096",
 "SurveyResultChangeLogID": "37167545-5afb-483c-a783-07fdd30af486",
 "ParticipantIdentifier": "PID-8081841",
 "ParticipantID": "7d2aa315-d838-487b-9a21-83d2442b5fa8",
 "SurveyID": "32b932fc-78d7-ec11-aaba-0afb9334277d",
 "Event": "",
 "Instance": "1",
 "StepIdentifier": "MBM-OPEN",
 "ResultIdentifier": "MBM-OPEN",
 "OldAnswers": "",
 "NewAnswers": "Rt upper arm,Lt upper leg",
 "ChangeDate": "2026-08-25T10:50:32-04:00",
 "ChangedByUserType": "Coordinator",
 "ChangedByUser": "staff@careevolution.com"
}