Query the available Keyword Locations in Bing Ads.

Table Specific Information

Select

You must specify the Keywords and Language columns in the WHERE clause to query this table. You can search on multiple keywords by setting the Keywords column value to a comma-separated list.

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

SELECT * FROM [ KeywordLocations ] WHERE Keywords = 'SAP development,PowerShell Excel' AND Language = 'English'

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 and Language 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.
Language	String				The language in which the keywords are written.
Device	String				The device of the user who entered the search query.
Keyword	String				The keyword.
Location	String				The country, state, metropolitan area, or city where users entered the search query.
Percentage	Double				The percentage of time that users searched for the keyword from the location. The value is specified in the range 0.0 through 100.0
AccountId	Long				The Bing Ads assigned identifier of an account.