Essential CRM KPIs to track: calculation formulas and examples
Mon Projet CRM - 31 octobre 2024
CRM (Customer Relationship Management) is a strategic lever for any business, but to be effective, its performance must be accurately measured. To achieve this, tracking specific KPIs is essential. Here is a list of the must-have KPIs to monitor, along with their calculation formulas and practical examples to help you implement them.
1. Customer Retention Rate
Formula: Customer Retention Rate = ((Number of customers at end of period - New customers) / Number of customers at start of period) × 100
Example: If a company had 1,000 customers at the start of the year, acquired 200 new customers and lost 100, then: Retention Rate = ((1,000 + 200 - 100) - 200) / 1,000 × 100 = 90%
A high retention rate is a sign of customer loyalty and satisfaction.
2. Customer Lifetime Value (CLV)
Formula: CLV = Average transaction value × Average purchase frequency × Average customer lifespan
Example: If a customer spends an average of £100 per transaction, buys 5 times a year and remains loyal for 3 years, the CLV is: CLV = 100 × 5 × 3 = £1,500
CLV helps in understanding how much revenue an average customer generates over time.
3. Customer Acquisition Cost (CAC)
Formula: CAC = Total sales and marketing costs / Number of new customers acquired
Example: If a company spends £10,000 on marketing and sales to acquire 50 new customers, then: CAC = 10,000 / 50 = £200
The CAC must be lower than the CLV to ensure profitability.
4. Conversion Rate
Formula: Conversion Rate = (Number of converted leads / Total number of leads) × 100
Example: If 20 out of 100 leads become customers, the conversion rate is: Conversion Rate = (20 / 100) × 100 = 20%
A high conversion rate indicates that sales and marketing efforts are effective.
5. Average Time to Conversion
Formula: Average Time to Conversion = Sum of time taken to convert each lead / Total number of conversions
Example: If three customers were converted in 15, 20, and 30 days respectively: Average Time to Conversion = (15 + 20 + 30) / 3 = 21.67 days
A short timeframe means the conversion process is efficient.
6. Customer Satisfaction Score (CSAT)
Formula: CSAT = (Number of positive responses / Total number of responses) × 100
Example: If 80 out of 100 customers respond positively, the CSAT is: CSAT = (80 / 100) × 100 = 80%
A high CSAT reflects customer satisfaction with products or services.
7. Net Promoter Score (NPS)
Formula: NPS = Percentage of Promoters - Percentage of Detractors
Example: If 60% of your customers are Promoters and 20% are Detractors: NPS = 60 - 20 = 40
A high NPS indicates that your customers are willing to recommend your company.
8. First Contact Resolution Rate
Formula: First Contact Resolution Rate = (Number of issues resolved on first contact / Total number of issues) × 100
Example: If out of 100 requests, 80 are resolved on the first contact: First Contact Resolution Rate = (80 / 100) × 100 = 80%
A high rate indicates the efficiency of the customer service team.
9. Average Customer Service Response Time
Formula: Average Response Time = Total response time / Total number of requests
Example: If customer service took an average of 5, 10 and 15 minutes for three requests: Average Response Time = (5 + 10 + 15) / 3 = 10 minutes
A short response time reflects good reactivity from customer service.
10. Customer Engagement Rate
Formula: Engagement Rate = (Number of customer actions (clicks, opens) / Total number of communications sent) × 100
Example: If 200 out of 1,000 customers clicked a link in an email: Engagement Rate = (200 / 1,000) × 100 = 20%
A high engagement rate shows that content is relevant to customers.
Conclusion
By tracking these KPIs and applying these formulas, you will be able to accurately analyse the effectiveness of your CRM. These indicators will provide an overview of performance, allowing you to optimise your strategies for better customer relationship management and sustainable growth in 2024.
Key takeaways
- Formula: Customer Retention Rate = ((Number of customers at end of period - New customers) / Number of customers at start of period) × 10...
- Formula: CLV = Average Transaction Value × Average Purchase Frequency × Customer Lifespan
- Formula: CAC = Total Sales and Marketing Costs / Number of New Customers Acquired
- Formula: Conversion Rate = (Number of Converted Leads / Total Number of Leads) × 100
- Formula: Average Lead-to-Close Time = Total time taken to convert all leads / Total number of conversions
Want to go further?
Discover our tools, checklists and templates to apply these recommendations immediately.