BudgetOpportunities
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 adapter will use the Bing Ads API to filter the results by CampaignId while the rest of the filter is executed client side within the adapter.
For example, the following query is processed server side:
SELECT * FROM " BudgetOpportunities " WHERE CampaignId = '234505536'
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. |