Create, Read, Update or Delete portfolio bidding settings.

Table-Specific Information

SELECT

The 本製品 uses 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 本製品.

Column	Supported Operators
AccountId	=
PortfolioBiddingId	=, IN
BudgetCampaignBudgetId	=, IN
Type	=, IN

For example:

SELECT * FROM DisplayAdsBiddingStrategies WHERE AccountId ='1234339'
SELECT * FROM DisplayAdsBiddingStrategies WHERE AccountId ='1234339' AND PortfolioBiddingId ='88272'
SELECT * FROM DisplayAdsBiddingStrategies WHERE AccountId ='1234339' AND Type='MAXIMIZE_CLICKS'

INSERT

To insert a row, specify the AccountId, PortfolioBiddingName, and Type columns. Optional non-read-only columns can also be included.

For example:

INSERT INTO  DisplayAdsBiddingStrategies (AccountId, PortfolioBiddingName, Type) VALUES('1234339', 'Test Bidding', 'MAXIMIZE_CLICKS')

UPDATE

To update a row, specify AccountId and PortfolioBiddingId in the WHERE clause. Any non-read-only columns can be updated.

For example:

UPDATE DisplayAdsBiddingStrategies SET PortfolioBiddingName = 'Test', Type = 'MAXIMIZE_CLICKS' WHERE AccountId = '1234339' AND PortfolioBiddingId = '88272'

DELETE

To delete a row, specify AccountId and PortfolioBiddingId in the WHERE clause.

For example:

DELETE FROM DisplayAdsBiddingStrategies WHERE AccountId = '1234339' AND PortfolioBiddingId = '88272'

Columns

Name	Type	ReadOnly	References	Description
PortfolioBiddingId [KEY]	Int64	True		Portfolio bidding ID.
AccountId	Int64	False	DisplayAdsAccounts.AccountId	Account ID.
PortfolioBiddingName	String	False		Portfolio bidding name.
BudgetCampaignBudgetId	Int64	True		The shared budget ID.
BudgetCampaignBudgetName	String	True		The name of the shared budget.
BudgetAmount	Int64	False		The amount of the shared budget.
BudgetIsRemoveCampaignBudget	String	False		Flag to remove campaign budget. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
Type	String	False		Campaign bid strategy type. 使用できる値は次のとおりです。MAXIMIZE_CONVERSIONS, MAXIMIZE_CONVERSION_VALUE, MAXIMIZE_CLICKS, MAXIMIZE_VIDEO_VIEWS, MAXIMIZE_VIEWABLE_IMPRESSIONS, MAXIMIZE_GAINING_FRIENDS, CPC, UNKNOWN
CpcBiddingSchemeCpc	Int64	False		The campaign maximum bid (CPC).
CpcBiddingSchemeEnhancedCpcEnabled	String	True		Specifies the enhanced CPC setting flag. 使用できる値は次のとおりです。TRUE, UNKNOWN
MaximizeConversionsBiddingSchemeTargetCpa	Int64	False		Campaign target cost per unit (tCPA).
MaximizeGainingFriendsBiddingSchemeTargetCpf	Int64	False		Campaign target cost per unit (tCPF).
MaximizeConversionValueBiddingSchemeTargetRoas	Double	False		This is the target value of ROAS. Return On Advertising Spend(ROAS). It is allowed only within the range of 0.01 to 1000.00 (1% to 100000%).
BiddingOption	String	False		Billing method. 使用できる値は次のとおりです。VCPM, CPC, CPV, UNKNOWN

Pseudocolumns

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

Name	Type	Description
ReferenceNumber	String	This column will be used in Bulk operations to get specific values from the Temp tables.