The customer retention formula is customers at the end of a period, minus the new customers added during it, divided by customers at the start, times 100. It shows what share of the customers you started with were still with you at the end.
The customer retention formula shows what share of your customers stayed with you over a set period of time. To calculate the results, you take the number of customers you had at the end, subtract the new customers you added along the way, then divide by the number you started with.

Your customer retention rate represents how many of the customers you had at the start of a quarter or a year are still with you at the end, and a drop is often an early sign that something in your service has changed.
You can figure out your customer retention ratio by entering three fields from your customer data, and the calculator below does the math for you.
Figure it the same way each time and compare each result with the one before it, so you can see which way your customer retention is trending.
Jump To: Formula | Calculator | Who Counts | Other Numbers | Improve Your Rate | FAQ
The customer retention formula takes your customer count at the start and end of a time period, along with the number of new customers you added in between.
To calculate the ratio in an Excel spreadsheet, put customers at the start in cell B1, new customers in B2 and customers at the end in B3, then type =(B3-B2)/B1*100 in any empty cell.
Jenna had 200 members on January 1. During the first quarter, 30 new members joined, and on March 31 she had 210.
Step 1. Take away the new members: 210 − 30 = 180. These are the members who were there on January 1 and were still there on March 31.
Step 2. Divide by where she started: 180 ÷ 200 = 0.90.
Step 3. Multiply by 100: 0.90 × 100 = a 90% retention rate.
That also means 20 of her original 200 members left during the quarter, a churn rate of 10%.
New sign-ups can hide the ones who left. Jenna finished the quarter with 10 more members than she started with, but 20 of her original members were gone.
Enter three numbers from the same period. The rates update as you type.
If your business doesn't sell memberships, you'll need to decide who counts as a customer before you run the numbers. Jenna can count her members, but a hardware store or a dental office has customers who come and go without signing up for anything.
Pick a rule based on how often a good customer normally comes back, and use the same rule every time. A hardware store might count anyone who bought something in the last 12 months. A dental office might count patients seen in the last 18 months, since most come in twice a year and 18 months allows for one missed visit.
Pull your customer list from your point-of-sale system or customer database at the start and the end of the period, and use the same report both times. If you change the rule or the report between runs, the two rates won't compare.
The formula stays the same in every industry, but what counts as a customer and what the measure is called can differ quite a bit.
| Industry | Who counts as a customer | What it's usually called |
|---|---|---|
| Banks and credit unions | Households with at least one open account | Household retention rate |
| Insurance agencies | Policies that came up for renewal in the period | Policy retention rate or renewal rate |
| Subscription and software | Paying accounts, and the revenue they bring in | Customer retention and net revenue retention |
| Retail stores and online shops | Customers who bought during the period | Repeat purchase rate and cohort retention |
| Dental, medical and veterinary | Patients seen in the last 12 to 18 months | Active patients and recall rate |
| Restaurants and hotels | Guests in the loyalty program or reservation system | Repeat guest rate |
| Contract services | Contracts that came up for renewal in the period | Contract renewal rate |
A bank counts households because a family that closes one checking account but keeps its mortgage and savings is still a customer. An insurance agency often tracks premium retention along with the policy count, so losing one large commercial policy shows up even when the number of policies barely moves.
Software and subscription companies also track net revenue retention, which counts the dollars from existing customers after upgrades and cancellations. It can go above 100% when customers who stay spend more than the ones who left.
These numbers are worth tracking alongside your retention rate, and you can figure each one from the same customer list and sales report.
Churn rate = Customers Lost ÷ Customers at Start × 100. It's the other side of retention, so the two always add up to 100%. Jenna lost 20 of her 200 members, so her churn rate for the quarter was 10%.
Repeat customer rate = Customers Who Bought More Than Once ÷ Total Customers × 100. This one is useful when customers don't sign up for anything. Jenna also sells drop-in classes, and of the 60 people who bought one last quarter, 15 came back at least once more, a repeat customer rate of 25%.
Average spend per customer = Total Revenue ÷ Number of Customers. Jenna's studio brought in $31,500 in the quarter from 210 members, so $31,500 ÷ 210 = $150 per member. If this number climbs while your retention rate holds steady, your customers are buying more from you.
Tracking Customer Service covers more numbers to review with your team, and Customer Loyalty and Retention Strategy shows how keeping good employees helps you keep customers.
- Theodore Levitt, The Marketing Imagination
When your rate slips, find out who left and why before you spend money on finding new customers.
1. Talk to customers who left. Call or email a handful of them and ask what made them stop coming in. Listen without arguing, even when you don't agree with what you hear.
2. Look at what changed. Compare the timing of the slip with anything that changed around the same time, such as a staff departure, new hours, a price increase or a new system.
3. Follow up on every problem. Log every complaint, give one person ownership of it and call the customer back once it's resolved, so they know someone saw it through. Courtesy calls work well for this.
4. Stay in touch between visits. A reminder call or a check-in after a large purchase keeps the relationship going, and the Customer Contact Plan helps you decide how often to reach out to each group.
5. Review the number with your team. Share the rate at your team meeting every month or quarter, along with what customers told you, and ask your team what they think is behind any change.
Jenna's customer retention rate dropped in her second quarter, and talking with former members showed her why.
The slip: Jenna started April with 210 members, added 25 and finished June with 201. That's 201 − 25 = 176 members kept, and 176 ÷ 210 is about 84%, down from 90%.
What she found: She called the 34 members who had left and reached 22 of them. Fourteen of them told her the 6 a.m. class had gone downhill since her longtime instructor moved away in April, with two canceled classes and a lot of late starts.
What she changed: She hired a dependable instructor for the 6 a.m. class, posted the class schedule a month ahead and texted the members who had left to invite them back for a free week.
The next quarter: Nine former members rejoined. She started July with 201 members, added 24 (including the 9 who came back) and ended September with 207. That's 207 − 24 = 183, and 183 ÷ 201 is a 91% retention rate.
| Quarter | Start | New | End | Retention |
|---|---|---|---|---|
| January to March | 200 | 30 | 210 | 90% |
| April to June | 210 | 25 | 201 | 84% |
| July to September | 201 | 24 | 207 | 91% |
Most of the members she reached gave the same reason, and once she fixed the 6 a.m. class, her rate climbed back to 91%.
The questions below address what leaders most commonly ask about the customer retention formula.
Click on the (+) sign below to expand each question. Click the (-) sign to collapse it again.
The customer retention formula is customers at the end of a period, minus the new customers added during it, divided by customers at the start, times 100. It shows what share of the customers you started with were still with you at the end.
Count your customers at the start and end of a period and the new customers added in between. Subtract the new customers from the ending count, divide by the starting count and multiply by 100. A business that starts with 200 customers, adds 30 and ends with 210 has a retention rate of 90%.
It depends on your industry and how often customers buy, so published averages vary widely. The most useful comparison is your own rate from one period to the next, figured the same way each time, and a steady or rising rate is a good sign.
Retention rate is the share of customers who stayed, and churn rate is the share who left. The two always add up to 100%, so a 90% retention rate means a 10% churn rate.
The formula is the same, but industries count customers differently. Banks often count households, insurance agencies count the policies that came up for renewal, and dental and medical offices count patients seen in the last 12 to 18 months. Subscription companies also track net revenue retention, which measures the dollars kept from existing customers.
Most businesses figure it monthly or quarterly and compare each result to the same period the year before. If your customers only buy once or twice a year, a yearly rate may give you a clearer picture.