DisplayAdsAdGroupAdServiceLabels
Retrieve the details of AdGroupAdService 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.
- AccountId supports the '='.
- AdGroupId supports the '=,IN'.
- AdId supports the '=,IN'.
- ApprovalStatus supports the '=,IN'.
- CampaignId supports the '=,IN'.
- MediaId 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 DisplayAdsAdGroupAdServiceLabels WHERE AccountId = '125466'
SELECT * FROM DisplayAdsAdGroupAdServiceLabels WHERE AccountId = '123436' AND AdId IN ('4561','6996')
SELECT * FROM DisplayAdsAdGroupAdServiceLabels WHERE AccountId = '123436' AND ApprovalStatus IN ('APPROVED','APPROVED_WITH_REVIEW')
SELECT * FROM DisplayAdsAdGroupAdServiceLabels WHERE AccountId = '123436' AND MediaId IN ('12644','325687') AND UserStatus IN ('ACTIVE')
SELECT * FROM DisplayAdsAdGroupAdServiceLabels WHERE AccountId = '123436' AND CampaignGoalFilterType = 'ALL'
SELECT * FROM DisplayAdsAdGroupAdServiceLabels WHERE AccountId = '123436' AND ContainsLabel = 'True' AND LabelId IN ('5697122')
SELECT * FROM DisplayAdsAdGroupAdServiceLabels WHERE AccountId = '123436' AND StartDate = '2021-06-03' AND EndDate = '2021-06-28'
Columns
| Name | Type | References | Description |
| LabelId [KEY] | Int64 | Label ID. | |
| AdId | Int64 | Ad ID | |
| AccountId | Int64 |
DisplayAdsAccounts.AccountId | Account ID |
| AdGroupId | Int64 |
DisplayAdsAdGroups.AdGroupId | Ad group ID |
| ApprovalStatus | String | Editorial status
使用できる値は次のとおりです。APPROVED, APPROVED_WITH_REVIEW, REVIEW, PRE_DISAPPROVED, POST_DISAPPROVED, UNKNOWN | |
| CampaignId | Int64 |
DisplayAdsCampaigns.CampaignId | Campaign ID |
| MediaId | Int64 |
Media.MediaId | Media ID |
| UserStatus | String | 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 | |
| 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 | start date of the search target period. | |
| EndDate | Date | This is the end date of the search target period. |