SearchAdsAdGroupAdServiceLabels
Retrieve the details of AdGroupAd 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 is required to make a request and the rest of the filter is executed client-side within the connector.
- AdId supports the '=,IN'.
- AccountId supports the '='.
- AdGroupId supports the '=,IN'.
- AdType supports the '=,IN'.
- ApprovalStatus supports the '=,IN'.
- CampaignId supports the '=,IN'.
- UserStatus supports the '=,IN'.
- ContainsLabelId supports the '='.
- LabelId supports the '='.
- StartDate supports the '='.
- EndDate supports the '='.
For example, the following queries are processed server side:
SELECT * FROM SearchAdsAdGroupAdServiceLabels WHERE AccountId = '25687';
SELECT * FROM SearchAdsAdGroupAdServiceLabels WHERE AccountId = '25687' AND AdId IN ('456971');
SELECT * FROM SearchAdsAdGroupAdServiceLabels WHERE AccountId = '25687' AND AdGroupId IN ('8520');
Columns
| Name | Type | References | Description |
| LabelId [KEY] | Int64 | Label Id. | |
| AdId | Int64 | Ad ID. | |
| AccountId | Int64 |
SearchAdsAccounts.AccountId | Account ID. |
| AdGroupId | Int64 |
SearchAdsAdGroups.AdGroupId | Ad group ID. |
| AdType | String | Device type and number of title and description character.
使用できる値は次のとおりです。EXTENDED_TEXT_AD, DYNAMIC_SEARCH_LINKED_AD, TEXT_AD2, APP_AD, RESPONSIVE_SEARCH_AD, UNKNOWN | |
| ApprovalStatus | String | Displays Editorial Status.
使用できる値は次のとおりです。APPROVED, APPROVED_WITH_REVIEW, REVIEW, PRE_DISAPPROVAL, POST_DISAPPROVAL, UNKNOWN | |
| CampaignId | Int64 |
SearchAdsCampaigns.CampaignId | Campaign ID. |
| UserStatus | String | Displays ad delivery status that can be set by an user.
使用できる値は次のとおりです。ACTIVE, PAUSED, UNKNOWN | |
| Color | String | Color. | |
| Description | String | Description. | |
| LabelName | String | Label name. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| ContainsLabel | String | Describes acquisition flag of label data.
使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN | |
| StartDate | Date | This is the start date of the search target period. | |
| EndDate | Date | This is the end date of the search target period. | |
| ReferenceNumber | String | This column will be used in Bulk operations to get specific values from the Temp tables. |