Tableau Connector for Yahoo! Ads

Build 24.0.9062

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

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