← All blog articles

A Team KPI Does Not Show a Consultant's Individual Impact

A client sends a team dashboard: 120 proposals, 24 signed projects. They ask you to write, "Our consultant generated half the wins."

The dashboard may support a useful statement about the team. It does not supply the missing link between those results and one person's work. Dividing 24 by two consultants would produce a number, but it would not establish who contributed to which project or what changed because of their involvement.

You can still deliver a useful report. State the team measure precisely, document the consultant's recorded work separately, and let the client choose whether an additional evidence check is worth commissioning.

Define the team result before discussing a personal share

The following example is entirely fictional. The numbers, documents, roles and dates illustrate a reporting decision; they are not customer results or a benchmark.

An independent sales operations consultant is preparing a review for a commercial director. The client supplies a cohort export and a separate activity record.

Field What the fictional records actually contain
Population 120 distinct proposal IDs issued by the whole team from 1 to 30 April 2026.
Recorded outcome 24 of those IDs marked signed by the 31 July 2026 reporting cutoff.
Team calculation 24 / 120 = 20% of the April proposal cohort recorded as signed by that cutoff.
Remaining proposals 96 not recorded as signed by the cutoff. Their other statuses are not supplied; do not label them all lost.
Consultant's work A dated activity record and document index show 18 proposal-brief reviews and delivery of a revised discovery checklist on 30 April.
Missing link No approved record connects the signed proposal IDs to the consultant's role, ownership or contribution. No individual credit rule is supplied.

Keep the cohort and cutoff in the wording. "Twenty per cent of the April proposal cohort was recorded as signed by 31 July" describes this record. It does not establish a final win rate for every proposal the team will ever issue, an improvement against an earlier period, or an individual result.

The 18 reviews are evidence of recorded activity. They are not automatically 18 distinct wins, and they do not tell you how many of the 24 signed proposals the consultant worked on.

Show why the total cannot identify the individual share

A short counterexample can make the limit easier to discuss than a general warning about data quality.

For illustration only, assume each signed project could be assigned to exactly one of two advisers. These are two invented allocations, not reconstructed staff records and not a proposed credit policy.

Invented allocation Projects assigned to Adviser A Projects assigned to Adviser B Team signed total
Possibility 1 12 12 24
Possibility 2 20 4 24

Both fit the same team total of 24 signed projects from 120 proposals. The supplied aggregate does not tell you which allocation, if either, occurred. It therefore cannot establish the requested "half the wins" claim.

Real work may be shared across advisers, account owners and delivery staff. In that case, an exclusive allocation may not describe the work at all. Do not make the numbers add up by inventing a one-owner rule after seeing the result.

Even a verified ownership count would answer a narrower question than "How many projects did this consultant cause us to win?" A record of involvement or responsibility is not a record of what would have happened without that person.

Complete the reporting decision before writing the conclusion

Here is the completed decision card for the fictional review. Its purpose is to agree what the client will receive now and what would require more evidence.

Client question or requested claim Available evidence Decision for this report Next owner or action
What happened to the April team proposal cohort? 120 distinct April proposal IDs; 24 marked signed by 31 July. Include the dated team calculation, 24 / 120 = 20%, with its cohort and cutoff. Commercial director confirms the export definition and reporting cutoff.
What work did the consultant deliver? Dated activity record and document index: 18 brief reviews; revised checklist delivered 30 April. Describe those recorded deliverables separately from sales outcomes. Consultant supplies the cited record references to the authorised report reviewer.
Did the consultant generate 12 of the 24 wins? No outcome-to-role link or agreed credit rule. Do not include this claim or an alternative estimated share. Commercial director decides whether a role-link check is needed.
Which signed proposals involved the consultant? The supplied records do not answer this. Mark unknown. Do not treat a missing link as evidence of no involvement. If commissioned, the CRM owner supplies the approved proposal-ID and role history needed for this question.
Did the consultant increase the team's results? One team cohort and an activity record; no evidence establishing the claimed effect. Do not describe a personal increase or causal contribution. Client either accepts the descriptive report or commissions a separately defined investigation. No result is promised.
What is the immediate client decision? The director needs a factual board update, not a staff ranking. Accept the team result plus delivery record now. Defer the individual-outcome question unless it changes a real decision. Director approves this reporting boundary before the conclusion is finalised.

The final row matters. An unknown does not automatically justify a larger analysis project. If the board needs a factual account of delivery and the team's current position, the bounded report may already answer its question.

Replace the unsupported sentence with usable wording

For this fictional case, a report could say:

The April team cohort contains 120 issued proposals. Of these, 24 were recorded as signed by 31 July 2026, representing 20% of that cohort at the reporting cutoff. The consultant's activity record documents 18 proposal-brief reviews and delivery of a revised discovery checklist on 30 April. The available records do not allocate signed outcomes to the consultant or establish the effect of that work on signing decisions.

This wording gives the reader a result, a delivery record and an explicit limit. It does not turn the unresolved proposals into failures or the consultant's activity into a personal share of sales.

If the director still wants "half the wins," ask which evidence supports 12 specific outcomes and what "generated" is intended to mean. A preference for a stronger sentence is not the missing evidence.

Offer a bounded evidence check when the answer will change a decision

If the client needs to know which signed proposals involved the consultant, agree the unit and role definition first. For example, "had a documented proposal review before signature" is different from "was the account owner" and different again from "caused the signature."

For the first question, a focused request might need the approved proposal IDs, dated review references and outcome flags for the same cohort. An account-ownership question would need the relevant assignment history and the agreed treatment of shared or changing responsibility. Request the fields needed for the chosen question through the client's authorised record owner; do not request every person's full CRM history by default.

Use this commissioning note to make the next step concrete:

Decision needed: Whether the report can name which of the 24 signed April-cohort proposals had a documented consultant review before signature. Work to commission: Check the approved proposal IDs against dated review references, record missing or ambiguous links, and return a descriptive list with source references. Client inputs: The CRM owner supplies the approved cohort/outcome extract; the consultant supplies the review index; the director agrees the meaning of documented involvement. Acceptance: Each reported link has a source, date and stated role; unresolved links remain unknown. Stopping point: If records cannot support the link, report that limit rather than estimate a personal share. Excluded promise: This check will not establish how many signatures the consultant caused.

For your own assignment, replace the dates, unit, role and source owner before quoting. Agree the fee and access arrangements for that defined check. Do not sell a guaranteed attribution percentage.

Turn the reporting limit into a clear service offer

A useful offer is specific: "I will turn your team KPI and delivery records into a client-approved report, identify which individual claims the records support, and document the evidence needed for any unresolved question."

The buyer can then choose a report using the available evidence, a targeted link check, or no further work. Your commercial value lies in making that choice clear and delivering the agreed output.

Use the Service-to-Segment Decision Sheet to describe that bounded service for the operations or commercial sponsor who needs it. Start with the reporting decision, the records required and the output they can use. Keep a promised personal impact figure out of the offer unless the evidence can actually support it.