Campaigns
Query Campaigns for a Marketo organization.
Select
Note: Filters provided with one of the supported operators listed in the "Operators" column are processed server-side, all the other filters are processed client-side.
SELECT * FROM Campaigns WHERE Id='1037'
SELECT * FROM Campaigns WHERE Id IN (1037, 1055, 1058)
SELECT * FROM Campaigns WHERE Name='TestCampaign1'
SELECT * FROM Campaigns WHERE Name='test' AND WorkspaceName='Default'
SELECT * FROM Campaigns WHERE ProgramName='Program6'
Columns
| Name | Type | Operators | Description |
| Id [KEY] | Int | =,IN | The unique, Marketo-assigned identifier of the campaign. |
| Name | String | =,IN | The name of the campaign. |
| Description | String | The description of the campaign. | |
| Type | String | The campaign type. | |
| ProgramId | Int | The Id of the program associated with the campaign. | |
| ProgramName | String | =,IN | The name of the program associated with the campaign. |
| WorkspaceName | String | =,IN | The name of the workspace associated with the campaign. |
| Active | Bool | Identifies whether the campaign is active. | |
| CreatedAt | Datetime | The date and time the campaign was created. | |
| UpdatedAt | Datetime | The date and time the campaign was last updated. |