Large portfolio, few active customers
A long customer list can hide a short working portfolio. The useful question is not how many registrations the ERP holds, but how many valid accounts have bought within a period that makes sense for the business.
Read the portfolio as accounts with a current commercial relationship
A registered customer is not automatically an active customer. Mergers, duplicate records, old prospects entered as customers and accounts that no longer fit the territory can all inflate the base. Start with an account list that can be checked against the legal entity, commercial owner and current scope.
The result is a more honest denominator for portfolio management. It also prevents the team from treating a database-cleaning issue as a retention problem, or assuming that one long list represents commercial reach.
Set an activity window before counting active accounts
The window should follow the purchase logic of the category, not a generic monthly rule. Consider the usual replenishment cycle, contract or maintenance interval, seasonality, lead time and the reporting cut-off date. A buyer of replacement parts may be expected to reorder on a different rhythm from a buyer of capital equipment.
Document the chosen window and review it when the commercial model changes. With the same date basis for every account, calculate:
Active penetration = (valid accounts with a purchase in the window / total valid accounts) × 100
This percentage describes the share of the usable portfolio that is buying now. It is a starting signal for investigation, not a universal target. A useful level depends on the offer, buying cycle, customer profile and the maturity of the underlying records.
Separate data quality from commercial behavior
Three labels keep the review clear. They should not be merged into a single inactive bucket because each calls for a different response.
- Invalid base: duplicate registration, missing company or contact information, merged legal entity, or an account outside the current commercial scope. Correct or remove it from the valid-base count.
- Inactive account: a valid account with no purchase within the agreed window. Verify known pauses, open quotations, delivery constraints and a change of buyer before deciding on contact.
- Low-frequency account: a valid account that bought in the window but below its own observed pattern. It remains active, yet deserves investigation into volume, interval, product mix or a temporary operational change.
Prioritize with potential, recency and purchased line
A percentage alone does not tell the team where to start. Segment valid accounts using three views that can be discussed by sales, service and operations.
- Potential: estimate the account’s relevant capacity from its application, installed base, production profile and commercial fit. High potential does not mean an automatic discount or a fixed revenue goal.
- Recency: place the latest valid purchase against the agreed window and the account’s own history. A recent buyer may need follow-through; a longer silence may need a diagnosis first.
- Purchased line: retain the product line in the view. A customer may be active in one line and absent in another, which changes both the commercial question and the person best placed to answer it.
Use the combination to make a short, accountable worklist: validate the record, confirm the commercial context, then choose a relevant next action. Review the reasons recorded by account owners so the next cycle improves both the data and the decision.
