Query the available Budget Opportunities in Bing Ads.

Table Specific Information

Select

You must specify the CampaignId column in the WHERE clause to query this table. The connector will use the Microsoft Ads API to filter the results by CampaignId while the rest of the filter is executed client side within the connector.

For example, the following query is processed server side:

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.