Template
Represents email templates in Salesforce Marketing Cloud. Each record defines the layout, content placeholders, and associated sender settings that are used to build emails. This view helps ensure standardized formatting and brand alignment across campaigns.
Table-Specific Information
Select
The connector uses the Salesforce Marketing Cloud APIs to process the following WHERE clause operators for all but date-time values: =, !=, <>, >, >=, <, <=, IN. For date-time values, only > and < are supported. The connector processes other filters client-side within the connector.
For example, the following (but not only) queries are processed server side:
SELECT * FROM Template WHERE ObjectID = 'nzxcaslkjd-123'
SELECT * FROM Template WHERE ObjectID IN ('nzxcaslkjd-123', 'nzxcaslkjd-456')
SELECT * FROM Template WHERE CreatedDate > '2017/01/25'
Columns
| Name | Type | Description |
| ObjectID | String | The system-generated text value that uniquely identifies this template object within Salesforce Marketing Cloud. |
| ID [KEY] | Int | The unique identifier (Id) for the record. This value is system-generated and cannot be modified. |
| Client_ID | Int | The Id that identifies the client account that owns or manages this template. |
| TemplateName | String | The name that identifies the template within the Salesforce Marketing Cloud application. This value helps administrators and content builders locate and reuse the template in email creation workflows. |
| LayoutHTML | String | The HTML markup that defines the structural layout, content regions, and visual framework of the template. This value allows designers to control formatting, placement of elements, and rendering behavior across email clients. |
| BackgroundColor | String | The color value that determines the background color applied to the template. This value influences visual branding and readability for the rendered email. |
| BorderColor | String | The color value that determines the border color that surrounds the template or its content regions. This value helps maintain consistent formatting and visual structure. |
| BorderWidth | Int | The numeric value that defines the width, in pixels, of the borders that appear around the template. This value controls how prominently the border is displayed in the final email design. |
| Cellpadding | Int | The numeric value that defines the internal padding, in pixels, within each table cell in the template layout. This value controls spacing between cell edges and content. |
| Cellspacing | Int | The numeric value that defines the spacing, in pixels, between individual table cells within the template layout. This value influences how tightly or loosely the table structure appears. |
| Width | Int | The numeric value that specifies the full pixel width of the template. This value determines how the template renders across various email clients and viewing panes. |
| Align | String | The alignment setting that determines how content within the template is positioned horizontally. This value influences layout presentation when the email is rendered. |
| ActiveFlag | Int | The numeric value that indicates whether the template is available for selection and use within the Salesforce Marketing Cloud account. A value of '1' typically indicates that the template is active. |
| CategoryID | Int | The Id that identifies the content validation category assigned to the email message that uses this template. This value allows systems to track the validation state for compliance and deliverability checks. |
| CategoryType | String | The value that identifies the type of categorization that links related objects across multiple requests. This value supports grouping, auditing, and coordinated processing of template-related operations. |
| OwnerID | Int | The Id that identifies the business unit (also known as the Member Identification value) that created the template within an Enterprise 2.0 account structure. This value supports security and content access controls. |
| HeaderContent_ID | Int | The Id that identifies the header content that is associated with the template. This value links the template to reusable content blocks. |
| HeaderContent_ObjectID | String | The system-generated text value that identifies the object that stores the header content associated with this template. |
| Layout_ID | Int | The Id that identifies the layout configuration that is assigned to the template. This value determines the structural framework used for rendering content. |
| Layout_LayoutName | String | The name of the layout that defines the structural arrangement and formatting rules used by the template. |
| CustomerKey | String | The user-supplied Id that uniquely identifies the template within the object type. This value supports custom integrations, automation, and cross-environment migrations. |
| TemplateSubject | String | The subject line text that the template applies to emails that are created from it. This value provides a default that helps standardize branding and communication patterns. |
| IsTemplateSubjectLocked | Bool | Returns a value of 'true' when the subject defined in the header content cannot be modified by emails that use this template. It returns a value of 'false' when the subject can be changed during email creation. |