Calculator Inputs
Use the score fields for current performance and weight fields for importance. Weights are normalized automatically if they do not total 100.
Example Data Table
| Client | Response Speed | Satisfaction | Retention | Referral Potential | CEI | Action |
|---|---|---|---|---|---|---|
| North Peak Advisory | 88 | 91 | 89 | 78 | 86.40 | Protect momentum and request a referral. |
| Greenline Retail | 74 | 80 | 72 | 61 | 74.85 | Improve review cadence and value reporting. |
| Atlas Creative | 67 | 69 | 64 | 58 | 65.72 | Repair follow-up discipline and clarify outcomes. |
| Harbor Tech | 49 | 58 | 46 | 40 | 50.33 | Escalate retention risk and stabilize service quality. |
Formula Used
Client Engagement Index:
CEI = Σ(Score × Weight) ÷ Σ(Weight)
Normalized Weight:
Normalized Weight % = (Individual Weight ÷ Total Weight) × 100
Benchmark Gap:
Benchmark Gap = CEI − Target Benchmark
Engagement-Adjusted Monthly Value:
Adjusted Value = Monthly Revenue × (CEI ÷ 100)
This approach converts several relationship indicators into one weighted score. Higher weights give more influence to the factors you consider strategically important.
How to Use This Calculator
- Enter the client name, account stage, benchmark target, revenue value, and relationship length.
- Rate each engagement factor from 0 to 100 using your latest client evidence.
- Assign a weight to each factor. Use larger weights for factors that matter more.
- Click the calculate button to generate the index, benchmark gap, recommendations, and graph.
- Review the strongest and weakest factors to guide account strategy and career development planning.
- Use the CSV or PDF buttons to save the result for reports, reviews, or coaching discussions.
FAQs
1. What does the client engagement index measure?
It measures the quality of a client relationship using weighted factors like responsiveness, satisfaction, retention likelihood, and follow-up consistency. The result summarizes engagement strength in one score.
2. Why are weights included?
Weights let you prioritize what matters most. For some roles, response speed matters more. For others, retention or satisfaction deserves stronger influence on the final score.
3. Do the weights have to total 100?
No. The calculator normalizes weights automatically. You can enter any positive values, and the formula converts them into proportional percentages for the final calculation.
4. What score is considered strong?
Scores above 85 usually indicate elite engagement. Scores from 75 to 84 suggest strong performance. Below 60 means improvement is needed before the relationship becomes unstable.
5. How often should I update the inputs?
Monthly reviews work well for active accounts. Update sooner after a major issue, renewal conversation, service change, or important client feedback event.
6. Can I use this for comparing multiple clients?
Yes. Apply the same scoring standards across accounts, then compare scores, gaps, and weak factors. That makes prioritization and portfolio reviews much easier.
7. Is revenue required for the calculation?
No. Revenue only supports the engagement-adjusted value estimate. The core CEI score still works even when revenue is unknown or irrelevant.
8. How does this help with career planning?
It helps you document relationship management strength, identify coaching priorities, and show measurable client stewardship during performance reviews, promotion cases, or consulting portfolio discussions.