CampaignAssets
Maintains relationships between campaigns and their associated assets in Salesforce Marketing Cloud. Each record links campaign initiatives with digital assets such as email templates, images, or social media content. This table supports create, update, delete, and query operations for managing campaign resources effectively.
View Specific Information
Select
Select all campaign assets for a specific campaign:
SELECT * FROM CampaignAssets WHERE CampaignId = '3130'
Retrieve a specific Campaign:
SELECT * FROM CampaignAssets WHERE CampaignId = '3130' AND Id = '3325'
Columns
| Name | Type | ReadOnly | References | Filters | Description |
| Id [KEY] | Integer | True | = |
Identifies the unique record for each campaign asset in Salesforce Marketing Cloud. This system-generated identifier (Id) serves as the primary key that is used to reference the campaign asset in API calls, reporting, and campaign management workflows. | |
| CampaignId | Integer | True | = |
Stores the Id of the campaign with which that the asset is associated. This value links the asset to its parent campaign, allowing Marketing Cloud to group and report assets that contribute to a specific marketing initiative. It ensures data integrity and supports cross-channel campaign tracking. | |
| Type | String | False |
Specifies the classification or type of campaign asset (for example, 'Email', 'Landing Page', or 'Content Block'). This field determines how the asset is processed and displayed in campaign analytics and reporting dashboards. | ||
| ItemId | String | False |
Stores the internal object Id that represents the specific asset within Salesforce Marketing Cloud. This value links the campaign asset record to its source object, such as a Content Builder item or send definition, enabling end-to-end traceability between campaign components and asset instances. | ||
| CreatedDate | Datetime | False |
Records the exact date and time when the campaign asset was created. This timestamp is system-generated and used for audit trails, campaign versioning, and time-based analytics. It helps marketers track asset creation trends and manage campaign lifecycle events. |