NewStart your own marketing agency on askotter.See how it works
PPC and B2B

B2B attribution with a long sales cycle: LinkedIn Ads, Salesforce and lag

B2B attribution with a long sales cycle breaks when you compare this month's spend with this month's revenue. The deals that spend creates close one or two quarters later. Measure each month's spend against the revenue it goes on to produce, and a channel that looks like a loss often is not one.

Nov 19, 2026Brian Chiou6 min read
the short answer
The problem
Spend lands this quarter. Closed revenue lands next quarter. Monthly reports compare the wrong two numbers.
Report instead
Pipeline created now, as the early signal. Closed-won by the month the buyer first clicked, as the proof.
How long to wait
At least one full sales cycle before you judge a month of spend. With a 90-day cycle, that is a quarter.

This guide is for demand-gen and marketing leads building a pipeline model a board will believe. It covers lag-adjusted ROAS, the difference between pipeline and closed-won credit, LinkedIn Ads pipeline attribution in Salesforce, and how to report a channel that looks unprofitable for its first 60 days.

Why platform ROAS understates B2B paid channels

Platform ROAS is revenue divided by spend inside the ad platform's own view. For a B2B channel, three things push it down:

  • The window is shorter than the cycle. LinkedIn counts conversions within 30 days of a click and 7 days of a view, by default. A deal that closes 90 days after the first click falls outside it.
  • The platform never sees the deal. LinkedIn sees clicks, lead-form submissions and the companies it reached. It never sees whether a lead became a deal, so the “revenue” in its ROAS is whatever value you gave the form fill.
  • The month is the wrong unit. A monthly report divides this month's revenue by this month's spend. The revenue came from spend two or three months ago. In a quarter where you raise spend, ROAS falls, even if every dollar is working.

Pipeline-created vs. closed-won attribution

There are two things a B2B channel can get credit for, and they answer different questions:

  • Pipeline created. The value of opportunities opened from the channel's leads. It arrives weeks after the click, so it is the earliest number that means something. But it is not money. Many opportunities never close.
  • Closed-won. The value of deals that actually closed. It is the number that matters, and it arrives last.

Credit by stage

Between the two, you can count how far each campaign's opportunities have moved: meeting held, proposal sent, closed-won. To turn stages into an estimate, use the share of opportunities at each stage that went on to close in your own history, not a default from a template. One caution: Salesforce stages move when someone updates them, so stage data is only as current as your team's habits in the CRM.

Building a lag-adjusted spend-to-revenue curve

Lag-adjusted ROAS fixes the timing. Instead of dividing this month's revenue by this month's spend, group buyers by the month of their first click, and follow each group's closed-won revenue over time:

  1. Take each month's spend as one group.
  2. Tie each closed deal back to the month its buyer first clicked.
  3. Add up each group's closed-won revenue at 30, 60 and 90 days after the month.
  4. Divide by that month's spend. That is the group's ROAS at each age.

Here is what that looks like. The numbers are a made-up illustration, not any client's data:

GroupSpendClosed-won by day 30By day 60By day 90
January clicks$10,000$0$8,000$26,000
February clicks$10,000$2,000$11,000not yet
March clicks$12,000$0not yetnot yet

Judged in January, the January spend returned nothing. At day 90 it returned $26,000 on $10,000, a lag-adjusted ROAS of 2.6. February is on a similar path at day 60. March is too young to judge. A monthly report would have shown three bad months in a row.

Stitching LinkedIn click IDs to Salesforce opportunities

None of this works unless a closed deal can be traced back to the click. In practice that means the LinkedIn click ID and the campaign tags are captured when the form is sent, stored on the Salesforce lead, and carried through to the contact and the opportunity when the lead converts.

Matching on the person is not always enough in B2B, because several people from one company touch the same deal. Match the company too: on its web domain first, then on a cleaned company name.

Our post on why LinkedIn Ads to Salesforce attribution breaks walks through the setup step by step: the hidden form fields, keeping first-touch data, and sending closed deals back to LinkedIn.

Reporting to a board without over-claiming

A board wants to know whether the money is working. Give them a report that is honest about what is known and what is not:

  • Report pipeline created and closed-won side by side, and never add pipeline to revenue.
  • Show each spend month by its age. Say plainly which months are too young to judge.
  • Do not project the newest month past what older months actually did at the same age.
  • Agree the attribution rule before the numbers come in: first touch, last touch, or shared. Changing it after a bad quarter looks like moving the goalposts.
  • Give a range, not a single figure, and name the share of revenue you could not attribute at all.

The channel that looks unprofitable for 60 days

Say so up front. Show the board the older months at the same age, and when they turned. If January paid back by day 90, the case for March rests on that, not on hope. If no month has paid back after a full cycle, that is a real answer too.

Cohort views that make long cycles legible

The cohort table is the core view. Three more make long cycles easier to read:

  • Curves by group. Plot each spend month's closed-won revenue against days since the month. Months that track above the older lines are doing better. Months below them deserve a look.
  • Time from first click to close. Show how long deals actually take. If the cycle is getting longer, judge spend later.
  • Pipeline by campaign and company size. A campaign with cheap leads that never become opportunities stops looking like the winner.

This is how askotter reports LinkedIn Ads and a CRM together: each campaign gets a line with its cost, the pipeline it created and the revenue it closed, and the attribution rule is a setting that recalculates history. HubSpot connects today. The LinkedIn Ads and Salesforce connections are on the integration roadmap. See Salesforce + LinkedIn Ads and HubSpot + LinkedIn Ads for what each pair lines up.