LinkedIn looks twice as expensive
Its opportunities simply take longer. A report at this point would move budget away from LinkedIn.
Guide · Measurement
How to measure the pipeline your paid ads create
Keep two ledgers. The reporting ledger tells your CEO what paid media contributed: lagged, cohort-based and drawn from several sources. The steering ledger tells Google, Meta and LinkedIn what a good lead looks like now. Mixing the two breaks both.
Short answer
Capture the source of every lead in your CRM, define the same stages for every channel, and report opportunities and pipeline value by the month leads were created, not the month deals closed. Compare channels only once cohorts have had time to mature, and add a self-reported source field to catch influence that tracking misses.
Original framework
Two ledgers: reporting pipeline vs steering the platforms
Both are needed. They answer different questions, run on different clocks and belong to different owners.
| Reporting ledger | Steering ledger | |
|---|---|---|
| Question | What did paid media contribute to pipeline? | What should the platforms find more of? |
| Owner | RevOps or marketing leadership | Performance marketing |
| Source of truth | CRM | CRM or sheet, sent to the platforms |
| Stage | Opportunity, quote, proposal, won | The earliest stage that reliably predicts value |
| Timing | Monthly cohorts, once matured | Days |
| Attribution | CRM source, self-reported source, optional lift test | Each platform’s own attribution |
| Used for | Budget decisions and board reporting | Bidding and targeting |
Why mixing them fails
Put platform-reported conversions in a board report and you present modelled, window-limited numbers as pipeline. Send closed deals to the platforms as the bidding goal and they arrive too late and too rarely to steer anything. See the signal gap.
What must be in place first
- Source on every lead. UTM parameters on every ad, captured in hidden form fields and written to the CRM; Google’s click ID stored alongside.
- A first-touch field that nothing overwrites. CRM deduplication and later form fills must not replace the original source.
- Phone and WhatsApp sources. Distinct tracking numbers per channel where possible, and a “where did you find us?” question on the first call.
- The same stages for every channel. Qualified, opportunity, quote or proposal, won and lost, defined once. See the lead generation funnel guide.
- A self-reported source field. An open “how did you hear about us?” answer catches podcasts, communities and word of mouth that tracking can’t see.
Definitions
What is the difference between sourced and influenced pipeline?
Short answer
Sourced pipeline comes from opportunities whose original source was paid media. Influenced pipeline includes any opportunity where a paid touch happened before the opportunity was created. Use sourced figures for channel budgets and influenced figures to understand campaign mix. Never add the two together, because influenced already contains sourced.
| Sourced | Influenced | |
|---|---|---|
| CRM rule | Original source is a paid channel | Any paid touch before opportunity creation |
| Supports | Channel budget decisions | Campaign mix and journey understanding |
| Risk | Understates channels that assist | Overstates channels that only touch late |
Original framework
Why monthly reports mislead: use lead cohorts
A “closed this month” report mixes spend from one period with outcomes from leads created months earlier. Cohort reporting judges each month’s spend by what its own leads became.
| Lead-created month | Channel | Spend | Leads | Qualified | Opps by day 30 | Opps by day 60 | Opps by day 120 | Pipeline value | Mature? |
|---|---|---|---|---|---|---|---|---|---|
| June | Google Ads | – | – | – | – | – | – | – | Yes / no |
| June | LinkedIn Ads | – | – | – | – | – | – | – | Yes / no |
| June | Meta Ads | – | – | – | – | – | – | – | Yes / no |
The maturity rule
Treat a cohort as mature for a channel once it is older than that channel’s median days from lead to opportunity. Show immature cohorts, but grey them out and don’t compare channels on them.
Worked numbers
The same June cohort at day 60 and day 120
A mid-market B2B software company spends US$15,000 on each of Google and LinkedIn in June.
| Channel | Leads | Qualified | Opps by day 60 | Cost per opp at day 60 | Opps by day 120 | Cost per opp at day 120 |
|---|---|---|---|---|---|---|
| Google Ads | 150 | 45 | 12 | US$1,250 | 15 | US$1,000 |
| LinkedIn Ads | 60 | 30 | 6 | US$2,500 | 12 | US$1,250 |
The gap has narrowed to 25%
LinkedIn doubled its opportunities while Google added three. Judge the channels on mature cohorts only.
| Stage | Per month | Cost each | Report |
|---|---|---|---|
| RFQs | 240 | ₹1,250 | Weekly, for steering |
| Qualified RFQs | 60 | ₹5,000 | Weekly, for steering |
| Quotes | 18 | about ₹16,667 | Monthly cohorts |
| Purchase orders | 4 | ₹75,000 | Quarterly cohorts: orders take 90–180 days |
Which attribution model should a B2B team use?
Short answer
For most B2B teams with modest opportunity volumes, the most dependable view combines CRM source fields, a self-reported “how did you hear about us” answer and lead-cohort reporting. Multi-touch models add detail when journeys are well tracked. Incrementality tests are the strongest evidence but need enough volume to be conclusive.
Position-based and multi-touch models are useful for comparing campaigns within a well-tracked journey, but they share one weakness: they only see touches that were tracked. B2B buyers read, ask peers and see ads on one device before filling in a form on another. Treat any model as a lens, and prefer decisions that hold under more than one view.
When can you test incrementality?
- Platform lift studies, such as LinkedIn’s conversion lift or Google and Meta lift studies, where your account is eligible. Check each platform’s current eligibility requirements.
- Geographic holdouts, only if each region produces enough opportunities to compare.
- On-off periods, as a last resort, with seasonality and sales capacity noted as caveats.
With ten to thirty opportunities a month, most formal tests won’t reach a clear answer. Cohort reporting plus self-reported source is the practical evidence until volume grows.
How should I report paid ads performance to my CEO?
Short answer
Show one page: spend, qualified leads, opportunities and pipeline value by channel for lead cohorts old enough to have matured, with younger cohorts marked as early. State one decision per channel, such as keep, shift or wait, and explain what changed since last quarter. Avoid platform-reported conversions as the headline.
- Headline: pipeline created by paid media from mature cohorts, sourced only.
- Channel table: spend, qualified leads, opportunities, pipeline value, cost per opportunity.
- Early cohorts: greyed, with “too early to judge”.
- Decisions: one line per channel: keep, shift, test or wait, with the reason.
- Changes: any measurement change this quarter, so jumps aren’t read as growth (recovered reporting).
For a quarterly review format, see the marketing QBR guide. To connect pipeline to acquisition cost, see customer acquisition cost.
What changes by company size
- SMB: a sheet with source, stage and value per lead, reviewed quarterly.
- Mid-market: CRM cohort reports plus a self-reported source field, reviewed monthly.
- Enterprise: add lift tests where eligible and reconcile pipeline with finance.
India, UAE and US notes
- India: many enquiries arrive by call or WhatsApp with no UTM. Use a tracking number per channel and ask for the source on the first call.
- UAE: multi-entity groups and tender-linked cycles; agree which entity’s pipeline counts and report in AED.
- US: expect finance to ask about sourced vs influenced definitions and payback; publish the definitions with the report.
Failure modes
Seven ways pipeline reporting goes wrong
Month-of-close reporting
Spend and outcomes from different months in the same row.
Last touch overwrites first touch
A later webinar sign-up replaces the ad that created the lead.
Unsourced calls and chats
Phone and WhatsApp enquiries land as “direct”.
Adding sourced and influenced
Counts the same pipeline twice.
Platform conversions as pipeline
Modelled, window-limited numbers presented to the board.
Recovered reporting read as growth
A tracking fix makes numbers jump with no change in demand.
Comparing immature cohorts
Slower channels always look worse early.
Zephra uses lead quality and business outcomes from CRM data or a spreadsheet, and checks its assessments against later wins and losses. Campaigns it creates carry a UTM template, so the parameters your CRM reads stay consistent. See lead quality optimisation and conversion tracking.
Questions, answered
Pipeline attribution FAQ
01Why does LinkedIn look worse in monthly reports?
Its leads often take longer to become opportunities, so a monthly report catches them before they progress. Compare channels on lead cohorts that are old enough for each channel’s typical lag.
02Should we trust platform-reported conversions?
Use them for steering: they tell each platform what to find more of. Use CRM data for pipeline reporting, because platform numbers are limited by attribution windows and partly modelled.
03Do we need an attribution tool?
Not to start. Clean source fields, consistent stages, a self-reported source question and a cohort report cover most B2B needs. Tools help once journeys and volumes are large enough to model.
04What is pipeline ROAS?
Pipeline value created divided by spend, calculated on mature lead cohorts. It is not revenue: pipeline still has to close, so pair it with win rates before comparing it with ecommerce-style returns.
05How do we attribute phone and WhatsApp leads?
Give each channel its own tracking number where possible, ask for the source on the first conversation, and record both in the CRM. Without them, these leads fall into direct or unknown.
06Did fixing our tracking grow pipeline?
No. Better tracking changes what is reported and attributed; the leads were already there. Check pipeline in the CRM across the change date before claiming growth.
For heads of marketing
Connect campaign decisions to lead quality and business outcomes.
See how Zephra uses CRM stages to guide Google, Meta and LinkedIn Ads, or start with a free assessment of your measurement gaps.