Campaigns
Get account information for the operation user_account
View-Specific Information
SELECT
The provider uses the Pinterest API to process WHERE clause conditions built with the following columns and operators. Any remaining filters are processed client-side within the provider.
| Column | Supported Operators |
| AdAccountId | = |
| Id | =, IN |
| Status | = |
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. Deprecated values are WEB_SESSIONS and VIDEO_VIEW (use VIDEO_COMPLETION instead).
The allowed values are AWARENESS, CONSIDERATION, WEB_CONVERSION, CATALOG_SALES, VIDEO_COMPLETION, APP_INSTALL, SALES, LEADS, WEB_SESSIONS, VIDEO_VIEW. | |
| 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. | |
| IsAutomatedCampaign | Boolean | Specifies whether the campaign was created in the automated campaign flow. | |
| IsPerformancePlus | Boolean | Enable Pinterest Performance+ for your campaign | |
| BidOptionsAgeBucketMultipliersAgeBucket | String | Age bucket identifier.
The allowed values are 18-24, 19+, 20+, 21+, 25-34, 35-44, 45-49, 50-54, 55-64, 65+. | |
| BidOptionsAgeBucketMultipliersProperty1 | Double | Bid multiplier value for age bucket targeting. | |
| BidOptionsAgeBucketMultipliersProperty2 | Double | Bid multiplier value for age bucket targeting. | |
| BidOptionsAppTypeMultipliersAppType | String | App type identifier.
The allowed values are android_mobile, android_tablet, ipad, iphone, web, web_mobile. | |
| BidOptionsAppTypeMultipliersProperty1 | Double | Bid Options App Type Multipliers Property1. | |
| BidOptionsAppTypeMultipliersProperty2 | Double | Bid Options App Type Multipliers Property2. | |
| BidOptionsAudienceMultipliersAudienceId | String | Audience ID for the multiplier. | |
| BidOptionsAudienceMultipliersProperty1 | Double | Bid multiplier value for audience targeting. Must be between 0 and 10. | |
| BidOptionsAudienceMultipliersProperty2 | Double | Bid multiplier value for audience targeting. Must be between 0 and 10. | |
| BidOptionsGenderMultipliersGender | String | Gender identifier.
The allowed values are unknown, male, female. | |
| BidOptionsGenderMultipliersProperty1 | Double | Bid multiplier value for gender targeting. | |
| BidOptionsGenderMultipliersProperty2 | Double | Bid multiplier value for gender targeting. | |
| BidOptionsPlacementMultipliersPlacement | String | Placement type for bid multiplier targeting.
The allowed values are SEARCH, BROWSE, RELATED_PINS. | |
| BidOptionsPlacementMultipliersProperty1 | Double | Bid Options Placement Multipliers Property1. | |
| BidOptionsPlacementMultipliersProperty2 | Double | Bid Options Placement Multipliers Property2 | |
| BidOptionsFrequencyMultipliersImpressionCount | String | Impression count identifier. | |
| BidOptionsFrequencyMultipliersProperty1 | Double | Bid Options Frequency Multipliers Property1. | |
| BidOptionsFrequencyMultipliersProperty2 | Double | Bid Options Frequency Multipliers Property2 | |
| BidOptionsFreqBidMultiplierTimeWindow | String | The time window for frequency bid multipliers.
The allowed values are WEEK, MONTH. |