Customer Wallet Share Intelligence
Identifying $4.8M in Untapped Revenue Across 1,200 Active Accounts
Industry
Industrial & MRO
Scale
$210M Revenue
Duration
20 Weeks
Location
Milwaukee, Wisconsin
Engagement
AI Consulting
Executive Summary
The SVP of Sales at a 9-branch industrial distributor in Milwaukee suspected her team was capturing only a fraction of what their accounts actually spent on MRO. She was right — but the fraction was worse than she expected. Our analysis across 1,200 active accounts revealed an average wallet share of 18% on the top 400 accounts, with specific product categories where competitors had displaced them without the sales team knowing. Intelligence was embedded into the daily workflow on Infor SX.e, giving 26 field and inside reps prioritized growth targets for every account they managed.
Business Impact
$1.6M
Revenue captured from identified opportunities
22%
Increase in targeted cross-sell conversion
18%→24%
Wallet share on priority accounts
31
Accounts upgraded to managed status
The Situation
The distributor served manufacturing plants, facility management companies, and municipal maintenance operations across Wisconsin and Northern Illinois. The sales team of 26 — 12 field reps and 14 inside — managed approximately 1,200 active accounts. Most reps knew their top 10 accounts deeply. The remaining 35-50 accounts in each territory received reactive coverage: the rep responded when the customer called and processed orders when they arrived.
The average account purchased from only 3-4 product categories out of a catalog spanning fasteners, safety, cutting tools, fluid power, and material handling.
- No structured estimate existed of any account's total MRO spend — reps guessed based on plant size and hallway conversations, not data
- Product category gaps were identified anecdotally, usually when a field rep noticed a competitor's packaging on a customer's receiving dock
- Account planning was an annual spreadsheet exercise that most reps completed in under 30 minutes and never opened again
- Growth targets were set at the territory level, making it impossible to distinguish whether a rep was expanding wallet share or simply riding a customer's natural volume increase
- The CRM held contact information and call notes but no purchasing intelligence — a rep could see who to call but not that an account's fluid power orders had declined 40% over six months
- The SVP's best reps drove 3x the cross-sell revenue of average performers, but nobody had documented what they were doing differently or how to replicate it
The growth opportunity wasn't in acquiring new logos. It was sitting inside 1,200 accounts that were already buying — just not buying enough.
The Challenge
The SVP had spent two years pushing her team to "grow existing accounts" as a strategic priority. The problem wasn't effort or motivation — her reps were working hard. The problem was visibility. A field rep walking into a 200-person manufacturing plant could sell whatever the maintenance manager asked for that day but had no way of knowing that the plant spent $380K annually on MRO, that the distributor captured $62K of it, and that the $180K in cutting tools and fluid power was going to a competitor 40 minutes away.
The annual account planning process was supposed to address this. In practice, it produced spreadsheets with territory-level revenue goals that told reps how much to sell but not where to find it.
- Wallet share estimation required combining internal transaction data with external benchmarks by industry, plant type, and employee count — analysis nobody had the tools or time to perform at scale
- Category gaps were invisible at the individual rep level — a customer buying $400K in fasteners and safety but nothing in cutting tools was a growth opportunity hiding in plain sight
- Territory-level targets rewarded reps for total revenue without distinguishing between organic customer growth and genuine wallet share expansion
The Solution
We analyzed 36 months of transaction data across all 1,200 accounts, then benchmarked purchasing patterns against industry-specific spend models for manufacturing, facility management, and municipal maintenance operations. The analysis was built with input from the SVP's top three performers — reps who had intuitively developed their own methods for identifying category gaps and prioritizing growth conversations.
The system analyzed signals including:
- Account-level purchasing by product category over 36 months, identifying concentration patterns and category gaps
- Industry-specific total MRO spend benchmarks by plant type, employee count, and SIC code
- Wallet share estimation calculated as actual purchasing divided by modeled total spend for each account
- Category penetration showing which product families each account purchased and which they should be purchasing but weren't
- Purchasing trajectory by account and category — growing, stable, or declining over rolling 12-month windows
- Competitive displacement indicators — categories where purchasing dropped suddenly, suggesting a competitor had captured the business
The SVP's requirement was specific: "Stop giving my reps territory revenue targets. Start giving them account-by-account, category-by-category growth maps."
The Challenge
The SVP had spent two years pushing her team to "grow existing accounts" as a strategic priority. The problem wasn't effort or motivation — her reps were working hard. The problem was visibility. A field rep walking into a 200-person manufacturing plant could sell whatever the maintenance manager asked for that day but had no way of knowing that the plant spent $380K annually on MRO, that the distributor captured $62K of it, and that the $180K in cutting tools and fluid power was going to a competitor 40 minutes away.
The annual account planning process was supposed to address this. In practice, it produced spreadsheets with territory-level revenue goals that told reps how much to sell but not where to find it.
- Wallet share estimation required combining internal transaction data with external benchmarks by industry, plant type, and employee count — analysis nobody had the tools or time to perform at scale
- Category gaps were invisible at the individual rep level — a customer buying $400K in fasteners and safety but nothing in cutting tools was a growth opportunity hiding in plain sight
- Territory-level targets rewarded reps for total revenue without distinguishing between organic customer growth and genuine wallet share expansion
The Solution
We analyzed 36 months of transaction data across all 1,200 accounts, then benchmarked purchasing patterns against industry-specific spend models for manufacturing, facility management, and municipal maintenance operations. The analysis was built with input from the SVP's top three performers — reps who had intuitively developed their own methods for identifying category gaps and prioritizing growth conversations.
The system analyzed signals including:
- Account-level purchasing by product category over 36 months, identifying concentration patterns and category gaps
- Industry-specific total MRO spend benchmarks by plant type, employee count, and SIC code
- Wallet share estimation calculated as actual purchasing divided by modeled total spend for each account
- Category penetration showing which product families each account purchased and which they should be purchasing but weren't
- Purchasing trajectory by account and category — growing, stable, or declining over rolling 12-month windows
- Competitive displacement indicators — categories where purchasing dropped suddenly, suggesting a competitor had captured the business
The SVP's requirement was specific: "Stop giving my reps territory revenue targets. Start giving them account-by-account, category-by-category growth maps."
Implementation
Deployment occurred over a 01 – 05 period.
Wallet Share Estimation Model
Every active account scored with estimated total MRO spend and current share, benchmarked against industry models calibrated by plant type, size, and application profile.
Category Gap Analysis
Account-level visibility into which product families the customer purchased and which represented untapped opportunity — ranked by estimated dollar value.
Prioritized Weekly Action Lists
Each rep received a weekly list of 5-8 specific accounts with specific categories, estimated opportunity size, and conversation starters drawn from the account's own purchasing history.
Account-Category Growth Tracking
Targets set and tracked at the account-category level monthly — replacing annual territory goals with granular objectives each rep could measure and act on.
SX.e Native Delivery
Intelligence surfaced within existing Infor SX.e workflow and delivered as a Monday morning email digest — no new system, no dashboard login, no additional tool to check.
Wallet Share Estimation Model
Every active account scored with estimated total MRO spend and current share, benchmarked against industry models calibrated by plant type, size, and application profile.
Category Gap Analysis
Account-level visibility into which product families the customer purchased and which represented untapped opportunity — ranked by estimated dollar value.
Prioritized Weekly Action Lists
Each rep received a weekly list of 5-8 specific accounts with specific categories, estimated opportunity size, and conversation starters drawn from the account's own purchasing history.
Account-Category Growth Tracking
Targets set and tracked at the account-category level monthly — replacing annual territory goals with granular objectives each rep could measure and act on.
SX.e Native Delivery
Intelligence surfaced within existing Infor SX.e workflow and delivered as a Monday morning email digest — no new system, no dashboard login, no additional tool to check.
Strategic Impact
Revenue Activation
$1.6M captured in 20 weeks from accounts where category gaps were identified and reps executed targeted outreach. A 33% conversion rate on the $4.8M in total identified opportunity — with the remaining pipeline still being worked.
Account Relationship Depth
31 accounts that had been purely transactional — ordering reactively in 1-2 categories — were upgraded to managed status with multi-category growth plans. Average revenue per account in this group increased 34% within the engagement period.
Sales Team Behavior Change
87% of reps engaged with the weekly action lists consistently. The SVP attributed this to specificity: "My reps don't need motivation. They need targets they can actually act on. 'Grow your territory 8%' doesn't tell them what to do Monday morning. 'Expand into fluid power at these 8 plants' does."
Key Takeaway
Most industrial distributors capture 15-25% of what their customers actually spend on MRO. The growth isn't in new logos — it's in the accounts already buying from you. The SVP didn't launch a prospecting campaign or hire new business development reps. She gave her existing 26 reps visibility into the category gaps sitting inside their own accounts — and connected that visibility to specific, weekly actions that turned wallet share data into $1.6M in captured revenue within five months.
Related Engagements
Inventory Intelligence
The Director of Procurement at a 7-branch industrial distributor in Minneapolis had known about the excess inventory for two years. The catalog exceeded 200,000 active SKUs, inventory sat at $42M, and...
Pricing & Quoting Intelligence
The VP of Commercial Operations at a 14-branch industrial distributor in Columbus, Ohio had watched gross margin decline for five consecutive quarters while revenue grew steadily. The root cause was s...
SPA & Rebate Intelligence
The VP of Purchasing at a 5-branch industrial distributor in Edmonton discovered the problem during year-end reconciliation: her team had missed a volume tier with their second-largest supplier — a ma...