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 contains the following fields:

SMS Notification Link Clicked

The SMS Notification Link Clicked file contains the following fields.

[Legacy] SMS Notification Sent

The SMS Notification Sent file contains the following fields.

Sample CSV Export

ParticipantIdentifier,Timestamp,ParticipantID,SmsEventKey,MessageID,NotificationIdentifier,MessageTimestamp,DestinationPhoneNumber,OriginationPhoneNumber,RecordStatus,MCCMNC,NumberOfMessageParts,MessageType
MDH-008,2022-06-13T20:07:43Z,5e4e4958-6812-ec11-aab0-0afb9334277d,49630106908387572488188190533472574108174215181487833090000000,gp2a7g2jmp7argv8rodd635hg6maodig7lse4do0,valentine-test-notification-2,2022-06-13T20:07:42Z,+17344172047,+19382231360,SUCCESSFUL,311489,1,Transactional

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": "+11234567890",
 "OriginationPhoneNumber": "+19876543210,
 "RecordStatus": "SUCCESSFUL",
 "MCCMNC": "311489",
 "NumberOfMessageParts": "1",
 "MessageType": "Transactional"
}