AdGroups
Get a list of the ad_accounts that the User has access to.
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 | = |
| TranslateInterestsToNames | = |
For example:
SELECT * FROM AdGroups WHERE AdAccountId = '3457832451'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | Advertiser ID. | |
| AdAccountId | String |
AdAccounts.Id | Ad Account ID. |
| CampaignId | String |
Campaigns.Id | Campaign ID of the ad group. |
| FeedProfileId | String | Feed Profile ID associated to the adgroup. | |
| AutoTargetingEnabled | Boolean | Enable auto-targeting for ad group. | |
| BidInMicroCurrency | Integer | Bid price in micro currency. | |
| BillableEvent | String | Ad group billable event type.
The allowed values are CLICKTHROUGH, IMPRESSION, VIDEO_V_50_MRC. | |
| BudgetInMicroCurrency | Integer | Budget in micro currency. | |
| BudgetType | String | Budget type
The allowed values are DAILY, LIFETIME, CBO_ADGROUP. | |
| ConversionLearningModeType | String | oCPM learn mode
The allowed values are NOT_ACTIVE, ACTIVE. | |
| CreatedTime | Datetime | Ad group creation time. | |
| EndTime | Datetime | Ad group end time. | |
| LifetimeFrequencyCap | Integer | Set a limit to the number of times a promoted pin from this campaign can be impressed by a pinner within the past rolling 30 days. | |
| Name | String | Ad group name. | |
| PacingDeliveryType | String | PacingDeliveryType
The allowed values are STANDARD, ACCELERATED. | |
| PlacementGroup | String | PlacementGroup | |
| StartTime | Datetime | Ad group start time | |
| Status | String | Ad group/entity status.
The allowed values are ACTIVE, PAUSED, ARCHIVED, DRAFT, DELETED_DRAFT. | |
| SummaryStatus | String | Ad group summary status.
The allowed values are RUNNING, PAUSED, NOT_STARTED, COMPLETED, ADVERTISER_DISABLED, ARCHIVED, DRAFT, DELETED_DRAFT. | |
| TargetingSpec | String | Ad group targeting specification defining the ad group target audience. | |
| TrackingUrlsAudienceVerification | String | Third-party tracking URLs. | |
| TrackingUrlsBuyableButton | String | Third-party tracking URLs. | |
| TrackingUrlsClick | String | Third-party tracking URLs. | |
| TrackingUrlsEngagement | String | Third-party tracking URLs. | |
| TrackingUrlsImpression | String | Third-party tracking URLs. | |
| Type | String | Type of ad group. | |
| UpdatedTime | Datetime | Ad group last update time. | |
| IsCreativeOptimization | Boolean | Enable creative optimization for the ad group, default value is FALSE. When enabled, you allow Pinterest to automatically turn your product Pins into ads in different formats (collections and shopping) and deliver those ads to users at scale. | |
| PromotionId | String | Default:0, Promotion ID. To clear this field, set to null. | |
| PromotionApplicationLevel | String | Level at which promotions are applied to the ad group.
The allowed values are NONE, ITEM, AD_GROUP. | |
| PromotionIds | String | List of promotion IDs associated with the ad group. | |
| BidStrategyType | String | Bid strategy type.
The allowed values are AUTOMATIC_BID, MAX_BID, TARGET_AVG. | |
| TargetingTemplateIds | String | Targeting template IDs applied to the ad group. | |
| DCAAssets | String | The Dynamic creative assets to use for DCA. Dynamic Creative Assembly (DCA) accepts basic creative assets of an ad (image, video, title, call to action, logo etc). | |
| OptimizationGoalMetadataConversionTagv3AttributionWindowsClickWindowDays | Integer | Optimization Goal Metadata Conversion Tag v3 Attribution Windows Click Window Days | |
| OptimizationGoalMetadataConversionTagv3AttributionWindowsEngagementWindowDays | Integer | Optimization Goal Metadata Conversion Tag v3 Attribution Windows Engagement Window Days | |
| OptimizationGoalMetadataConversionTagv3AttributionWindowsViewWindowDays | Integer | Optimization Goal Metadata Conversion Tag v3 Attribution Windows View Window Days | |
| OptimizationGoalMetadataConversionTagv3ConversionEvent | String | Optimization Goal Metadata Conversion Tag v3 Conversion Event
The allowed values are PAGE_VISIT, SIGNUP, CHECKOUT, CUSTOM, VIEW_CATEGORY, SEARCH, ADD_TO_CART, WATCH_VIDEO, LEAD, APP_INSTALL. | |
| OptimizationGoalMetadataConversionTagv3ConversionTagId | String | Optimization Goal Metadata Conversion Tag v3 Conversion Tag Id | |
| OptimizationGoalMetadataConversionTagv3CPAGoalValueInMicroCurrency | String | Optimization Goal Metadata Conversion Tag v3 CPA Goal Value In Microcurrency | |
| OptimizationGoalMetadataConversionTagv3IsROASOptimized | Boolean | Pinterest Performance+ ROAS bidding. When enabled, Pinterest will optimize for conversion value instead of conversion volume. | |
| OptimizationGoalMetadataConversionTagv3ReportingEvent | String | Event name for custom or standard events mapped to an oCPM model. | |
| OptimizationGoalMetadataFrequencyGoalFrequency | Integer | Optimization Goal Metadata Frequency Goal Frequency. | |
| OptimizationGoalMetadataFrequencyGoalTimerange | String | Optimization Goal Metadata Frequency Goal Timerange.
The allowed values are THIRTY_DAY, DAY, SEVEN_DAY, TWENTY_MINUTE, TEN_MINUTE, TWENTY_FOUR_HOUR. | |
| OptimizationGoalMetadataScrollupGoalValueInMicroCurrency | String | Optimization Goal Metadata Scrollup Goal Value In MicroCurrency. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description | |
| TranslateInterestsToNames | Boolean | Return interests as text names and not topic IDs? |