Power BI Connector for Yahoo! Ads

Build 24.0.9062

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

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