This page contains information about your SMS campaign-related data views. For more information on Open Data - Data views, see Data views overview.
SMS campaigns
View name: sms_campaigns_[customer_ID] (where customer_ID is your Emarsys account ID)
This view contains general information about your SMS campaigns.
It contains data from September 19, 2017 onwards.
| Data field | Description | Type |
|---|---|---|
| name | The name of the SMS campaign. | string |
| sender_name | The name of the sender. | string |
| message | The text of the SMS message. | string |
| include_unsubscribe_link | Unsubscribe link included or not. | boolean |
| trigger_type | Trigger type. Possible values are batch_now, ac and batch_later. |
string |
| campaign_id | The ID of the campaign that contains this message. | integer |
| event_time | The time when the campaign was created or modified. | timestamp |
| customer_id | The unique ID (account ID) of the customer. | integer |
| loaded_at | Loading date to Data Platform (UTC). | timestamp |
| business_unit | The provider's name (this field is currently always null). | string |
SMS send reports
View name: sms_send_reports_[customer_ID] (where customer_ID is your Emarsys account ID)
This view contains the SMS delivery information.
It contains data from September 19, 2017 onwards.
| Data field | Description | Type |
|---|---|---|
| bounce_type | The reason of the bounce. | string |
| campaign_id | The ID of the campaign that contains this message. | integer |
| contact_id | Emarsys internal unique contact ID. Same as the user_id values in the contact export files. |
integer |
| customer_id | The unique ID (account ID) of the customer. | integer |
| event_time | The time when the SMS message was sent. | timestamp |
| loaded_at | Loading date to Data Platform (UTC). | timestamp |
| message_id | The unique ID of the message. | string |
| status | The current status of the SMS sent by the SMS provider. | string |
SMS sends
View name: sms_sends_[customer_ID] (where customer_ID is your Emarsys account ID)
This view contains information about your sent SMS messages.
It contains data from September 19, 2017 onwards.
| Data field | Description | Type |
|---|---|---|
| message_id | The unique ID of the message. | string |
| launch_id | The unique ID of the related launch. | integer |
| contact_id | Emarsys internal unique contact ID. Same as the user_id values in the contact export files. |
integer |
| program_id | The ID of the program which sent this message (NULL since 2020-10-05). |
integer |
| campaign_id | The ID of the campaign that contains this message. | integer |
| customer_id | The unique ID (account ID) of the customer. | integer |
| loaded_at | Loading date to Data Platform (UTC). | timestamp |
| event_time | The exact time when the sms was sent (UTC). | timestamp |
| treatments.rti.id | The ID of a real-time interaction (populated from 2020-10-05). |
string |
| treatments.rti.run_id | The ID of an individual real-time interaction run instance (populated from 2020-10-05). |
string |
| treatments.ac.id | The ID of an automation center program (populated from 2020-10-05). |
integer |
| treatments.ac.run_id |
The ID of an automation center program run instance (populated from 2020-10-05). |
string |
SMS clicks
View name: sms_clicks_[customer_ID] (where customer_ID is your Emarsys account ID)
This view contains clicks on links of the SMS messages.
It contains data from September 19, 2017 onwards.
| Data field | Description | Type |
|---|---|---|
| launch_id | The unique ID of a launch. | integer |
| contact_id | Emarsys internal unique contact ID. Same as the user_id values in the contact export files. |
Integer |
| link_id | The ID of the link. | Integer |
| is_dry_run | If URL is intended for testing. | Boolean |
| user_agent | The user agent which made the clicks on behalf of the contact. | string |
| campaign_id |
The ID of the campaign that contains this message. |
Integer |
| event_time | The exact time when the event happened. |
timestamp |
| customer_id | The unique ID (account ID) of the customer. |
Integer |
| loaded_at | Time when the event has been loaded into the table. |
Nullable |
SMS unsubscribes
View name: sms_unsubscribes_[customer_ID] (where customer_ID is your Emarsys account ID)
This view contains the SMS-based subscription cancellation events.
It contains data from September 19, 2017 onwards.
| Data field | Description | Type |
|---|---|---|
| contact_id | Emarsys internal unique contact ID. Same as the user_id values in the contact export files. |
Integer |
| unsubscribe_type | Type of cancellation. | string |
| event_time | The exact time when the subscription cancellation happened (UTC). | timestamp |
| campaign_id | The ID of the campaign that contains this message. | integer |
| loaded_at | Loading date to Data Platform (UTC). | timestamp |
| customer_id | The unique ID (account ID) of the customer. | integer |