Why this matters
A report of leads by channel rewards whatever produces the cheapest form fills. The business-to-business measurement guide puts pipeline and revenue at the top, recommends reporting sourced and influenced pipeline side by side with self-reported AttributionAssigning conversion credit to touchpoints., and warns about lag and small numbers. The guide to connecting the CRM to ads and analytics covers the plumbing that makes any of it possible: identifiers at the form, source fields on the record and outcomes sent back to the platforms.
The firm and its CRM
Planeform is an invented company selling drawing-management software to small and mid-sized architecture practices. Marketing reports leads by channel; nobody can say which campaigns create pipeline. The CRM's "lead source" picklist is filled in by whoever creates the record, forms drop campaign parameters, and opportunities have no campaign field. Sales cycles run for several months.
Planeform: last quarter's spend and leads by campaign
| Campaign | Spend | Leads | Cost per lead |
|---|---|---|---|
| Paid search, brand terms | £4,000 | 30 | £133 |
| Paid search, generic terms | £18,000 | 85 | £212 |
| LinkedIn gated guide on planning submissions | £15,000 | 240 | £63 |
| LinkedIn webinar on coordinating consultants | £9,000 | 60 | £150 |
| Trade show stand | £12,000 | 45 | £267 |
| Podcast sponsorship | £6,000 | 0 tracked | Not applicable |
| Organic | £0 | 50 | Not applicable |
Connecting campaigns to opportunities
Three joins have to hold. The click to the lead: campaign parameters and click identifiers are read on arrival, stored in first-party storage and written into hidden form fields, so the lead record carries them. The lead to the account: first touch is recorded on the account, not only the person, because the committee buys. The account to the opportunity: every opportunity inherits the account's first touch and lists the campaigns that touched any of its contacts before it was created. Then two counting rules: sourced pipeline credits the account's first touch, and influenced pipeline credits every campaign that touched the opportunity. A free-text "how did you hear about us?" field on the demo form adds the third view.
Task
- Plan the data flow from click to opportunity: what is captured at the form, which fields hold it, and what is sent back to the ad platforms.
- Write the counting rules for sourced and influenced pipeline.
- Read the opportunity export: total sourced and influenced pipeline by campaign.
- Compare each campaign's spend with the pipeline it sourced, and set that beside cost per lead.
- Decide which campaigns earn more budget next quarter, which keep theirs and what you will not decide yet.
- List the data fixes that must come first.
Worked answer
Data flow. Every paid link carries UTMURL tags identifying traffic source. values from one naming convention, so the campaign on the lead matches the campaign in the ad account. Auto-tagging stays on and the click identifier is stored alongside. Hidden fields write the parameters, landing page and consent state to the record; a test lead is submitted on every form, including the embedded webinar form, and the record read. First touch is copied to the account when it is created and never overwritten. A "qualified opportunity" stage is sent back to Google Ads as an offline conversion, where consent allows, for bidding; won deals are sent for reporting.
Planeform: the opportunity export, read both ways
| Opportunity | Value | First touch on the account | Campaigns touching the opportunity | Self-reported source |
|---|---|---|---|---|
| O1 | £24,000 | Webinar | Webinar, brand search | Webinar |
| O2 | £12,000 | Generic search | Generic search | |
| O3 | £36,000 | Trade show | Trade show, gated guide, brand search | Met you at the show |
| O4 | £18,000 | Organic | Organic, webinar, brand search | Podcast |
| O5 | £9,000 | Gated guide | Gated guide | |
| O6 | £15,000 | Generic search | Generic search, gated guide | |
| O7 | £30,000 | Missing | Brand search | Podcast |
| O8 | £27,000 | Webinar | Webinar, trade show | A colleague |
| O9 | £21,000 | Trade show | Trade show | The show |
| O10 | £6,000 | Gated guide | Gated guide, brand search |
Total pipeline: £198,000 across 10 opportunities.
| Campaign | Spend | Sourced pipeline | Sourced pipeline per £1 spent | Influenced pipeline | Cost per lead |
|---|---|---|---|---|---|
| Webinar | £9,000 | £51,000 | £5.67 | £69,000 | £150 |
| Trade show | £12,000 | £57,000 | £4.75 | £84,000 | £267 |
| Generic search | £18,000 | £27,000 | £1.50 | £27,000 | £212 |
| Gated guide | £15,000 | £15,000 | £1.00 | £66,000 | £63 |
| Brand search | £4,000 | £0 | £0 | £114,000 | £133 |
| Podcast | £6,000 | £0 tracked | Not applicable | £0 tracked; named on £48,000 | Not applicable |
| Organic | £0 | £18,000 | Not applicable | £18,000 | Not applicable |
| Missing source | Not applicable | £30,000 | Not applicable | Not applicable | Not applicable |
Sourced pipeline sums to £198,000; influenced pipeline sums to more because opportunities share campaigns.
Reading it. By cost per lead the gated guide wins easily; by pipeline it sourced the least per pound of the prospecting campaigns, though it touches several opportunities later in the journey. The webinar and the trade show source the most pipeline per pound. Brand search sources nothing and influences most: it captures demand other campaigns created, so cutting it would lose the capture without removing the demand. The podcast has no tracked touches but is named on two opportunities, one of them the largest with a missing source.
Decision. Move part of the gated guide's budget into a second webinar and keep the trade show. Keep brand search. Keep the podcast for another quarter and read self-reported mentions before judging it. Do not cut generic search on one quarter's two opportunities.
Limits. Ten opportunities is a small number, and with a long cycle many were first touched in earlier quarters. Read each campaign again as a cohort after a full cycle, and judge cost per customer (CACCost to acquire one new customer.) only when deals close.
Fixes first. Required source and campaign fields on leads and opportunities; hidden fields tested on every form; first touch on the account; the free-text source question on the demo form; one naming convention held for years so cohorts can be matched to spend later.
Common mistakes
- Judging campaigns on cost per lead. The cheapest leads sourced the least pipeline.
- Cutting brand search because it sources nothing. It captures demand created elsewhere.
- Ignoring the missing source. The largest opportunity was untraceable until someone asked the buyer.
- Deciding on one quarter. Small numbers and long cycles call for cohorts, not verdicts.
Next, take on the business-to-business pipeline plan capstone, which uses the KPI tree for lead generation, or return to the intermediate business-to-business level.
