Every distribution business loses customers, and almost always quietly. A reliable account that once ordered every week begins to order fortnightly. Then monthly. Then not at all. By the time a sales representative notices, the relationship has cooled and the revenue is already gone.
For one specialist valve and fitting distributor with hundreds of active accounts spread across multiple regions and sales teams, this slow erosion was the single largest unmanaged risk in the business. Tracking retention by intuition was impossible at that scale. Spreadsheets gave snapshots, not trends. The sales team needed a way to see the truth of the customer base, not as a gut feeling, but as numbers they could act on.
Working with Floware, an order management partner that builds custom systems for distributors, the company introduced a feature called Customer Trajectory. The system continuously analyses two to three years of order history for every account and assigns each one a trajectory classification, automatically, every month.
Every customer is sorted into one of five states.
The five percent threshold is deliberate. It filters out the normal fluctuation that distorts a single month's view, and focuses attention on genuine trends. Comparing each customer against their own peak performance over two years, rather than simply against last year, means an account that slipped twelve months ago and never recovered is still correctly flagged as declining. The system does not let a customer hide.
The mechanics are straightforward but disciplined. On the last day of each month, the system runs through the entire customer base and does four things in sequence.
First, it builds a snapshot for every active customer, calculating monthly sales averages across four time windows: the rolling twelve months, the current calendar year so far, the previous calendar year, and the year before that. These snapshots become a permanent part of the customer record.
Second, a growth engine compares the rolling twelve month average against the higher of the two previous yearly averages, producing a single growth percentage that captures the customer's direction of travel.
Third, that percentage, combined with account age and recent activity, drives the trajectory assignment. If a customer's trajectory has changed since the previous month, the change is logged as a timestamped event on the customer record, complete with the old state, the new state, and the growth figure.
Fourth, an automated retention report is emailed to management, broken down by region. The report includes overall retention percentages, trajectory distribution, and direct links into the live dashboards.
For new customers with less than a year of history, a separate estimation process projects monthly sales from as little as seven days of order data, so the team can gauge new account performance without waiting twelve months for the numbers to mature.
Your business is unique — your software should be too. Let's talk about a system built around how you actually work.
Book a free demoThe system surfaces all of this through two dashboards.
The Trajectory Analysis dashboard offers a high level view of the entire customer base. A row of headline metrics gives an instant snapshot: total customers, sales volume growth, the percentage of the base that is new, and the headline retention figure, which is the percentage of established customers who are either stable or growing. Underneath these sit the financial figures that turn retention into a revenue conversation: monthly gain from new accounts, monthly gain from accounts trending up, monthly loss from accounts trending down, and monthly loss from accounts gone dormant.
A doughnut chart visualises the distribution of customers across the five states, providing an immediate visual answer to the only question that matters: is the customer base healthy?
Below the chart sit prioritised action lists. The top ten customers by sales volume with their current trajectory. The largest declining customers, where intervention could recover the most revenue. The largest dormant accounts. The largest growing accounts. The most promising new accounts. Every list can be filtered by region and by sales representative, so management can drill into performance at every level of the organisation.
The second view, the Trajectory Report, is granular. It is a customer by customer table showing each account's trajectory classification with colour coded badges, their volume tier (high, medium, or low), monthly average sales for each of the last three years, and the growth percentages between them. The report is sorted by sales volume, because a ten percent decline on an account worth one hundred thousand rand a month demands more urgent attention than the same percentage on an account worth five thousand rand a month. It is filterable by every dimension that matters: trajectory, volume tier, region, sales rep, customer group, and tags.
Several things shifted, and not all of them were technical.
Retention became a number. Before the system, retention was a concept the team knew mattered but could not quantify. Now it is a single figure, updated monthly, visible to everyone. When the dashboard shows seventy eight percent, the business knows precisely what that means: twenty two percent of established customers are declining or dormant. That number became a target to improve, and the conversation around it sharpened immediately.
Revenue at risk became financial, not anecdotal. The system does not just flag declining customers. It attaches rand values to the trend. When the dashboard shows forty five thousand rand in monthly downtrend losses, the urgency becomes obvious. Retention stopped being a customer service concern and started being a revenue concern, which is the only kind of concern that reliably gets executive attention.
Decline gets caught early. Because trajectories are recalculated monthly against two years of history, the system catches problems while there is still a relationship to save. A customer trending down eight percent appears on the Downward list immediately. Without the system, that decline would have gone unnoticed until the orders stopped altogether.
Sales teams stopped guessing where to spend their time. The prioritised action lists function as a weekly plan. A regional manager opens the dashboard on Monday morning and sees, without digging through anything, the five most impactful conversations to have that week. The largest declining account in their territory. The largest dormant one. The most promising new one. No spreadsheets. No guesswork.
New accounts get attention from week one. The estimation engine means the business does not have to wait a year to know whether a new customer is worth investing in. Within weeks, projected monthly figures appear alongside trajectory data, and the sales team can lean into the relationships that show early promise.
Performance comparisons became honest. With filters for region and sales representative, management can compare retention across teams. If one region retains eighty five percent of its customers while another retains sixty five percent, that gap drives a conversation. The data removes ambiguity from performance reviews and territory planning.
Every customer has a documented journey. Because trajectory changes are logged as events, the customer record over time tells a clear story. A customer who moved from New to Upward to Stable to Downward presents a narrative that helps the sales team understand what happened, when, and what to do about it.
The monthly retention report, delivered automatically, provides something most businesses never quite manage to enforce on themselves: a recurring discipline. It guarantees that customer health is reviewed every month, without fail. The combination of automated data processing and human readable dashboards means the insight is always current and always accessible. The team spends less time building reports and more time acting on them.
By making retention visible, measurable, and actionable, the system shifted the culture from reactive to proactive. Declining customers are contacted before they leave. Growing customers are recognised and rewarded. And the business has, for the first time, a clear and honest answer to the question every distributor needs to ask: are we keeping our customers?
Most order management software was designed for everyone, which is another way of saying it was designed for no one in particular. It records your invoices, stores your customer list, and produces reports that tell you what happened last quarter, which is about as useful as yesterday's weather forecast.
The Customer Trajectory feature was not bought from a catalogue. It was designed for one company, to answer one company's questions, using one company's data. The result is a tool that does not merely record transactions but reveals the commercial truth hiding inside them.
The most durable advantage in distribution and manufacturing is rarely a better product or a lower price. It is better information, acted on sooner. A system built around your business does not just give you better information. It gives you better information before your competitors have any information at all.
If that is a conversation worth having, Floware is rather good at this sort of thing.
Your business is unique, but your software is off the shelf? Ditch the workarounds and let's build your ERP systems to fit your teams.