Email Publication DMO
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
ssot__EmailPublication__dlm
Engagement
Engagement
Email Publication Id (ssot__Id__c)
| Object | Field | Cardinality | Related Object | Related Field |
|---|---|---|---|---|
| Object | Field | Cardinality | Related Object | Related Field |
| Email Engagement | Engagement Publication | ManyToOne | Email Publication | Email Publication Id |
| Field Name | Field API Name | Description | Data Type |
|---|---|---|---|
| Body Text | ssot__BodyTxt__c | The text representation of an Email message. | text |
| Click Through Percent | ssot__ClickThroughPct__c | The percentage of emails sent which contained a tracked URL that was clicked by the recipient. | number |
| Click To Open Percent | ssot__ClickToOpenPct__c | The quantity of emails where the tracked URL was clicked, compared with the quantity that were opened, expressed as a percentage. | number |
| Created Date | ssot__CreatedDate__c | The date and time record was created. | datetime |
| Data Source | ssot__DataSourceId__c | A reference ID for the logical name for a system that is the source of records identified by External Record Id. | text |
| Data Source Object | ssot__DataSourceObjectId__c | 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. | text |
| Delivery Percent | ssot__DeliveryPct__c | The percentage of emails sent based on this template that were successfully delivered. | number |
| Description | ssot__Description__c | Detailed description of an in-person appointment. | text |
| Duration Seconds Quantity | ssot__DurationSecondsQty__c | number | |
| Email Publication Id | ssot__Id__c | A unique ID used as the primary key for Email Publication Id. | text |
| Engagement Asset | ssot__EnagementAssetId__c | A reference ID to the engagement asset. | text |
| Engagement Asset content | ssot__EnagementAssetContentId__c | A reference ID to the engagement asset content. | text |
| Engagement Channel Type | ssot__EngagementChannelTypeId__c | A reference ID to the type of engagement channel. | text |
| Engagement Publication Number | ssot__EngagementPublicationNbr__c | The engagement publication number. | text |
| Engagement Publication Status | ssot__EngagementPublicationStatusId__c | The engagement publication status. | text |
| Engagement Publication Type | ssot__EnagementPublicationTypeId__c | The engagement publication type. | text |
| Engagement Topic Group | ssot__EngagementTopicGroupId__c | A reference ID for the master list of topics that Engagements can be about. | text |
| Error Message Text | ssot__ErrorMessageTxt__c | The text of the error message | text |
| External Record Id | ssot__ExternalRecordId__c | A reference ID to an external data source system. | text |
| External Source Id | ssot__ExternalSourceId__c | A reference ID for the system in which the External Record ID was assigned. | text |
| Failed Record Count | ssot__FailedRecordCt__c | number | |
| From Address | ssot__FromAddr__c | Email address from which the emails are sent | text |
| From Name | ssot__FromName__c | The name of the person the email is from. | text |
| Has Attachment | ssot__HasAttachment__c | True if an attachment is included in this email. | text |
| HTML Body | ssot__HTMLBodyTxt__c | The HTML rendering of the email body. | text |
| Internal Organization | ssot__InternalOrganizationId__c | A reference ID to a business unit or other internal organization that owns the business account. | text |
| Is Tracked | ssot__IsTracked__c | text | |
| Last Modified Date | ssot__LastModifiedDate__c | Date and time when the user last modified the record. | datetime |
| Name | ssot__Name__c | The name of the Email publication. | text |
| Open Percent | ssot__OpenPct__c | The number of emails opened compared to the number of emails sent, expressed as a percentage. | number |
| Opt Out Percent | ssot__OptOutPct__c | The quantity of emails that resulted in unsubscription, compared to the total number sent, expressed as a percentage. | number |
| Parent Engagement Publication | ssot__ParentEngagementPublicationId__c | A reference ID for another publication. This relationship enables engagement publication hierarchies. | text |
| Publication Attempts Number | ssot__PublicationAttemptsNbr__c | number | |
| Publication Status Date | ssot__PublicationStatusDt__c | datetime | |
| Reply to Address | ssot__ReplyToAddr__c | The reply-to address set on the generated emails. | text |
| Scheduled Date | ssot__ScheduledDt__c | The scheduled date and time to send the email to recipients. | datetime |
| Send Classification | ssot__SendClassificationId__c | 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) | text |
| Send Mechanism Name | ssot__SendMechanismName__c | The mechanism used to send this email. | text |
| Successful Record Count | ssot__SuccessfulRecordCt__c | number | |
| Total Delivered Quantity | ssot__TotalDeliveredQty__c | The number of times emails based on this template have been successfully delivered. | number |
| Total Hard Bounce Quantity | ssot__TotalHardBounceQty__c | The number of times emails based on this template have hard bounced due to invalid email addresses. | number |
| Total Opens Quantity | ssot__TotalOpensQty__c | The number of times emails based on this template have been opened. | number |
| Total Publication Items Count | ssot__TotalPublicationItemsCt__c | number | |
| Total Sent Quantity | ssot__TotalSentQty__c | The number of emails sent. | number |
| Total Soft Bounce Quantity | ssot__TotalSoftBounceQty__c | The number of times emails based on this template have soft bounced (returned by server). | number |
| Total Spam Complaints Quantity | ssot__TotalSpamComplaintsQty__c | The number of emails that were reported as spam. | number |
| Total Tracked Link Clicks Quantity | ssot__TotalTrackedLinkClicksQty__c | The number of tracked URLs in emails that were opened. | number |
| Unique Click Through Percent | ssot__UniqueClickThroughPct__c | The percentage of emails sent which contained a tracked URL that was clicked by unique recipients. | number |
| Unique Opens Quantity | ssot__UniqueOpensQty__c | The number of emails that were opened by unique recipients. | number |
| Unique Opt Outs Quantity | ssot__UniqueOptOutsQty__c | The total number of emails that resulted in recipients unsubscribing. | number |
| Unique Tracked Link Clicks Quantity | ssot__UniqueTrackedLinkClicksQty__c | The number of tracked URLs in emails that were opened by unique recipients. | number |