CData Python Connector for Microsoft Ads

Build 23.0.8839

KeywordLocations

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.

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