SearchAdsAccountManagement

Create, update or Read account information.

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'.
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.