Customer base: active, repeat, new and returning
Shows the health of the base over a period: how many customers came back, how many left, the share of new and repeat buyers and how the ticket and revenue per customer differ for new and returning ones. You set what “active” and “repeat” mean, so the figures are comparable only inside your company.
At a glance
- What question does it answer?
- Is the customer base healthy: how many customers came back, how many left, whom revenue rests on.
- What data is needed?
- Customers in the base, those active at the start, returning and new in the period; your “active” window.
- How to read the result?
- On the example of 18,000 customers active at the start, 7,200 came back: retention 40%, churn 60%. At the end of the period there are 13,200 active (7,200 returning and 6,000 new), which is 25.4% of a base of 52,000; inactive are 38,800. New customers are 45.5% of the period’s buyers. Repeat buyers over 12 months are 30% (6,300 of 21,000). Returning customers bring 65.4% of revenue at an average ticket of 1,700 against 1,500 for new ones; revenue per returning customer is 2,597 and per new one 1,650. Example on the default values: Retention of the active (came back ÷ were active): 40%; Churn of the active: 60%; Active at the end of the period (returning and new): 13,200; Active share of the base: 25.4%. The figures are illustrative: enter your own to see your result.
Why and how to reason
Revenue is made of customers and customers can be lost quietly: while growth of new ones hides the outflow, everything seems fine. The calculation splits the base into four notions to see it. Active at the start are those who bought recently; of them 7,200 of 18,000 came back in the period, retention 40%, outflow 60%. Active at the end are 13,200 (returned plus new), 25% of a base of 52,000, and the other 38,800 are dormant or gone. The share of new among buyers of the period is 6,000 ÷ 13,200 = 45%: almost half of revenue depends on acquisition. But returning customers bring 65% of revenue: their order is 1,700 against 1,500 for new, and revenue per customer 2,597 against 1,650. So retaining one is cheaper than winning a new one. You define “active” and “repeat”, so figures are comparable only within your own company.
When to use it
Use it quarterly or seasonally to check the health of the base and before launching a loyalty program. It suits a brand or retailer with customer identification (card, phone). It does not suit a case where most sales are anonymous: first look at CRM coverage. Assumptions: the period and the definition of active are the same at start and end; repeat buyers are counted over 12 months.
How to read the result
Look at retention of actives and the share of actives in the base: if retention falls while you bring in more new customers, you spend on acquisition what you lose to outflow. Compare the repeat share with your own history: there is no single benchmark. Use the gap in order value and revenue between new and returning customers for budget decisions: if a returning customer brings one and a half times more, limit first-purchase discounts and direct money to winning back. Keep dormant and gone customers as a separate segment and count the payback of a win-back campaign. Make the budget decision on the combination of retention, repeat share and revenue per customer, not on one indicator.
Common mistakes
Comparing your retention rate with someone else’s under a different definition of activity. Counting as new those customers who were already in the base under another phone. Forgetting that without identification part of the purchases is invisible. Another trap: treating “inactive” customers as lost forever when some come back after a reminder or promotion.
What data is needed?
- Customers in the base, those active at the start, returning and new in the period; your “active” window.
- Buyers and repeat buyers over 12 months; orders and revenue of new and returning customers.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Customers in the base (bought at least once) | customers | 52,000 | All customers with at least one purchase that can be traced by card, phone or email. |
| Active at the start of the period | customers | 18,000 | Bought at least once within the activity window (for example 12 months before the start). You choose the window and keep it the same. |
| Of them bought again in the period | customers | 7,200 | Only those who were active at the start and bought in the period. |
| New customers in the period | customers | 6,000 | The first purchase in the base fell in this period. |
| Buyers over the last 12 months | customers | 21,000 | Unique customers with at least one purchase over the year. |
| Of them with two or more orders | customers | 6,300 | The numerator of the repeat-buyer share; not more than the buyers over 12 months. |
| Orders (receipts) of new customers | orders | 6,600 | Number of receipts of new customers in the period. |
| Revenue from new customers | ₽ | 9,900,000 | Amount excl. VAT: the general rate is 22% from 01.01.2026. The rate follows the shipment date; confirm your regime and rate with an accountant. |
| Orders (receipts) of returning customers | orders | 11,000 | Receipts of those who bought again in the period. |
| Revenue from returning customers | ₽ | 18,700,000 | Amount excl. VAT: the general rate is 22% from 01.01.2026. The rate follows the shipment date; confirm your regime and rate with an accountant. |
How it is calculated
| Step | Formula |
|---|---|
| Retention | came back in the period ÷ active at the start |
| Active at the end | returning + new |
| Repeat buyers | customers with 2+ orders over 12 months ÷ all buyers over 12 months |
| Ticket and revenue per customer | group revenue ÷ orders; group revenue ÷ customers of the group |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Retention of the active (came back ÷ were active)
- 40 %The share of those active at the start who bought again in the period.
- Churn of the active
- 60 %
- Active at the end of the period (returning and new)
- 13,200
- Active share of the base
- 25.4 %
- Inactive in the base (dormant and lost)
- 38,800
- Share of new among the period’s buyers
- 45.5 %
- Repeat-buyer share over 12 months
- 30 %
- Revenue share from returning customers
- 65.4 %
- Average ticket of new customers
- 1,500 ₽
- Average ticket of returning customers
- 1,700 ₽
- Revenue per new customer
- 1,650 ₽
- Revenue per returning customer
- 2,597 ₽
New and returning customers
| Group | Customers | Orders | Revenue | Average ticket | Orders per customer | Revenue per customer | Revenue share |
|---|---|---|---|---|---|---|---|
| New | 6,000 | 6,600 | 9.9 m ₽ | 1,500 ₽ | 1.1 | 1,650 ₽ | 34.6 % |
| Returning | 7,200 | 11,000 | 18.7 m ₽ | 1,700 ₽ | 1.5 | 2,597 ₽ | 65.4 % |
There is no single standard for retention or the repeat share in Russia: compare with your own past periods and channels under one definition of “active”.
Nuances and limits
- Changing the “active” window between periods: the metrics stop being comparable.
- Counting one person as two customers because of different cards and phones.
- There is no single retention standard in Russia: compare with your own periods.