Query the available Budget Opportunities in Bing Ads.

Table Specific Information

Select

The following queries are processed server-side:

SELECT * FROM BudgetOpportunities
SELECT * FROM BudgetOpportunities WHERE CampaignId = '234505536'

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

Columns

Name	Type	Select requirement	Metric	Aggregate	Description
OpportunityKey	String				An identifier that uniquely identifies the opportunity.
BudgetAmount	Double				A potential new budget.
BudgetPointType	String				The type of budget relative to a list of budget points. For example, if the budget point type is Current then this object's BudgetAmount element would be equal to the corresponding campaign's daily budget.
EstimatedWeeklyClicks	Double				The estimated weekly clicks for the given budget amount.
EstimatedWeeklyCost	Double				The estimated weekly cost for the given budget amount.
EstimatedWeeklyImpressions	Double				The estimated weekly impressions for the given budget amount.
BudgetType	String				The type of budget that the campaign uses.
CampaignId	Long				The identifier of the campaign to which the suggested budget applies
CurrentBudget	Double				The campaign's current budget.
IncreaseInClicks	Double				The estimated clicks opportunities corresponding to the suggested budget.
IncreaseInImpressions	Double				The estimated impressions opportunities corresponding to the suggested budget.
PercentageIncreaseInClicks	Integer				The estimated percentage increase in clicks corresponding to the suggested budget.
PercentageIncreaseInImpressions	Integer				The estimated percentage increase in impressions corresponding to the suggested budget.
RecommendedBudget	Double				The suggested budget based on the last 15 days of performance history for the corresponding campaign.
AccountId	Long				The Bing Ads assigned identifier of an account.