ODBC Driver for Yahoo! Ads

Build 24.0.9062

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 本製品 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 本製品.

  • 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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062