ContentArea

Represents a content area (ContentArea) in Salesforce Marketing Cloud. A ContentArea defines a reusable section of content, such as text, images, or dynamic blocks, that can be inserted into multiple messages or templates. This table allows you to manage reusable content elements to ensure brand consistency and efficiency.

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 ContentArea WHERE Id = 123

SELECT * FROM ContentArea WHERE Id IN (123, 456)

SELECT * FROM ContentArea WHERE CreatedDate > '2017/01/25'

Insert

You must specify the following fields when inserting to this table: Name and Content.

INSERT INTO ContentArea (Name, Content) VALUES ('Testing', 'Hello world')

Update

You must specify the Id in the WHERE clause when executing an update against this table.

UPDATE ContentArea SET Name = 'Changed' WHERE Id = 123

Delete

You must specify the Id in the WHERE clause when executing a delete against this table.

DELETE FROM ContentArea WHERE Id = 123

Columns


Name	Type	ReadOnly	Description
RowObjectID	String	False	Specifies the system-controlled text string that uniquely identifies the individual row that represents the content area in the underlying data store. This value supports internal tracking and record reconciliation.
ObjectID	String	False	Specifies the system-controlled text string that uniquely identifies the content area object across API operations. This value ensures consistency when retrieving or updating content assets.
ID [KEY]	Int	False	Specifies the system-generated identifier (Id) that uniquely represents the content area within Salesforce Marketing Cloud. This Id is read-only and supports administrative and programmatic reference.
CustomerKey	String	False	Specifies the user-defined unique Id that is assigned to the content area within its object type. This value enables external systems and templates to reference the content area consistently across environments.
Client_ID	Int	False	Specifies the Id of the client context that is associated with the content area. This value determines the business unit in which the content area exists.
ModifiedDate	Datetime	False	Indicates the most recent date and time when the content area was updated. This value helps administrators track editorial and configuration changes.
CreatedDate	Datetime	False	Specifies the date and time when the content area was created. This value supports lifecycle tracking and audit requirements.
CategoryID	Int	False	Specifies the Id of the folder in which the content area is stored within Content Builder. This value supports folder-based organization and access control.
Name	String	False	Specifies the name that has been assigned to the content area. This value appears in Content Builder, search results, and API responses.
Layout	String	False	Specifies the layout type that is associated with the content area. This value determines how the content is structured or rendered in downstream email or content blocks.
IsDynamicContent	Bool	False	Returns a value of 'true' when the content area contains dynamic content that renders different output based on subscriber attributes or rules. It returns a value of 'false' when the content area contains static content only.
Content	String	False	Specifies the HTML or text content that the content area contains. This value represents the primary material used in email and template rendering.
IsSurvey	Bool	False	Returns a value of 'true' when the content area includes survey-related material that is intended to collect responses or feedback. It returns a value of 'false' when the content area does not include survey elements.
IsBlank	Bool	False	Returns a value of 'true' when the content area contains no content. It returns a value of 'false' when any content, markup, or whitespace is present.
Key	String	False	Specifies the internal key that Salesforce Marketing Cloud uses to reference the content area when it is included in HTML bodies or template constructs. This value ensures proper resolution during rendering.