To connect ad spend to pipeline and revenue, carry the ad campaign into every lead with utm_campaign, keep that value on the contact and the deal in your CRM, then divide each campaign's spend by the opportunities, pipeline value and won revenue that trace back to it. The result is cost per opportunity, pipeline per dollar and ROAS by campaign, which show where the next dollar should go.
Why platform numbers stop short
Ad platforms report what happens on their side: impressions, clicks and the conversions you send them, usually form fills. In B2B, the outcome that matters comes later. A form fill becomes a contact, sales qualifies it, an opportunity is opened and, weeks or months later, a deal is won or lost. That part lives in your CRM, not in Google Ads or LinkedIn Ads. Unless the two are joined, the budget owner can say how much was spent and how many leads came in, but not which campaigns created pipeline and revenue.
The five links in the chain
Spend reaches revenue only if every link holds. Most gaps come from one broken link, not from the reporting tool.
| Link | What carries it | What usually breaks it |
|---|---|---|
| Ad click to landing page | utm_campaign set to the ad campaign's name or ID, plus utm_source and utm_medium | Ads with no tracking template, or campaign names typed by hand |
| Visit to contact | Your form or CRM tracking stores the UTM values on the new contact | Forms that drop hidden fields, or contacts created by import |
| Contact to opportunity | The deal is associated with the contact or lead it came from | Deals created without a contact, so the source is lost |
| Opportunity to revenue | Amount, stage and close date kept current in the CRM | Stale stages and missing amounts |
| Spend to campaign | Spend by campaign pulled from each ad platform | Campaign renamed after launch, so the CRM value no longer matches |
The metrics to track by campaign
| Metric | Formula | Answers |
|---|---|---|
| Cost per opportunity | Spend / opportunities | What does a real sales conversation cost from this campaign? |
| Pipeline per $1 | Pipeline value / spend | How much pipeline does each dollar create? |
| ROAS | Won revenue / spend | How much closed revenue came back per dollar? |
| CAC | Spend / customers | What does a new customer cost from paid media? |
| Win rate | Won / (won + lost) | Does this campaign bring deals that close? |
A worked example
Three campaigns over the last six months, with opportunities and revenue traced back to each one by first touch:
| Campaign | Spend | Opportunities | Cost per opportunity | Pipeline | Pipeline per $1 | Won revenue | ROAS |
|---|---|---|---|---|---|---|---|
| Google Ads non-brand search | $60,000 | 30 | $2,000 | $900,000 | 15.0 | $240,000 | 4.0 |
| LinkedIn Ads ABM | $75,000 | 20 | $3,750 | $1,000,000 | 13.3 | $150,000 | 2.0 |
| Microsoft Ads search | $15,000 | 9 | $1,667 | $180,000 | 12.0 | $60,000 | 4.0 |
All dollar figures in the examples are illustrative. They are not results from any account.
On platform conversions alone, LinkedIn might look expensive and be cut. With pipeline in view, it produces the largest pipeline in total, so the better question is whether its deals close. Microsoft Ads has the lowest cost per opportunity but a small volume, so it may be able to take more budget.
How to set it up
- Tag every adSet utm_campaign to the ad campaign's name or ID on every ad, with a tracking template or final URL suffix so nobody types it by hand. A shared UTM naming convention keeps the values the same across the team.
- Store the source on the contactMake sure your forms or CRM tracking save the UTM values on new contacts. HubSpot records the original source and its drill-downs on each contact (Understand traffic source properties (HubSpot Knowledge Base)).
- Link deals to contactsOpen opportunities from the contact or lead so the source travels with the deal, and keep amounts and stages current.
- Join spend and CRM in one placePull spend by campaign from each ad platform and the CRM records by the same campaign value, for the same period.
- Review monthly, decide quarterlyCost per opportunity moves every month. Pipeline and revenue need a longer window, so judge campaigns on the last three to six months.
What Pacing Console shows
Pacing Console reads spend from Google Ads, Microsoft Ads, LinkedIn Ads and TikTok Ads and connects to HubSpot, Salesforce or Pipedrive, or any other CRM by CSV or API. On Pro you see contacts, MQLs, SQLs and opportunities next to each campaign's spend, with cost per stage. On Enterprise, the Pipeline and Revenue pages add pipeline value, pipeline per $1, won revenue, ROAS, CAC, win rate and payback by campaign, by channel and in total, with each deal given to the campaign of its first touch. See Pipeline and Revenue for the exact definitions, or open the live demo to see them on sample data.
Plans: CRM lifecycle stages (contacts, MQLs, SQLs and opportunities by campaign, with cost per stage) are on Pro, USD 49 per workspace per month. The Pipeline and Revenue pages, revenue forecasts, what-if scenarios and budget targets need Enterprise. See Plans, pricing and billing.
Questions people ask
How do I connect ad spend to revenue?
Pass the ad campaign into every lead with utm_campaign, keep it on the contact and the deal in your CRM, then join CRM deals with spend by campaign. Divide spend by opportunities, pipeline and won revenue to get cost per opportunity, pipeline per dollar and ROAS.
Which attribution model should I use?
Start with one you can explain and keep it stable. First touch, which credits the campaign that brought the contact in, is simple and fits paid media that creates new demand. Pacing Console uses first touch for deals.
Why do platform conversions and CRM numbers not match?
Platforms count conversions they observe, such as form fills, often with their own attribution windows. The CRM counts records and deals. They answer different questions, so use the platform for delivery and the CRM for pipeline and revenue.
How long before I can judge a campaign on revenue?
It depends on your sales cycle. Cost per opportunity is useful within a month or two. Won revenue and ROAS need a window at least as long as a typical deal takes to close.
Do I need a data warehouse for this?
Not to start. If UTMs reach the CRM and deals are linked to contacts, a tool that reads spend and CRM records by campaign can do the join. A warehouse helps when you want custom models across many sources.
Related articles
Last updated 2026-11-22. Platform and CRM rules change, so check their own help for the current details.