Inputs and weights
Large screens: 3 columns · Small screens: 2 · Mobile: 1Example dataset (monthly cohort)
Use this sample structure to build a simple loyalty dashboard.
| Month | NPS | Retention % | Repeat % | Engagement | CLV | Returns % | Support |
|---|---|---|---|---|---|---|---|
| 2026-01 | -12 | 60 | 36 | 52 | 740 | 8 | 68 |
| 2026-02 | -6 | 62 | 38 | 55 | 780 | 7 | 70 |
| 2026-03 | 2 | 65 | 41 | 58 | 830 | 6 | 73 |
| 2026-04 | 8 | 67 | 44 | 60 | 890 | 6 | 75 |
Formula used
This calculator builds a single Customer Loyalty Index (CLI) by combining normalized drivers with adjustable weights.
- Normalize each driver to 0–100. Example: NPS → (NPS + 100) / 2.
- CLV scaling: score = clamp( (CLV / Target) × 50, 0, 100 ).
- Quality penalty: score = 100 − Returns/Complaints rate.
- Weighted index: CLI = Σ (wᵢ / Σw) × scoreᵢ.
You can interpret CLI as a comparable score across segments and time.
How to use this calculator
- Enter your period metrics (NPS, retention, repeat purchase, engagement, CLV, and service signals).
- Set a realistic CLV target that matches your segment.
- Adjust weights to reflect your strategy (growth, retention, value, or service).
- Click Calculate to see the index above the form.
- Use CSV for dashboards and PDF for stakeholder reporting.
1) Normalization keeps channels comparable
All drivers are converted to a 0–100 scale so retail, subscription, and marketplace segments can be compared. NPS maps from −100 to 100 into 0 to 100, while retention, repeat purchase, engagement, and support already sit on a percentage or score scale. This makes month‑to‑month movement easy to read, even when raw units differ.
2) Weights reveal strategy, not just performance
Weights are auto‑normalized, so you can change emphasis without breaking the index. A growth posture often allocates 25–35% to advocacy and engagement, while retention programs frequently push 45–55% into retention and repeat purchase. If two segments share the same CLI but different driver mixes, your campaign plan should differ immediately.
3) CLV target turns revenue into a score
CLV is scaled against a target and capped once CLV reaches 2× target. For example, CLV 780 against a 1000 target scores 39.00, while CLV 1500 scores 75.00. Use a realistic target by cohort: new customers may target 600–900, while mature cohorts can target 1200–1800. Keep the target stable for a quarter to avoid noisy reporting.
4) Quality and support protect the index from churn surprises
Returns or complaint rate is converted into a penalty score (100 − rate). A return rate rising from 6% to 10% drops that driver from 94 to 90, which can move the CLI by 0.2–0.8 points depending on weight. Support experience adds a stabilizer: improving support from 65 to 75 can offset weak engagement when service matters.
5) Segment bands help prioritize budgets
Use bands to drive action: Champion (75–100) segments can fund referral, UGC, and premium bundles; Stable (55–74.99) cohorts benefit from upsell nudges and lifecycle education; Vulnerable (40–54.99) groups need friction removal and targeted offers; At risk (0–39.99) should trigger win‑back, service recovery, and churn‑driver analysis. Track band movement per month for quick wins.
6) Reporting cadence and sample size guidance
Run the index monthly for stable demand, or weekly for high‑velocity products. For survey‑based NPS, aim for at least 200 responses per segment per month to reduce volatility. For behavioral metrics, prioritize consistent definitions: same retention window, same repeat purchase rule, and the same engagement scoring rubric. Consistency is what turns the CLI into a reliable KPI.
FAQs
1) What does a CLI score of 60 mean?
A 60 typically indicates stable loyalty with clear upside. Keep retention healthy, then lift repeat purchase and engagement through lifecycle messaging, bundles, and post‑purchase education.
2) Can I remove a driver from the index?
Yes. Set that driver’s weight to 0. The calculator auto‑normalizes remaining weights so the final index still stays on a 0–100 scale.
3) How should I pick the CLV target?
Use a target that reflects your segment’s expected value for the same time window. Keep it consistent for at least a quarter to avoid artificial jumps in the CLV score.
4) Why is returns/complaints treated as a penalty?
Higher return or complaint rates often signal product‑market fit or fulfillment issues. Converting it to 100 minus rate makes the impact intuitive: rising issues reduce the quality score.
5) How often should I calculate the index?
Monthly is common for strategic reporting. Weekly can work for fast‑moving products, but only if your definitions and sample sizes remain stable enough to reduce noise.
6) Should I compare CLI across very different products?
You can, but align definitions first. Use the same retention window, repeat purchase rule, and engagement scoring. Otherwise, differences may reflect measurement choices rather than true loyalty.