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.

Excel Add-In for Marketo

Campaigns

Select

Columns