The Email Publication DMO represents a publication, such as a campaign or an orchestration, used in the email channel.
Object API Name
ssot__EmailPublication__dlm
Category
Engagement
Primary Subject Area
Engagement
Primary Key
Email Publication Id (ssot__Id__c)
Relationships
| Object | Field | Cardinality | Related Object | Related Field |
|---|---|---|---|---|
| Object | Field | Cardinality | Related Object | Related Field |
| Email Engagement | Engagement Publication | ManyToOne | Email Publication | Email Publication Id |
All Fields
| 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 |