Any MCP-compatible appRead live data
- Campaigns, ad groups and ads
- Impression share, and share lost to budget or rank
- Quality Score, expected CTR and landing page experience
- Low-quality clicks and phone calls
Connect once, use it two ways
Connect Microsoft Ads to Jepto once. What you build in Jepto and what you ask in Claude or ChatGPT read the same data, so the numbers match wherever you look.
Add the Jepto MCP server and ask about Microsoft Ads in plain English, across all your brands. Included on every plan.
and any MCP-compatible appJepto runs a hosted Microsoft Ads MCP server at mcp.jepto.com. Connect it once and Claude, ChatGPT, Cursor or any MCP-compatible app can query 126 Microsoft Advertising fields across every account you manage, next to Google Ads and your other channels. There's nothing to install and no developer token to set up. It reads your Microsoft Ads data and never changes it.
Paste the URL into your AI assistant, or find Jepto in Claude's connector directory or ChatGPT's Plugins page. Sign in to Jepto once and every conversation can use your live Microsoft Ads data.
Works with
OAuth sign-in. Each person sees only the brands their Jepto login can.
Your assistant shows a preview. Nothing saves until you confirm.
Nothing. The Jepto MCP reads your Microsoft Ads data and never changes it.
Paste one into Claude or ChatGPT once Jepto is connected. Swap [brand] for one of yours.
“Which campaigns are losing the most impression share to budget, and which to rank, this month?”
“Which ad groups have the lowest Quality Score, and how much did they spend last month?”
“How many low-quality clicks did [brand] get last month, and which campaigns had the highest rate?”
“Compare Microsoft Ads and Google Ads CPC and conversion rate by campaign type for the last 30 days.”
“What share of spend went to top-of-page positions compared with other positions?”
“Is [brand]'s Microsoft Ads spend on track for this month's budget?”
Microsoft's own server is in pilot. Jepto works today, and puts Microsoft Ads next to Google Ads so you can compare the two in one answer.
| Compared on | Jepto MCP | Microsoft Advertising MCP | Community servers |
|---|---|---|---|
| Setup | Hosted. Paste one URL, or pick Jepto in the Claude or ChatGPT directory, then sign in. | Pilot onboarding through Microsoft. | You install, host and update it, and supply your own API credentials. |
| Accounts | Every Microsoft Ads account you've connected, across all your brands, in one connection. | Accounts your Microsoft login can reach. | Usually one login or token at a time. |
| Other channels | Ask across Microsoft Ads and every other connected source in the same question. | Microsoft Advertising only. | One platform per server. You combine servers yourself. |
| Brand context | Reads each brand's details and knowledgebase, so answers reflect what the business sells and what it's aiming for. | None. | None. |
| Field guidance | Ships a query guide the AI reads first, so it picks the right Microsoft Ads fields and says what isn't available. | Microsoft's own tools. | Raw API fields. The AI works out what they mean. |
| Changes | Read-only in Microsoft Ads. Budgets and KPI targets in Jepto can be set from chat, with a confirm step. | Read-only at launch. | Varies. Some write to your account with no confirm step. |
| Cost | Included on every Jepto plan, with no usage limits. | Free to connect. | Free code. Your time to run and maintain it. |
Every Microsoft Ads metric and dimension in the Jepto data model, with its definition. Each one works the same way in Reports, Data Chat and the Jepto MCP.
| How you connect | Sign in with Microsoft. You need access to the Microsoft Advertising accounts. |
| Levels | Account, campaign, ad group, ad, device, network |
| Use it in | Reports, Data Chat, KPI forecasting, budget tracking, anomaly alerts and the Jepto MCP |
| AI assistants | Claude, ChatGPT, Cursor and any MCP client, at https://mcp.jepto.com |
| Changes from chat | None. The MCP reads your data and never changes it |
| Field | Description | Kind | Type | Aggregation | Format |
|---|---|---|---|---|---|
ImpressionsmicrosoftAds.impressions | Number of times your ads were shown, including repeat views by the same person. | Metric | number | Sum | — |
ClicksmicrosoftAds.clicks | Number of clicks on your ads during the reporting period. | Metric | number | Sum | — |
Phone impressionsmicrosoftAds.phoneImpressions | Number of times your phone number was displayed with your ad. | Metric | number | Sum | — |
Phone callsmicrosoftAds.phoneCalls | Number of calls made to the phone number displayed in your ad. | Metric | number | Sum | — |
Phone-through ratemicrosoftAds.ptr | Phone-through rate: percentage of phone impressions that resulted in a phone call. | Metric | number | Sum | — |
Avg. watch time per impressionmicrosoftAds.avgWatchTimePerImpression | Average time users spent watching your video ad per impression. | Metric | number | Average | — |
SalesmicrosoftAds.sales | Number of sales events attributed to your ads. | Metric | number | Sum | — |
InstallsmicrosoftAds.installs | Number of app installs attributed to the ad. | Metric | number | Sum | — |
Click-through ratiomicrosoftAds.clickThroughRatio | Click-through ratio: clicks ÷ impressions, expressed as a decimal ratio. Calculated in Jepto from other fields in this report using the formula on the metric. | Metric | number | Calculated: Clicks ÷ Impressions | — |
CPM (from spend)microsoftAds.costPerMilleFromSpend | Average cost per 1,000 impressions: spend ÷ impressions × 1,000. Calculated in Jepto from other fields in this report using the formula on the metric. | Metric | number | Calculated: (Spend ÷ Impressions) × 1,000 | — |
Install ratemicrosoftAds.installRatePct | Percentage of clicks that resulted in an install: installs ÷ clicks. Calculated in Jepto from other fields in this report using the formula on the metric. | Metric | number | Calculated: (Installs ÷ Clicks) × 100 | — |
Sales ratemicrosoftAds.salesRatePct | Percentage of clicks that resulted in a sale: sales ÷ clicks. Calculated in Jepto from other fields in this report using the formula on the metric. | Metric | number | Calculated: (Sales ÷ Clicks) × 100 | — |
Avg. watch time per impressionmicrosoftAds.avgWatchTimeMsPerImpressionDerived | Average total watch time in ms per impression (derived). | Metric | number | Calculated | — |
Phone-through ratemicrosoftAds.phoneThroughRatePctDerived | Percentage of phone impressions that resulted in a phone call: phone calls ÷ phone impressions. Calculated in Jepto from other fields in this report using the formula on the metric. | Metric | number | Calculated: (Phone calls ÷ Phone impressions) × 100 | — |
| Field | Description | Kind | Type | Aggregation | Format |
|---|---|---|---|---|---|
SpendmicrosoftAds.spend | Total advertising spend during the reporting period, in your account currency. | Metric | number | Sum | Currency |
Avg. CPCmicrosoftAds.avgCpc | Average cost per click: spend divided by clicks, in account currency. | Metric | number | Average | Currency |
Avg. CPMmicrosoftAds.avgCpm | Average cost per 1,000 impressions: spend divided by impressions (×1,000), in account currency. | Metric | number | Average | Currency |
Cost per assistmicrosoftAds.costPerAssist | Average spend for each assist: spend divided by the number of assist events. | Metric | number | Average | Currency |
Avg. CPVmicrosoftAds.avgCpv | Average cost per video view: spend ÷ video views. | Metric | number | Average | Currency |
Cost per salemicrosoftAds.costPerSale | Average spend for each sale: spend divided by the number of sale events. | Metric | number | Average | Currency |
Cost per installmicrosoftAds.costPerInstall | Average spend for each install: spend divided by the number of install events. | Metric | number | Average | Currency |
| Field | Description | Kind | Type | Aggregation | Format |
|---|---|---|---|---|---|
CTRmicrosoftAds.ctr | Click-through rate: clicks divided by impressions, shown as a percentage. | Metric | number | Average | Percentage |
View-through ratemicrosoftAds.viewThroughRate | Percentage of impressions that resulted in a view-through conversion: view-through conversions ÷ impressions. | Metric | number | Average | Percentage |
All ROASmicrosoftAds.allReturnOnAdSpend | Return on ad spend including all conversion types: all revenue ÷ spend. | Metric | number | Average | Decimal (×) |
Relative CTRmicrosoftAds.relativeCtr | Your CTR compared to the average CTR of all other advertisers on the same websites: your CTR ÷ competitor average CTR. | Metric | number | Average | Percentage |
| Field | Description | Kind | Type | Aggregation | Format |
|---|---|---|---|---|---|
Video viewsmicrosoftAds.videoViews | Number of times your video ad was viewed. | Metric | number | Sum | — |
Video views 25%microsoftAds.videoViewsAt25Percent | Number of times your video ad was watched to at least 25% completion. | Metric | number | Sum | Percentage |
Video views 50%microsoftAds.videoViewsAt50Percent | Number of times your video ad was watched to at least 50% completion. | Metric | number | Sum | Percentage |
Video views 75%microsoftAds.videoViewsAt75Percent | Number of times your video ad was watched to at least 75% completion. | Metric | number | Sum | Percentage |
Video completionsmicrosoftAds.completedVideoViews | Number of times your video ad was watched to completion. | Metric | number | Sum | — |
Video completion ratemicrosoftAds.videoCompletionRate | Percentage of video views that were watched to completion: video completions ÷ video views. | Metric | number | Average | Percentage |
Avg. watch time per viewmicrosoftAds.avgWatchTimePerVideoView | Average time users spent watching your video ad per view. | Metric | number | Average | — |
Video view ratemicrosoftAds.videoViewsPerImpressionPct | Percentage of impressions that resulted in a video view: video views ÷ impressions. Calculated in Jepto from other fields in this report using the formula on the metric. | Metric | number | Calculated: (Video views ÷ Impressions) × 100 | — |
Video completion rate (by impressions)microsoftAds.completedVideoViewsPerImpressionPct | Percentage of impressions that resulted in a completed video view: video completions ÷ impressions. Calculated in Jepto from other fields in this report using the formula on the metric. | Metric | number | Calculated: (Video completions ÷ Impressions) × 100 | — |
| Field | Description | Kind | Type | Aggregation | Format |
|---|---|---|---|---|---|
Avg. positionmicrosoftAds.avgPosition | Average position of your ad on the search results page during the reporting period. | Metric | number | Average | — |
Impression sharemicrosoftAds.impressionSharePercent | Percentage of available impressions your ads received: impressions ÷ total eligible impressions. | Metric | number | Average | Percentage |
Impression share lost (budget)microsoftAds.impressionLostToBudgetPercent | Percentage of eligible impressions your ads missed because your budget was too low. | Metric | number | Average | Percentage |
Impression share lost (rank)microsoftAds.impressionLostToRankPercent | Percentage of eligible impressions your ads missed due to poor ad rank. | Metric | number | Average | Percentage |
Quality ScoremicrosoftAds.qualityScore | Measures how relevant your ad, keywords, and landing page are to users. | Metric | number | Sum | — |
Expected CTRmicrosoftAds.expectedCtr | Expected click-through rate component of quality score (1–3: Below Average, Average, Above Average). | Metric | number | Average | Percentage |
Ad relevancemicrosoftAds.adRelevance | Ad relevance score indicating how closely your ad matches user intent: 1=Below Average, 2=Average, 3=Above Average. | Metric | number | Sum | — |
Landing page experiencemicrosoftAds.landingPageExperience | Landing page relevance score: 1=Below Average, 2=Average, 3=Above Average. | Metric | number | Sum | — |
Low quality clicksmicrosoftAds.lowQualityClicks | Number of clicks on your ads flagged as low quality (invalid or fraudulent). | Metric | number | Sum | — |
Low quality click ratemicrosoftAds.lowQualityClicksPercent | Percentage of total clicks flagged as low quality: low quality clicks ÷ total clicks. | Metric | number | Average | Percentage |
Low quality impressionsmicrosoftAds.lowQualityImpressions | Number of impressions flagged as low quality. | Metric | number | Sum | — |
Low quality impression ratemicrosoftAds.lowQualityImpressionsPercent | Percentage of total impressions flagged as low quality: low quality impressions ÷ total impressions. | Metric | number | Average | Percentage |
Abs. top impression ratemicrosoftAds.absoluteTopImpressionRatePercent | Percentage of your impressions that appeared in the absolute top position (above all search results). | Metric | number | Average | Percentage |
Top impression ratemicrosoftAds.topImpressionRatePercent | Percentage of your impressions that appeared in a top position above organic search results. | Metric | number | Average | Percentage |
Abs. top impression sharemicrosoftAds.absoluteTopImpressionSharePercent | Percentage of total eligible impressions your ads received in the absolute top position. | Metric | number | Average | Percentage |
Top impression sharemicrosoftAds.topImpressionSharePercent | Percentage of total eligible impressions your ads received in a top position above organic search results. | Metric | number | Average | Percentage |
Click sharemicrosoftAds.clickSharePercent | Percentage of total eligible clicks your ads received: clicks ÷ total eligible clicks. | Metric | number | Average | Percentage |
Exact match impression sharemicrosoftAds.exactMatchImpressionSharePercent | Percentage of eligible exact-match impressions your ads received for searches that exactly matched your keywords. | Metric | number | Average | Percentage |
Low quality click rate (calculated)microsoftAds.lowQualityClickRatePct | Percentage of total clicks flagged as low quality: low quality clicks ÷ total clicks. Calculated in Jepto from other fields in this report using the formula on the metric. | Metric | number | Calculated: (Low quality clicks ÷ Clicks) × 100 | — |
| Field | Description | Kind | Type | Aggregation | Format |
|---|---|---|---|---|---|
ConversionsmicrosoftAds.conversions | Number of completed conversion actions you are measuring (e.g. purchases, sign-ups, leads). | Metric | number | Sum | — |
Conversion ratemicrosoftAds.conversionRate | Conversion rate as percentage: (Conversions / Clicks) × 100. | Metric | number | Average | Percentage |
Cost per conversionmicrosoftAds.costPerConversion | Average spend for each conversion: spend divided by the number of conversion events. | Metric | number | Average | Currency |
View-through conversionsmicrosoftAds.viewThroughConversions | Number of conversions from users who saw your ad but didn't click, then converted within the attribution window. | Metric | number | Sum | — |
View-through conversions (qualified)microsoftAds.viewThroughConversionsQualified | Qualified view-through conversions including partial values from external attribution. | Metric | number | Sum | — |
View-through revenuemicrosoftAds.viewThroughRevenue | Revenue attributed to view-through conversions during the reporting period. | Metric | number | Sum | Currency |
Conversion ValuemicrosoftAds.conversionValue | Total conversion value reported for attributed conversion events, in your account currency. Only populated when conversion tracking sends a value. | Metric | number | Sum | Currency |
ROASmicrosoftAds.revenueSpendRatio | Return on ad spend: total revenue divided by total advertising spend. | Metric | number | Average | Decimal (×) |
Revenue per conversionmicrosoftAds.revenuePerConversion | Average revenue per conversion: total conversion value ÷ conversions. | Metric | number | Average | Currency |
AssistsmicrosoftAds.assists | Number of times a click on your ad preceded a conversion that was ultimately attributed to a different ad. | Metric | number | Sum | — |
Revenue per assistmicrosoftAds.revenuePerAssist | Average revenue per assist: total revenue ÷ assists. | Metric | number | Average | Currency |
Conversions (qualified)microsoftAds.conversionsQualified | Conversions including partial externally attributed offline conversions. | Metric | number | Sum | — |
All conversions (qualified)microsoftAds.allConversionsQualified | All conversions including partial values, regardless of ExcludeFromBidding setting. | Metric | number | Sum | — |
All conversion ratemicrosoftAds.allConversionRate | Percentage of clicks that resulted in any conversion (all types): all conversions ÷ clicks. | Metric | number | Average | Percentage |
All cost per conversionmicrosoftAds.allCostPerConversion | Average spend per all-type conversion: spend ÷ all conversions. | Metric | number | Average | Currency |
All revenuemicrosoftAds.allRevenue | Total revenue attributed to all conversion types during the reporting period. | Metric | number | Sum | Currency |
All revenue per conversionmicrosoftAds.allRevenuePerConversion | Average revenue per all-type conversion: all revenue ÷ all conversions. | Metric | number | Average | Currency |
Revenue per salemicrosoftAds.revenuePerSale | Average revenue per sale event: total revenue ÷ sales. | Metric | number | Average | Currency |
Revenue per installmicrosoftAds.revenuePerInstall | Average revenue per install: total revenue ÷ installs. | Metric | number | Average | Currency |
App installsmicrosoftAds.appInstalls | Number of app installs attributed to your ads. | Metric | number | Sum | — |
Conversion rate (by clicks)microsoftAds.conversionRateByClicksPct | Conversion rate (%) from clicks; same basis as API ConversionRate, as an explicit calculated measure. For session-based rates, join session data from another source—Microsoft Ads reports do not expose sessions. Calculated in Jepto from other fields in this report using the formula on the metric. | Metric | number | Calculated: (Conversions ÷ Clicks) × 100 | — |
Conversion rate (by impressions)microsoftAds.conversionRateByImpressionPct | Percentage of impressions that resulted in a conversion: conversions ÷ impressions. Calculated in Jepto from other fields in this report using the formula on the metric. | Metric | number | Calculated: (Conversions ÷ Impressions) × 100 | — |
All conversion rate (by impressions)microsoftAds.allConversionRateByImpressionPct | Percentage of impressions that resulted in any conversion (all types): all conversions ÷ impressions. Calculated in Jepto from other fields in this report using the formula on the metric. | Metric | number | Calculated: (All conversions (qualified) ÷ Impressions) × 100 | — |
Revenue per clickmicrosoftAds.revenuePerClick | Average revenue per click: total conversion value ÷ clicks. Calculated in Jepto from other fields in this report using the formula on the metric. | Metric | number | Calculated: Conversion Value ÷ Clicks | — |
Revenue per impressionmicrosoftAds.revenuePerImpression | Average revenue per impression: total conversion value ÷ impressions. Calculated in Jepto from other fields in this report using the formula on the metric. | Metric | number | Calculated: Conversion Value ÷ Impressions | — |
Net conversion valuemicrosoftAds.netConversionValue | Profit from conversions after deducting ad spend: conversion value − spend. Calculated in Jepto from other fields in this report using the formula on the metric. | Metric | number | Calculated: Conversion Value − Spend | — |
Conversion value marginmicrosoftAds.conversionValueMarginPct | Percentage of conversion value remaining after deducting ad spend: (conversion value − spend) ÷ conversion value. Calculated in Jepto from other fields in this report using the formula on the metric. | Metric | number | Calculated: ((Conversion Value − Spend) ÷ Conversion Value) × 100 | — |
Assists per conversionmicrosoftAds.assistsPerConversion | Average number of assist clicks per recorded conversion: assists ÷ conversions. Calculated in Jepto from other fields in this report using the formula on the metric. | Metric | number | Calculated: Assists ÷ Conversions | — |
Assists per clickmicrosoftAds.assistsPerClick | Average number of assist clicks per total click: assists ÷ clicks. Calculated in Jepto from other fields in this report using the formula on the metric. | Metric | number | Calculated: Assists ÷ Clicks | — |
View-through to click conversion ratiomicrosoftAds.viewThroughToClickConversionRatio | Ratio of view-through conversions to click-based conversions: view-through conversions ÷ conversions. Calculated in Jepto from other fields in this report using the formula on the metric. | Metric | number | Calculated: View-through conversions ÷ Conversions | — |
All conversions per clickmicrosoftAds.allConversionsPerClick | All conversions per click: all qualified conversions ÷ clicks. Calculated in Jepto from other fields in this report using the formula on the metric. | Metric | number | Calculated: All conversions (qualified) ÷ Clicks | — |
App install ratemicrosoftAds.appInstallRatePct | Percentage of clicks that resulted in an app install: app installs ÷ clicks. Calculated in Jepto from other fields in this report using the formula on the metric. | Metric | number | Calculated: (App installs ÷ Clicks) × 100 | — |
| Field | Description | Kind | Type | Aggregation | Format |
|---|---|---|---|---|---|
Account IDmicrosoftAds.accountId | Unique identifier for the Microsoft Advertising account. | Dimension | string | — | — |
Account namemicrosoftAds.accountName | Name of the Microsoft Advertising account. | Dimension | string | — | — |
Account statusmicrosoftAds.accountStatus | Current delivery status in the advertising platform (for example enabled, paused, or removed). | Dimension | string | — | — |
Currency codemicrosoftAds.currencyCode | Currency code for the account (e.g. USD, EUR, AUD). | Dimension | string | — | — |
Customer IDmicrosoftAds.customerId | Unique identifier for the Microsoft Advertising customer (manager account). | Dimension | string | — | — |
Customer namemicrosoftAds.customerName | Name of the Microsoft Advertising customer (manager account). | Dimension | string | — | — |
| Field | Description | Kind | Type | Aggregation | Format |
|---|---|---|---|---|---|
Campaign IDmicrosoftAds.campaignId | Unique identifier for the campaign. | Dimension | string | — | — |
CampaignmicrosoftAds.campaignName | Name of the campaign. Shown in campaign reports and breakdowns. | Dimension | string | — | — |
Campaign statusmicrosoftAds.campaignStatus | Current delivery status in the advertising platform (for example enabled, paused, or removed). | Dimension | string | — | — |
Campaign typemicrosoftAds.campaignType | Type of campaign (e.g. Search, Shopping, Audience, Dynamic Search Ads). | Dimension | string | — | — |
GoalmicrosoftAds.goal | Name of the conversion goal attributed to this result. | Dimension | string | — | — |
Goal typemicrosoftAds.goalType | Type of conversion goal (e.g. URL, Duration, Pages Per Visit, Event, App Install). | Dimension | string | — | — |
| Field | Description | Kind | Type | Aggregation | Format |
|---|---|---|---|---|---|
Ad group IDmicrosoftAds.adGroupId | Unique identifier for the ad group. | Dimension | string | — | — |
Ad groupmicrosoftAds.adGroupName | Name of the ad group. Shown in ad group reports and breakdowns. | Dimension | string | — | — |
Ad group statusmicrosoftAds.adGroupStatus | Current delivery status of the ad group (e.g. Active, Paused, Deleted). | Dimension | string | — | — |
| Field | Description | Kind | Type | Aggregation | Format |
|---|---|---|---|---|---|
Ad IDmicrosoftAds.adId | Unique identifier for the ad. | Dimension | string | — | — |
Ad namemicrosoftAds.adName | Title or headline of the ad. | Dimension | string | — | — |
Ad statusmicrosoftAds.adStatus | Current delivery status in the advertising platform (for example enabled, paused, or removed). | Dimension | string | — | — |
Ad typemicrosoftAds.adType | Type of ad (e.g. Expanded Text Ad, Responsive Search Ad, Dynamic Search Ad). | Dimension | string | — | — |
Ad distributionmicrosoftAds.adDistribution | Where your ad was distributed (e.g. Search, Content, Mixed). | Dimension | string | — | — |
Destination URLmicrosoftAds.destinationUrl | The URL of the webpage where users land after clicking the ad. | Dimension | string | — | — |
Display URLmicrosoftAds.displayUrl | The URL displayed in your ad creative. | Dimension | string | — | — |
Final URLmicrosoftAds.finalUrl | The final landing page URL users were directed to after clicking your ad. | Dimension | string | — | — |
Ad descriptionmicrosoftAds.adDescription | The description text of your ad. | Dimension | string | — | — |
Ad description 2microsoftAds.adDescription2 | The second description line of your ad. | Dimension | string | — | — |
Title part 1microsoftAds.titlePart1 | First part of the ad title. | Dimension | string | — | — |
Title part 2microsoftAds.titlePart2 | Second part of the ad title. | Dimension | string | — | — |
Title part 3microsoftAds.titlePart3 | Third part of the ad title. | Dimension | string | — | — |
HeadlinemicrosoftAds.headline | Headline text of your ad. | Dimension | string | — | — |
Long headlinemicrosoftAds.longHeadline | Long headline text used in multimedia or responsive ads. | Dimension | string | — | — |
Path 1microsoftAds.path1 | First display path appended to your URL in the ad. | Dimension | string | — | — |
Path 2microsoftAds.path2 | Second display path appended to your URL in the ad. | Dimension | string | — | — |
Business namemicrosoftAds.businessName | Business name shown in your ad. | Dimension | string | — | — |
| Field | Description | Kind | Type | Aggregation | Format |
|---|---|---|---|---|---|
Device typemicrosoftAds.deviceType | Type of device your ad was shown on (e.g. Computer, Smartphone, Tablet). | Dimension | string | — | — |
Device OSmicrosoftAds.deviceOs | Operating system of the device your ad was shown on (e.g. Windows, iOS, Android). | Dimension | string | — | — |
NetworkmicrosoftAds.network | Search network where your ad was shown (e.g. Bing Search, Bing Search Partners, Bing and AOL). | Dimension | string | — | — |
Top vs othermicrosoftAds.topVsOther | Whether your ad appeared in a top position above organic results or in another position. | Dimension | string | — | — |
| Field | Description | Kind | Type | Aggregation | Format |
|---|---|---|---|---|---|
DatemicrosoftAds.date | Date of the reporting period. | Dimension | string | — | — |
Bid match typemicrosoftAds.bidMatchType | The match type you bid on for this keyword (Exact, Phrase, Broad). | Dimension | string | — | — |
Delivered match typemicrosoftAds.deliveredMatchType | The actual match type that triggered your ad for a given search (Exact, Phrase, Broad). | Dimension | string | — | — |
LanguagemicrosoftAds.language | Language of the user query or ad targeting at the time of impression. | Dimension | string | — | — |
Reports, budgets, forecasts and alerts all use the same Microsoft Ads fields listed above.
Describe the report you want and Jepto builds it from your Microsoft Ads data, then writes an analysis of what changed and why.
Explore reportingTrack Microsoft Ads spend against a budget for each account or group of campaigns, and see mid-month whether you're on course to overspend.
Explore budget trackingSet a target on any Microsoft Ads metric and see where the month is likely to finish, while there's still time to act.
Explore KPI forecastingAdd an anomaly alert to the Microsoft Ads metrics you care about, and Jepto tells you when one moves outside its normal range.
Explore anomaly detectionSign in with the Microsoft account that has access to your ad accounts.
In Jepto, add a Microsoft Ads connection and sign in with a Microsoft account that has access to the ad accounts.
Select the Microsoft Advertising accounts you want to report on.
Your data is ready in Reports and Data Chat. Connect https://mcp.jepto.com to your AI assistant to ask about it from there too.
About Microsoft Ads in Jepto and the Jepto MCP.
Yes. Jepto hosts an MCP server at https://mcp.jepto.com that gives Claude, ChatGPT, Cursor and other MCP-compatible apps access to your Microsoft Ads data. There's nothing to install: you sign in to Jepto with OAuth, and the assistant can query every Microsoft Ads field in the Jepto data model.
Microsoft announced a Microsoft Advertising MCP server in June 2026, read-only and in pilot. Jepto's hosted server is available now, and lets one question cover Microsoft Ads, Google Ads and your analytics across every brand you manage.
Jepto includes Microsoft Ads metrics such as Impressions, Clicks, CTR, Spend, Avg. CPC, Avg. CPM, Avg. position and Conversions. You can break them down by dimensions for Account, Campaign, Ad group, Ad & creative, Device & placement and Segments. Every field, with its definition, is listed on this page.
No. Through the Jepto MCP, Microsoft Ads data is read-only: the assistant can query it but can't change anything in Microsoft Ads.
Keyword and search term dimensions aren't in the Microsoft Ads data model yet.
Yes. When both are connected to the same brand, any report or chart can use fields from either source, and Data Chat and the Jepto MCP can answer questions that span the two. Cross-platform fields such as unified.spend also add Microsoft Ads to totals across your other ad platforms.
Yes. Impression share, impression share lost to budget and rank, Quality Score, expected CTR, ad relevance and landing page experience are all metrics.
No. You connect Microsoft Ads to Jepto by signing in, and Jepto handles the API access. Your AI assistant then connects to Jepto at https://mcp.jepto.com.
Yes. Every Microsoft Ads account connected to Jepto, across all your brands, is available through the one connection. What each person can see follows their Jepto login.
No. The Jepto MCP is included on every plan with no usage limits. Check that your AI assistant's plan lets you add connectors.
Related Articles
Start asking your data smarter questions today. Connect your first data source in minutes.
