SMSMTEvent
Contains information about outbound (mobile-terminated) Short Message Service (SMS) messages that were are to subscribers in Salesforce Marketing Cloud. Each record includes message identifiers (Ids), timestamps, and delivery results for mobile messaging analysis.
View-Specific Information
Select
The connector uses the Salesforce Marketing Cloud APIs to process the following WHERE clause operators for all but date-time values: =, !=, <>, >, >=, <, <=, IN. For date-time values, only > and < are supported. The connector processes other filters client-side within the connector.
For example, the following (but not only) queries are processed server side:
SELECT * FROM SMSMTEvent WHERE ObjectID = 'nzxcaslkjd-123'
SELECT * FROM SMSMTEvent WHERE ObjectID IN ('nzxcaslkjd-123', 'nzxcaslkjd-456')
SELECT * FROM SMSMTEvent WHERE CreatedDate > '2017/01/25'
Columns
| Name | Type | Description |
| ObjectID [KEY] | String | Specifies the system-controlled text string that serves as the unique identifier (Id) for the event record that is generated when a Short Message Service (SMS) message is delivered to a mobile device as part of a mobile-terminated (MT) interaction. This Id ensures that the platform can reliably reference and track the event. |
| EventDate | Datetime | Indicates the date and time when the mobile-terminated SMS tracking event occurred. |
| Client_ID | Long | Specifies the Id of the client that owns or administers the SMS configuration associated with this event. |
| MOCode | String | Specifies the mobile-originated (MO) code that is associated with the MO or MT tracking event. This value identifies the keyword or short code path that triggered the interaction. |
| SMSTriggeredSend_SMSSendId | String | Specifies the Id of the specific SMS send operation that is associated with the triggered send event. |
| SMSTriggeredSend_SMSTriggeredSendDefinition_ObjectID | String | Specifies the system-controlled text string identifier that is associated with the triggered send definition used for this SMS event. |
| SMSTriggeredSend_SMSTriggeredSendDefinition_CustomerKey | String | Specifies the user-supplied unique identifier for the triggered send definition that governs how the SMS message was generated and delivered. |
| Subscriber_ID | Int | Specifies the Id of the subscriber for whom the SMS tracking event was recorded. |
| Subscriber_SubscriberKey | String | Specifies the subscriber key that identifies the individual subscriber associated with the SMS event. |
| Subscriber_PrimarySMSAddress_Address | String | Specifies the primary SMS address that is associated with the subscriber's profile and used for message delivery. |
| Carrier | String | Specifies the mobile carrier that is associated with the subscriber's SMS address and used to route the message through the appropriate network. |