KeywordHistoricalSearch
Query the available Keyword Historical Search in Bing Ads.
Table Specific Information
Select
You must specify the Keywords, Language, StartDate, and EndDate columns 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 cmdlet will use the Microsoft Ads API to filter the results by Keywords, Language, StartDate, and EndDate while the rest of the filter is executed client side within the cmdlet. For example,
SELECT * FROM KeywordHistoricalSearch WHERE Keywords = 'SAP development' AND Language = 'English' AND StartDate = '2014-01-01' AND EndDate = '2017-01-01'
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, StartDate, and EndDate 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. | |||
| StartDate | Date | The start date of the date range that identifies the data that you want to use to determine the historical search count. | |||
| EndDate | Date | The end date of the date range that identifies the data that you want to use to determine the historical search count. | |||
| Keyword | String | The keyword. | |||
| SearchCount | Long | The number of times that the keyword was used in a search query on the specified device type during the time period. The count aggregates data from all specified countries. | |||
| SearchDate | Date | The time period in which the count was captured. | |||
| AccountId | Long | The Bing Ads assigned identifier of an account. |