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