ContentsKeywordLists

Get the contents keyeord list

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 '='.
ContentsKeywordListId supports the '=,IN'.

For example:

SELECT * FROM ContentsKeywordLists WHERE AccountId = '1002504155'

SELECT * FROM ContentsKeywordLists WHERE ContentsKeywordListId = '1000010795'

INSERT

Insert can be executed by specifying the AccountId, ContentsKeywordListName, ContentsKeyword and ContentsKeywordId 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 ContentsKeywordListsContentsKeyword#TEMP (ContentsKeywordId) VALUES (181202)
INSERT INTO ContentsKeywordLists (ContentsKeywordListName, ContentsKeyword, accountid) VALUES ('testvickyy', 'ContentsKeywordListsContentsKeyword#TEMP', 1002504155)

UPADTE

Update can be executed by specifying the AccountId, ContentsKeywordListId and ContentsKeywordId in the WHERE Clause. The columns that are not read-only can be Updated. For example:

INSERT INTO ContentsKeywordListsContentsKeyword#TEMP (ContentsKeywordId) VALUES (181202)
UPDATE ContentsKeywordLists SET ContentsKeywordListName = 'NewTestLabeltest' WHERE AccountId = '1002504155' AND ContentsKeyword = 'ContentsKeywordListsContentsKeyword#TEMP' AND ContentsKeywordListId = '1000010795'

DELETE

Delete can be executed by specifying the AccountId and ContentsKeywordListId in the WHERE Clause. For example:

DELETE FROM ContentsKeywordLists WHERE AccountId = '1002504155' AND ContentsKeywordListId = '1000010795'

Columns


Name	Type	ReadOnly	References	Description
ContentsKeywordListId [KEY]	Int64	True		Contents keyword list ID.This field is required in SET and REMOVE operation.
AccountId	Int64	True	DisplayAdsAccounts.AccountId	Account ID.
BrandSafetyDenyListFlg	Boolean	False		A flag that indicates whether it is an exclusion list.This field is optional in ADD operation (default value will be FALSE), and cannot be specified in SET operation 使用できる値は次のとおりです。TRUE, FALSE
ContentsKeyword	String	False		Contents keyword.This field is required in ADD and SET operation
ContentsKeywordListDescription	String	False		Description of Contents keyword list
ContentsKeywordListName	String	False		Name of Contents keyword list.This field is required in ADD operation
IsRemoveContentsKeywordListDescription	String	False		ContentsKeywordListServiceIsRemoveFlg is a flag for removing an information item