Query the available Keyword Performance in Bing Ads.

Table Specific Information

Select

You must specify the Keywords, MatchType, Language, and PublisherCountry columns in the WHERE clause to query this table. Set the MatchType column to one of the following in the WHERE clause: Exact, Phrase, Broad, Content, or Aggregate.

The connector 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 connector. 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.
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.