Campaigns

Get account information for the operation user_account

Table Specific Information

Select

The 本製品 will use the Pinterest API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the 本製品.

AdAccountId supports the '=' operator.
Id supports the '=,IN' operator.
Status supports the '=' operator.

For example:

	
	SELECT * FROM Campaigns WHERE AdAccountId = '3457832451'

Columns


Name	Type	References	Description
Id [KEY]	String		Campaign ID.
AdAccountId	String	AdAccounts.Id	Campaign's Advertiser ID.
CreatedTime	Datetime		Campaign creation time.
DailySpendCap	Integer		Campaign total spending cap.
LifetimeSpendCap	Integer		Campaign daily spending cap.
Name	String		Campaign name.
ObjectiveType	String		Campaign objective type. 使用できる値は次のとおりです。AWARENESS, CONSIDERATION, VIDEO_VIEW, WEB_CONVERSION, CATALOG_SALES, WEB_SESSIONS, VIDEO_COMPLETION
OrderLineId	String		Order line ID that appears on the invoice.
Status	String		Entity status. 使用できる値は次のとおりです。ACTIVE, PAUSED, ARCHIVED, DRAFT, DELETED_DRAFT
TrackingUrlsAudienceVerification	String		Tracking Urls Audience Verification.
TrackingUrlsBuyableButton	String		Tracking Urls Buyable Button.
TrackingUrlsClick	String		Tracking Urls Click.
TrackingUrlsEngagement	String		Tracking Urls Engagement
TrackingUrlsImpression	String		Tracking Urls Impression.
Type	String		Type of campaign.
UpdatedTime	Datetime		Last update time.
StartTime	Datetime		Start time.
EndTime	Datetime		End time.
SummaryStatus	String		Summary status. 使用できる値は次のとおりです。RUNNING, PAUSED, NOT_STARTED, COMPLETED, ADVERTISER_DISABLED, ARCHIVED, DRAFT, DELETED_DRAFT
IsFlexibleDailyBudgets	Boolean		Is Flexible Daily Budgets.
IsCampaignBudgetOptimization	Boolean		Is Campaign Budget Optimization.

SSIS Components for Pinterest

Campaigns

Table Specific Information

Select

Columns