SearchAdsAccountManagement
Create, update or Read 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'.
- AccountType supports the '=,IN'.
- Status supports the '=,IN'.
- IncludeTestAccount supports the '=,IN'.
For example:
SELECT * FROM SearchAdsAccountManagement WHERE AccountId = '25687' SELECT * FROM SearchAdsAccountManagement WHERE AccountId = '25687' AND AccountType IN ('INVOICE') SELECT * FROM SearchAdsAccountManagement WHERE AccountId = '25687' AND Status IN ('SUSPENDED') SELECT * FROM SearchAdsAccountManagement WHERE AccountId = '25687' AND IncludeTestAccount IN ('ONLY_TEST')
INSERT
Insert can be executed by specifying the AccountName, AccountPaymentInvoiceBudgetAmount, ClientCity, ClientCompanyName, ClientCompanyNameKana, ClientEnterpriseType ,ClientPhoneNumber, ClientStreet1, ClientStreet2, ClientUrl, ClientUrlType, ClientZip and ClientType columns. The columns that are not read-only can be inserted optionally.
INSERT INTO SearchAdsAccountManagement (AccountName,AccountPaymentInvoiceBudgetAmount,AccountPaymentPaymentType,ClientBuilding,ClientCity,ClientCompanyName,ClientCompanyNameKana,ClientEnterpriseType,ClientPhoneNumber,ClientStreet1,ClientStreet2,ClientUrl,ClientUrlType,ClientZip,ClientType ) VALUES ('test',1234,'PREPAY','cdata','blr','infosys','cd','GOMEI','98765-98765-98765','street1','street2','ClientUrl','PC','123-1234','AGENT')
UPDATE
The columns that are not read-only can be Updated.
For example:
UPDATE SearchAdsAccountManagement SET AccountName = 'TestAccount' WHERE AccountId = '1002504155';
Columns
Name | Type | ReadOnly | References | Description |
AccountId [KEY] | Int64 | True |
SearchAdsAccounts.AccountId |
Account ID. |
AccountName | String | False |
Account Name. | |
AccountPaymentInvoiceBudgetAmount | Int64 | False |
Budget Amount. Amount must be more than 3,000 and less than 999,999,999,999,000. The unit is 1,000 | |
AccountPaymentInvoiceStartDate | Date | False |
Start Date.This field will be automatically registered in ADD operation. | |
AccountPaymentInvoiceEndDate | Date | False |
End Date. Specify the date in .The default value in ADD operation will be 20371231. 20371231 will be considered as No setting. | |
AccountPaymentPaymentType | String | False |
Describes the type of payment. 使用できる値は次のとおりです。PREPAY, INVOICE, UNKNOWN | |
AgencyPersonName | String | False |
Agency Person Name. | |
AgencyPrefectureCode | String | False |
Describes the code of prefectures.Under 'client' this field will be required in ADD operation. 使用できる値は次のとおりです。HOKKAIDO, AOMORI, IWATE, MIYAGI, AKITA, YAMAGATA, FUKUSHIMA, IBARAKI, TOCHIGI, GUNMA, SAITAMA, CHIBA, TOKYO, KANAGAWA, NIIGATA, TOYAMA, ISHIKAWA, FUKUI, YAMANASHI, GIFU, AICHI, MIE, SIGA, KYOTO, OSAKA, HYOGO, NARA, WAKAYAMA, TOTTORI, SHIMANE, OKAYAMA, YAMAGUCHI, TOKUSHIMA, KAGAWA, EHIME, KOCHI, FUKUOKA, SAGA, NAGASAKI, KUMAMOTO, OITA, MIYAZAKI, KAGOSHIMA, OKINAWA, NONE, UNKNOWN | |
AutoTaggingEnabled | String | False |
The Management flag for whether or not to set auto tag. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN デフォルト値はTRUEです。 | |
ClientBuilding | String | False |
Client Building name. | |
ClientCity | String | False |
Client City name. | |
ClientClientPersonName | String | False |
Client person name. | |
ClientCompanyName | String | False |
Client Company name. | |
ClientCompanyNameKana | String | False |
Kana characters of company name. | |
ClientEnterpriseType | String | False |
Describes type of enterprise. 使用できる値は次のとおりです。KABUSHIKI, YUGEN, GOSI, ZAIDAN, SYADAN, SYUKYO, GAKKO, KOJIN, OTHER, GOMEI, HIEIRI, GODO, KYODO, Unknown | |
ClientEnterpriseTypePosition | String | False |
Describes the position of enterprise type. Cannot be set when enterpriseType is KOJIN or OTHER in ADD operation. 使用できる値は次のとおりです。FRONT, BACK, UNKNOWN | |
ClientPhoneNumber | String | False |
Phone number. In xxxxx-xxxxx-xxxxx format. | |
ClientPrefectureCode | String | False |
Describes the code of prefectures. 使用できる値は次のとおりです。HOKKAIDO, AOMORI, IWATE, MIYAGI, AKITA, YAMAGATA, FUKUSHIMA, IBARAKI, TOCHIGI, GUNMA, SAITAMA, CHIBA, TOKYO, KANAGAWA, NIIGATA, TOYAMA, ISHIKAWA, FUKUI, YAMANASHI, GIFU, AICHI, MIE, SIGA, KYOTO, OSAKA, HYOGO, NARA, WAKAYAMA, TOTTORI, SHIMANE, OKAYAMA, YAMAGUCHI, TOKUSHIMA, KAGAWA, EHIME, KOCHI, FUKUOKA, SAGA, NAGASAKI, KUMAMOTO, OITA, MIYAZAKI, KAGOSHIMA, OKINAWA, NONE, UNKNOWN | |
ClientStreet1 | String | False |
Street1. | |
ClientStreet2 | String | False |
Street2. | |
ClientUrl | String | False |
Site URL for placing advertisement. | |
ClientUrlType | String | False |
Describes the type of application url. 使用できる値は次のとおりです。PC, DOCOMO, KDDI, SOFTBANK, OTHER, UNKNOWN | |
ClientZip | String | False |
Zip code in xxx-xxxxx format. | |
ClientType | String | False |
Describes the type of client. 使用できる値は次のとおりです。AGENT, SELF, UNKNOWN | |
ContactBizId | String | False |
Contact Business ID. | |
DeliveryStatus | String | False |
Describes account delivery status. 使用できる値は次のとおりです。ACTIVE, PAUSED, UNKNOWN デフォルト値はACTIVEです。 | |
IsAdultAccount | String | False |
The Adult Account flag. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN | |
IsTestAccount | String | False |
Describes whether the account is a test account or not. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN | |
Status | String | False |
Describes contract status of account. 使用できる値は次のとおりです。INPROGRESS, WAIT_DECIDE, SUSPENDED, SERVING, ENDED, UNKNOWN | |
ClientCorportateNumber | Int64 | False |
Corporate number. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
IncludeTestAccount | String |
Accounts to retrieve. 使用できる値は次のとおりです。ONLY_TEST, EXCLUDE_TEST, ALL, UNKNOWN |
AccountType | String |
Account Payment Types. |