Query the available Campaigns in Bing Ads.

Table Specific Information

Select

Searches on this table are processed client-side by the driver; the following query is processed server-side:

SELECT * FROM [ Campaigns ]

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search query will return an error.

Columns

Name	Type	Select requirement	Metric	Aggregate	Description
Id [KEY]	Long				The unique Bing Ads identifier of the campaign.
AccountId	String				The unique Bing Ads identifier of the account associated with this campaign.
CampaignType	String				The campaign type determines whether the campaign is an Audience, Dynamic Search Ads, Search, Shopping or Search & Content campaign. The allowed values are Search, Shopping, DynamicSearchAds, Audience.
Name	String				The name of the campaign. The name must be unique among all active or paused campaigns within the account.
Status	String				The status of the campaign. The allowed values are Active, Paused.
SubType	String				The campaign sub type. This element is only applicable for campaigns of type Shopping, and will be nil for all other campaign types.
BiddingSchemeType	String				The bid strategy type for how you want to manage your bids. The allowed values are EnhancedCpc, InheritFromParent, ManualCpc, MaxClicks, MaxConversions, TargetCpa.
BudgetType	String				The budget type determines how the budget is spent. The allowed values are DailyBudgetAccelerated, DailyBudgetStandard.
DailyBudget	Double				The amount to spend daily on the campaign. You must set the daily budget amount if BudgetId is not set.
ExperimentId	Long				The system generated identifier of the Experiment.
TimeZone	String				The time zone where the campaign operates.
TrackingUrlTemplate	String				The tracking template to use as a default for all URLs in your campaign.
UrlCustomParameters	String				Your custom collection of key and value parameters for URL tracking.
BudgetId	Long				The unique Bing Ads identifier of the Budget that this campaign shares with other campaigns in the account.
AudienceAdsBidAdjustment	Integer				The percent amount by which to adjust your bid for audience ads above or below the base ad group or keyword bid.
Languages	String				The languages of the ads and keywords in the campaign.