Campaigns
Retrieve and modify campaigns.
Table Specific Information
Select
The connector will use the Salesforce Marketing Cloud Account Engagement API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the connector.
- Id supports '=', '<', '<=', '>', '>='.
- Name supports '='.
- CreatedAt supports '=', '<', '<=', '>', '>='.
- UpdatedAt supports '=', '<', '<=', '>', '>='.
For example, the following queries are processed server side:
SELECT * FROM Campaigns WHERE Id = 50 SELECT * FROM Campaigns WHERE Name = 'campaignName' SELECT * FROM Campaigns WHERE CreatedAt > '01/01/2022'
GetDeleted
To retrieve campaigns that are in the recycle bin in Pardot the following operation is supported:
GETDELETED FROM Campaings
Columns
| Name | Type | References | Description |
| Id [KEY] | Int64 | Pardot ID for this campaign. | |
| Name | String | Campaign's name. | |
| Cost | Integer | Cost associated to the campaign. | |
| IsDeleted | Boolean | True if the object is in the recycle bin in Pardot. | |
| FolderId | Int64 | ID of the folder containing this object. | |
| ParentCampaignId | Int64 | The ID of the parent campaign. | |
| CreatedAt | Datetime | The timestamp of when this object was created. | |
| UpdatedAt | Datetime | The timestamp of when this object was last updated. | |
| CreatedById | Int64 | ID of the individual who created this object. | |
| UpdatedById | Int64 | ID of the individual who last updated this object. | |
| SalesforceId | String | The alphanumeric Id of the Salesforce Org. |