Salesforce Marketing Cloud | Send Standard Dataset
ChannelMix
Below are the measures and dimensions Alight Analytics considers standard for Salesforce Marketing Cloud Send dataset. There is a 2 day lag and data is pulled for the previous 90 days.
| Field | Field Type | Description |
| Report Date | DATE | The date the email was sent |
| Additional | VARCHAR | Additional ID |
| Created Date | TIMESTAMP | Read-only date and time of the email's creation. |
| Duplicates | INTEGER | Represent the number of duplicate email addresses associated with a send. |
| Email Name | VARCHAR | Specifies the name of an email message associated with a send. |
| Existing Undeliverables | INTEGER | |
| Existing Unsubscribes | INTEGER | Indicates whether unsubscriptions occurred on previous send. |
| Forwarded Emails | INTEGER | Number of emails forwarded for a send. |
| From Address | VARCHAR | Indicates From address associated with a object. |
| From Name | VARCHAR | Specifies the default email message From Name. |
| Hard Bounces | INTEGER | Indicates number of hard bounces associated with a send. |
| ID | INTEGER | Message Delivery ID |
| Invalid Addresses | INTEGER | Specifies the number of invalid addresses associated with a send. |
| Is Always On | BOOLEAN | Indicates whether the request can be performed while the system is is maintenance mode. |
| Is Multipart | BOOLEAN | Indicates whether the email is sent with Multipart/MIME enabled. |
| Links | VARCHAR | Contains an array of links included in a send. |
| Missing Addresses | INTEGER | Specifies number of missing addresses encountered within a send. |
| Modified Date | TIMESTAMP | Indicates the last time the email was modified. |
| Number Delivered | INTEGER | Number of sent emails that did not bounce. |
| Number Errored | INTEGER | Number of emails not sent as part of a send because an error occurred while trying to build the email. |
| Number Excluded | INTEGER | Indicates the number recipients excluded froman email send because of a held, unsubscribed, master unsubscribed, or global unsubscribed status. |
| Number Sent | INTEGER | Number of emails actually sent as part of an email send. |
| Number Targeted | INTEGER | Indicates the number of possible recipients for an email send. |
| Objectid | VARCHAR | |
| Other Bounces | INTEGER | Specifies number of Other-type bounces in a send. |
| Partner Key | VARCHAR | |
| Partner Properties | VARCHAR | A collection of metadata supplied by the client and stored by the system. |
| Preview URL | VARCHAR | Indicates URL used to preview the message associated with a send. |
| Send Date | TIMESTAMP | Indicates the date on which a send occurred. |
| Sent Date | TIMESTAMP | Indicates date on which a send took place. |
| Soft Bounces | INTEGER | Indicates number of soft bounces associated with a specific send. |
| Status | VARCHAR | Defines status of an address. |
| Subject | VARCHAR | Contains subject area information for a message. |
| Unique Clicks | INTEGER | Indicates number of unique clicks on message. |
| Unique Opens | INTEGER | Indicates number of unique opens resulting from a triggered send. |
| Unsubscribes | INTEGER | Indicates the number of unsubscribe events associated with a send. |
| Client ID | INTEGER | Specifies the account ownership and context of an object. |
| Email Partner Key | INTEGER | |
| Email ID | INTEGER | Email ID |
| Email Object ID | INTEGER | |
| Email Send Definition Partner Key | VARCHAR | |
| Email Send Definition Customer Key | VARCHAR | |
| Email Send Definition Object ID | VARCHAR | |
| Insert Date | TIMESTAMP | |
| ChannelMix Profile | VARCHAR |