A Reopened Opportunity Is Not Automatically a New Lead
A previously closed opportunity may return to active discussion. Decide how that event should appear in reporting before counting it as new demand. Otherwise a dashboard can suggest growth that actually reflects a status change in an existing record.
Define the unit being counted
Separate a person, an organization, an inquiry and an opportunity. They are related but different units. Write a plain-language rule for when an opportunity is considered reopened and whether a genuinely new project receives a separate record. Keep the rule consistent across reporting periods rather than choosing the treatment that produces the most attractive total.
Preserve the original chronology
Retain the original creation date, closure event and reopening event where the system supports that history. Avoid replacing the first date simply to make the active pipeline look recent. If data is exported, check which date drives each chart. A first-created cohort and a recently-active cohort answer different questions even when they contain some of the same records.
Reconcile counts with the underlying events
Review a small sample of reopened records against the stated rule before presenting a trend. Explain any definition change beside the metric so comparisons remain meaningful. If automation proposes classifications, check ambiguous cases rather than silently accepting them. This is reporting guidance, not a claim that CloseRail currently implements a particular deduplication or cohort feature.
Copyable worksheet
Use one row for each field. Mark unknown information clearly and retain the original records.
| Field | Your note |
|---|---|
| Reporting unit | ____________________ |
| Reopening rule | ____________________ |
| Original and reopened dates | ____________________ |
| Chart date definition | ____________________ |
| Reviewed exception or rule change | ____________________ |
Worked example
Illustrative example: a fictional team has ten new inquiries and two reopened opportunities. Its report shows the two groups separately rather than announcing twelve new leads. The active workload is still visible, while demand generation is not overstated by a change in record status.