SearchAdsCampaignServiceLabels
Retrieve the details of Campaign 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 '='.
- CampaignId supports the '=,IN'.
- BiddingStrategyConfigurationBiddingStrategyId supports the '=,IN'.
- StartDate supports the '='.
- EndDate supports the '='.
- UserStatus supports the '=,IN'.
- ContainsLabel supports the '='.
- LabelId supports the '=,IN'.
- MinBudgetAmount supports the '='.
- MaxBudgetAmount supports the '='.
For example:
SELECT * FROM SearchAdsCampaignServiceLabels WHERE AccountId = '12346' SELECT * FROM SearchAdsCampaignServiceLabels WHERE AccountId = '12346' AND CampaignId = '9756' SELECT * FROM SearchAdsCampaignServiceLabels WHERE AccountId = '12346' AND StartDate = '2021-01-21' AND EndDate = '2021-02-03' SELECT * FROM SearchAdsCampaignServiceLabels WHERE AccountId = '12346' AND UserStatus = 'UNKNOWN' SELECT * FROM SearchAdsCampaignServiceLabels WHERE AccountId = '12346' AND ContainsLabel = 'TRUE' SELECT * FROM SearchAdsCampaignServiceLabels WHERE AccountId = '12346' AND MinBudgetAmount = '1' AND MaxBudgetAmount = '1000'
Columns
| Name | Type | References | Description |
| LabelId [KEY] | Int64 | Label ID. | |
| Color | String | Color. | |
| Description | String | Description. | |
| LabelName | String | Label name. | |
| CampaignId | Int64 | Campaign ID. | |
| AccountId | Int64 |
SearchAdsAccounts.AccountId | Account ID. |
| BiddingStrategyConfigurationBiddingStrategyId | Int64 | Auto Bidding ID. This field cannot be specified when Standard bidding is setting, and is required when Portfolio bidding is setting in ADD operation. It cannot be specified at the same times as biddingScheme. | |
| StartDate | Date | Start date of Campaign. The default value in ADD operation will be Today's date. The default value in ADD operation will be Today's date. Cannot set the past date. Cannot change the date to the campaign that is already active. | |
| EndDate | Date | End date of Campaign. The default value in ADD operation will be 20371231. Cannot set the past date and date before the start date. | |
| UserStatus | String | Displays ad delivery status that can be set by an user.
使用できる値は次のとおりです。ACTIVE, PAUSED, UNKNOWN |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| ContainsLabel | String | acquisition flag of label data
使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN | |
| MinBudgetAmount | Int64 | Minimum value of the search range. | |
| MaxBudgetAmount | Int64 | Maximum value of the search range. |