Skip to content
Faisal Mahmud TusherDigital marketing, SEO & analytics
with Faisal Tusher

B2B Marketing › Intermediate

Tracing Pipeline Back to Campaigns for an Architecture Software Firm

Practise moving a team from leads by channel to pipeline by campaign. You plan how campaign data reaches an invented architecture software firm's CRM, define sourced and influenced pipeline, read a sample opportunity export against spend and decide which campaigns earn more budget, while respecting what a single quarter of small numbers can and cannot show.
ExerciseIntermediate levelModule 3: Pipeline measurement5 minUpdated

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 Attribution, 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.

Illustrative example — not a real result

Planeform: last quarter's spend and leads by campaign

CampaignSpendLeadsCost per lead
Paid search, brand terms£4,00030£133
Paid search, generic terms£18,00085£212
LinkedIn gated guide on planning submissions£15,000240£63
LinkedIn webinar on coordinating consultants£9,00060£150
Trade show stand£12,00045£267
Podcast sponsorship£6,0000 trackedNot applicable
Organic£050Not 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

  1. 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.
  2. Write the counting rules for sourced and influenced pipeline.
  3. Read the opportunity export: total sourced and influenced pipeline by campaign.
  4. Compare each campaign's spend with the pipeline it sourced, and set that beside cost per lead.
  5. Decide which campaigns earn more budget next quarter, which keep theirs and what you will not decide yet.
  6. List the data fixes that must come first.

Worked answer

Data flow. Every paid link carries UTM 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.

Illustrative example — not a real result

Planeform: the opportunity export, read both ways

OpportunityValueFirst touch on the accountCampaigns touching the opportunitySelf-reported source
O1£24,000WebinarWebinar, brand searchWebinar
O2£12,000Generic searchGeneric searchGoogle
O3£36,000Trade showTrade show, gated guide, brand searchMet you at the show
O4£18,000OrganicOrganic, webinar, brand searchPodcast
O5£9,000Gated guideGated guideLinkedIn
O6£15,000Generic searchGeneric search, gated guideGoogle
O7£30,000MissingBrand searchPodcast
O8£27,000WebinarWebinar, trade showA colleague
O9£21,000Trade showTrade showThe show
O10£6,000Gated guideGated guide, brand searchLinkedIn

Total pipeline: £198,000 across 10 opportunities.

CampaignSpendSourced pipelineSourced pipeline per £1 spentInfluenced pipelineCost 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 trackedNot applicable£0 tracked; named on £48,000Not applicable
Organic£0£18,000Not applicable£18,000Not applicable
Missing sourceNot applicable£30,000Not applicableNot applicableNot 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 (CAC) 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.

Pages this lesson applies

Terms used on this page

Also related

Related