Campaigns
Get account information for the operation user_account
View-Specific Information
SELECT
The connector 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 connector.
| Column | Supported Operators |
| AdAccountId | = |
| Id | =, IN |
| Status | = |
For example:
SELECT * FROM Campaigns WHERE AdAccountId = '3457832451'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The unique identifier of the campaign. | |
| AdAccountId | String |
AdAccounts.Id | The ID of the ad account associated with this campaign. |
| CreatedTime | Datetime | Campaign creation time. | |
| DailySpendCap | Integer | The daily spending cap for the campaign in microcurrency. | |
| LifetimeSpendCap | Integer | The lifetime spending cap for the campaign in microcurrency. | |
| Name | String | The name of the campaign. | |
| 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 | The current status of the campaign.
The allowed values are ACTIVE, PAUSED, ARCHIVED, DRAFT, DELETED_DRAFT. | |
| TrackingUrlsAudienceVerification | String | The third-party audience verification tracking URL for the campaign. | |
| TrackingUrlsBuyableButton | String | The third-party buyable button tracking URL for the campaign. | |
| TrackingUrlsClick | String | The third-party click tracking URL for the campaign. | |
| TrackingUrlsEngagement | String | The third-party engagement tracking URL for the campaign. | |
| TrackingUrlsImpression | String | The third-party impression tracking URL for the campaign. | |
| Type | String | The type of the campaign. | |
| UpdatedTime | Datetime | The date and time when the campaign was last updated. | |
| StartTime | Datetime | The scheduled start time for the campaign. | |
| EndTime | Datetime | The scheduled end time for the campaign. | |
| SummaryStatus | String | The computed delivery status of the campaign, which may differ from the entity status.
The allowed values are RUNNING, PAUSED, NOT_STARTED, COMPLETED, ADVERTISER_DISABLED, ARCHIVED, DRAFT, DELETED_DRAFT. | |
| IsFlexibleDailyBudgets | Boolean | Indicates whether flexible daily budgets are enabled for the campaign. | |
| IsCampaignBudgetOptimization | Boolean | Indicates whether campaign budget optimization is enabled for the campaign. | |
| IsAutomatedCampaign | Boolean | Specifies whether the campaign was created in the automated campaign flow. | |
| IsPerformancePlus | Boolean | Indicates whether Pinterest Performance+ is enabled for the campaign. | |
| BidOptionsAgeBucketMultipliersAgeBucket | String | The age range identifier to which the bid multiplier is applied.
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 | The app type identifier to which the bid multiplier is applied.
The allowed values are android_mobile, android_tablet, ipad, iphone, web, web_mobile. | |
| BidOptionsAppTypeMultipliersProperty1 | Double | The first bid multiplier value applied to the specified app type. | |
| BidOptionsAppTypeMultipliersProperty2 | Double | The second bid multiplier value applied to the specified app type. | |
| BidOptionsAudienceMultipliersAudienceId | String | The ID of the audience to which the bid multiplier is applied. | |
| 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 | The gender identifier to which the bid multiplier is applied.
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 | The first bid multiplier value applied to the specified placement type. | |
| BidOptionsPlacementMultipliersProperty2 | Double | The second bid multiplier value applied to the specified placement type. | |
| BidOptionsFrequencyMultipliersImpressionCount | String | The impression count identifier to which the frequency bid multiplier is applied. | |
| BidOptionsFrequencyMultipliersProperty1 | Double | The first bid multiplier value applied to the specified impression count bucket. | |
| BidOptionsFrequencyMultipliersProperty2 | Double | The second bid multiplier value applied to the specified impression count bucket. | |
| BidOptionsFreqBidMultiplierTimeWindow | String | The time window for frequency bid multipliers.
The allowed values are WEEK, MONTH. | |
| DefaultAdGroupBudgetInMicroCurrency | Integer | When transitioning from campaign budget optimization to non-campaign budget optimization, this value propagates to each child ad group's daily budget. Unit is micro currency of the associated advertiser account. |