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

SMS Notification Export Formats

The SMS notification data represents all SMS notification events triggered by MyDataHelps. For all of the SMS notification events, a record can be uniquely identified 99% of the time using ParticipantID (or ParticipantIdentifier) plus Timestamp plus NotificationIdentifier.

SMS Notification Send, Delivery, Opt Out, & Failure

The SMS Notification Send, Delivery, Opt Out, and Failure files contain the following fields:

Field Description
ParticipantID The stable, automatically generated, internal system identifier for this participant.
ParticipantIdentifier The identifier of the participant the notification or survey was delivered to. Can be used to cross reference with Participants.
NotificationIdentifier The workspace-specific identifier of the notification that was sent. This is the identifier shown in the Notifications library.
SmsEventKey  A unique key for the SMS event.
MessageID The unique ID generated when the message is accepted by the system.
Timestamp The timestamp of when the SMS notification was sent, in UTC.
MessageTimestamp The timestamp of when the event was received by the system, in UTC.
DestinationPhoneNumber Phone number to which the SMS was sent.
OriginationPhoneNumber Phone number from which the SMS was sent.
RecordStatus Status of the SMS event, e.g. `"SUCCESSFUL"`.
MCCMNC Mobile Country Codes (MCC) and Mobile Network Codes (MNC), identifying the country of the SMS recipient.
NumberOfMessageParts

Number of message parts sent out as part of the message. 

Generally, SMS messages can contain only 160 GSM-7 characters or 67 non-GSM characters, although these limits can vary by country. If you send a message that exceeds these limits, the message is automatically split into smaller parts.
MessageType The type of message. Possible values are "Promotional" and "Transactional". Generally will be "Transactional" as participants have opted into your project.
DetailedEventType More detail about what happened to the message, such as whether it was delivered or why it failed. For example, TEXT_DELIVERED means the message reached the participant’s phone, and TEXT_CARRIER_BLOCKED means the participant’s mobile carrier blocked it. 

SMS Notification Link Clicked

The SMS Notification Link Clicked file contains the following fields.

Field Description
ParticipantID The stable, automatically generated, internal system identifier for this participant.
ParticipantIdentifier The identifier of the participant the notification or survey was delivered to. Can be used to cross reference with Participants.
Timestamp The timestamp of when the SMS notification link was clicked, in UTC.
NotificationIdentifier The workspace-specific identifier of the notification that was sent. This is the identifier shown in the Notifications library.
TargetURL The URL within the notification that was clicked.

[Legacy] SMS Notification Sent

The SMS Notification Sent export is a legacy export and we recommend using the other SMS Notification Exports above.

The SMS Notification Sent file contains the following fields.

Field Description
ParticipantID The stable, automatically generated, internal system identifier for this participant.
ParticipantIdentifier The identifier of the participant the notification or survey was delivered to. Can be used to cross reference with Participants.
Timestamp The timestamp of when the SMS notification was sent, in UTC.
Message The text of the SMS message.
NotificationIdentifier The workspace-specific identifier of the notification that was sent. This is the identifier shown in the Notifications library.
To The phone number that the SMS notification was sent to

Sample CSV Export

ParticipantIdentifier,Timestamp,ParticipantID,SmsEventKey,MessageID,NotificationIdentifier,MessageTimestamp,DestinationPhoneNumber,OriginationPhoneNumber,RecordStatus,MCCMNC,NumberOfMessageParts,MessageType,DetailedEventType
MDH-008,2022-06-13T20:07:43Z,5e4e4958-6812-ec11-aab0-0afb9334277d,49630106908387572488188190533472574108174215181487833090000000,gp2a7g2jmp7argv8rodd635hg6maodig7lse4do0,test-notification,2022-06-13T20:07:42Z,+15555555555,+11234567890,SUCCESSFUL,311489,1,Transactional,_SMS.BUFFERED
MDH-008,2026-10-20T14:32:09Z,5e4e4958-6812-ec11-aab0-0afb9334277d,93148615230689276209659873169003326594226396911541241987000000,09c4dca6-c339-4424-adb2-5c0d8670b80f,test-notification,2026-10-20T14:32:08Z,+15555555555,+11234567890,CARRIER_BLOCKED,311489,1,Transactional,TEXT_CARRIER_BLOCKED

Sample JSON Export

{
  "ParticipantIdentifier": "MDH-008",
  "Timestamp": "2022-06-13T20:07:43Z",
  "ParticipantID": "5e4e4958-6812-ec11-aab0-0afb9334277d",
  "SmsEventKey": "49630106908387572488188190533472574108174215181487833090000000",
  "MessageID": "gp2a7g2jmp7argv8rodd635hg6maodig7lse4do0",
  "NotificationIdentifier": "test-notification",
  "MessageTimestamp": "2022-06-13T20:07:42Z",
  "DestinationPhoneNumber": "+15555555555",
  "OriginationPhoneNumber": "+11234567890",
  "RecordStatus": "SUCCESSFUL",
  "MCCMNC": "311489",
  "NumberOfMessageParts": "1",
  "MessageType": "Transactional",
  "DetailedEventType": "_SMS.BUFFERED"
}
{
  "ParticipantIdentifier": "MDH-008",
  "Timestamp": "2026-10-20T14:32:09Z",
  "ParticipantID": "5e4e4958-6812-ec11-aab0-0afb9334277d",
  "SmsEventKey": "93148615230689276209659873169003326594226396911541241987000000",
  "MessageID": "09c4dca6-c339-4424-adb2-5c0d8670b80f",
  "NotificationIdentifier": "test-notification",
  "MessageTimestamp": "2026-10-20T14:32:08Z",
  "DestinationPhoneNumber": "+15555555555",
  "OriginationPhoneNumber": "+11234567890",
  "RecordStatus": "CARRIER_BLOCKED",
  "MCCMNC": "311489",
  "NumberOfMessageParts": "1",
  "MessageType": "Transactional",
  "DetailedEventType": "TEXT_CARRIER_BLOCKED"
}