EmailPublication
The Email Publication DMO is a Data Cloud data model object (DMO) that contains information about a publication such as a campaign or an orchestration used in the Email channel
Columns
| Name | Type | References | Description |
| Body Text | Varchar | The text representation of an Email message. | |
| Click Through Percent | Double | The percentage of emails sent which contained a tracked URL that was clicked by the recipient. | |
| Click To Open Percent | Double | The quantity of emails where the tracked URL was clicked, compared with the quantity that were opened, expressed as a percentage. | |
| Created Date | Datetime | The date and time record was created. | |
| Data Source | Varchar | A reference ID for the logical name for a system that is the source of records identified by External Record Id. | |
| Data Source Object | Varchar | A reference ID for the logical name of the object where the record came from, whether that is the name of a cloud storage file or another connector’s external object. | |
| Delivery Percent | Double | The percentage of emails sent based on this template that were successfully delivered. | |
| Description | Varchar | Detailed description of an in-person appointment. | |
| Duration Seconds Quantity | Double | ||
| Email Publication Id | Varchar | A unique ID used as the primary key for Email Publication Id. | |
| Engagement Asset | Varchar | A reference ID to the engagement asset. | |
| Engagement Asset content | Varchar | A reference ID to the engagement asset content. | |
| Engagement Channel Type | Varchar | A reference ID to the type of engagement channel. | |
| Engagement Publication Number | Varchar | The engagement publication number. | |
| Engagement Publication Status | Varchar | The engagement publication status. | |
| Engagement Publication Type | Varchar | The engagement publication type. | |
| Engagement Topic Group | Varchar | A reference ID for the master list of topics that Engagements can be about. | |
| Error Message Text | Varchar | The text of the error message | |
| External Record Id | Varchar | A reference ID to an external data source system. | |
| External Source Id | Varchar | A reference ID for the system in which the External Record ID was assigned. | |
| Failed Record Count | Double | ||
| From Address | Varchar | Email address from which the emails are sent | |
| From Name | Varchar | The name of the person the email is from. | |
| Has Attachment | Varchar | True if an attachment is included in this email. | |
| HTML Body | Varchar | The HTML rendering of the email body. | |
| Internal Organization | Varchar | A reference ID to a business unit or other internal organization that owns the business account. | |
| Is Tracked | Varchar | ||
| Last Modified Date | Datetime | Date and time when the user last modified the record. | |
| Name | Varchar | The name of the Email publication. | |
| Open Percent | Double | The number of emails opened compared to the number of emails sent, expressed as a percentage. | |
| Opt Out Percent | Double | The quantity of emails that resulted in unsubscription, compared to the total number sent, expressed as a percentage. | |
| Parent Engagement Publication | Varchar | A reference ID for another publication. This relationship enables engagement publication hierarchies. | |
| Publication Attempts Number | Double | ||
| Publication Status Date | Datetime | ||
| Reply to Address | Varchar | The reply-to address set on the generated emails. | |
| Scheduled Date | Datetime | The scheduled date and time to send the email to recipients. | |
| Send Classification | Varchar | A reference ID that determines how consent is checked. Enum values: Transactional (for example, placing an order implies opt-in for an order confirmation email), Commercial (promotional email requiring opt-in) | |
| Send Mechanism Name | Varchar | The mechanism used to send this email. | |
| Successful Record Count | Double | ||
| Total Delivered Quantity | Double | The number of times emails based on this template have been successfully delivered. | |
| Total Hard Bounce Quantity | Double | The number of times emails based on this template have hard bounced due to invalid email addresses. | |
| Total Opens Quantity | Double | The number of times emails based on this template have been opened. | |
| Total Publication Items Count | Double | ||
| Total Sent Quantity | Double | The number of emails sent. | |
| Total Soft Bounce Quantity | Double | The number of times emails based on this template have soft bounced (returned by server). | |
| Total Spam Complaints Quantity | Double | The number of emails that were reported as spam. | |
| Total Tracked Link Clicks Quantity | Double | The number of tracked URLs in emails that were opened. | |
| Unique Click Through Percent | Double | The percentage of emails sent which contained a tracked URL that was clicked by unique recipients. | |
| Unique Opens Quantity | Double | The number of emails that were opened by unique recipients. | |
| Unique Opt Outs Quantity | Double | The total number of emails that resulted in recipients unsubscribing. | |
| Unique Tracked Link Clicks Quantity | Double | The number of tracked URLs in emails that were opened by unique recipients. |