Customer Retention Rate Calculator

The customer retention metric looks at the core group of existing buyers who remain loyal during a measurement window, deliberately excluding any brand-new customers acquired within that same timeframe. To calculate the retention rate, you take the total number of customers at the end of the period (End cus), subtract the number of newly acquired customers (New cus), and divide that result by the total number of customers at the start of the period (Beg cus). Mathematically, this is expressed as: cus_ret = (End cus - New cus) / Beg cus. Additionally, the attrition rate—or churn rate—represents the exact inverse, calculated simply as attrition_rate = 1 - cus_ret.

Imagine you operate a subscription box service. At the beginning of the quarter, you had 1,000 active subscribers (Beg cus). Over the next three months, you successfully acquired 200 brand-new subscribers (New cus). However, by the end of the quarter, your total active subscriber count stood at 1,100 (End cus). First, subtract your new customers from your ending total: 1,100 minus 200 leaves you with 900 loyal, core customers retained from your original base. Next, divide this 900 by your starting count of 1,000. The resulting customer retention rate is 0.90, or 90 percent. Consequently, your attrition rate is 10 percent, meaning you lost 10 percent of your original audience during the quarter.

To maximize the value of your retention metrics, always evaluate them over consistent timeframes, such as monthly, quarterly, or annually. Avoid mixing cohorts, as seasonal shifts can heavily skew your incoming new customer totals. Finally, always pair your retention rate with financial metrics like Customer Lifetime Value (CLV) and Churn Cost to get a comprehensive view of your enterprise health.