Campaigns

Get account information for the operation user_account

Table Specific Information

Select

The add-in 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 add-in.

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. The allowed values are 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. The allowed values are 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. The allowed values are RUNNING, PAUSED, NOT_STARTED, COMPLETED, ADVERTISER_DISABLED, ARCHIVED, DRAFT, DELETED_DRAFT.
IsFlexibleDailyBudgets	Boolean		Is Flexible Daily Budgets.
IsCampaignBudgetOptimization	Boolean		Is Campaign Budget Optimization.

Excel Add-In for Pinterest

Campaigns

Table Specific Information

Select

Columns