JDBC Driver for Microsoft Ads

Build 22.0.8462


Query the available Bid Opportunities in Bing Ads.

Table Specific Information


You must specify the OpportunityType column in the WHERE clause to query this table. You can specify the following values for OpportunityType: FirstPage, MainLine, and MainLine1.

The driver will use the Microsoft Ads API to filter the results by OpportunityType while the rest of the filter is executed client side within the driver. For example, the following query is processed server side.

SELECT * FROM [ BidOpportunities ] WHERE OpportunityType = 'FirstPage'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refers to columns other than OpportunityType will cause an error.


Name Type Select requirement Metric Aggregate Description
OpportunityKey String An identifier that uniquely identifies the opportunity.
AdGroupId Long The identifier of the ad group that owns the keyword.
CampaignId Long The identifier of the campaign for the ad group that owns the keyword.
OpportunityType String Defines the possible bid opportunity types you can request when calling GetBidOpportunities. Avaiable values are: FirstPage,MainLine and MainLine1.

The default value is FirstPage.

CurrentBid Double The current keyword bid amount specified for the match type in the MatchType element.
EstimatedIncreaseInClicks Double The estimated clicks opportunities corresponding to the suggested bid.
EstimatedIncreaseInCost Double The estimated increase in spend corresponding to the suggested bid.
EstimatedIncreaseInImpressions Long The estimated impressions opportunities corresponding to the suggested bid.
KeywordId Long The identifier of the keyword to which the bid opportunity applies.
MatchType String The match type to which the suggested bid value applies. The possible values are BroadMatch, ExactMatch, and PhraseMatch.
SuggestedBid Double The suggested bid based on the last 7 days of performance history for the corresponding ad group.
AccountId Long The Bing Ads assigned identifier of an account.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462