Bing Ads/Microsoft Ads Sample
https://connectors.windsor.ai/bing?api_key=[your API key]&date_preset=last_7d&fields=campaign,clicks,spend,impressions,date,source&_renderer=csv
Fields ID Type Name Description account_id TEXT Account ID The account id account_name TEXT Account Name The account name account_number TEXT Account Number The Microsoft Advertising assigned number of an account. account_status TEXT Account Status The account status ad_group_id NUMERIC Ad group ID The ID of the AdGroup. ad_group_name TEXT Ad group The name of the AdGroup. ad_id TEXT Ad ID The ad id ad_title TEXT Ad Title The ad title ad_title_part_1 TEXT Title Part 1 The title part 1 attribute of an ad. ad_title_part_2 TEXT Title Part 2 The title part 2 attribute of an ad. ad_title_part_3 TEXT Title Part 3 The title part 3 attribute of an ad. adnetwork_conversions NUMERIC Ad Network Conversions The ad network reported conversions adnetwork_revenue NUMERIC Ad Network Revenue The ad network reported revenue all_conversion_rate NUMERIC All Conversion Rate The conversion rate as a percentage. all_conversions NUMERIC All Conversions The number of conversions. all_cost_per_conversion NUMERIC AllCostPerConversion The cost per conversion. all_revenue NUMERIC All Revenue The revenue optionally reported by the advertiser as a result of conversions. all_revenue_per_conversion NUMERIC All Revenue Per Conversion The revenue per conversion.The formula for calculating the revenue per conversion is (Revenue / Conversions). all_roas NUMERIC AllReturnOnAdSpend The return on ad spend (ROAS).The formula for calculating the ROAS is (Revenue / Spend). average_cpc NUMERIC Average CPC The 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. average_cpm NUMERIC Average CPM The total advertising cost divided by the number of impressions (in thousands). campaign TEXT Campaign The campaign Name campaign_id TEXT Campaign ID The campaign ID clicks NUMERIC Clicks The number of clicks conversions NUMERIC Conversions The number of conversions ctr PERCENT Ctr The number of clicks your ad receives (Clicks) divided by the number of times your ad is shown (Impressions). currency_code TEXT Currency Code The account currency type. daily_budget_spend NUMERIC Daily Spend The average amount of campaign budget spent per day. date DATE Date The date device TEXT Device Type Device type final_url TEXT The Final URL of the keyword Only 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. final_url_suffix TEXT Final Url Suffix A place in your final URL where you can add parameters that will be attached to the end of your landing page URL. goal TEXT Goal The name of the goal you set for the conversions you want, meaning actions customers take after clicking your ad. goal_type TEXT Goal Type The type of conversion goal. Possible values include AppInstall, Duration, Event, InStoreTransaction, OfflineConversion, PagesViewedPerVisit, and Url. impression_share_percent TEXT Impression Share Percent The estimated percentage of impressions, out of the total available impressions in the market you were targeting. impressions NUMERIC Impressions The number of impressions keyword TEXT Keyword The keyword. keyword_id NUMERIC Ad group ID The keyword ID. month_to_date_budget_spend NUMERIC Month to Date Budget Spend The amount of money spent to date for the month. monthly_budget NUMERIC Monthly Budget The anticipated maximum monthly budget amount that was calculated on the date of the most recent budget change. revenue NUMERIC Revenue The amount of revenue spend NUMERIC Spend The media spend top_impression_rate_percent TEXT Top Impression Rate Percent The percentage of times your ad showed in the mainline, the top placement where ads appear above the search results, out of your total impressions. totalcost NUMERIC Total Cost The media spend (Duplicate) transactionrevenue NUMERIC Transaction Revenue The amount of revenue
