EmailTemplate
The Email Template DMO is a Data Cloud data model object (DMO) for the standard form of an email message that can be personalized and customized based on a campaign.
Columns
| Name | Type | References | Description |
| API Version | Varchar | The variant number of email API used with template. | |
| Body | Varchar | The content of an email. | |
| Created Date | Datetime | The date record was created. | |
| Data Source | Varchar | A reference ID for logical name for system that is source of records identified by External Record ID. | |
| Data Source Object | Varchar | A reference ID for the logical name of the object where this record came from, whether that is a name of a cloud storage file or another connector’s external object. | |
| Delivery Percent | Double | The percentage of emails based on template that were successfully delivered. | |
| Email Template Body Text | Varchar | Text representation of email. | |
| Email Template ID | Varchar | A unique ID used as primary key for Email Template DMO. | |
| Email Template Style | Varchar | A reference ID for enumeration values of Email Template Style: None, FreeForm, FormalLettter, PromotionRight, PromotionLeft, Newsletter, and Products. | |
| Email Template Type | Varchar | A reference ID for enumeration values of email template type, such as text or HTML. | |
| Engagement Asset Number | Varchar | A number assigned to an engagement asset. | |
| Engagement Asset Type | Varchar | A reference ID for the description of an engagement asset type, such as an email or phone. | |
| Engagement Message Type | Varchar | A reference ID for the description of an Engagement Message Type. Examples include: Outbound, Location Entry, Location Entry, Beacon. | |
| External Record ID | Varchar | A reference ID for an external data source system. | |
| External Source ID | Varchar | A reference ID for the system in which the external record ID was assigned. | |
| Internal Organization | Varchar | A reference ID for the business unit or other internal organization that owns the business account. | |
| Last Modified Date | Datetime | The date when user last modified record. | |
| Message Format Type | Varchar | A reference ID for description of the format of the asset/template. Examples include Landing Page, Application Alert. | |
| Name | Varchar | The engagement’s name. | |
| Namespace Prefix Text | Varchar | A value that defines a unique set of email templates. | |
| Parent Engagement Asset | Varchar | A reference ID to the parent record’s engagement asset. | |
| Send Classification | Varchar | A reference ID for the method of how user consents to email engagement, for example transactional or commercial. | |
| Subject | Varchar | The main topic of email. | |
| Times Used Quantity | Varchar | The number of times emails based on template has been used to create published emails. | |
| Total Delivered Quantity | Double | The number of times emails based on template that were successfully delivered. | |
| Total Hard Bounced Quantity | Double | The number of times emails based on template have hard bounced (invalid email address). | |
| Total Opens Quantity | Double | The number of times emails based on template have been opened. | |
| Total Sent Quantity | Double | The number of times published emails based on template have been sent. | |
| Total Soft Bounced Quantity | Double | The number of times emails based on template have soft bounced (returned by server). | |
| User Interface Type | Varchar | The description of type of user interface (UI) presented in received email message. |