AdGroupCriteriaLabels
Retrieve the details of AdGroupCriteria Labels.The columns values set read-only false can be inserted in the parent table using Temp tables
Table Specific Information
Select
The connector will use the Yahoo! Ads API to process WHERE clause conditions built with the following column and operator. The AccountId and Use is required to make a request and the rest of the filter is executed client-side within the connector.
- AccountId supports the '='.
- AdGroupId supports the '=,IN'.
- CriterionId supports the '=,IN'.
- ApprovalStatus supports the '=,IN'.
- CampaignId supports the '=,IN'.
- KeywordMatchType supports the '='.
- CriterionKeywordText supports the '='.
- PortfolioBiddingId supports the '=,IN'.
- ContainsLabelId supports the '='.
- LabelIds supports the '=,IN'.
- UserStatus supports the '=,IN'.
- Usesupports the '='.
- Min supports the '='.
- Max supports the '='.
For example:
SELECT * FROM AdGroupCriteriaLabels WHERE AccountId = '1234339' AND USE = 'BIDDABLE' SELECT * FROM AdGroupCriteriaLabels WHERE AccountId = '1234339' AND USE = 'BIDDABLE' AND AdGroupId = '303252478'
Columns
| Name | Type | References | Description |
| LabelId [KEY] | Int64 | Label ID. | |
| CriterionId | Long | Criterion ID. | |
| AccountId | Int64 |
SearchAdsAccounts.AccountId | Account ID. |
| AdGroupId | Int64 |
SearchAdsAdGroups.AdGroupId | Ad group ID. |
| ApprovalStatus | String | Displays Editorial Status.
使用できる値は次のとおりです。APPROVED, APPROVED_WITH_REVIEW, REVIEW, PRE_DISAPPROVED, POST_DISAPPROVED, UNKNOWN | |
| UserStatus | String | Displays ad delivery status that can be set by an user.
使用できる値は次のとおりです。ACTIVE, PAUSED, UNKNOWN | |
| CampaignId | Int64 |
SearchAdsCampaigns.CampaignId | Campaign ID. |
| KeywordMatchType | String | Describes keyword match type.
使用できる値は次のとおりです。EXACT, PHRASE, BROAD, UNKNOWN | |
| KeywordText | String | AdGroupCriterionServiceKeyword element.Maximum of 80 letters, 10 words. | |
| Color | String | Color. | |
| Description | String | Description. | |
| LabelName | String | Label name. | |
| Use | String | Describes criterion to be selected.
使用できる値は次のとおりです。BIDDABLE, NEGATIVE, UNKNOWN |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| PortfolioBiddingId | Int64 | Auto bidding ID. | |
| ContainsLabelId | String | Describes acquisition flag of label data.
使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN | |
| LabelIds | Int64 | Label ID. | |
| Min | Int64 | Minimum value of the search range. | |
| Max | Int64 | Maximum value of the search range.. |