Campaigns

Retrieve and modify campaigns.

テーブル固有の情報

connector はSalesforce Marketing Cloud Account Engagement API を使用して、以下のカラムと演算子で構築されたWHERE 句条件を処理します。その他のフィルタはクライアントサイドでconnector 内部で処理されます。

例えば、次のクエリはサーバーサイドで処理されます。

SELECT * FROM Campaigns WHERE Id = 50
SELECT * FROM Campaigns WHERE Name = 'campaignName'
SELECT * FROM Campaigns WHERE CreatedAt > '01/01/2022'

Pardot のごみ箱にあるキャンペーンを取得する場合、次の操作がサポートされています。

GETDELETED FROM Campaings


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.