SearchAdsBaseAccount
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 SearchAdsBaseAccount SELECT * FROM SearchAdsBaseAccount WHERE AccountId = '1001987917' SELECT * FROM SearchAdsBaseAccount WHERE AccountName = 'CData Software Japan 株式会社' SELECT * FROM SearchAdsBaseAccount WHERE IncludeMccAccount = 'ONLY_MCC'
Columns
| Name | Type | References | Description |
| AccountId [KEY] | Int64 |
SearchAdsAccounts.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 |