DisplayAdsAdGroupServiceLabels
Retrieve the details of AdGroup 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 The rest of the filter is executed client side within the connector.
- AdGroupId supports the '=,IN'.
- AccountId supports the '='.
- CampaignId supports the '=,IN'.
- UserStatus supports the '=,IN'.
- CampaignGoalFilterType supports the '='.
- ContainsLabel supports the '='.
- LabelId supports the '=,IN'.
- StartDate supports the '='.
- EndDate supports the '='.
SELECT * FROM DisplayAdsAdGroupServiceLabels WHERE AccountId = '1002504155' SELECT * FROM DisplayAdsAdGroupServiceLabels WHERE AccountId = '1002504155' AND AdGroupId = '437264177'
Columns
| Name | Type | References | Description |
| LabelId [KEY] | Int64 |
DisplayAdsLabels.LabelId | Label ID. |
| AdGroupId | Int64 |
DisplayAdsLabels.AdGroupId | Ad group ID. |
| AccountId | Int64 |
DisplayAdsAccounts.AccountId | Account ID. |
| CampaignId | Int64 |
DisplayAdsCampaigns.CampaignId | Campaign ID. |
| FeedSetId | Int64 |
FeedSets.FeedSetId | Feed set ID.If feedSetId is not specified in ADD operation, the default set is associated automatically |
| UserStatus | String | Ad delivery status that can be set by an user.This field is required in ADD operation
使用できる値は次のとおりです。ACTIVE, PAUSED, UNKNOWN | |
| Color | String | Color. | |
| Description | String | Description | |
| LabelName | String | Label Name |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| CampaignGoalFilterType | String | Setting for filtering campaigns (with campaignGoal) or (with no campaignGoal).
使用できる値は次のとおりです。ALL, NON_GOAL, UNKNOWN デフォルト値はALLです。 | |
| ContainsLabel | String | Flag of contains label ID. | |
| StartDate | Date | This is the start date of the search target period. | |
| EndDate | Date | This is the end date of the search target period. |