KeywordPerformance
Query the available Keyword Performance in Bing Ads.
Table Specific Information
Select
You must specify the Keywords, Language, and PublisherCountry columns in the WHERE clause to query this table. If not set, MatchType will match all possible values: Exact, Phrase, Broad, Content, Aggregate.The connector will use the Microsoft Ads API to filter the results by Keywords, MatchType, Language, and PublisherCountry while the rest of the filter is executed client side within the connector.
For example, the preceding query is processed on the server.
SELECT * FROM KeywordPerformance WHERE Keywords = 'SAP development,PowerShell Excel' AND Language = 'English' AND PublisherCountry = 'US' AND MatchType = 'Exact'
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, PublisherCountry, and MatchType 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. | |||
AdPosition | String | The position in the search results in which the ad appeared. | |||
MatchType | String | The match type that you specified in the request.
使用できる値は次のとおりです。Exact, Aggregate, Broad, Phrase | |||
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'.
使用できる値は次のとおりです。Computers, NonSmartphones, Smartphones, Tablets | |||
Keyword | String | The keyword. | |||
Clicks | Integer | The number of clicks that the keyword and match type generated during the specified time interval. | |||
Impressions | Long | The number of impressions that the keyword and match type generated during the specified time interval. | |||
AverageCPC | Double | The average cost per click (CPC). The average CPC is calculated by dividing the cost of all clicks by the number of clicks. | |||
ClickThroughRate | Double | The click-through rate (CTR) as a percentage. The CTR is calculated by dividing the number of clicks by the number of impressions and multiplying the result by 100. | |||
TotalCost | Double | The cost of using the specified keyword and match type during the specified time interval. | |||
AverageBid | Double | The average bid of the keyword. | |||
AccountId | Long | The Bing Ads assigned identifier of an account. |