AdGroups
Get a list of the ad_accounts that the User has access to.
Table Specific Information
Select
The add-in 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 add-in.
- AdAccountId supports the '=' operator.
- Id supports the '=,IN' operator.
- Status supports the '=' operator.
- TranslateInterestsToNames supports the '=' operator.
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. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description | |
| TranslateInterestsToNames | Boolean | Return interests as text names and not topic IDs? |