CData Python Connector for Pinterest

Build 23.0.8839

Campaigns

Get account information for the operation user_account

Table Specific Information

Select

The connector 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 connector.

  • 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.
OrderLineId String Order line ID that appears on the invoice.
Status String Entity status.

The allowed values are ACTIVE, PAUSED, ARCHIVED.

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.
IsFlexibleDailyBudgets Boolean Is Flexible Daily Budgets.
IsCampaignBudgetOptimization Boolean Is Campaign Budget Optimization.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839