| Column Name | Type | Max Length | Column Description | Default Value | Allow Null | Read Only |
|---|
| ID | Int32 | | The ID of the sent mailing. Typically referred to as MailingID or MessageID elsewhere. | | X | X |
| DripCampaignID | Int32 | | The ID of the automation | | X | X |
| smsName | String | 2000 | The Name of the SMS Campaign | | X | X |
| smsType | String | 20 | The Type of SMS Campaign | | X | X |
| sent | Int32 | | Number of sent recipients | | X | X |
| delivered | Int32 | | Number of successfully delivered recipients | | X | X |
| undelivered | Int32 | | Number of unsuccessful delivered recipients | | X | X |
| unknown | Int32 | | | | X | X |
| unique_clicks | Int32 | | Number of unique clickthroughs | | X | X |
| total_clicks | Int32 | | Total number of clickthroughs | | X | X |
| unique_clickStreams | Int32 | | Number of unique clickstreams | | X | X |
| total_clickStreams | Int32 | | Total number of clickstreams | | X | X |
| lastSent | DateTime | | DateTime of the the last recipient was sent | | X | X |
| purchasesCommerce | Int32 | | Total sum of purchases | | X | X |
| revenueCommerce | Decimal | | Total sum of revenue | | X | X |