AdGroups
Get a list of the ad_accounts that the User has access to.
Table Specific Information
Select
The 本製品 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 本製品.
- 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. | |
| BudgetInMicroCurrency | Integer | Budget in micro currency. | |
| BudgetType | String | Budget type | |
| ConversionLearningModeType | String | oCPM learn mode | |
| 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 | |
| PlacementGroup | String | PlacementGroup | |
| StartTime | Datetime | Ad group start time | |
| Status | String | Ad group/entity status.
使用できる値は次のとおりです。ACTIVE, PAUSED, ARCHIVED | |
| SummaryStatus | String | Ad group summary status. | |
| 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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| TranslateInterestsToNames | Boolean | Return interests as text names and not topic IDs? |