SearchAdsRetargetingLists

Create, Read or Update the target list information.

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 SearchAdsRetargetingLists WHERE AccountId = '125466'

SELECT * FROM SearchAdsRetargetingLists WHERE AccountId = '125466' AND TargetListId = '234234'

INSERT

Insert can be executed by specifying the AccountId, LogicalTargetListLogicalGroup, RuleBaseTargetListIsAllVisitorRule, TargetListName and TargetListType columns. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table

INSERT INTO SearchAdsRetargetingListRuleBaseTargetListRuleRuleItems#TEMP (RuleOperator,RuleType,UrlRuleItemUrlRuleKey,Value) VALUES ('EQUALS','URL_RULE','URL','bestcampaign.com')
INSERT INTO SearchAdsRetargetingListRuleBaseTargetListRules#TEMP (RuleItems) VALUES ('SearchAdsRetargetingListRuleBaseTargetListRuleRuleItems#TEMP')
INSERT INTO SearchAdsRetargetingLists (AccountId,TargetListName,TargetListType,RuleBaseTargetListIsAllVisitorRule,RuleBaseTargetListIsDateSpecificRule,RuleBaseTargetListRules) values (1234339,'RuleBaseRetargetingList','RULE','TRUE','FALSE','SearchAdsRetargetingListRuleBaseTargetListRules#TEMP')

UPDATE

UPDATE can be executed by specifying the AccountId, TargetListId, LogicalTargetListLogicalGroup, RuleBaseTargetListIsAllVisitorRule and TargetListType in the WHERE Clause. The columns that are not read-only can be Updated. For example:

INSERT INTO SearchAdsRetargetingListRuleBaseTargetListRuleRuleItems#TEMP (RuleOperator,RuleType,UrlRuleItemUrlRuleKey,Value) VALUES ('NOT_EQUAL','URL_RULE','REFFER_URL','badcampaign.com')
INSERT INTO SearchAdsRetargetingListRuleBaseTargetListRules#TEMP (RuleItems) VALUES ('SearchAdsRetargetingListRuleBaseTargetListRuleRuleItems#TEMP')
UPDATE SearchAdsRetargetingLists SET TargetListName = 'UpdateRetargetingList', TargetListType = 'RULE', RuleBaseTargetListIsAllVisitorRule = 'TRUE', RuleBaseTargetListIsDateSpecificRule = 'FALSE', RuleBaseTargetListRules = 'SearchAdsRetargetingListRuleBaseTargetListRules#TEMP' WHERE AccountId = '1234339' AND TargetListId = '634293'

Columns


Name	Type	ReadOnly	References	Description
TargetListId [KEY]	Int64	True		Target List ID.
AccountId	Int64	True	SearchAdsAccounts.AccountId	Account ID.
ClosingReason	String	False		The reason for closing. 使用できる値は次のとおりです。UNUSED_LIST, UNKNOWN
DefaultTargetListTagAdvancedSnippet	String	False		The new format of site retargeting tag avoids the impacts such as changes made to the browser.
LogicalTargetListLogicalGroup	String	False		An object that holds combination group information.
Reach	Int64	False		Number of users stored to the list.
ReachStorageSpan	Int64	False		Days to hold Cookie. Default:180
ReachStorageStatus	String	False		The flag status to store Cookie reach. 使用できる値は次のとおりです。OPEN, CLOSED, UNKNOWN
RetargetingAccountStatusAgreeDate	String	False		Agreement date.
RetargetingAccountStatusReviewRequestDate	String	False		Re-examination review request date.
RetargetingAccountStatusReviewStatus	String	False		The review status of target list. 使用できる値は次のとおりです。APPROVED, DISAPPROVED, DISAPPROVED_WITH_REVIEW, UNKNOWN
RuleBaseTargetListStartDate	String	False		Start date of rule setting in
RuleBaseTargetListEndDate	String	False		End date of rule setting in
RuleBaseTargetListIsAllVisitorRule	String	False		The rule of visitors. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
RuleBaseTargetListIsDateSpecificRule	String	False		The rule with deadline. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
RuleBaseTargetListRules	String	False		An object that holds grouped URL/LABEL rules.
TargetListDescription	String	False		Description of Target List.
TargetListName	String	False		Target List name.
TargetListOwner	String	False		Describes the owner information of the target list. 使用できる値は次のとおりです。ONWER, SHARED, UNKNOWN
TargetListTrackId	Int64	False		Tracking ID of Target list.
TargetListType	String	False		The type of target list. 使用できる値は次のとおりです。DEFAULT, RULE, LOGICAL, UNKNOWN

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
ReferenceNumber	String	This column will be used in Bulk operations to get specific values from the Temp tables.