You can create a regular, scheduled data export from Ometria to an AWS S3 bucket, Databricks, Google Cloud, Microsoft Azure, or an SFTP you host.
See also: Customised data export
SMS events data relates to your automation and broadcast SMS sends. The exported data includes all SMS events, e.g. sends, deliveries, clicks etc.
`null` - this means Ometria has no data for that field.| Field | Type | Description | |
| event_id | String |
The unique identifier for the event.
|
|
| uuid | String |
The universally unique identifier for the message sent.
|
|
| event_type | String |
The type of SMS event recorded. One of: sent, delivered, delivery_failed, clicked, unsubscribed.
|
|
| dt_occurred | Time |
The date and time the event occurred.
|
|
| customer_id | String |
The contact's Customer ID. Use this to join SMS events to your contact records.
|
|
| profile_hash | String |
A unique, encoded identifier for the contact's profile, sometimes called a profile ID.
|
|
| campaign_title | String |
The title of the campaign this message is part of.
|
|
| campaign_type | String |
The type of phone number the message was sent from, e.g. TF (toll-free), 10DLC, alphanumeric, or short code.
|
|
| node_id | String |
The unique ID of the send SMS action node in an automation campaign. This is only populated for automation campaigns.
|
|
| node_label | String |
The name you have given the send SMS action in an automation campaign. This is only populated for automation campaigns.
|
|
| channel_type | String |
The messaging channel. This is always sms for SMS events.
|
|
| direction | String |
Whether the message was sent to the contact or received from them.
|
|
| retailer_number | String |
The sender ID or number the message was sent from.
|
|
| contact_number | String |
The contact's phone number the message was sent to.
|
|
| country | String |
The country the contact's phone number is registered to.
|
|
| chargeable_units | Integer |
The number of message segments the send was charged as. Longer messages are split into more than one segment.
|
|
| send_classification | String |
Whether the message was sent as a marketing or transactional message.
|
|
| coupon_code | String |
The coupon code included in the message, if any.
|
|
| utm_params | String (JSON object) |
The campaign tracking parameters on the links in the message, as a JSON object.
|
|
| reason | String |
The reason a message failed, where applicable. This is null unless the event_type is delivery_failed.
|
|
| OMETRIA_EXPORTED_AT | Time |
The date and time the record was included in your export.
|
|
Comments
0 comments
Please sign in to leave a comment.