DisplayAdsAccounts

Read Or Update account 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 rest of the filter is executed client-side within the connector.

AccountId supports the '=,IN'.
AccountName supports the '='.
AccountStatus supports the '=,IN'.
AccountType supports the '=,IN'.
IncludeTestAccount supports the '='.
IncludeManagerAccount supports the '='.

For example:

SELECT * FROM DisplayAdsAccounts WHERE AccountName = 'TestAccount'

SELECT * FROM DisplayAdsAccounts WHERE AccountStatus = 'SERVING'

SELECT * FROM DisplayAdsAccounts WHERE AccountType = 'PREPAY'

SELECT * FROM DisplayAdsAccounts WHERE IncludeTestAccount = 'ALL'

SELECT * FROM DisplayAdsAccounts WHERE IncludeManagerAccount = 'ALL'

UPDATE

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

UPDATE DisplayAdsAccounts SET AccountName = 'TestAccount' WHERE AccountId = '1002504155'

Columns


Name	Type	ReadOnly	References	Description
AccountId [KEY]	Int64	True		Account ID.
AccountName	String	False		Account Name.
AccountStatus	String	False		Account status. 使用できる値は次のとおりです。INPROGRESS, WAIT_DECIDE, SUSPENDED, SERVING, ENDED, UNKNOWN
AccountType	String	False		Payment type of the account. 使用できる値は次のとおりです。PREPAY, INVOICE, UNKNOWN
AutoTaggingEnabled	String	False		The Management flag for whether or not to set auto tag.
ContactBizId	String	False		Contact Business ID.
DeliveryStatus	String	False		Delivery Status.
StartDate	Date	False		Start date of ad serving.
EndDate	Date	False		End date of ad serving.
IsMccAccount	String	False		Describes whether it is an MCC account.
IsTestAccount	String	False		Describes whether it is a Test account.
OptimizationScore	Double	False		Optimization Score.

Pseudo-Columns

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