Jepto

Pricing

Sign In

Try For Free

Microsoft Ads

Microsoft Ads reporting and automation for agencies

Pull Bing and Microsoft Audience Network campaign performance into unified client reports.

Microsoft Ads
~120 fields · 5 entities · Full history
Daily sync
Reports Insights KPI Forecasting Budget Tracker

Clicks

Paid search clicks

2,410

Impressions

Search & audience impressions

612k

CTR

Click-through rate

1.35%

Clicks and Impressions Trend

Daily trend from Microsoft Ads

Clicks2,410
Impressions612k

Clicks by Campaign

Top campaigns · Microsoft Ads

Clicks2,410
Aug 12

Anomaly detected

An exception in Conversions has been detected.

Actual Negative Expected

On August 18 you had 42 conversions where we expected 680, which is 94% less than expected.

Aug 10

Microsoft Ads destination URL checker

Broken destination URLs detected on active ads.

2 ads are serving with destination URLs returning 404. Last checked Aug 12, 2026 6:40am.

CTR

Target: 1.6% CTR
Previous Period: 1.4% (Jul 1, 2026 – Jul 31, 2026)

Actual Prediction Target

Your MTD average is 0.95% and is -41% below your target of 1.6% CTR.

Conversions

Target: 900
Previous Period: 740 (Jul 1, 2026 – Jul 31, 2026)

Actual Prediction Target

Your MTD total is 620 (69%) and if you continue at the same rate you will finish at 870 vs target 900.

Monthly Account Budget

Target: $6,000

Spend Estimated Target Range

Your current spend is $4,820 (80%) and if you continue at the same average rate you will spend $6,900 (115%) by August 31.

Brand Campaign Budget

Target: $2,000

Spend Estimated Target Range

Your current spend is $1,380 (69%) and if you continue at the same average rate you will spend $1,960 (98%) by August 31.

circle-4circle-3circle-1circle-2

Everything we pull from Microsoft Ads

Jepto syncs core Microsoft Ads metrics — clicks, impressions, spend, conversions and impression share — at account, campaign, ad group and keyword level.

Entity What it contains
Account Account-level spend, conversions and impression share.
Campaign Type, status, budget and full performance history.
Ad group Performance and status within each campaign.
Keyword Match type, quality score and metrics for each keyword that served.
ClicksImpressionsCTRSpendAvg CPCAvg CPM
ConversionsConversion rateConversion valueCost per conversionRevenue
Impression shareLost IS (budget)Lost IS (rank)Top impression rate
Cross-source clicksCross-source impressionsCross-source spendCross-source CPCCross-source CPMCross-source CTRCross-source reachCross-source frequency
Microsoft Ads uses a unified schema in Jepto — metrics align with Google Ads field names where possible so you can build cross-platform reports without duplicate logic. Some Microsoft-specific metrics map to their closest unified equivalent.
Read-only source

Query Microsoft Ads without leaving the conversation

Query Microsoft Ads metrics and dimensions through natural language — no write-back.

Read-only analytics

Ask questions about connected microsoft ads accounts

Use MCP to ask about spend, delivery, conversions and efficiency. Jepto maps your question to the right Microsoft Ads dimensions and metrics.

  • Query spend, clicks and conversions
  • Break down by campaign, ad group or keyword
  • Compare with Google Ads using unified metrics
  • Inspect impression share and efficiency

schema()

Explore Microsoft Ads entities and unified metrics on the connected account.

data()

Query live Microsoft Ads performance across campaigns, ad groups and keywords.

actions()

Not available — this is a read-only source. No write-back actions are supported.

execute()

Not available — this is a read-only source. Jepto cannot modify data in the platform.

Setup

Connecting Microsoft Ads

Microsoft OAuth. One login can cover every ad account you manage.

  1. 1. Sign in with Microsoft

    Click Connect and authenticate with the Microsoft account that has access to your client's ad accounts.

  2. 2. Choose ad accounts

    Select which Microsoft Ads accounts to include.

  3. 3. Share the connection to a client

    Assign the connection to the relevant client so reports and forecasts can pull from it.

  4. 4. Wait for the first sync

    Jepto backfills full account history, then syncs daily.

Microsoft Ads metrics use Jepto's unified schema where possible. Field names may differ slightly from the native Microsoft Ads UI — check the coverage section for the full list.
Read the setup guide

Frequently asked questions

Everything you need to know about Microsoft Ads in Jepto.

Jepto maps Microsoft Ads metrics to unified field names shared with Google Ads, so you can build one report that works across both platforms without duplicate columns.

Jepto backfills full account history on the first sync, then syncs daily.

Yes. Each account shared to a client counts as one data source.

Yes. Keywords sync with match type, quality score and full metric history.

Jepto flags the connection and stops reporting stale numbers. Reconnecting takes one Microsoft sign-in.

Related Articles

Get Started Today

Start asking your data smarter questions today. Connect your first data source in minutes.