The question is whether the account departed from its own pattern
A list of customers is not enough. The useful record has one row per order or invoice and identifies the customer, date, product or product line, quantity or value. With that, the team can see both a complete pause and a gradual reduction in volume or mix.
Minimum fields for the first review
- Customer: a stable name or code, so the same account is not split across spellings.
- Order date: the basis for measuring the interval between purchases.
- Product or line: to distinguish a lost category from a customer that still buys another item.
- Quantity or value: to reveal a meaningful decline before the account becomes inactive.
The rule should not be “no purchase in 30 days” for every customer. A monthly consumables buyer, an annual maintenance buyer, and a project-driven account have different expected intervals. Set a practical reference for each account or customer group, then review exceptions with the person who knows the relationship.
ERP, CSV, spreadsheet, review
Export closed orders with the agreed fields.
Keep a dated source file so the review can be repeated.
Sort by last order, compare cadence, and mark exceptions.
Confirm context and choose the next action.
The spreadsheet is not a substitute for the ERP. It is a working view built from the ERP data, with columns for expected interval, reason to investigate, assigned owner, next action, and review date. It should point people to a decision, not become a second system of record.
Detection without ownership only creates another report
For each flagged account, assign one commercial owner. That person checks open quotes, service incidents, contact changes, stock or delivery issues, and the account’s own seasonality before making contact. The record should state what was learned and when the next review happens.
Where the manual routine reaches its limit
It becomes fragile when exports depend on several people, account names do not match, product lines need many reconciliations, or the action list is reviewed late. Those are process limits, not proof that the current system must be replaced.
Automate after the rule and response are stable
Automation becomes useful when the team has already agreed on fields, cadence rules, exceptions, and ownership. It can prepare a recurring exception list, notify the account owner, or keep the review queue organized. It does not decide why the customer paused or what the conversation should be.
There is no need to promise a real-time view. A weekly or monthly rhythm can be enough when it matches the buying cycle and the team can act on what it sees. Improve the frequency only when the current review is consistently used and a shorter interval changes a real commercial decision.
This is part of the same operational discipline behind making RD Station useful: clear data, a defined process, and a visible owner.
Return to the RD Station pain pillar or see how Revenue-Oriented Marketing Direction can establish this decision rhythm.
