Customer Retention Rate Calculator

Form

Results

Attrition rate

0

Customer retention rate

0

1

What is Customer Retention Rate?

Customer retention rate estimates what percentage of the customers present at the start of a period were still customers at the end. It separates retained customers from customers acquired during the period. The companion attrition rate is the percentage not retained under the same count-based definition.

The metric is meaningful only when the three counts cover the same dates and customer definition. A subscription business might count paying accounts; a retailer might count qualifying purchasers. Document that rule before comparing periods.

2

How to Use This Calculator

  1. Choose the reporting period and identify its exact start and end dates.
  2. Enter Existing customers, meaning the number at the start of the period.
  3. Enter New customers, meaning customers added during that same period.
  4. Enter Total customers, meaning the customer count at the end of the period.
  5. Select Calculate. The page subtracts new customers from the ending total, divides by the starting count and converts the ratio to a percentage.

The subtraction is essential. Without it, growth from acquisition could hide losses from the opening customer group. The page also reports attrition as 100% minus retention. This is a simple count-based measure: it gives every customer equal weight and does not measure the amount of revenue retained.

Before entering data, reconcile mergers, duplicate accounts, free trials, reactivations and customer-account consolidations. If the population definition changes during the period, the percentage can move even when actual customer behavior does not.

3

Formula Used

Retention rate (%) = ((ending customers − new customers) ÷ starting customers) × 100

Attrition rate (%) = 100 − retention rate

On this form, “Existing customers” is the starting count and “Total customers” is the ending count. The formula assumes that the ending customers left after removing new additions belong to the opening group. It cannot identify individual customer histories or handle reactivations correctly unless the source data has already assigned them consistently.

4

Variables Explained

Input or resultMeaning
Existing customersThe qualifying customer count at the beginning of the selected period; this is the denominator.
New customersQualifying customers first added during the period, using the same counting rule as the opening and ending totals.
Total customersThe qualifying customer count at the end of the period.
Retained customersEnding customers minus new customers under this simplified calculation.
Retention rateRetained customers as a percentage of the opening count.
Attrition rateOne hundred percent minus retention; also called a count-based churn rate in some reports.
5

Worked Example

A business begins a quarter with 200 existing customers. During the quarter it adds 50 new customers, and it finishes with 230 total customers.

  1. Remove new customers from the ending total: 230 − 50 = 180 customers attributed to the opening group.
  2. Divide by the opening group: 180 ÷ 200 = 0.90.
  3. Convert to a percentage: 0.90 × 100 = 90.00% retention.
  4. Find attrition: 100% − 90% = 10.00% attrition.

The ending total rose from 200 to 230, yet the company still lost 20 of the original customers. This is why net customer growth and retention answer different questions. The example assumes none of the 50 additions is a reactivated opening customer and that all counts use one definition.

6

Why Use This Calculator?

A 90% result means the calculation attributes 90 of every 100 starting customers to the ending population. It does not mean 90% of revenue was retained or that any particular customer will renew. Count retention can remain high while revenue falls if large accounts leave.

Compare like with like. Monthly and annual retention differ because customers have different time to leave. Seasonal businesses may benefit from year-over-year comparisons. Segment results can also reveal differences by product, plan or channel.

There is no universal “good” percentage. Contract length, purchase frequency and industry structure matter. If the page returns more than 100% or a negative percentage, inspect the inputs: the counts likely overlap or use different definitions.

7

Common Mistakes

    • Treating “existing” as the end count: on this page it is the number at the start of the period.
    • Mixing periods: new customers must be additions within the same interval bounded by the opening and ending counts.
    • Changing the customer definition: free users, trials, subsidiaries and duplicate accounts must be handled consistently.
    • Counting reactivations twice: decide whether a returning customer belongs to the opening cohort or to new additions.
    • Using revenue in a customer-count formula: gross or net revenue retention requires a different numerator and denominator.
    • Dividing by zero: a business with no opening customers has no defined retention rate for that period.
    • Assuming attrition identifies causes: the percentage records loss but does not explain cancellation, nonrenewal or inactivity.
    • Ignoring impossible outputs: retention above 100% or below 0% usually signals inconsistent counts.
8

Frequently Asked Questions

What period should I use for customer retention?

Use a period that matches the customer relationship, such as a month for monthly subscriptions or a year for annual contracts. State the dates and compare only with periods calculated the same way.

Is customer retention the same as revenue retention?

No. This calculator counts customers equally. Revenue retention follows money from an opening customer cohort and may include or exclude expansion depending on whether the measure is gross or net.

Can retention be greater than 100%?

Under this customer-count formula, a result over 100% usually means the opening, new or ending counts are inconsistent. Expansion revenue can make net dollar retention exceed 100%, but that is a different metric.

How should reactivated customers be counted?

Choose a written rule based on your reporting purpose and apply it consistently. A reactivated opening customer and a truly new customer should not be counted as the same event or counted twice.

Why can a growing business still have attrition?

New acquisitions may exceed losses. The ending population can grow even though some members of the starting population left, which is why new customers are removed in the retention formula.

What happens if existing customers is zero?

The rate is undefined because the formula would divide by zero. Start measurement after there is an opening cohort, or report acquisition and ending counts without a retention percentage.

9

Sources & References