SearchAdsAccounts

Read Or Update account information.

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 '=,IN'.
AccountName supports the '='.
AccountStatus supports the '=,IN'.
AccountType supports the '=,IN'.
IncludeTestAccount supports the '='.
IncludeManagerAccount supports the '='.

For example:

SELECT * FROM SearchAdsAccounts WHERE AccountId='123436'

SELECT * FROM SearchAdsAccounts WHERE AccountId='123436' AND AccountName='Test'	

SELECT * FROM SearchAdsAccounts WHERE AccountId='123436' AND AccountStatus IN ('INPROGRESS')

SELECT * FROM SearchAdsAccounts WHERE AccountId='123436' AND AccountType IN ('Regular')

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 SearchAdsAccounts SET AccountName = 'Test Account' WHERE AccountId = '123436'

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.

Pseudo-Columns

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