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 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
IncludeTestAccount | String |
Accounts to retrieve. 使用できる値は次のとおりです。ONLY_TEST, EXCLUDE_TEST, ALL, UNKNOWN デフォルト値はEXCLUDE_TESTです。 |
IncludeManagerAccount | String |
Represents whether the account to be retrieved includes an MCC account. 使用できる値は次のとおりです。ONLY_MANAGER, EXCLUDE_MANAGER, ALL, UNKNOWN デフォルト値はEXCLUDE_MANAGERです。 |