Track Microsoft Ads to Pipeline, Not Form Fills
The core question isn’t ‘what was our cost per click?’ It’s how much pipeline and revenue each campaign produced, and at what cost. That needs your CRM connected to Microsoft Ads, with qualified outcomes sent back so the platform optimizes for them.
How do you track Microsoft Ads to pipeline?
Capture the Microsoft click ID (MSCLKID) on every lead, store it in your CRM, then send qualified leads, opportunities and closed deals back to Microsoft Ads as offline conversions. Report cost per qualified opportunity and pipeline by campaign, not cost per form fill.
The funnel to track: click, conversion, qualified lead, sales opportunity, customer. CAC is total channel spend divided by new customers from the channel.
What changes when you track to pipeline?
| Campaign | Conv. | Cost/conv. |
|---|---|---|
| Category | 71 | $46 |
| Problem | 58 | $41 |
| Broad · AI Max | 55 | $62 |
| Campaign | Opps | Pipeline | Cost/opp. |
|---|---|---|---|
| Category | 6 | $96K | $548 |
| Problem | 7 | $104K | $470 |
| Broad · AI Max | 1 | $12K | $3,400 |
How do you set up offline conversions?
- Create an offline conversion goal. This switches on MSCLKID auto-tagging.
- Capture the MSCLKID from the landing page URL, store it in a cookie and pass it into a hidden form field.
- Save it on the lead record in your CRM.
- Upload conversions for qualified leads, opportunities and deals, with values, by file or a scheduled import.
- Upload daily, and restate or retract conversions when deals change.
Microsoft says to wait two hours after creating the goal before uploading, that conversions can count up to 90 days after the click, and that daily uploads help automated bidding (Microsoft’s offline conversion help).
Which metrics should you report?
- Spend, impressions, click-through rate, cost per click and search terms.
- Landing page conversion rate.
- Qualified lead rate and opportunity rate.
- Pipeline created and closed-won revenue.
- Cost per qualified opportunity, CAC and CAC payback.
- Sales cycle and win rate by campaign, keyword group and audience.
For payback maths, see CAC payback; for the same setup on Google, Google Ads conversion tracking.
Optimize for what sales can close.
The platform learns from what you send it. Send it opportunities, not just leads.
Why does lead cost mislead?
A $40 lead is expensive if it never reaches a sales conversation. A $350 lead can be cheap if it regularly becomes a $20,000 annual contract. Without pipeline data sent back, automation optimizes for whatever is easiest to generate, often low-quality leads, which matters most with AI Max and broad matching. Plan test budgets around opportunities on the test plan and budget page, and use LinkedIn data to price better segments on LinkedIn profile targeting.
Frequently asked questions
How do I track Microsoft Ads leads in my CRM?
Capture the MSCLKID on each lead, store it in the CRM, and upload qualified outcomes as offline conversions.
What is MSCLKID?
The Microsoft Click ID added to landing page URLs, used to match CRM outcomes back to ad clicks.
How long after a click can offline conversions count?
Microsoft lets you set a conversion window of up to 90 days after the click.
How often should I upload offline conversions?
Daily, which Microsoft says helps automated bidding.
What should B2B companies optimize Microsoft Ads for?
Qualified leads or opportunities from the CRM, not all form fills.
How do I calculate CAC for Microsoft Ads?
Total Microsoft Ads spend divided by new customers attributed to the channel.
Can I update a conversion after uploading it?
Yes. Microsoft supports restating values and retracting conversions.
Sources & further reading
Standards and platform rules change. These sources let you verify the current requirements directly. All screens shown are mock-ups of fictional products.