Campaigns

Represents campaigns in Salesforce Marketing Cloud. Each campaign groups related marketing efforts and performance metrics under a single initiative. This table allows you to create, update, delete, and query campaigns to manage lifecycle stages, track engagement, and associate related assets or audiences.

Table Specific Information

Select

Select all campaigns:

SELECT * FROM Campaigns

Retrieve a specific Campaign:

SELECT * FROM Campaigns WHERE Id = '3130'

Insert

To create a campaign, you will need to specify at least the Name column.

INSERT INTO [Campaigns] (Name, Description, CampaignCode, Color, Favorite) VALUES ('Test Camp', 'Test Description', 'tst 001', '0000ff', true)

Update

UPDATE operations are not supported for this table.

Delete

Campaigns may be deleted by providing the CampaignId of the campaign and issuing a DELETE statement.

DELETE FROM [Campaigns] WHERE Id = '5161'

Columns


Name	Type	ReadOnly	References	Filters	Description
Id [KEY]	Integer	True		=	Identifies the unique record for each campaign in Salesforce Marketing Cloud. This system-generated identifier (Id) serves as the primary key that is used to reference the campaign in API calls, analytics, and campaign management workflows. It ensures data integrity and supports reporting relationships across assets, sends, and journeys.
Name	String	False			Specifies the name that identifies the campaign. This user-defined value appears in Marketing Cloud dashboards, reports, and automation interfaces. Maintaining a clear and consistent naming convention helps users quickly locate and organize campaigns across business units.
CampaignCode	String	False			Stores the custom code that uniquely represents the campaign. This value can be used for cross-platform integration, analytics tracking, or external system synchronization. Campaign codes help align Marketing Cloud campaigns with third-party customer relationship management (CRM) or advertising identifiers.
Color	String	False			Defines the hexadecimal or predefined color value that represents the campaign visually in the user interface. This color helps users differentiate campaigns quickly in dashboards and overview reports.
Favorite	Boolean	False			A Boolean field that returns a value of 'true' when the campaign is marked as a favorite by the user. It returns a value of 'false' when it is not marked as a favorite. Marking a campaign as a favorite adds it to personalized quick-access lists within the user interface for faster navigation.
CreatedDate	Datetime	False			Records the date and time when the campaign was first created. This system-generated timestamp supports audit tracking, campaign lifecycle management, and time-based reporting. It is immutable and reflects the campaign's original creation event.
ModifiedDate	Datetime	False			Records the most recent date and time when the campaign was updated. This timestamp is automatically refreshed whenever campaign details or metadata are changed. It enables teams to track modification activity and identify recently edited campaigns.
Description	String	False			Provides a summary that explains the purpose, scope, or target audience of the campaign. This field supports search, categorization, and collaboration by offering context for marketing goals and key initiatives within Salesforce Marketing Cloud.