BidOpportunities
Query the available Bid Opportunities in Bing Ads.
Table Specific Information
Select
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 connector will use the Microsoft Ads API to filter the results by OpportunityType while the rest of the filter is executed client side within the connector. 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.
Columns
| 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. |