CData Python Connector for Yahoo! Ads

Build 24.0.9062

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062