SearchAdsBudgets
Read or Update budget information for the account.
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'.
For example:
SELECT * FROM SearchAdsBudgets WHERE AccountId = '12346'
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 SearchAdsBudgets SET Amount = '1000', LimitChargeType = 'MONTHLY' WHERE AccountId = '12346'
Columns
| Name | Type | ReadOnly | References | Description |
| AccountId [KEY] | Int64 | True |
SearchAdsAccounts.AccountId |
Account ID. |
| AccountType | String | False |
Displays the account charge type. 使用できる値は次のとおりです。PREPAY, INVOICE, UNKNOWN | |
| Amount | Int64 | False |
Amount of budget. The monthly budget can be changed only when accountType is INVOICE. In addition, the budget amount must be specified in units of 1000 yen. | |
| LimitChargeType | String | False |
Serves the account's budget allotment. Specify MONTHLY to change the monthly budget. 使用できる値は次のとおりです。SUM, MONTHLY, UNKNOWN |