AdGroups
Get a list of the ad_accounts that the User has access to.
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 |
| CampaignId | =, IN |
| Status | = |
| TranslateInterestsToNames | = |
For example:
SELECT * FROM AdGroups WHERE AdAccountId = '3457832451'
SELECT * FROM AdGroups WHERE CampaignId IN ('626759512981', '626759512982')
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The unique identifier of the ad group. | |
| AdAccountId | String |
AdAccounts.Id | The ID of the ad account associated with this ad group. |
| 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 | The type of budget applied to the ad group.
The allowed values are DAILY, LIFETIME, CBO_ADGROUP. | |
| ConversionLearningModeType | String | The oCPM (Optimized Cost Per Mile) learning mode status for the ad group.
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 | The pacing and delivery type for the ad group.
The allowed values are STANDARD, ACCELERATED. | |
| PlacementGroup | String | The placement group for the ad group.
The allowed values are ALL, SEARCH, BROWSE, OTHER. | |
| 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 | The third-party audience verification tracking URL for the ad group. | |
| TrackingUrlsBuyableButton | String | The third-party buyable button tracking URL for the ad group. | |
| TrackingUrlsClick | String | The third-party click tracking URL for the ad group. | |
| TrackingUrlsEngagement | String | The third-party engagement tracking URL for the ad group. | |
| TrackingUrlsImpression | String | The third-party impression tracking URL for the ad group. | |
| 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 | The bidding strategy applied to the ad group.
The allowed values are AUTOMATIC_BID, MAX_BID, TARGET_AVG. | |
| TargetingTemplateIds | String | The list of targeting template IDs applied to this 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 | The number of days in the click attribution window used to track conversions for the v3 conversion tag optimization goal. | |
| OptimizationGoalMetadataConversionTagv3AttributionWindowsEngagementWindowDays | Integer | The number of days in the engagement attribution window used to track conversions for the v3 conversion tag optimization goal. | |
| OptimizationGoalMetadataConversionTagv3AttributionWindowsViewWindowDays | Integer | The number of days in the view attribution window used to track conversions for the v3 conversion tag optimization goal. | |
| OptimizationGoalMetadataConversionTagv3ConversionEvent | String | The Pinterest tag conversion event tracked by the v3 conversion tag optimization goal.
The allowed values are PAGE_VISIT, SIGNUP, CHECKOUT, CUSTOM, VIEW_CATEGORY, SEARCH, ADD_TO_CART, WATCH_VIDEO, LEAD, APP_INSTALL. | |
| OptimizationGoalMetadataConversionTagv3ConversionTagId | String | The ID of the Pinterest tag used for the v3 conversion tag optimization goal. | |
| OptimizationGoalMetadataConversionTagv3CPAGoalValueInMicroCurrency | String | The target cost-per-action (CPA) goal value in microcurrency for the v3 conversion tag optimization goal. | |
| 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 | The target number of impressions per user for the frequency cap optimization goal. | |
| OptimizationGoalMetadataFrequencyGoalTimerange | String | The timerange over which the frequency cap optimization goal is enforced.
The allowed values are THIRTY_DAY, DAY, SEVEN_DAY, TWENTY_MINUTE, TEN_MINUTE, TWENTY_FOUR_HOUR. | |
| OptimizationGoalMetadataScrollupGoalValueInMicroCurrency | String | The target scroll-up goal value in microcurrency for the scrollup optimization goal. | |
| BidMultiplier | Double | Bid multiplier for the ad group. This value is a double between 0.1 and 10.0. Enter 0 to remove the bid multiplier. Not currently supported for Performance+ campaigns. |
Pseudocolumns
Pseudocolumn 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. |