DisplayAdsAccountManagement

Create, Update or Read account information. Restricted to some users

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 AccountId is required to make a request and the rest of the filter is executed client-side within the connector.

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

For example:

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