Skip to content
More support
Contact us
  • There are no suggestions because the search field is empty.

Survey Result Change Log Export Format

MyDataHelps maintains a canonical, current-state copy of every survey result—one row per participant, survey, event, and instance—separate from the more detailed, metadata-rich survey result records described elsewhere. The Survey Result Change Log records every insert, update, and delete made to that canonical copy, giving you a complete audit trail of how a survey result changed over time and who changed it.

A change log is written automatically whenever a canonical survey result is inserted, updated, or deleted—there's nothing a participant or coordinator needs to do to generate one.

Data Fields

Field Description
ChangeLogID The stable, automatically generated identifier for this change log entry.
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 result belongs to.
ChangeType What kind of change this was: Insert, Update, or Delete.
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,ParticipantIdentifier,ParticipantID,SurveyID,Event,Instance,ChangeType,ChangeDate,ChangedByUserType,ChangedByUser
fa349469-cf1a-4d09-ad59-82c23003cc82,PID-8081841,7d2aa315-d838-487b-9a21-83d2442b5fa8,6cb70619-06a1-ef11-bafb-0affe8024cad,,1,INSERT,2026-08-25T10:50:56-04:00,Coordinator,staff@careevolution.com
37167545-5afb-483c-a783-07fdd30af486,PID-8081841,7d2aa315-d838-487b-9a21-83d2442b5fa8,32b932fc-78d7-ec11-aaba-0afb9334277d,,1,INSERT,2026-08-25T10:50:32-04:00,Coordinator,staff@careevolution.com

Sample JSON Export

{
 "ChangeLogID": "fa349469-cf1a-4d09-ad59-82c23003cc82",
 "ParticipantIdentifier": "PID-8081841",
 "ParticipantID": "7d2aa315-d838-487b-9a21-83d2442b5fa8",
 "SurveyID": "6cb70619-06a1-ef11-bafb-0affe8024cad",
 "Event": "",
 "Instance": "1",
 "ChangeType": "INSERT",
 "ChangeDate": "2026-08-25T10:50:56-04:00",
 "ChangedByUserType": "Coordinator",
 "ChangedByUser": "staff@careevolution.com"
}
{
 "ChangeLogID": "37167545-5afb-483c-a783-07fdd30af486",
 "ParticipantIdentifier": "PID-8081841",
 "ParticipantID": "7d2aa315-d838-487b-9a21-83d2442b5fa8",
 "SurveyID": "32b932fc-78d7-ec11-aaba-0afb9334277d",
 "Event": "",
 "Instance": "1",
 "ChangeType": "INSERT",
 "ChangeDate": "2026-08-25T10:50:32-04:00",
 "ChangedByUserType": "Coordinator",
 "ChangedByUser": "staff@careevolution.com"
}