Blog · Board and management reporting
Build sales and marketing metrics around the same acquisition cohorts. Reconcile lead counts, sales acceptance, opportunities, wins, and realized revenue before comparing channels or assigning actions.
Sales and marketing metrics should follow the same eligible customers from acquisition through sales acceptance, opportunities, wins, and realized revenue. Shared definitions make the handoffs measurable. Separate current-period activity from cohort outcomes so the teams can explain a gap without arguing over unrelated totals.
Choose the entity you are counting. A business selling to companies may use an account, because several people can represent one buyer. A transactional business may use an individual customer. Do not divide opportunity counts by contact counts and call the result an account conversion rate.
Use a stable acquisition cohort, such as eligible accounts first acquired during a stated month. Fix a review horizon, then record the date of each handoff. A mature cohort lets the team compare outcomes after the same elapsed time; a recent cohort should be labeled incomplete.
Agree whether stage counts mean ever reached the stage by the cutoff or currently sitting in it. The worked example uses ever reached. Those counts are nested, so a won account remains in the earlier accepted and opportunity counts. Current-stage inventory needs a different reconciliation because each account occupies only one current stage.
Keep detailed definitions in the sales analytics KPI reference. This scorecard is about one common population moving through the commercial process.
Start with the marketing acquisition export, CRM account and opportunity exports, and the finance customer revenue register. Keep account ID, original acquisition source, first eligible date, acceptance date, first qualified opportunity date, win date, and finance customer ID.
For the simple example below, each account has at most one qualifying acquisition opportunity. If real accounts can have several, count distinct accounts for account conversion and show opportunity counts separately. Otherwise the middle of the funnel can grow simply because sales creates extra records.
Assign one agreed acquisition source per account for this scorecard. Keep multi-touch influence in a separate report rather than allowing several channels to claim the same account in totals. Marketing owns source completeness; sales operations owns stage definitions and dates; finance owns the link to recognized revenue.
The GAO guide to assessing data reliability emphasizes accuracy, completeness, and applicability to the intended purpose. Apply those checks before calculating rates. The CRM data quality scorecard helps organize the field-level review.
A US business compares two source groups from the same monthly account cohort, reviewed at the same cutoff after an agreed observation window. Every count is a distinct account that reached the stated stage. Revenue is earned by won accounts from that cohort through the cutoff, after credits, rather than contract face value.
| Acquisition source | Eligible accounts | Accepted by sales | Qualified opportunity accounts | Won accounts | Realized revenue (USD) | Acquisition cost (USD) |
|---|---|---|---|---|---|---|
| Search | 400 | 240 | 120 | 30 | 150,000 | 40,000 |
| Events | 600 | 180 | 90 | 18 | 72,000 | 30,000 |
| Total | 1,000 | 420 | 210 | 48 | 222,000 | 70,000 |
The cost column uses the same agreed acquisition-cost categories for both sources. It is not a complete company profit calculation. Revenue likewise needs its own time boundary: a win late in the window may have less earned revenue than a win early in it.
The SEC's financial statements guide describes an income statement as revenue earned and expenses incurred over a period, while cash flow statements describe cash movements. Use finance's recognized revenue schedule, and report cash collected separately if collection is part of the review.
Acceptance rate = Accepted accounts / Eligible accounts
Opportunity rate after acceptance = Opportunity accounts / Accepted accounts
Opportunity win rate = Won accounts / Opportunity accounts
End-to-end conversion = Won accounts / Eligible accounts
| Measure | Search | Events | Total |
|---|---|---|---|
| Acceptance rate | 60.0% | 30.0% | 42.0% |
| Opportunity rate after acceptance | 50.0% | 50.0% | 50.0% |
| Opportunity win rate | 25.0% | 20.0% | 22.9% |
| End-to-end conversion | 7.5% | 3.0% | 4.8% |
| Revenue per eligible account (USD) | 375 | 120 | 222 |
| Acquisition cost per won account (USD) | 1,333.33 | 1,666.67 | 1,458.33 |
Rates are rounded to one decimal place, and acquisition cost per won account to cents. Calculate with unrounded counts. For a worksheet matching the first table, headers are in row 1, source rows in rows 2 and 3, and totals in row 4. The total acceptance rate is =SUM(C2:C3)/SUM(B2:B3); total end-to-end conversion is =SUM(E2:E3)/SUM(B2:B3).
Do not average channel percentages to get the company rate. Search and events contribute different numbers of accounts at each stage, so every total rate uses its own summed denominator.
The exact total stage rates multiply back to end-to-end conversion:
(420 / 1,000) x (210 / 420) x (48 / 210) = 48 / 1,000 = 4.8%
That identity proves the arithmetic uses consistent denominators. It does not prove the underlying account records are complete. Confirm that every opportunity account belongs to the accepted population and every won account belongs to the opportunity population.
The same cohort also reconciles into outcomes that are mutually exclusive: 580 accounts never accepted, 210 accepted without a qualified opportunity, 162 qualified without a win, and 48 won. The sum is 1,000. Each group should have a review action or a documented reason to remain open.
Here, events have lower acceptance than search, while both sources convert accepted accounts to opportunities at the same rate. Marketing and sales should inspect rejected event accounts and the acceptance rule first. The win-rate difference needs a separate review of opportunity fit, timing, and follow-up; the table alone does not prove a cause.
Tie the $222,000 of revenue to the finance schedule for these won customers and the stated dates. Keep unmatched records visible, using coverage measurement to explain what the report can represent. Marketing channel activity belongs in supporting views such as social media marketing metrics.
Bring a sample of your own agreed cohort workbook, CRM export, and customer revenue file to Covirage; it maps the columns, and its tools compute and check the shared metrics. The external AI model explains the results with every figure traced to its rows. Create a free Covirage account, then set up your business and bring your files.
See sales insights for the supporting business context.
Share an eligible cohort count, sales acceptance rate, opportunity creation rate, win rate, acquired customers, and realized revenue. Add spending or acquisition cost when the cost boundary is agreed. Keep activity measures nearby when they explain a bottleneck, but do not substitute them for outcomes.
Reports often count different entities or periods. Marketing may count contacts created during a month while sales counts opportunities closed during that month. Duplicated accounts, changing stage definitions, and incomplete campaign or finance links create further differences that need reconciliation.
Use a cohort when asking what happened to a defined set of leads or accounts. Use monthly activity totals to manage current workload. Both can be useful, but opportunities created this month divided by unrelated leads created this month is not a matched cohort conversion rate.