FMCG/CPG metric
What is the active customer base
The active customer base is the number of retail outlets that had at least one transaction - an order or a shipment - in the chosen period. It is not the size of the customer catalogue: an outlet enters on the fact of a transaction, and the activity rule and the period are set before the calculation.
- SFA: field sales automation
- Analytics & BI for Distribution

In detail
The active customer base helps sales managers see how many outlets buy during a selected period. Count unique outlets, not orders, customer records or legal entities. Several qualifying transactions at one store do not increase the outlet count. Choose the event and period first, then count distinct outlet IDs with that event.
The active customer base is a count with no denominator. Active share is a separate metric: divide the active count by the agreed comparison base, then multiply by one hundred for a percentage. All active outlets must belong to that base; target outlets that have not yet bought can remain in it. A smaller base can raise the share without adding buyers, so show both counts and changes in membership. The share is undefined for an empty base and zero for a complete, non-empty base with no purchases.
Orders and shipments give different views of purchasing activity. An order-based count does not require shipment; a shipment-based count requires more than an order. Shipment does not itself confirm customer receipt. Payment of an old debt without a new purchase is financial activity, so report paying outlets separately. Fix the event, document status and date for each measure in advance.
A larger active base does not by itself prove higher revenue, profit or retention. A one-off purchase and regular orders both qualify an outlet. With overlapping rolling windows, the same purchase can appear in both periods; that is not a repeat purchase. To assess repeat buying, check distinct events. Read shipment value and assortment alongside activity for the same outlets and period, with explicit return rules.
This movement analysis uses adjacent, non-overlapping periods. Retained outlets are active in both; new outlets have their first qualifying event in the current period; reactivated outlets were active earlier, skipped the previous period and are active again now. Lapsed outlets were active in the previous period but not in the current one. No event in this window does not prove permanent customer loss.
Comparison requires the same event, comparable periods and a consistent scope. An outlet buying a category for the first time is not necessarily new to the company; transfer between branches is not acquisition either. Report territory, channel and status changes separately. Incomplete earlier history prevents a reliable distinction between new and reactivated outlets. If current documents are still arriving, the absence of a purchase is also unconfirmed.
How it is measured
- Prepare outlet IDs, channel, territory, status and status-change dates. Match duplicates using verified data; the same name or address alone is not a reason to merge distinct stores.
- Choose orders or shipments and the qualifying document status. Define treatment of cancellations, returns and late-arriving data. If a qualifying document is excluded, recount outlets with at least one remaining qualifying event; do not subtract document counts from outlet counts.
- Set period boundaries, the time zone and the data update time. A rolling window can track activity, but overlap with the previous window does not prove a repeat purchase. To analyse new, retained and lapsed outlets, use non-overlapping periods that reflect the purchasing cycle. Label an incomplete period separately.
- Display the active count, comparison base and active share separately. Recalculate the overall count from unique outlets: totals by employee, category or period can count one store repeatedly. A quarter’s count cannot simply be the sum of its monthly counts.
- Compare outlet lists and distinct events, not just totals. Check earlier history and current data completeness. For inactive outlets, investigate purchasing cycles, stock availability, terms and refusal reasons. A higher share after catalogue cleanup calls for a different conclusion from genuine buyer acquisition.
- Choose an action and owner for the identified cause, then check the next comparable period. For discussion, prepare an anonymised outlet register, order or shipment history and an example of disagreeing reports with their filters and update times. Explore outlet and visit workflows in SFA and reporting views in analytics.
