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 adapter will use the Bing Ads API to filter the results by Keywords, Language, StartDate, and EndDate while the rest of the filter is executed client side within the adapter. For example,
SELECT * FROM " KeywordHistoricalSearch " WHERE Keywords = 'SAP development' AND Language = 'English' AND StartDate = '2014-01-01' AND EndDate = '2017-01-01'
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. |