Help center

How to connect ad spend to pipeline and revenue

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.

LinkWhat carries itWhat usually breaks it
Ad click to landing pageutm_campaign set to the ad campaign's name or ID, plus utm_source and utm_mediumAds with no tracking template, or campaign names typed by hand
Visit to contactYour form or CRM tracking stores the UTM values on the new contactForms that drop hidden fields, or contacts created by import
Contact to opportunityThe deal is associated with the contact or lead it came fromDeals created without a contact, so the source is lost
Opportunity to revenueAmount, stage and close date kept current in the CRMStale stages and missing amounts
Spend to campaignSpend by campaign pulled from each ad platformCampaign renamed after launch, so the CRM value no longer matches

The metrics to track by campaign

MetricFormulaAnswers
Cost per opportunitySpend / opportunitiesWhat does a real sales conversation cost from this campaign?
Pipeline per $1Pipeline value / spendHow much pipeline does each dollar create?
ROASWon revenue / spendHow much closed revenue came back per dollar?
CACSpend / customersWhat does a new customer cost from paid media?
Win rateWon / (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:

CampaignSpendOpportunitiesCost per opportunityPipelinePipeline per $1Won revenueROAS
Google Ads non-brand search$60,00030$2,000$900,00015.0$240,0004.0
LinkedIn Ads ABM$75,00020$3,750$1,000,00013.3$150,0002.0
Microsoft Ads search$15,0009$1,667$180,00012.0$60,0004.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

  1. Tag every ad
    Set 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.
  2. Store the source on the contact
    Make 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)).
  3. Link deals to contacts
    Open opportunities from the contact or lead so the source travels with the deal, and keep amounts and stages current.
  4. Join spend and CRM in one place
    Pull spend by campaign from each ad platform and the CRM records by the same campaign value, for the same period.
  5. Review monthly, decide quarterly
    Cost 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.