JDBC Driver for Microsoft Ads

Build 22.0.8462

Ads

Query the available Ads in Bing Ads.

Table Specific Information

Select

You must specify the AdGroupId and Type columns in the WHERE clause to query this table. The driver uses the Microsoft Ads API to filter the results by AdGroup and Type, while the rest of the filter is executed client side within the driver.

For example, the following query is processed server side:

SELECT * FROM [Ads] WHERE AdGroupId = '5179946006' AND Type = 'Text'
SELECT * FROM Ads WHERE AdGroupId = '1297424037031698' AND Type = 'DynamicSearch' AND AccountId = '135093022'
SELECT * FROM Ads WHERE AdGroupId = '1302921473177959' AND Type = 'Text' AND AccountId IN ('2562405','141163457','180394748')

Columns

Name Type Select requirement Metric Aggregate Description
Id [KEY] Long The unique Bing Ads identifier for the ad.
AdGroupId Long The system generated identifier of the ad group.
Type String The ad type. One of Text,Image,Product,AppInstall,ExpandedText,DynamicSearch
Title String The title of the ad. The title must contain at least one word. The ad's copy and title combined must total at least three words.
TitlePart1 String The first title part of the ad.
TitlePart2 String The second title part of the ad.
Text String The ad copy. The copy must contain at least one word. The ad's copy and title combined must total at least three words.
Domain String The URL to display in the ad.
DestinationUrl String The URL of the webpage to take the user to when they click the ad.
UrlCustomParameters String Your custom collection of key and value parameters for URL tracking.
TrackingUrlTemplate String The tracking template to use as a default for all landing page URLs.
Status String The status of the ad.
ForwardCompatibilityMap String The list of key and value strings for forward compatibility. This element can be used to avoid otherwise breaking changes when new elements are added in future releases.
FinalUrls String The last or final URL where a user is ultimately taken, whether or not the click to final URL path included any redirects.
FinalMobileUrls String The mobile landing page URL.
FinalAppUrls String Reserved for future use.
EditorialStatus String The editorial review status of the ad, which indicates whether the ad is pending review, has been approved, or has been disapproved.
DevicePreference Integer Determines the device preference for showing the ad.
AdFormatPreference String The Ad Format Preference is used to indicate whether or not you prefer the ad copy to be shown to users as a search or native ad. Search ads tend to be written as a call to action, whereas native ads should be written in more of an informational style.
AccountId Long The Bing Ads assigned identifier of an account.

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