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