DisplayAdsAccountManagement
Create, Update or Read account information. Restricted to some users
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'.
- AccountStatus supports the '=,IN'.
- AccountType supports the '=,IN'.
- IncludeTestAccount supports the '='.
SELECT * FROM DisplayAdsAccountManagement WHERE AccountId = '1002504155' SELECT * FROM DisplayAdsAccountManagement WHERE AccountId = '1002504155' AND AccountStatus = 'INPROGRESS' SELECT * FROM DisplayAdsAccountManagement WHERE AccountId = '1002504155' AND AccountType = 'PREPAY' SELECT * FROM DisplayAdsAccountManagement WHERE AccountId = '1002504155' AND IncludeTestAccount = 'EXCLUDE_TEST'
INSERT
Insert can be executed by specifying the AccountName,AccountPaymentInvoiceBudgetAmount,AccountPaymentPaymentType,ClientBuilding,ClientCity,ClientCompanyName,ClientCompanyNameKana,ClientEnterpriseType,ClientPhoneNumber,ClientStreet1,ClientStreet2,ClientUrl,ClientUrlType,ClientZip,ClientType columns. The columns that are not read-only can be inserted optionally.
INSERT INTO DisplayAdsAccountManagement (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
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 DisplayAdsAccountManagement SET AccountName='TestAccount' WHERE AccountId='1002504155'
Columns
Name | Type | ReadOnly | References | Description |
AccountId [KEY] | Int64 | True |
DisplayAdsAccounts.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. | |
AccountPaymentPaymentType | String | False |
Type of payment.Amount must be more than 3,000 and less than 999,999,999,999,000. The unit is 1,000. 使用できる値は次のとおりです。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, NAGANO, GIFU, SHIZUOKA, AICHI, MIE, SIGA, KYOTO, OSAKA, HYOGO, NARA, WAKAYAMA, TOTTORI, SHIMANE, OKAYAMA, HIROSHIMA, YAMAGUCHI, TOKUSHIMA, KAGAWA, EHIME, KOCHI, FUKUOKA, SAGA, NAGASAKI, KUMAMOTO, OITA, MIYAZAKI, KAGOSHIMA, OKINAWA, NONE, UNKNOWN | |
AutoTaggingEnabled | String | False |
Management flag for whether or not to set auto tag 使用できる値は次のとおりです。FALSE, TRUE, UNKNOWN デフォルト値はTRUEです。 | |
ClientBuilding | String | False |
Building name. | |
ClientCity | String | False |
City name.When clientType is SELF, this field will be ignored in ADD and SET operations. | |
ClientClientPersonName | String | False |
Client person name. | |
ClientCompanyName | String | False |
Company name.When clientType is SELF, this field will be ignored in ADD and SET operations. | |
ClientCompanyNameKana | String | False |
Kana characters of company name . When clientType is SELF, this field will be ignored in ADD and SET operations. | |
ClientCorporateNumber | Int64 | False |
Corporate number. | |
ClientEnterpriseType | String | False |
Type of enterprise.When clientType is SELF, this field will be ignored in ADD and SET operations. 使用できる値は次のとおりです。KABUSHIKI, YUGEN, GOSI, ZAIDAN, SYADAN, SYUKYO, GAKKO, KOJIN, OTHER, GOMEI, HIEIRI, GODO, KYODO, UNKNOWN | |
ClientEnterpriseTypePosition | String | False |
Position of enterprise type .Cannot be set when enterpriseType is KOJIN or OTHER in ADD operation.When clientType is SELF, this field will be ignored in ADD and SET operations. 使用できる値は次のとおりです。FRONT, Back, UNKNOWN | |
ClientPhoneNumber | String | False |
Phone number In xxxxx-xxxxx-xxxxx format. When clientType is SELF, this field will be ignored in ADD and SET operations. | |
ClientPrefectureCode | String | False |
Code of prefectures | |
ClientStreet1 | String | False |
Street1. When clientType is SELF, this field will be ignored in ADD and SET operations. | |
ClientStreet2 | String | False |
Street2. When clientType is SELF, this field will be ignored in ADD and SET operations. | |
ClientUrl | String | False |
Site URL for placing advertisement. | |
ClientUrlType | String | False |
Type of application url. 使用できる値は次のとおりです。PC, DOCOMO, KDDI, SOFTBANK, OTHER, UNKNOWN | |
ClientZip | String | False |
Zip code.In xxx-xxxx format.When clientType is SELF, this field will be ignored in ADD and SET operations. | |
ClientType | String | False |
Type of client. 使用できる値は次のとおりです。AGENT, SELF, UNKNOWN | |
ContactBizId | String | False |
Contact Business ID. | |
DeliveryStatus | String | False |
Account delivery status. 使用できる値は次のとおりです。ACTIVE, PAUSED, UNKNOWN デフォルト値はACTIVEです。 | |
StartDate | Date | False |
Start Date. | |
EndDate | Date | False |
End Date. | |
IsTestAccount | String | False |
Account is a test account or not. 使用できる値は次のとおりです。ACTIVE, PAUSED, UNKNOWN | |
Status | String | False |
Contract status of account. 使用できる値は次のとおりです。INPROGRESS, WAIT_DECIDE, SUSPENDED, SERVING, ENDED, UNKNOWN |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
AccountStatus | String |
Account Statuses. |
AccountType | String |
Account Payment Types. |
IncludeTestAccount | String |
Control which accounts are retrieved. 使用できる値は次のとおりです。ONLY_TEST, EXCLUDE_TEST, ALL, UNKNOWN |