Build a sector-specific cross-sell review population

A line-penetration report can claim a huge gap if it includes clients for whom the line is irrelevant or records no information about external placements. A sector-specific review improves the denominator, but it should start conversations rather than diagnose coverage from incomplete data.

Define the data before the metric

One row represents: one client-line review record with an eligibility and evidence status.

Useful fields: Client ID, broad sector, relevant business attributes, line, eligibility basis, held status, external-placement evidence, not-applicable reason and last reviewed date.

Have qualified account staff define the review criteria. Use sector as one input rather than the entire rule. Maintain unknowns and source dates. Calculate penetration among confirmed eligible clients with known placement status, while showing how many potential clients remain unreviewed. Link to placement-share analysis only when actual spend estimates are available.

Worked example

The following records and amounts are invented to show the method. They are not customer results, industry benchmarks or a forecast of Covirage performance.

Among the 35 eligible clients with known placement status, 57.1% hold the line through the agency. The 25 unknowns are not 25 proven sales opportunities. Reporting 20 out of all 70 as penetration would mix eligible, unknown and not-applicable cases in one denominator.

Use the result in a review

1. Prioritize outdated or unknown evidence before building a revenue estimate from presumed gaps.
2. Ask account staff to confirm business changes that affect eligibility and the relevance of the line.
3. Separate confirmed external placements from unreviewed clients when planning relationship conversations.

Checks before publishing

• Keep eligibility rules documented and dated rather than changing them to improve a reported ratio.
• Confirm each client-line record has one status and an evidence date where known.
• Do not sum inferred opportunity amounts into forecast income without a separately qualified opportunity record.

Where this analysis can mislead

This analytical population is not a recommendation that a client should buy a particular policy. Suitability, obligations, limits and coverage need require qualified review using the client's circumstances.

Explore this question with your own data

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.

Related guides

• Separate client-declared cover from inferred insurance gaps
• Create a cyber coverage inventory for agency account reviews
• Commercial insurance broker KPIs

Reference context

These references provide terminology or governance background. The worked example and proposed review method above are original illustrations, not prescribed industry standards.

• Insurance context
• Insurance data context