Blog · Data quality and reconciliation · Insurance
Measure missing, vague and evidenced loss reasons before interpreting why clients left. Weight completeness by prior agency income.
The existing loss report can show price as the top reason even when staff use it as a default label. The quality question comes first: how much lost business has a reason based on documented client or account evidence? Without that check, a confident retention narrative can rest on incomplete coding.
One row represents: one confirmed lost policy or relationship outcome with its reason record and evidence status.
Useful fields: Loss event ID, client or term ID, prior agency income, reason code, reason detail, evidence source, captured date, owner and review status.
Define a usable reason as a specific approved category with enough evidence for the agency's reporting purpose. Separate unknown, not recorded and broad 'other' codes. Report completeness by count and by prior income. Use the existing loss-analysis guide for interpretation after the coding-quality review is complete.
The following records and amounts are invented to show the method. They are not customer results, industry benchmarks or a forecast of Covirage performance.
| Reason quality | Lost renewals | Prior agency income |
|---|---|---|
| Usable evidence | 12 | $18,000 |
| Vague label | 5 | $7,000 |
| No reason | 3 | $15,000 |
Usable reasons cover 60% of losses by count but only 45% of the $40,000 prior income lost. The three missing-reason events contain more value than the five vague events. A reason distribution based only on the usable 12 cannot safely explain the entire lost-income population.
Client explanations can be incomplete or influenced by how the question is asked. A coded reason is evidence for a review, not proof of causation. Preserve unknowns rather than forcing certainty.
Bring a small, authorized sample to Covirage for insurance agencies and brokers. Use the sample to discuss the fields and views your business needs. A dashboard or AI analyst can help explore this question when the required data and definitions are available; missing records still need to be resolved.
Upload sample data to check its structure. Keep unnecessary personal, claims and policyholder details out of an initial sample. The sample check does not establish that every analysis in this guide is available automatically.
These references provide terminology or governance background. The worked example and proposed review method above are original illustrations, not prescribed industry standards.
No. Keep them visible and report their count and value. Redistributing them invents evidence and can distort the agency's priorities.