ODBC Driver for Microsoft Ads

Build 24.0.9060

KeywordPerformance

Query the available Keyword Performance in Bing Ads.

Table Specific Information

Select

You must specify the Keywords, Language, and PublisherCountry columns in the WHERE clause to query this table. If not set, MatchType will match all possible values: Exact, Phrase, Broad, Content, Aggregate.

The driver will use the Microsoft Ads API to filter the results by Keywords, MatchType, Language, and PublisherCountry while the rest of the filter is executed client side within the driver. For example, the preceding query is processed on the server.

SELECT * FROM KeywordPerformance WHERE Keywords = 'SAP development,PowerShell Excel' AND Language = 'English' AND PublisherCountry = 'US' AND MatchType = 'Exact'
You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refers to columns other than Keywords, Language, PublisherCountry, and MatchType will cause an error.

Filtering by accountid

You can filter by accountid using the IN condition. For example,

SELECT * FROM KeywordEstimatedBid 
WHERE KeywordText IN ('Text', 'Gmail') 
AND MatchType = 'Exact' 
AND AccountId IN ('141163452', '2562405', '141163453', '141163454', '141163455', '141163456', '141163457')

Columns

Name Type Select requirement Metric Aggregate Description
Keywords String List of Keywords. Use to filter the table.
AdPosition String The position in the search results in which the ad appeared.
MatchType String The match type that you specified in the request.

The allowed values are Exact, Aggregate, Broad, Phrase.

Language String The language in which the keywords are written.
PublisherCountry String The country code of the country/region to use as the source of the demographics data. The country/region that you specify must support the language specified in the Language element.
Device String The device of the user who entered the search query. Default value is 'Computers'.

The allowed values are Computers, NonSmartphones, Smartphones, Tablets.

Keyword String The keyword.
Clicks Integer The number of clicks that the keyword and match type generated during the specified time interval.
Impressions Long The number of impressions that the keyword and match type generated during the specified time interval.
AverageCPC Double The average cost per click (CPC). The average CPC is calculated by dividing the cost of all clicks by the number of clicks.
ClickThroughRate Double The click-through rate (CTR) as a percentage. The CTR is calculated by dividing the number of clicks by the number of impressions and multiplying the result by 100.
TotalCost Double The cost of using the specified keyword and match type during the specified time interval.
AverageBid Double The average bid of the keyword.
AccountId Long The Bing Ads assigned identifier of an account.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060