The short answer
Group people by a meaningful starting event and compare equal ages. The cohort should match the business question you want to answer.
Before you start
- Identify the authoritative source for spend, contacts, qualification and customer outcomes.
- Document metric definitions, date basis, duplicate rules and reporting delays before comparing totals.
- Select a small set of traceable records to verify the journey across systems.
Put it into practice
01Define the starting point
Choose the cohort event explicitly. First enquiry, first purchase and product activation answer different questions. Keep the source date stable so later status changes do not rewrite history.
02Build the next step
Track progression over consistent intervals. Allow enough time for the outcome of interest and mark incomplete periods. Do not fill future intervals with zeros and call them poor performance.
03Review the evidence
Segment only when the sample remains useful. Channel, market or offer differences can reveal important patterns, but tiny groups may require qualitative review rather than confident numerical comparisons.
A worked example
A mistake to avoid
Avoid averaging away canceled or refunded customers. The cohort should retain the real economic consequences of acquisition, not just the successful survivors.
How to evaluate the result
Reconcile differences before choosing the most favorable number. Systems can count events, people and opportunities differently, and each report can use a different date or attribution rule. Label incomplete cohorts, unavailable data and known blind spots explicitly. Review whether a change in the metric comes from customer behavior or from a revised definition or integration. Once the measurement is reliable enough, use it to support a decision and name the uncertainty that remains. Precision in formatting should never exceed precision in the underlying evidence.
Apply this to your business
Create a cohort sheet with start event, source, size, elapsed time, qualified progression and realized revenue. Note which cells are still incomplete before drawing conclusions.
Your working notes
Copy these prompts into your project document. Keep observations separate from assumptions and give the next action an owner.
- Metric formula, scope and authoritative source
- Known gaps, duplicates and timing differences
- Decision supported and evidence still missing
Record what happened at the next review. If the evidence is incomplete, write down what would resolve the uncertainty instead of forcing a positive or negative verdict.