Tableau Connector for Yahoo! Ads

Build 24.0.9062

DisplayAdsBaseAccount

Get lists of all accounts (MCC and ad accounts).

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

  • AccountId supports the '=,IN'.
  • AccountName supports the '='.
  • AccountStatus supports the '=,IN'.
  • AuthType supports the '='.
  • IncludeAdminAuth supports the '='.
  • IncludeMccAccount supports the '='.
  • IncludeTestAccount supports the '='.

For example:

SELECT * FROM DisplayAdsBaseAccount
SELECT * FROM DisplayAdsBaseAccount WHERE AccountId = '1001987917'
SELECT * FROM DisplayAdsBaseAccount WHERE AccountName = 'CData Software Japan 株式会社'
SELECT * FROM DisplayAdsBaseAccount WHERE IncludeMccAccount = 'ONLY_MCC'

Columns

Name Type References Description
AccountId [KEY] Int64

DisplayAdsAccounts.AccountId

Account ID.
AccountName String Account name.
AccountStatus String Displays the account registration status.
AuthType String Access Roles.
HasAdminAuth String It indicates whether admin access is available for this account.
IsRootMccAccount String It indicates whether it is an root MCC account.
IsMccAccount String It indicates whether it is an MCC account.
IsTestAccount String It indicates whether it is a test account.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
IncludeAdminAuth String It indicates whether to include accounts with admin access for accounts you get.

使用できる値は次のとおりです。ONLY_ADMIN, EXCLUDE_ADMIN, UNKNOWN

IncludeMccAccount String It represents whether the account to be retrieved includes an MCC account.

使用できる値は次のとおりです。ONLY_MCC, ONLY_ROOT_MCC, ONLY_ADS_ACCOUNT, ALL, UNKNOWN

IncludeTestAccount String It represents whether the account to be retrieved includes an test account.

使用できる値は次のとおりです。ONLY_TEST, EXCLUDE_TEST, ALL, UNKNOWN

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