The Challenge
The client, a building materials distributor, served over 40,000 trade accounts through a coverage model shaped more by local geography and legacy habits rather than actual account value. Field reps naturally prioritised the accounts closest to their patches or the clients they knew best, leaving thousands of intermediate customers without any structured contact.
Management suspected the mismatch was costly in both directions, with expensive field visits going to low-value accounts that would never justify them, while promising mid-sized customers drifted towards competitors. Because nobody could calculate a reliable cost-to-serve or identify latent account potential, resource allocation remained entirely unoptimised.
The business needed a segmentation grounded in account value and buying behaviour to rebuild its sales deployment strategy.
The Solution
Many trade customers operated multiple branches under a single parent company that needed to be unified into a single parent-level account view before any clustering could begin.
Clustering on order frequency, product breadth, margin contribution, and digital ordering adoption surfaced five distinct customer segments, ranging from high-volume multi-branch contractors buying across every category to low-frequency occasional purchasers ordering a handful of times a year. The behavioural detail mattered as much as the value ranking, revealing that accounts of identical transaction size often maintained entirely different purchasing preferences.
These segments formed the basis of a tiered coverage model where field sales managed high-value accounts with complex needs, a structured telesales programme took over the steady mid-tier, and a digital self-serve route absorbed small infrequent buyers. Segment assignments were loaded into the client’s CRM system and are reviewed quarterly, ensuring accounts shifted tier as their purchasing activity developed.
The Impact
Redirecting field visits away from low-margin accounts cut cost to serve by 15% in the first year, while field representatives reported far more productive commercial conversations now that their schedules were populated by viable prospects.
The previously neglected mid-tier drove the primary revenue expansion, with accounts now receiving consistent telesales contacts delivering an 11% increase in revenue, and several high-performers graduated into field coverage as their order patterns deepened.
Meanwhile, moving small accounts to digital self-serve was met with no measurable revenue loss across the segment and order frequency holding steady, confirming that thousands of costly courtesy visits had been shaped by field sales habits rather than actual customer requirements.
Key Takeaways
- Account Hierarchy Resolution – Untangled fragmented multi-branch customers into a clean parent-level view before starting the segmentation process.
- Behavioural and Value Clustering – Replaced legacy geographical habits with five distinct segments built on order frequency, product breadth, margin, and digital adoption.
- Tiered Coverage Model – Deployed field, telesales, and self-serve routes to match the cost of contact directly to the commercial value of the account.
- Quarterly Tier Reviews – Refreshed account assignments regularly to allow accounts to move between coverage tiers as their buying behaviour develops.
- Commercial Results - Cost to serve down 15%, mid-tier revenue up 11%, and no revenue loss from moving small accounts to self-serve.
Tools and Techniques
- Customer segmentation
- Exploratory data analysis – profiling database health, identifying parent-child linkages, and mapping transactional histories
- K-medoids clustering (PAM) – executing the robust statistical classification to build the five customer segments
- SQL – data extraction, account hierarchy resolution, and multi-source transformation
- R – data handling, distance matrix calculations, and cluster validation modelling
- Salesforce – operational CRM integration and automated tier routing
- Power BI – pipeline reporting and segment performance monitoring
Related services
No matching items