EARLIEST RECORDED SOURCE
4
Of the ten closed-won records originally entered through Meta.
ILLUSTRATIVE ASSESSMENT / MARKETING-TO-REVENUE DIAGNOSTIC
The CRM reports one Meta win. The earlier records show four.
In this fictional business scenario, leadership is considering moving CAD $5,000 per month away from Meta because the current-source report makes it look weak. Before making that decision, what should the underlying customer records tell us?
ENTIRELY SYNTHETIC DATA · NOT ACTUAL CLIENT RESULTS
24
Unique synthetic leads examined
32
Historical CRM status-event rows
10
Recorded closed-won opportunities in the sample
01 / THE MANAGEMENT QUESTION
Should the business move its marketing budget?
Imagine a fictional B2B technical-services company comparing Meta lead reporting with its current CRM customer-source report.
The CRM shows only one Meta-labelled win. A leadership team could interpret that as evidence that Meta contributes little to sales and propose reallocating CAD $5,000 per month to Google.
But a CRM's latest recorded source may reflect later customer interactions rather than the earliest known enquiry. The label must be understood before it is used to compare investment.
The first decision is whether the evidence is fit for the budget question—not which channel should win.
02 / THE RECORD-LEVEL FINDING
One customer history. Two very different source views.
CURRENT CRM SOURCE LABEL
1
Of the ten closed-won records currently has Meta as its CRM source.
Three originally Meta-sourced wins now show Google or Direct as the current label. One originally Google-sourced win has a blank current-source field. These are observations within a fictional sample, not findings about an actual company's attribution.
03 / THE INVESTIGATION
The problem sits beneath the dashboard.
SOURCE FIELDS
Eight of the 24 leads have conflicting or missing source information. Four of the ten wins are affected. Preserve earliest known source separately from later interactions.
UNIQUE RECORDS
The 32 status-history events represent just 24 unique lead IDs. Counting every event as a new lead would inflate the total.
SALES STAGES
Enquiries, qualified leads, opportunities and closed sales need agreed definitions and reliable IDs. One account may have more than one opportunity.
REVENUE LINKAGE
The fictional example doesn't include customer revenue, contribution margin or a validated finance-to-opportunity join. A channel-profitability conclusion is therefore unsupported.
04 / WHAT HAS TO WORK TOGETHER
Follow the record beyond the first click.
01 / ACQUISITION
Marketing
Capture original source, campaign information and a stable enquiry identifier.
02 / FOLLOW-UP
CRM & sales
Retain original source, store latest interactions separately and record stage progression.
03 / CUSTOMER
Won record
Link a distinct opportunity to the accepted sale without double-counting status events.
04 / DECISION
Reporting
Present verified metrics, unknown values and exceptions under agreed definitions.
05 / THE DECISION THE EVIDENCE SUPPORTS
Don't move the budget on this report alone.
The proposed decision in the fictional scenario is to hold the reallocation temporarily, approve clearer source-data standards, validate the customer journey and then revisit the channel decision using more reliable commercial evidence.
The data supports a finding about record mismatch and reporting quality. It does not establish Meta profitability, causal attribution, incremental sales or the correct budget split.
The CAD $5,000 per month figure is a fictional proposed budget reallocation—not an identified saving, loss or real client budget.06 / FROM DIAGNOSIS TO ACTION
Fix evidence quality before designing another dashboard.
DAYS 1–15
Agree definitions, exceptions, privacy requirements and the highest-priority technical changes.
DAYS 16–30
Have authorized specialists establish persistent source capture and test controlled lead journeys.
DAYS 31–60
Validate opportunity identifiers, sales-stage rules and the feasibility of reconciling commercial records.
DAYS 61–90
Monitor completeness and exceptions, then make a qualified investment decision using approved reporting.
THE THREE-WEEK HANDOVER
Evidence, requirements and a prioritized next step.
The corresponding consulting sprint investigates the agreed customer journey, examines a bounded sample of up to 25 unique leads where lawful access and identifiers permit, identifies reporting exceptions and documents recommended improvements.
The handover is an executive diagnosis, gap register, logical technical and process requirements, acceptance tests and a 90-day plan—not a completed CRM implementation or a rebuilt attribution platform.
Technical feasibility and effort require specialist review. If records cannot support a reliable conclusion, the outcome is a documented limitation rather than an invented answer.
YOUR DATA, YOUR COMMERCIAL DECISION
You're paying for leads. Can you confidently connect them to revenue?
The Marketing-to-Revenue Clarity Sprint helps establish what your reporting actually supports, where visibility breaks down and what needs to change before your next investment decision.