Previously, this series on the benefits of spend visibility has focused on the value beyond savings of using data to influence buying behavior in your organization. However, in these last few months of attending multiple conferences and meetings with public sector procurement professionals ‒ and a few with the CFOs, operations directors and others whom procurement teams report to ‒ it’s become clear that before we can discuss more ‘beyond savings’ opportunities, we really need to address the two most critical misconceptions about spend analytics - first, that it is difficult, and second, that it will take a long time to deliver real results.

Spend analytics is easier than you think and it can deliver results very quickly. 

Spend analytics is easier than you think

When we claim that spend analytics isn’t difficult, the three main objections we hear as are follows: the data isn’t available, the data can’t be extracted easily or that the data in the systems is so bad that no one could fix it. 

The truth is that the basic data you need for spend analytics are available in your ERP, accounts payable, purchasing card, eProcurement and other systems today. You can start spend analytics with just a few pieces of information: who was paid, when, how much, and who in your organization spent the money. It’s simply not possible that your organization functions without those key pieces of information. Unlike classifications, those pieces of data are going to be correct more than 99 percent of the time (or else your organization has bigger challenges to face). Once you have those nailed, you can move on to categorization, enhancement from external sources (business size, minority status) and then identify collaborative opportunities with other nearby organizations. Don’t let perfect data get in the way of the good. 

You can extract the data out of your systems. The key to getting over the data extraction hurdle is to be as specific and collaborative as possible with the people and/or teams who will extract the data for you. “Please give me all expenditure for the last year” is not specific enough to act on and will likely land your request in the ‘too hard’ bucket because it is too vague. If you ask the people extracting data for exactly what you want and why you want it, they’ll be able to act quicker and even provide guidance on other data points they have which might be relevant for you. For example: “I’m trying to get a handle on our goods and services spend with third parties across our organization. Can you please provide an Excel file with the supplier name, invoice ID, invoice date, amount and department name for all transactions where the invoice date is between July 1, 2015 and June 30 2016? Please exclude salaries, benefits, inter-organization transfer payments, rent and investments.” People can act and deliver more quickly if they know exactly what you are asking for.

Cleaning and classifying your data is the most complicated part of the process, but the good news is that there are many options available to tackle that part of the process. Each have their own pros and cons which are outside the scope of this article, but more information can be found in at the 30:42 mark of the Spend 101 NIGP webinar available here: (

Delivering results quickly

The main objection I hear regarding savings is that it takes a long time to deliver any results from a spend analytics project. Interestingly, I only hear this from people who haven’t done it. Delivering results quickly through spend analytics isn’t an all-or-nothing proposition. You don’t have to hit the ball out of the park with $1 million in savings delivered on your first attempt to make a spend analytics project successful. In fact, many organizations can achieve a 2-4x return on investment (ROI) on their spend analytics investment by delivering the first small-to-medium-sized project they identify and execute.

Even with basic spend visibility, you can identify and deliver quick, tactical savings projects in your first 90 days that give you the cover you need to plan and deliver longer term, strategic projects. You can start by more actively managing spend with your top 20 percent suppliers, progress to transactional efficiencies which free up your team for more strategic tasks, then identify common spend across departments that can be rolled up to create more efficiencies. Delivering those three programs will give you a significant ROI on your spend analytics investment, and give you time to plan your category management strategy, or to join external data sources to your spend data to visualize spend with minority/small businesses, spend with contracted suppliers and spend in common with nearby entities. 

The following are a few real life examples seen over the last six years:

  • One organization estimated $3 million in quick wins simply from rationalizing their information technology suppliers – within one day of having better spend visibility.
  • Another got an immediate benefit from reduction of the cost to their SWAM (minority spend) report from 1.5 FTEs to less than $20,000 per year.
  • Another reduced the time it took the procurement team to respond to FOIA requests from a week or more to a few hours – within weeks of completing their first spend analysis exercise.
  • Another identified and realized a 30 percent increase in the rebate on their pCard program within a few months by targeting the departments that were not compliant with policy.
  • Within six months, one city of approximately 100,000 population identified and delivered savings of approximately $500,000 with even more identified to be implemented.
  • Whether you’re delivering hard dollar savings which can be redirected to new purposes or you’re freeing up your staff’s time and resources to focus on new strategic initiatives, many opportunities can be identified quickly and executed quickly when you have the right spend visibility in place. 

​NIGP and Spikes Cavell

As part of Spikes Cavell’s ongoing partnership with NIGP, we will continue to provide education and guidance on spend analytics and using data to enhance your procurement teams’ output no matter how you carry out your spend analytics project or with whom. The URL above has a number of other spend analytics training sessions with ideas of how you can carry out the data collection and transformation process yourself, or what you should expect if you work with a third party. 

So – what’s stopping you?

You have the data in your systems. It can be extracted. You have options for how to clean and classify the data. And you’re likely to get a 2-4X ROI on your spend analytics efforts after delivering your first savings project. Any way you look at it, that’s a good investment.


Jonathan White, Director, Business Development (Americas) Applied Analytics, Spikes Cavell, part of CSC; (571) 313-5257 ext. 102;;; w: