A conversation between Ian Heller, co-founder and chief strategy officer at Distribution Strategy Group, and Ashley Bass, senior director of product marketing at Phocas Software.
Ian Heller, co-founder and chief strategy officer at Distribution Strategy Group, talks with Ashley Bass, senior director of product marketing at Phocas Software, about how analytics and CRM can help every distributor rep sell more strategically, not just the top performers. Phocas works with more than 2,500 customers worldwide, with distribution at the core of its business.
Ian Heller: Ashley, welcome. You made the point that distributors already have the data reps need, but usually only the best sellers dig it out. Let’s start there.
Ashley Bass: Thanks, it’s great to be here. As we were prepping, we had a lot of conversations about how important it is to pull the lever you have with the sales team. Getting the sellers working strategically, more productively, making the best use of their time, is probably one of the strongest levers any business has. At Phocas, that’s absolutely top of mind. If anybody knows anything about Phocas, you already know that helping businesses use their data and analytics to improve sales performance is in our DNA. We started with an analytics platform more than 25 years ago, and sales use cases have been one of the primary ways people get value out of it.
It’s also something I relate to on a personal level. I co-own a small distribution business with my husband, and we never have enough time to get to the data to make strategic selling decisions. Whenever we do that work and surface those insights, lightbulbs go off and we run a better business. But it’s painful to get through if you don’t have the right tools.
Using data and reporting to improve sales performance has always been one of the primary reasons people come to us. Our website is full of case studies where putting data from the ERP directly into the hands of sellers, sales managers and branches has driven real gains: more accounts worked, fewer accounts slipping away, stronger retention across the business.
To describe Phocas more broadly: it’s a platform that combines analytics and BI at the core. That’s where we started as a business. We connect to more than 200 ERPs and make the data in your ERP and other sources available for all manner of analytics and reporting. Over time we’ve evolved the platform to add specific capabilities for finance teams, for planning and budgeting, and we have targeted CRM and sales solutions built on top of that analytics foundation. What we’ve arrived at is a platform built for distributors and manufacturers to make use of their data in a number of different ways. So when we talk about combining analytics with CRM today, it’s worth understanding that we built our CRM and our Sales Insights tool, which surfaces sales analytics using AI, right on top of that ERP analytics platform.
Ian Heller: Your research found that not knowing which accounts to prioritize is the number one internal issue for distributor sales teams, and the information reps struggle most to access is which customers are quietly at risk. Distributors are sitting on years of transaction data. Why is this still such a struggle?
Ashley Bass: When we did that research, we were seeking to understand the state of selling in distribution. We asked about technology and a lot of other things, so we’ll reference it throughout the talk. One of the distributors we spoke with, in a survey plus some qualitative research, put it perfectly: we don’t know what we don’t know.
That’s really at the heart of the struggle. The problem isn’t that the data doesn’t exist. The businesses we work with are sitting on years of transaction and customer history, so the answers are in that data. It’s just hard to see them, and that comes from two things. One is volume. There’s so much data that the signal gets buried in it, and behind that is access: the data is there, but how do you get it out and surface the signal? The other is time. Even for a small business like my own, it’s taking the time to sit down, find the answers, share them with the team, turn them into something usable, and then keep checking on it frequently. Most companies don’t have enough ease of access to the data and enough time put together to do this well on an ongoing basis. That’s the gap.
Ian Heller: Spreadsheets were the second most common sales tool in your survey, but only about a third of users say they have a big impact. What does the run-a-report, build-a-spreadsheet routine actually cost a sales team?
Ashley Bass: The research asked distributors what’s in your sales tech stack and how much impact does it have. Spreadsheets stood out because they’re heavily used, but they were the least trusted, least impactful tool in the stack. On the other end of the spectrum, analytics and CRM had the opposite story: people use them less often, but they rate the impact really high. That tells a lot of the story, which is that when teams have the right tools, they get better outcomes.
What’s attractive about spreadsheets is that they’re free, or feel free, and they’re available. People know how to use them, and there’s a real concern around technology adoption. At Phocas, the most common scenario we see is people coming to us to solve the spreadsheet problem. Most customers who come to Phocas are stuck in spreadsheets trying to make better use of ERP reports. Maybe they have something like Power BI or a reporting module from an ERP, but none of those tools make it easy to put the data directly in people’s hands in a way that surfaces insights.
The run-a-report, build-a-spreadsheet routine costs teams in a few ways, and they compound. One is time. One of our customers summed it up perfectly: the biggest drain on the sales team is that they have to go search for information. There are lots of reports getting set up, and it can be an overload of information, but a lot of the time gets lost pulling the reports, cleaning them, making them available, trying to massage the data themselves. Another cost is that the data goes stale. Because of all that time, there’s a risk that it’s not fresh, so it’s a snapshot, and it’s not empowering people to act more strategically or proactively. And then it just doesn’t scale. The knowledge sits over here, and there are a lot of single points of failure: someone’s desktop, someone breaks a spreadsheet. Those are costs people don’t always think of when they’re working with spreadsheets, but it’s what we hear a lot when people come to us ready to get out of that world.
Spreadsheets do have the advantage that they’re familiar and free. The bar for us is how we can help people replace those default ways of working with something that’s actually easier and more powerful, but also quick to adopt.
Ian Heller: It’s only as good as the seller’s personal Excel skills.
Ashley Bass: That’s the thing. It is their skills, but some people have built up their skills or they’ve got their perfect spreadsheet. So we have to be thoughtful on the tech side: if we’re going to replace that, the value really has to be there, because people will default to the way they’re used to working. Part of our goal is to make sure we’re delivering enough value to make the default far less interesting.
Ian Heller: What do the best distributor sellers do that the average seller doesn’t?
Ashley Bass: The average seller knows their customers personally. But the best ones are thinking commercially. Not just who do I call and what did I talk to this person about recently, but at an account level: what do they buy, how often, how can I help them grow, where’s the opportunity in that account, and what are the patterns around why people might be slipping away?
Strategic sellers see the patterns. They see the system and make good choices about how to spend their time on high-value things. They might use data to become a much more consultative seller, looking at their own book of business, applying strategic thinking, bringing that into customer conversations more proactively, and choosing how to spend their time wisely.
But even the best sellers need the information to do that. If they don’t have what they need to make those choices or have those conversations, or if it’s not easy for them to get to it, even your most strategic sellers are going to struggle to do it time and time again, or at a scale that has even higher impact on the business. They shouldn’t have to spend their time digging that out if you have the right tools in place to surface it. The big difference isn’t the talent so much, although drive is really important. It’s having the information that allows more people to act more strategically.
Ian Heller: Your research shows reps value product knowledge and relationships above everything else, and most learn the job through on-the-job mentoring. If the craft gets passed down that way, how do you get what your top reps know down to everyone else?
Ashley Bass: Going back to what our customers say, it’s things like: we have an experienced team, some of them have been calling on the same customers for 20-plus years, and they have what feels like an innate understanding of how to manage those accounts and work strategically, in their heads. But as one customer said in our survey, as people start to retire, we need a central place. We need to allow sales managers to lead and manage, hold the team accountable, and help the team understand the opportunities out there.
Ultimately the best selling is human in its nature. What we want to do is look to technology to support all the things you can’t replace with humans. Some of that is freeing up time for those highly experienced sellers to coach and mentor, not just focus on their book, pulling their data and figuring out their stuff, but actually institutionalize it and give them time to help other people learn to be better sellers. On-the-job mentoring is really high value, but it only happens if the mentor has time. So our question is: how can we not just institutionalize and surface best practices in the tech, but also use the tech to free up time, even for the best sellers, so they can pass on their knowledge?
We launched a product about a year ago called Sales Insights, which is there to surface usable data and insights for sellers and help them understand where the opportunity lies. We’ll get into the details in a bit, but what it ultimately does is take a lot of that data digging off everyone’s plate. Whether that’s an experienced rep or someone new, it’s going to help them understand the accounts, flag who’s drifting, and surface what they can do, automatically. That helps anyone, senior or junior, make better strategic decisions and spend their time better. But it also gives time back to the tenured rep so they can mentor.
Information surfacing is one important side of that. The other side is where something like a CRM comes in, capturing the notes, the commitments, the relationship context and the activities, so that as reps retire, as people leave the business, as succession happens, that information is there. It’s not sitting in someone’s head or on a spreadsheet that can’t be surfaced. It’s really important to institutionalize that information, and that’s what CRMs are good at.
Ian Heller: Every distributor has a story about the account that slipped away while nobody was watching. Why haven’t we fixed that problem yet?
Ashley Bass: It’s hard to fix because of data volume and time. It comes back to: do you have the signal, is the signal visible, and do you know what to look for? If you know what to look for and you have the data and it’s easily visible and accessible, great, you can win. But that’s easier said than done for most people, because they don’t have the tools to surface it.
We have a customer who was really honest with us recently and described exactly what you just described: we literally lost a customer last week. We’d only just picked it up, but they stopped placing orders four months ago. This was a sales manager speaking, and he was taking the blame on himself: I thought I’d given my team the tools, I should have had a better line of sight. That conversation was happening while they were talking to us about how they’re using Sales Insights. That’s not somebody being careless or a weak team. These people understand how to diagnose the gap. They just weren’t seeing it. They weren’t watching the account because they were too busy focusing on other things. That’s why it keeps happening. It’s in there, but it’s not easily visible, and somebody has to stop, take the time, and go figure it out.
Ian Heller: Sales Insights segments a rep’s customers into champions, declining accounts, can’t-lose accounts and so on. Walk us through how that works and why it’s more useful than giving reps another dashboard.
Ashley Bass: What we’re doing is surfacing information about the accounts people are working with and displaying it in a way that makes it easy to see what’s going on and what you can do about it. Under the hood, we’re using an RFM model: recency, frequency and monetary value. Every account is scored on how recently they’ve ordered, how often, and how much they’re worth. Those three signals combined and surfaced put a huge amount of information in front of a rep or manager about the health of the account. A customer who used to order every week but hasn’t ordered in a month looks very different, and is segmented differently, from one who’s right on their normal rhythm. Even if the relationship feels the same to the rep, surfacing that information in an obvious way allows someone to see it and do something about it.
Sales Insights runs that RFM model across all of your data automatically. That’s the data we’ve pulled out of the ERP, and it’s always up to date. When anyone logs in, it’s just there in plain-language groups. We use labels like champions and at risk. The model identifies the opportunities, so the rep doesn’t have to.
Then we go further than segmentation. If I click into the at-risk customers, for each one, generative AI writes a short summary for the rep: what’s changed, what’s dropped off, what’s growing. That’s all the context a rep would normally have to dig for as they plan to call on that customer. And predictive machine learning ranks their next best move by revenue impact. So here’s the history of the account, here’s what’s happened, and here’s what you can do about it, with a dollar value attached. The rep starts from the segment and quickly drills down so they understand not just who to call, but what to talk about and what it’s worth. The segmentation starts you off with visibility, and the AI helps you take action.
The biggest difference between that and a dashboard is that dashboards are good at showing you status. You might see how you’re tracking toward a goal, or a trend. They show you the picture, but they don’t push you toward the next step. The human still has to figure out what to do with the information. Even if you built a segmentation dashboard, it’s not going to take those next steps to help you prep for a call or proactively plan your week.
Then, as a final step, Sales Insights lets people automatically populate the CRM at the push of a button, if a Phocas customer is also using our CRM. That tight integration is one more way to go from insight to action to tracking what happened. A standard dashboard isn’t going to do that. It shows you the data and leaves you to figure out what to do with it.
Ian Heller: A new rep’s territory looks very different from a veteran’s, and a contractor account doesn’t spend like a retail account. How do you keep the segments meaningful when customers look so different?
Ashley Bass: From a technology perspective, we have an opinionated product, which I think is really valuable. The RFM model is built in, and there’s best practice there. But we know there are differences, and the way we handle that is through what we call threshold sets. An admin, which could be a sales manager, because Phocas is very easy to administer and doesn’t require someone highly technical, can apply different segmentation thresholds by rep, by customer type, or whatever dimension is meaningful to the business. So at risk for a contractor is defined by contractor behavior. For a retail account, it’s defined by retail behavior. A champion in a new rep’s territory might be judged on what good looks like for them, not for someone else.
The segments need to be meaningful. The out-of-the-box view we ship with is great. A lot of people look at it when we turn it on with their data and immediately see the opportunity. But then they can tweak it over time. That’s the point: ship with what works out of the box for the most part, and give people just enough opportunity to make it meaningful within their business context.
Ian Heller: When a rep opens a customer record, they get an AI summary of what’s changed, grown and dropped off. How does the rep use that before a call? And how do you handle the rep who wants a one-sentence recap versus the one who wants a full briefing?
Ashley Bass: I get excited about this part, because the way we’ve designed this capability is one of those things that makes the juice worth the squeeze. We talked earlier about people being used to working the way they work, whether that’s spreadsheets or otherwise. The technology you choose to solve these problems needs to work in someone’s workflow. They need to want to use it. Sometimes one size fits all starts to detract from the value.
Picture a rep about to walk into a meeting or pick up the phone. Ideally, a strong rep looks up order history and figures out what happened last time, maybe through a spreadsheet or a CRM, if they have time to do it at all. A lot of people wing it because it’s too hard to get to the information. With Sales Insights, they open the customer record and the summary is there: a few lines on what’s changed, what’s grown, what’s dropped off. In about a minute, the rep has the context they might normally spend a lot of time trying to find, or skip altogether.
Where it gets exciting is that we’ve designed the feature so you can adjust how much detail you get. Some reps just want the one-line recap. That’s all they need, and we don’t want to force them to read a novel when all they need is the CliffsNotes. That may be because they’re really familiar with the account and just need to jog their memory. But sometimes they want the full briefing. If Sales Insights has surfaced an at-risk account you haven’t talked to in a long time, we want to make it easy for that person to get the context they need. Different reps have different levels of expertise, and different accounts have different histories. Having that adjustable depth is one of those simple but almost magical things that makes the technology much more valuable and adaptable to an individual rep.
Ian Heller: If you had to boil it down, what’s the core problem you’re solving for distribution sales teams right now?
Ashley Bass: In its simplest terms, we’re helping distributors use data to close the gap between the revenue that’s theoretically there for the business and what’s actually being captured. That gap is probably bigger than most people realize. The research shows people are concerned that they can’t see what’s there, that they can’t prioritize the things that matter most, and that revenue is leaking away invisibly. Those blind spots, like the customer who’s slipping away while the relationship still feels okay, are problematic and erode revenue and margin over time.
That’s what we’re trying to surface. It’s like an ongoing audit of your own revenue. Not a once-a-year look back, not how are we tracking to target, but a continuous, proactive understanding of where the risk is and where the opportunity is. That all sits in the data, and a tool like Sales Insights makes it obvious, flagging problems and telling reps what to do about it. The other half, of course, is making sure that what gets found in the data gets acted on. That’s where the CRM component comes in.
Ian Heller: An insight no one follows up on is just another report. How does a sales manager turn a segment, say every can’t-lose account that’s starting to slip, into action across the whole team?
Ashley Bass: You can have great segmentation, data insights, dashboards, whatever it is. But if it’s just sitting there and not getting acted on, you haven’t gained anything. Take the example of can’t-lose accounts starting to slip. With good tooling in place and good data in front of you, the manager can open the segment and see that there are maybe 15 accounts across the team that need attention right now. In the old world, the manager with a spreadsheet might screenshot or export it, share it in an email, hope somebody sees it and acts on it, and follow up manually.
With a connected technology view, the manager can take that whole segment to action in one move. In our technology, you tick the boxes, and those 15 accounts automatically become 15 CRM tasks. Each rep who owns one of those customers automatically gets that information routed to them. They’re effectively auto-assigned the work: this one’s outreach, reach out. If they’re using the CRM, it just pops up and lands there, assigned and ready to go. The manager has done it once, instead of sending 15 different emails. And then they can see what happens within those accounts in the CRM, see whether the follow-up has been done, and report on it.
Ian Heller: So they know whether or not it happened.
Ashley Bass: Exactly. That’s where the accountability comes in, and that’s what CRMs are great for. They’re great for seeing what’s going on with the team, and I think that’s the real value to sales managers: what’s happening, are you doing the work, what’s going on with the pipeline, what’s all the activity? If we can make that data capture and the assignment of actions really easy for both the manager and the rep, that’s a win-win.
Ian Heller: In the State of Sales 2026 research, better CRM adoption came out as the capability that would most improve sales teams, yet only about a third of distributors with a CRM log most of their customer interactions in it. Why are reps still resisting CRM, and what changes when the CRM is fed by insights rather than everything having to be entered by hand?
Ashley Bass: CRM adoption, or lack of it, is an age-old problem. It really comes down to value: am I getting enough value for the time I have to put into it? One way to drive adoption is to create more value. The connection between Sales Insights or the Phocas analytics product and the CRM makes the CRM more valuable. Data is flowing from Sales Insights into the CRM, which makes it much more compelling for a rep to log in and see how they can take action to make more money.
The other way is to make it easier for the reps. This isn’t a niche complaint. Lots of CRMs struggle with adoption. One of the big things you see changing now, particularly with the introduction of AI into these tools, is that we can make it far less work for a rep. As an example, we’ve effectively rebuilt our CRM. You have that data integration, automatically surfacing valuable insights a rep can act on through the CRM, which makes them want to come back and use it. But we’ve also focused a lot in our recent upgrade on making the CRM mobile-first. Most of our customers have people out in the field, driving around. It’s too hard for them to sit down and type information in. And AI gives us a great opportunity: we have a voice-note-to-task feature. I’m in my car, I give a quick summary of what happened at an account, and that automatically populates the CRM. Those are the types of things we can do to both increase value and reduce effort, and that’s ultimately what drives adoption and ROI.
Ian Heller: Here’s a skeptic question I get a lot. Every distributor thinks their data is a mess, and sometimes that’s true, but sometimes it’s an excuse. What has to be true about a distributor’s data before this works?
Ashley Bass: Our response is: that’s okay, because that’s what we’re here to fix for you. That’s what Phocas does. We connect to more than 200 ERPs, and we’ve been doing it for 25-plus years. One of our mottos is that we handhold people to success, and ultimately, for Phocas to deliver any value to a customer, we have to fix that data problem. So it’s a welcome statement, because we know we have a solution for it.
The big problem we’re solving at the core of everything is this: if the data is sitting in the ERP and it takes too much time, too much effort, and it isn’t in a shape where you can use it yourself, if you’re exporting into a spreadsheet and doing a bunch of massaging on your own, that’s not going to get you very far. It’s core to our value proposition that we’ve done this work with thousands of customers and hundreds of different ERPs, and we continue to invest heavily in it. We upgrade our connectors, build out-of-the-box solutions, and constantly improve our tools for data mapping and validation, all the things someone needs to get value quickly out of the surfaces that sit on top of the data. We’re working with a lot of customers who don’t want to invest, and can’t invest, in a big IT project or months of waiting to become data-driven. We know we have to build that expertise up front. That’s why our analytics foundation is such a critical part of the package. It’s not just a CRM, it’s not just a Sales Insights tool. It’s all the connectivity, data modeling and work we take off your plate that allows it to work well.
Ian Heller: Say a VP of sales rolls this out next quarter. What should they measure in the first 90 days to know whether it’s working?
Ashley Bass: From our research, we know there are a lot of metrics distributors aren’t measuring yet. They’re on a maturity journey. For example, 32% don’t measure existing-account win rates, 27% don’t measure retention, and 40% don’t track forecast accuracy or don’t know it. One way to think about this is to start small with the things that make a difference to your bottom line and mature how you use the data over time. First, get that messy data into a system that makes it usable. Rely on the technology to do that work, not the human being.
In the first 30 days, once you’ve got the tools and the data in front of the team, it’s about adoption. Are the reps logging in? Are they actioning the tasks? Are they looking at the segmentation screen, clicking in, reading the summaries and making the calls? Nothing is going to happen without adoption. That’s the leading indicator for everything else, and the earliest signal that you’re getting traction.
In the next 60 days, it’s digging into the behavior. Yes, they’re looking at the tool, but are they actually contacting people? Are they using the ranked opportunities and the AI summaries to improve their calls and plan their week and their month? From there, you start to see the outcomes and measure them, and in Phocas there are ways we can help you do that. Are people moving out of the at-risk segment into the champion segment? You’d see the results in sales orders, AR and the lagging indicators too, but the tool can also help you see how accounts are moving, and the CRM helps you understand what actions are actually happening and what the pipeline looks like.
So start with getting the data in and driving adoption. Once you get to that point, you can start doing more with metrics like win rates, retention and forecasting, after you’ve established the low-hanging fruit the technology brings to the surface.
Ian Heller: Half of distributors already use AI in sales and most of the rest plan to within six months. But everyone in your survey with no AI plans runs a team of fewer than 20 reps. What would you say to a smaller distributor who thinks this is only for the big players?
Ashley Bass: The research showed that 49% are using AI, a lot are planning to, and there’s a group of about 20% with no plans. That really surprised me, because there’s a real risk for smaller distributors who aren’t using technology and AI. It’s a missed opportunity to become more competitive.
I wonder if what sits behind that is worry about how to use the technology, or a misconception that they have to do the work to figure out how to use AI, when in fact they could be working with vendors who have AI built into their tools. Maybe they’re worried they don’t have the data, or they don’t think they have enough volume of problems. But if you’re working with the right vendor, using AI to your advantage is a huge opportunity to stay competitive as a small distributor with the big dogs. I’d love to know more about what sits behind that answer, and it’s something we want to dig into.
The real risk for a small distributor isn’t that they’re small. It’s that they may be leaving an opportunity on the table to become more competitive by using technology and AI. It matters more when you’re small, because you don’t have the other resources at play: you don’t have all the reps, all the data, all the technology. AI can really help shortcut that.
Ian Heller: A lot of those companies assume they can’t afford it, but they’ve never priced it or looked at what they’d get.
Ashley Bass: Exactly. There’s so much technology now, ours and others, where AI is just embedded within it. You almost wouldn’t know it’s there, but it’s making things work better and faster. Take something as simple as CRM voice notes. A small sales team might think, we just work in spreadsheets, we have our OneNotes and our Outlook tasks. But that doesn’t scale and it doesn’t centralize. A small field sales team can benefit just as much as a large one. Things like AI letting someone record voice notes and populate a CRM don’t cost you anything on top of the core technology. They’re just where AI is making a real difference in a bigger system. It’s also understanding that AI isn’t a big scary thing. It can be deployed in many different ways across a technology platform to make a difference.
Ian Heller: To wrap up, where is this heading in the next year or two? And if a sales leader watching could do one thing next quarter, what would it be?
Ashley Bass: With the way technology is moving, it’s hard to even think about a few months from now, let alone a couple of years. We see it at Phocas all the time. We’ve shipped dozens of new features across the platform in the last six weeks. The pace of change is wild, and AI is amplifying it. What’s happening in the next year or two is that we’re going to see lots of technology innovation, moving really fast. At Phocas, we have a roadmap with a bunch of AI capabilities, big and small, and a bunch of non-AI improvements too. It’s not just about AI.
So it’s important for people to get on the technology bandwagon now: get your data out and take advantage of what’s there, so you can be ready for the next thing that comes. Those of us building and shipping technology can take a lot of that work off your plate. You don’t have to go build the AI and build the tools. Let us do it for you, and because we’re moving fast, you can take advantage of that.
The big near-term thing for us, and I think we’ll see this across a lot of vendors, is conversational and agentic AI embedded into existing data platform experiences, so you don’t have to build it. You can rely on us to know the models and handle the security. For managers and sellers, being able to log in, ask a question, and conversate your way to a strategic plan is really game-changing. That’s a step change beyond where we even are now. Then layer on top of that something like Sales Insights, which today surfaces information and makes it actionable. In the future, we can actually take some of that action on your behalf. That’s where we’re going, and where everybody’s headed.
If I were to say one thing to a sales leader watching this, the one thing to do next quarter is pick the technology that’s going to make a difference to you right now, and pick a vendor you believe is going to continue to evolve with the technology. That means you can focus on your business and rely on Phocas, or whoever you choose, to deliver more and more value over time. If you don’t start somewhere, the amount of work you have to do to catch up and get your data sorted just gets bigger. That gap is widening now if you’re not adopting this technology.
Share this article:
