JDBC Driver for Microsoft Ads

Build 22.0.8462

Campaigns

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462