AdGroupBidMultipliers
Read, Update or Delete bid multiplier of adgroup.
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 '='.
- AdGroupId supports the 'IN'.
- CampaignId supports the 'IN'.
- PlatformType supports the 'IN'.
For example, the following queries are processed server side:
SELECT * FROM AdGroupBidMultipliers WHERE AccountId = '25687' SELECT * FROM AdGroupBidMultipliers WHERE AccountId = '25687' AND AdGroupId IN ('456971') SELECT * FROM AdGroupBidMultipliers WHERE AccountId = '25687' AND CampaignId IN ('25687') SELECT * FROM AdGroupBidMultipliers WHERE AccountId = '25687' AND PlatformType IN ('SMART_PHONE')
UPDATE
Update can be executed by specifying the AccountId, AdGroupId, BidMultiplier, CampaignId and PlatformType in the WHERE Clause. The columns that are not read-only can be Updated.
For example:
UPDATE AdGroupBidMultipliers SET PlatformType = 'SMART_PHONE' WHERE AccountId = '1569' AND AdGroupId = '7894' AND BidMultiplier = 'Test' AND CampaignId = '4569'
DELETE
Delete can be executed by specifying the AccountId, AdGroupId, CampaignId and PlatformType in the WHERE Clause.
For example:
DELETE FROM AdGroupBidMultipliers WHERE AccountId = '1569' AND AdGroupId = '7894' AND CampaignId = '4569' AND PlatformType = 'SMART_PHONE'
Columns
Name | Type | ReadOnly | References | Description |
AdGroupId [KEY] | Int64 | True |
SearchAdsAdGroups.AdGroupId |
Ad group ID. |
AccountId | Int64 | True |
SearchAdsAccounts.AccountId |
Account ID. |
BidMultiplier | String | False |
Bid adjustment rate. Can be specified between 0 to 10.00. When specified 0, the ad will not be delivered. Bid adjustment rate can be specified up to two decimal places. | |
CampaignId | Int64 | False |
SearchAdsCampaigns.CampaignId |
Campaign ID. |
PlatformType | String | False |
A platform of the selected device. 使用できる値は次のとおりです。SMART_PHONE, TABLET, DESKTOP, UNKNOWN |