AudienceLists

Create, Read, Update or Delete the Audience list for site retargeting

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

For example:

SELECT * FROM AudienceLists WHERE AccountId = '1234339'
SELECT * FROM AudienceLists WHERE AccountId = '1234339' AND AudienceListId = '1003039071'
SELECT * FROM AudienceLists WHERE AccountId = '1234339' AND AudienceListId = '1003039071' AND AudienceListType = 'DEFAULT_LIST'

INSERT

Insert in AudienceLists can be done using temp tables.

INSERT INTO DisplayAdsAudienceListContentCombinationAudienceListRulesRuleConditions#TEMP(AccountId, CompareOperator, RuleType, Value) VALUES (1002504155, 'EQUAL', 'URL', 'Cdata.com')
INSERT INTO DisplayAdsAudienceListContentRuleAudienceListRules#TEMP(AccountId, RuleConditions) VALUES (1002504155, 'DisplayAdsAudienceListContentCombinationAudienceListRulesRuleConditions#TEMP')
INSERT INTO AudienceLists(AccountId, AudienceListType, AudienceListName, ContentRuleAudienceListRetargetingTagId, ContentRuleAudienceListIsOpen, ContentRuleAudienceListIsPreset, ContentRuleAudienceListReachPeriod, ContentRuleAudienceListRules) VALUES (1002504155, 'RULE', 'UpdatingRetargetingListThrice', 'YWQ5T1KH11', TRUE, FALSE, 7, 'DisplayAdsAudienceListContentRuleAudienceListRules#TEMP')

UPDATE

Update can be executed by specifying the AccountId, AudienceListId, AudienceListName AND AudienceListType in the WHERE Clause. For example:

UPDATE AudienceLists SET AudienceListName = 'UpdatingRetargetingListFour' WHERE AudienceListId = 1003411978 AND AccountId = 1002504155 AND AudienceListName = 'UpdatingRetargetingListThrice' AND AudienceListType = 'RULE'

DELETE

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

DELETE FROM AudienceLists WHERE AudienceListId = 1003411978 AND AccountId = 1002504155

Columns


Name	Type	ReadOnly	References	Description
AudienceListId [KEY]	Int64	True		Audience List ID.
AccountId	Int64	True	DisplayAdsAccounts.AccountId	Account ID.
AudienceListType	String	False		Types of audience list. DEFAULT_LIST cannot be specified in ADD operation. 使用できる値は次のとおりです。DEFAULT_LIST, COMBINATION, SIMILARITY, WEBSITE_VISITORS, CUSTOMER_DATA, APP_USER, YAHOO_JAPAN_AUDIENCE_DISCOVERY, UNKNOWN, ADVANCED_SEGMENTS, AD_ACTION_USERS
ContentCombinationAudienceListCombinations	String	False		Combination of audience list information. If targetListType is COMBINATION, this field is required in ADD and SET operation.
ContentCustomerDataAudienceListCustomAudienceId	String	False		Custom audience ID.
ContentCustomerDataAudienceListDataDuration	Int64	False		Duration of user data configured from DMP (1-60days).This field is required in ADD operation.
ContentRuleAudienceListIsOpen	String	False		Display the setting of store to reaches Audience List. If audienceListType is RULE, this field is required in ADD operation, and is optional in SET operation. If audienceListType is DEFAULT_LIST, this field is optional in SET operation. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
ContentRuleAudienceListIsPreset	String	False		Display the setting of history of past visit. This field is required in ADD operation. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
ContentRuleAudienceListDataDuration	Int64	False		Cookies validation period. (1 - 540 days). This field is required in ADD operation and is Optional in SET operation.
ContentRuleAudienceListRetargetingTagId	String	False		ID of Retargeting Tag. This field is required in ADD operation.
ContentRuleAudienceListRules	String	False		It displays the Possible conditions for audience list. This field is optional in ADD and SET operation.
ContentSimilarityAudienceListId	Int64	False		Audience list ID that is the basis for creating the audience list (similar users). This field is required in ADD operation, and will be ignored in SET and REMOVE operation.
ContentSimilarityAudienceListSize	String	False		It serves audience list size of similarity audience list. Under similarityaudienceList, this field is optional in ADD and SET operation, and will be ignored in REMOVE operation.
ContentSimilarityAudienceListSizeReaches	String	False		It contains each reaches of audience list size. Although this field will be returned in the response, it will be ignored on input.
ContentWebsiteVisitorsAudienceListIsOpen	String	False		Display the setting of store of reaches to Audience List. If audienceListType is RULE, this field is required in ADD operation, and is optional in SET operation. If audienceListType is DEFAULT_LIST, this field is optional in SET operation.
ContentWebsiteVisitorsAudienceListIsPreset	String	False		Display the setting of history of past visit.This field is required in ADD operation. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
ContentWebsiteVisitorsAudienceListDataDuration	Int64	False		Cookies validation period. (1 - 540 days). This field is required in ADD operation, and is optional in SET operation.
ContentWebsiteVisitorsAudienceListRetargetingTagId	String	False		ID of Retargeting Tag. This field is required in ADD operation.
ContentWebsiteVisitorsAudienceListRules	String	False		Displays the possible conditions for audience list. This field is optional in ADD and SET operation.
ContainDataConnectionStopped	String	False		AudienceListServiceContainDataConnectionStopped display whether the list contains audience lists that have stopped the data connection.
AudienceListName	String	False		Audience List name.
DeliveryStatus	String	False		Account delivery status 使用できる値は次のとおりです。ACTIVE, PAUSED, UNKNOWN
Description	String	False		Description of Audience List.
IsRemoveDescription	String	False		flag for removing an information item.If the set value is 'TRUE', the set value will be invalid. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
IsShared	Boolean	False		Describes the sharing status of the audience list 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
Reach	Int64	False		Number of reaches.
SourceAccountId	Int64	False		Account ID of the sharing source.
SourceAccountName	String	False		Account name of the sharing source.
SourceType	String	False		Describes the source type.
DataConnectionStopped	String	False		It shows whether or not the custom list stopped the data connection.
YahooJapanAudienceDiscoveryAudienceListDataDuration	String	False		It displays audience list (Yahoo! JAPAN Audience Discovery).
ContentAppUserAudienceListIsOpen	String	False		It displays the setting of store of reaches to Audience List.
ContentAppUserAudienceListIsPresent	String	False		It displays the setting of history of past visit.
ContentAppUserAudienceListDataDuration	Int64	False		It represents Cookies validation period. (1 - 540 days).
ContentAppUserAudienceListRules	String	False		It displays the possible conditions for audience list.
ContentAppUserAudienceListAppLinkAppId	String	False		App Id.
ContentAppUserAudienceListAppLinkAppVendor	String	False		It serves app measurement partner.
ContentAppUserAudienceListAppLinkLinkId	String	False		Link ID.
ContentAppUserAudienceListAppLinkAppPlatform	String	False		It displays the platform of app link.

Pseudo-Columns

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


Name	Type	Description
SharingStatusFilterType	String	Sharing status of the Audiencet list. 使用できる値は次のとおりです。ALL, SHARED, NOT_SHARED, UNKNOWN デフォルト値はALLです。
ReferenceNumber	String	This column will be used in Bulk operations to get specific values from the Temp tables.

ODBC Driver for Yahoo! Ads