CData Python Connector for Microsoft Ads

Build 23.0.8839

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 connector will use the Microsoft Ads API to filter the results by KeywordText and MatchType while the rest of the filter is executed client side within the connector. 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
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 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.
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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839