JDBC Driver for Microsoft Ads

Build 23.0.8839

KeywordDemographics

Query the available Keyword Demographics in Bing Ads.

Table Specific Information

Select

You must specify the Keywords, Language, and PublisherCountry 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 in the WHERE clause.

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

SELECT * FROM [ KeywordDemographics ] WHERE Keywords = 'Gmail Excel,PowerShell Excel' AND Language = 'English' AND PublisherCountry = 'US'

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, and PublisherCountry 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.
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.
Age18to24 Double The percentage of time that users 18 through 24 years of age searched for the keyword. The value is specified in the range 0.0 through 1.0.
Age25to34 Double The percentage of time that users 25 through 34 years of age searched for the keyword. The value is specified in the range 0.0 through 1.0.
Age35to49 Double The percentage of time that users 35 through 49 years of age searched for the keyword. The value is specified in the range 0.0 through 1.0.
Age50to64 Double The percentage of time that users 50 through 64 years of age searched for the keyword. The value is specified in the range 0.0 through 1.0.
Age65Plus Double The percentage of time that users 65 years of age or older searched for the keyword. The value is specified in the range 0.0 through 1.0.
AgeUnknown Double Not used.
Female Double The percentage of time that female users searched for the keyword. The value is specified in the range 0.0 through 1.0.
Male Double The percentage of time that male users searched for the keyword. The value is specified in the range 0.0 through 1.0.
GenderUnknown Double Not Used.
AccountId Long The Bing Ads assigned identifier of an account.

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