Power BI Connector for Microsoft Ads

Build 24.0.9060

Campaigns

Query the available Campaigns in Bing Ads.

Table Specific Information

Select

The following query is processed server-side:

SELECT * FROM Campaigns

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) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060