SearchAdsRetargetingListRuleBaseTargetListRuleRuleItems
Retrieves the details of RetargetingList RuleBaseTargetList Rule RuleItems.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 '='.
- TargetListId supports the '=,IN'.
- TargetListOwner supports the '='.
- TargetListType supports the '=,IN'.
For example:
SELECT * FROM SearchAdsRetargetingListRuleBaseTargetListRuleRuleItems WHERE AccountId = '125466' SELECT * FROM SearchAdsRetargetingListRuleBaseTargetListRuleRuleItems WHERE AccountId = '125466' AND TargetListId = '234234'
Columns
| Name | Type | References | Description |
| TargetListId | Int64 | Target List ID. | |
| AccountId | Int64 |
SearchAdsAccounts.AccountId | Account ID. |
| TargetListOwner | String | Describes the owner information of the target list.
使用できる値は次のとおりです。ONWER, SHARED, UNKNOWN | |
| TargetListType | String | The type of target list.
使用できる値は次のとおりです。DEFAULT, RULE, LOGICAL, UNKNOWN | |
| CustomKeyRuleItemTextKey | String | Evaluation item. If ruleType is CUSTOM_KEY_RULE, this field is required in ADD and SET operation. | |
| RuleOperator | String | The evaluation type to set evaluation condition of rules.
使用できる値は次のとおりです。UNKNOWN, EQUALS, NOT_EQUAL, CONTAINS, NOT_CONTAIN, STARTS_WITH, NOT_START_WITH, ENDS_WITH, NOT_END_WITH | |
| RuleType | String | The rule type of target list.
使用できる値は次のとおりです。URL_RULE, CUSTOM_KEY_RULE, UNKNOWN | |
| UrlRuleItemUrlRuleKey | String | The evaluation to set URL rules. If ruleType is URL_RULE, this field is required in ADD and SET operation.
使用できる値は次のとおりです。URL, REFER_URL, UNKNOWN | |
| Value | String | Evaluation value. Cannot use: bracket, single quote, double quote, and tab. Can select up to 250 characters. |