Bing Ads/Microsoft Ads Field Reference

Sample

 

https://connectors.windsor.ai/bing?api_key=[your API key]&date_preset=last_7d&fields=campaign,clicks,spend,impressions,date,source


Fields

IDTypeNameDescriptionReports
absolute_top_impression_rate_percentTEXTAbsolute Top Impression Rate PercentHow often your ad was in the first position of all results, as a percentage of your total impressions. A higher number indicates your ad is frequently showing in the best ad position.user_location_performance;
account_idTEXTAccount IDThe account idad_performance; campaign_performance; keyword_performance; conversion_performance; budget_summary; user_location_performance;
account_nameTEXTAccount NameThe account namead_performance; campaign_performance; keyword_performance; conversion_performance; budget_summary; user_location_performance;
account_numberTEXTAccount NumberThe Microsoft Advertising assigned number of an account.ad_performance; campaign_performance; keyword_performance; conversion_performance; budget_summary; user_location_performance;
account_statusTEXTAccount StatusThe account statusad_performance; campaign_performance; keyword_performance; conversion_performance;
ad_distributionTEXTAd DistributionThe network where you want your ads to show. This can be the entire Microsoft Advertising Network, Microsoft sites and select traffic, or only partner traffic.user_location_performance;
ad_group_idTEXTAd group IDThe ID of the AdGroup.ad_performance; keyword_performance; conversion_performance; user_location_performance;
ad_group_nameTEXTAd groupThe name of the AdGroup.ad_performance; keyword_performance; conversion_performance; user_location_performance;
ad_idTEXTAd IDThe ad idad_performance;
ad_titleTEXTAd TitleThe ad titlead_performance;
ad_title_part_1TEXTTitle Part 1The title part 1 attribute of an ad.ad_performance;
ad_title_part_2TEXTTitle Part 2The title part 2 attribute of an ad.ad_performance;
ad_title_part_3TEXTTitle Part 3The title part 3 attribute of an ad.ad_performance;
adnetwork_conversionsNUMERICAd Network ConversionsThe ad network reported conversionsad_performance; campaign_performance; keyword_performance; conversion_performance; user_location_performance;
adnetwork_revenueNUMERICAd Network RevenueThe ad network reported revenuead_performance; campaign_performance; keyword_performance; conversion_performance; user_location_performance;
all_conversion_rateNUMERICAll Conversion RateThe conversion rate as a percentage.ad_performance; campaign_performance; keyword_performance; conversion_performance; user_location_performance;
all_conversionsNUMERICAll ConversionsThe number of conversions.ad_performance; campaign_performance; keyword_performance; conversion_performance; user_location_performance;
all_cost_per_conversionNUMERICAllCostPerConversionThe cost per conversion.ad_performance; campaign_performance; keyword_performance; conversion_performance; user_location_performance;
all_revenueNUMERICAll RevenueThe revenue optionally reported by the advertiser as a result of conversions.ad_performance; campaign_performance; keyword_performance; conversion_performance; user_location_performance;
all_revenue_per_conversionNUMERICAll Revenue Per ConversionThe revenue per conversion.The formula for calculating the revenue per conversion is (Revenue / Conversions).ad_performance; campaign_performance; keyword_performance; conversion_performance; user_location_performance;
all_roasNUMERICAllReturnOnAdSpendThe return on ad spend (ROAS).The formula for calculating the ROAS is (Revenue / Spend).ad_performance; campaign_performance; keyword_performance; conversion_performance; user_location_performance;
average_cpcNUMERICAverage CPCThe average cost per click (CPC). The total cost of all clicks on an ad divided by the number of clicks. This is the average amount you're actually charged each time your ad is clicked.ad_performance; campaign_performance; keyword_performance; user_location_performance;
average_cpmNUMERICAverage CPMThe total advertising cost divided by the number of impressions (in thousands).ad_performance; campaign_performance; keyword_performance; user_location_performance;
bid_match_typeNUMERICBid Match TypeThe keyword bid match type. This can be different from the DeliveredMatchType column, for example if you bid on a broad match and the search term was an exact match. For more information, see Budget and Bid Strategies. The possible values are Broad, Exact, Phrase, and Unknown.ad_performance; campaign_performance; keyword_performance; user_location_performance;
campaignTEXTCampaignThe campaign Namead_performance; campaign_performance; keyword_performance; conversion_performance; budget_summary; user_location_performance;
campaign_idTEXTCampaign IDThe campaign IDad_performance; campaign_performance; keyword_performance; conversion_performance; budget_summary; user_location_performance;
cityTEXTCityThe city where the user was physically located when they clicked the ad.user_location_performance;
clicksNUMERICClicksThe number of clicksad_performance; campaign_performance; keyword_performance; conversion_performance; user_location_performance;
conversion_ratePERCENTConversion RateThe conversion rate as a percentage.ad_performance; campaign_performance; keyword_performance; conversion_performance; user_location_performance;
conversionsNUMERICConversionsThe number of conversionsad_performance; campaign_performance; keyword_performance; conversion_performance; user_location_performance;
cost_per_conversionNUMERICCostPerConversionThe cost per conversion.ad_performance; campaign_performance; keyword_performance; conversion_performance; user_location_performance;
countryCOUNTRYCountryThe country where the user was physically located when they clicked the ad.user_location_performance;
countyTEXTCountyThe county where the user was physically located when they clicked the ad.user_location_performance;
ctrPERCENTCtrThe number of clicks your ad receives (Clicks) divided by the number of times your ad is shown (Impressions).ad_performance; campaign_performance; keyword_performance; conversion_performance; user_location_performance;
currencyTEXTCurrencyThe account currency type.ad_performance; campaign_performance; keyword_performance; conversion_performance; budget_summary; user_location_performance;
currency_codeTEXTCurrency CodeThe account currency type.ad_performance; campaign_performance; keyword_performance; conversion_performance; budget_summary; user_location_performance;
daily_budget_spendNUMERICDaily SpendThe average amount of campaign budget spent per day.budget_summary;
dateDATEDateThe datead_performance; campaign_performance; keyword_performance; conversion_performance; budget_summary; user_location_performance;
delivered_match_typeNUMERICDelivered Match TypeThe match type used to deliver an ad. This can be different from the BidMatchType column, for example if you bid on a broad match and the search term was an exact match. For more information, see Budget and Bid Strategies. The possible values are Broad, Exact, Phrase, and Unknown.ad_performance; campaign_performance; keyword_performance; user_location_performance;
deviceTEXTDevice TypeDevice typead_performance; campaign_performance; keyword_performance; user_location_performance;
device_osNUMERICDevice OSThe operating system of the device reported in the DeviceType column. The possible values include Android, Blackberry, iOS, Other, Unknown, and Windows. If the operating system of the device cannot be determined or is not one of the operating systems that you can target, the value in this column will be Unknown.ad_performance; campaign_performance; keyword_performance; user_location_performance;
final_urlTEXTThe Final URL of the keywordOnly the first URL in the list is reported. If the URL contains dynamic text substitution parameters (for example, {param1}), the report will contain the URL before substitution.ad_performance;
final_url_suffixTEXTFinal Url SuffixA place in your final URL where you can add parameters that will be attached to the end of your landing page URL.ad_performance; campaign_performance; keyword_performance;
goalTEXTGoalThe name of the goal you set for the conversions you want, meaning actions customers take after clicking your ad.conversion_performance; user_location_performance;
goal_typeTEXTGoal TypeThe type of conversion goal. Possible values include AppInstall, Duration, Event, InStoreTransaction, OfflineConversion, PagesViewedPerVisit, and Url.conversion_performance; user_location_performance;
impression_share_percentTEXTImpression Share PercentThe estimated percentage of impressions, out of the total available impressions in the market you were targeting.ad_performance; campaign_performance; keyword_performance;
impressionsNUMERICImpressionsThe number of impressionsad_performance; campaign_performance; keyword_performance; conversion_performance; user_location_performance;
keywordTEXTKeywordThe keyword.keyword_performance; conversion_performance;
keyword_idNUMERICThe Keyword IDThe keyword ID.keyword_performance; conversion_performance;
languageTEXTLanguageThe language of the publisher where the ad was shown. The language display name will be provided in the report e.g. English.user_location_performance;
location_idTEXTLocation IdThe Microsoft Advertising identifier of the location where the user was physically located when they clicked the ad. For geographical location identifiers, see Geographical Location Codes. If the location ID is in the report but not found in the file downloaded via GetGeoLocationsFileUrl, it is not targetable.user_location_performance;
metro_areaTEXTMetro AreaThe metro area (Nielsen DMA in the United States) where the user was physically located when they clicked the ad.user_location_performance;
month_to_date_budget_spendNUMERICMonth to Date Budget SpendThe amount of money spent to date for the month.budget_summary;
monthly_budgetNUMERICMonthly BudgetThe anticipated maximum monthly budget amount that was calculated on the date of the most recent budget change.budget_summary;
neighborhoodTEXTNeighborhoodThe neighborhood where an ad was physically served, or the neighborhood that your customer had shown interest in through searches or content they had viewed. This helps you find out how your ads are doing in different locations, which can help you decide where to focus more of your advertising efforts.user_location_performance;
postal_codeTEXTPostal CodeThe postal code where the user was physically located when they clicked the ad.user_location_performance;
proximity_target_locationTEXTProximity Target LocationThe radius target bid name. The name of the geographic radius where the user was physically located when they clicked the ad. The Radius attribute column contains the distance of the radius.user_location_performance;
query_intent_cityTEXTQuery Intent CityThe name of a city if the user's geographical intent can be determined. The city is set if the user's intent is a city, and not necessarily if they are physically located in the city.user_location_performance;
query_intent_countryTEXTQuery Intent CountryThe name of a country if the user's geographical intent can be determined. The country is set if the user's intent is related to a country, and not necessarily if they are physically located in the county.user_location_performance;
query_intent_countyTEXTQuery Intent CountyThe name of a county if the user's geographical intent can be determined. The county is set if the user's intent is related to a county, and not necessarily if they are physically located in the county.user_location_performance;
query_intent_dmaTEXTQuery Intent DMAThe name of a metro area (Nielsen DMA in the United States) if the user's geographical intent can be determined. The metro area is set if the user's intent is a metro area or city within the metro area, and not necessarily if they are physically located in the metro area.user_location_performance;
query_intent_location_idTEXTQuery Intent Location IdThe location identifier if the user's geographical intent can be determined.user_location_performance;
query_intent_neighborhoodTEXTQuery Intent NeighborhoodThe name of a neighborhood if the user's geographical intent can be determined. The neighborhood is set if the user's intent is related to a neighborhood, and not necessarily if they are physically located in the neighborhood. For example, the user's search query was rental cars in Encino.user_location_performance;
query_intent_postal_codeTEXTQuery Intent Postal CodeThe name of a postal code if the user's geographical intent can be determined. The postal code is set if the user's intent is a postal code, and not necessarily if they are physically located in the postal code.user_location_performance;
query_intent_stateTEXTQuery Intent StateThe name of a state if the user's geographical intent can be determined. The state is set if the user's intent is a state or sub geography of the state, and not necessarily if they are physically located in the state.user_location_performance;
radiusNUMERICRadiusThe radius of a radius target bid. The geographic radius where the user was physically located when they clicked the ad. The ProximityTargetLocation attribute column contains the address or landmark name of the radius.user_location_performance;
revenueNUMERICRevenueThe amount of revenuead_performance; campaign_performance; keyword_performance; conversion_performance; user_location_performance;
spendNUMERICSpendThe media spendad_performance; campaign_performance; keyword_performance; conversion_performance; user_location_performance;
stateTEXTStateThe state where the user was physically located when they clicked the ad.user_location_performance;
top_impression_rate_percentTEXTTop Impression Rate PercentThe percentage of times your ad showed in the mainline, the top placement where ads appear above the search results, out of your total impressions.ad_performance; campaign_performance; keyword_performance; conversion_performance; user_location_performance;
top_vs_otherTEXTTop vs OtherIndicates whether the ad impression appeared in a top position or elsewhere. The possible values include AOL search - Top, AOL search - Other, Audience network, Bing and Yahoo! search - Top, Bing and Yahoo! search - Other, Syndicated search partners - Top, Syndicated search partners - Other, Content network, and Unknown.of your total impressions.ad_performance; campaign_performance; keyword_performance; conversion_performance; user_location_performance;
totalcostNUMERICTotal CostThe media spend (Duplicate)ad_performance; campaign_performance; keyword_performance; conversion_performance; user_location_performance;
transactionrevenueNUMERICTransaction RevenueThe amount of revenuead_performance; campaign_performance; keyword_performance; conversion_performance; user_location_performance;
view_through_revenueNUMERICView Through RevenueThe revenue optionally reported by the advertiser as a result of view-through conversions.ad_performance; campaign_performance; keyword_performance; conversion_performance; user_location_performance;