KeywordEstimatedPosition
Query the available EstimatedPosition in Bing Ads.
Table Specific Information
Select
You must specify the Keywords and MatchType columns in the WHERE clause to query this table. Set MatchType to one of the following values: Exact, Phrase, Broad, Content and Aggregate. 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 KeywordText and MatchType while the rest of the filter is executed client side within the adapter.
For example, the following query is processed server side.
SELECT * FROM "KeywordEstimatedPosition" WHERE Keywords = 'SAP development,PowerShell Excel' AND MatchType = 'Exact'
SELECT * FROM KeywordEstimatedPosition WHERE Keywords='ssh transfer' AND MatchType='Exact' AND AccountId='135093022' AND MaxBid=50
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. | |||
MaxBid | Long | The maximum bid value to use to determine the estimated position in the search results. | |||
MatchType | String | The keyword match type used to determine the estimates. Can be one of Exact, Phrase, Broad, Aggregate. | |||
CurrencyCode | String | The monetary unit of the cost values, such as AverageCPC. | |||
CampaignId | Long | The system generated identifier of the campaign. | |||
AdGroupId | Long | The system generated identifier of the ad group. | |||
Keyword | String | The keyword. | |||
MinClicksPerWeek | Double | The estimated minimum number of clicks per week. | |||
MaxClicksPerWeek | Double | The estimated maximum number of clicks per week. | |||
AverageCPC | Double | The estimated average CPC. | |||
MinImpressionsPerWeek | Long | The estimated minimum number of impressions per week. | |||
MaxImpressionsPerWeek | Long | The estimated maximum number of impressions per week. | |||
ClickThroughRate | Double | The estimated CTR. | |||
MinTotalCostPerWeek | Double | The estimated minimum cost per week. | |||
MaxTotalCostPerWeek | Double | The estimated maximum cost per week. | |||
EstimatedAdPosition | Double | The position in the search results given the specified bid. | |||
AccountId | Long | The Bing Ads assigned identifier of an account. |