40 Ecommerce Supply Chain Analytics [Updated for 2020]
Today you are going to learn which analytics and metrics matter for ecommerce supply chains.
This resource is different from anything else you’ll find because our goal is to list and talk through lots of examples. Few resources out there extend beyond a bland definition of analytics.
The guide will be especially interesting to ecommerce professionals because the list is sourced from veterans of Amazon and Zulily, pulling from their experience of measuring the things that mattered.
There are a lot of ways to measure performance of your supply chain. Some are better than others. What’s most important is the understanding that an ecommerce supply chain is dramatically different from a supply chain that supports older, physical business models, like brick-and-mortar (B&M) stores.
Let’s briefly talk about how to think about analytics (and metrics, and KPIs, and measurement) in an ecommerce sense, then we will dive into the long list of possible options for you to pick for your own supply chain.
Difference between analytics and metrics
Veterans of large ecommerce companies intimately understand what separates analytics from metrics from KPIs and measurement, but let’s quickly give a definition so the following list is easier to understand.
The definitions build on each other, almost like a pyramid.
Measurement is the “how” of data collection. Measurement within ecommerce businesses is uniquely different—and better—than in physical stores. Since ecommerce systems are inherently digital, data is being shed with every “action” happening along the supply chain. Therefore, measurement is as simple as capturing the enormous amounts of data produced from every interaction within every system every second of every day.
- A customer views the product page.
- The store (site) calls your inventory management system to see if the product is in stock, and it’s not in stock.
- The customer sees the item is out of stock, and leaves the store.
- The customer engages with customer service to ask when the product will be back in stock.
Get the idea? The measurement of all those actions is how modern ecommerce companies gain sophisticated metrics and analytics that set them apart from the competition. It’s really hard for Office Depot to know which pen the customer wanted when passing through Aisle 12 at the store down the street, for example.
The big “ah-ha!” for ecommerce companies is data = measurement, and ecommerce companies inherently have a lot of data! To take advantage of it, and create metrics and analytics that boost your business, you need to store the data in a structured way and connect it with other sources of data.
Metrics are quantifiable measurements that give a standardized value. For example, “Out-of-Stock-Bounce-Rate” is a metric, and is the culmination of the measurements from our previous story. By stringing together the data, a supply chain manager can create this metric with a statement like “17% of the time a customer visited a product page, we were out of stock, and they immediately left the site.” That’s a metric.
Key Performance Indicators (KPI) are simply your most important metrics. It might be stock levels, inbound cost-per-unit, NPS scores, whatever. You might check other metrics monthly, but you look at KPIs on a weekly or even daily basis.
Analytics adds context to a collection of metrics to inform future decision making. Continuing our story, let’s suppose the supply chain manager ended contracts with 10 suppliers last month because the company didn’t believe there was demand anymore for those 10 products. But by digging into the “Out-of-Stock-Bounce-Rate” and combining with other data, the manager notices that over half of the bounces are for one of the suspended products. The manager can take this insight and demonstrate a missed revenue opportunity, and perhaps restart negotiations with that supplier.
The four families of metrics and analytics
There are four types of metrics and analytics, but for the purpose of this next section, we’ll just call everything analytics.
Each type builds on the previous type towards more automated decision making. While full automation is a dream scenario for many businesses, it simply isn’t practical, so all four types play a role in a modern data-driven company.
Descriptive analytics explain “what happened” at some point along the supply chain. Examples:
- SLA fill rate with Fulfillment Center A, B, or C
- Last month’s lead time with Vendor X, Y, or Z
- Total dollars spent procuring inventory last month
Descriptive analytics are the bulk of what makes up dashboards.
While all four families are useful for tracking month-over-month changes, descriptive analytics are especially useful because of the guaranteed consistency of the measurements. Descriptive analytics are inherently simple measurements with little interpretation, which means they are less useful at automating decision making and more useful at logging rates-of-change for basic measurements over a given time period. For example, an increase in weekly inventory spend may alert you to a change happening that your partners elsewhere in the business may have forgotten to tell you about. Descriptive analytics are the foundation of all other analytics and frequently critical in their own right
Diagnostic analytics explain why something happened. Examples:
- An uptick in “Out of Stock Bounce Rate” is due to upstream supplier delays.
- “Order to Ship” has been poor recently because “Time to Pick” is 4x what it used to be, which suggests the recent floor redesign is not going as planned.
- “Ship to Deliver” is averaging over 7 days now, when it used to be under 3, which suggests the recent shift to a USPS injection shipping method to cut costs might not be worth it.
Diagnostic analytics are most often used to assess root causes of past output or outcomes. They tend to be more a tool you use on a specific problem versus a regular measurement over time, like descriptive analytics. You will see them deployed to understand what went wrong if a particular outcome was unexpected..
Diagnostic analytics are usually a combination of several descriptive analytics to tell a story about causation, which is the main difference from descriptive analytics.
One of the more interesting areas we see diagnostics analytics is within simulation exercises. Few people have the bandwidth to do these exercises on their own, but they can be useful when available. A specific scenario can be played out via a simulation in order to create the upside of diagnostic data without the downside of a real-life negative outcome. Simulating a pandemic to diagnose the impact on customer demand or supplier lead time sure would have been useful to do in January 2020!
Predictive analytics explain what will happen. Examples:
- Demand forecasting
- Margin impact when bundling
- Estimating the impact of weather on shipping times
The most important thing for predictions, whether by human or machine, is lots of data. Predictive models need historical data to project what will happen in the future. Companies who have high quality data sources that are interoperable and structured will perform better at predictive analytics.
While segmentation can happen at any layer, it has the biggest impact on company operations with predictive analytics. It’s common to segment predictive analytics by product, customer, channel, geography, and so on. Predictive analytics will tell you not to purchase winter coats for Miami during summer, for example.
Prescriptive analytics tell you what actions to take, within some degree of confidence. Examples:
- Where to locate your next fulfillment center
- Selecting the best outbound carrier option per shipment
- Where to place inventory within your fulfillment network
Prescriptive analytics are probabilistic. Much like predictive analytics, they take a ton of data then model outcomes. But unlike predictive analytics, they consider probabilistic scenarios and suggest the best actions to take (this is what makes them prescriptive).
They are deployed mostly related to performance outcomes. Reducing costs, increasing revenue and increasing or minimizing in-stock levels depending on the situation are all good examples of use cases for prescriptive analytics.
Which matter to you?
Everyone wants prescriptive analytics because of their power to automate decision making, but we are still in an era where the practicality of that is less than marketers would have you believe. Human consideration and decision making is still required for many tasks because of how complex supply chains and logistics can be. But prescriptive analytics go through the brute computational work for you to help make your decision easier and more informed than may be possible through other means.
Instead of jumping right to perspective analytics, you can gain immediate value by getting accurate descriptive and diagnostic analytics in place first, without which prescriptive analytics are not possible
Let’s dive into a comprehensive list of example analytics and metrics to help paint a broad picture of what’s possible—and advised—for ecommerce companies.
It’s simplest to think about supply chain analytics in the linear flow of goods.
Purchase Order (PO) Frequency - How often you cut a PO, and the associated data like volume and price.
Mean Lead Time - Average lead time per supplier, tracked over a period of time so you can evaluate rates of change.
Lead Time Variability - The variance of lead time per supplier. For example, tells you how often a given supplier misses an expected lead time (in either direction), and to what severity.
Lead Time Segments - Ability to break down by individual suppliers/manufacturers to see lead time data. Additional segmentation via attributes like geography, mode (ground, air, sea), or even receiving dock (if you use more than one) are examples of additional segmentations that move from descriptive to diagnostic when needed.
Inbound Transit Time - How long it takes to go from factory to your FC. Should be measured as one large metric, but it’s important to be able to do segmentation to move from descriptive to diagnostic capabilities. Examples:
- PO to Vendor Ready for Pickup - How long it takes to go from the factory to receiving dock. For example, the time it takes to get from order ready in China to your receiving dock in Seattle.
- Vendor to FC Transit Time - How long a shipment sits at the dock before going in transit.
- FC Arrival to Receive Complete - How long to go from dock to FC.
- Received to Stow Complete - How long to stow after arrival at FC.
Cost of Inbound Transportation - Similar to time metrics above, just the cost dimension of them.
Units Received per Hour - The number of units received at the FC per hour.
Normalized Received Productivity - The percentage of an expected rate.
Receive Accuracy - Compares what receivers said they would receive and what they found when a stower put the items away.
Inbound Exception Rate - Exceptions come in many forms. Here is a quick punch list of examples to track, which should be segmented by supplier, product, etc.:
- PO Volume Accuracy - Percent rate of overage or underage delivered.
- PO Error Accuracy - Percent rate of simply the wrong stuff delivered.
- Damaged - Percent rate of goods that were damaged upon delivery.
- Lost or Stolen - Percent rate of full shipments that simply never made it.
Prep Time (and/or bundling) - The time it takes to translate delivered goods into packaging that can be picked and packed for delivery. It might sound trivial, but for companies with custom packaging, it can be a bottleneck on the only question that matters—”Are my products ready to be sold?”
Inbound Cost per Unit: PO frequency, PO volume, and PO price combined with inbound transit costs and geography will determine the cost-per-unit of a given order. This is one of the more important metrics impacting margin. There are a lot of variables at play and decisions to be made:
- Partially fill a container with a single order, or wait to buy in bulk in order to fill a container?
- Order only the amount of product needed for today, or buy in bulk to get a volume discount?
And so on. There is no one best practice or universal goal for this metric, but instead targets are frequently determined by geography. For example, Japan prioritizes more frequent orders at lower volumes and higher costs-per-unit due to the cost of real estate and overall storage costs-per-unit, whereas American companies receiving product from China will almost always benefit from waiting to fill an entire container before shipping across the Pacific Ocean.
We generally define the supply chain as the flow of goods, and in the context of ecommerce, often single-piece flow. Modernizing the supply chain means optimizing the continual movement of goods.
Inventory management, much like demand forecasting, is its own science. Indeed, there are whole books written on different ways to measure and manage inventory. Managing inventory is intimately related to the supply chain, but is separate and large enough of a topic that it’s worth saving this discussion for a different article.
Instead of listing inventory management metrics, I’m going to provide a few concepts linking inventory to other metrics throughout the supply chain so that you understand in greater detail how much modern ecommerce analytics rely on interoperability of data across multiple systems.
- Customers care about availability of the thing they want to buy. Your inventory management system will know what is available to buy. Connecting this data across systems will not only improve other supply chain metrics, but help shift you towards a more customer-centric mindset.
- Part of inventory management is the metadata associated with products stowed. Often the inventory management system will be connective tissue between other metrics.
Order to Ship - How long it takes from the time a customer places an order to when it is handed off to an outbound carrier. It’s a composite of the following metrics within this Fulfillment category.
Order Generation to Order Drop - The time it takes for an order from an online channel to hit the FC that will be distributing the order.
Process Path Assignment - Different products can have different paths. How an order is assigned to which path is a step that, if manual, can cause delays.
Time to Pick - The time it takes the assigned FC to pick all items off the shelf.
Time to Sort - The time it takes sorting multiple items into a single order, depending on your picking process
Time to Pack - The time it takes to pack all sorted items into your packaging. This is an area where bundling can come into play, so depending on your business, you might have an additional metric to understand how much time the bundling exercise is adding to this process step.
Time to Load - The time it takes to load a packaged order onto trucks and handed off to an outbound carrier.
Ship to Deliver - This is a sibling to Order-to-Ship and is the second half of measuring the time it takes to go from an order being placed to it being delivered. It’s a composite of the following metrics in this Outbound category. Similar to most inbound transit metrics, you don’t necessarily have control over the performance of outbound transit. What you do have control over is who you select as your outbound carrier partner, and how you negotiate rate tables across shipping methods, which is why it’s crucial to at least collect and measure the performance so you can make more informed decisions with future carrier selection.
Send to Carrier Facility - How long it takes for the carrier to go from pickup at your FC to delivery of their distribution center (DC). Most often this isn’t a bottleneck. Sometimes, it can be, like with injection shipping.
Last Mile Handoff - How long the package sits at the carrier DC before being loaded onto the truck for last mile delivery. Usually this is vertically integrated—a UPS driver is picking up from a UPS DC to then deliver to your house—but this could be a bottleneck area to watch if you are including a last-mile delivery partner.
Last Mile Delivery - How long it takes to deliver from carrier DC to the customer. Often measured more in hours than days or weeks. Mostly matters when working with multiple outbound partners so you can identify hand off bottlenecks.
For ecommerce companies, returns can be a hard puzzle. Returns are part of modern ecommerce and can’t be entirely avoided. You can improve processes and data to reduce some of them but you can’t get rid of them, so it’s important that you are good at them in a way that doesn’t completely destroy your margins.
Subsequently, supply chain managers should keep a close tabs on return metrics and incorporate them into reverse logistics analytics.
“Where Is My Return?” (WISMR) - Total volume and total percentage of customer support cases where the customer is asking for their return credit, meaning you are still going through a process of receiving and organizing a return.
Recovery rate - Percentage break down of the resalability of returned goods. Worst case is you burn it in the parking lot. Best case is the item is undamaged and you can sell it again. Middle ground is the item still qualifies for liquidation or can be sold used. For ecommerce, the middle ground is considerably more viable because used channels online are unique compared to physical retail. Online discount channels garner more eyeballs than physical stores which increases the probability of a resale. Subsequently, ecommerce supply chain managers want to help minimize the worst case, versus maximize the best case, which is what older B&M retailers have to do.
Customer-centric metrics are cross-functional
Winning ecommerce companies prioritize metrics that put the customer first. It’s hard to do, though, because they are inherently cross-functional. It requires a shift in company perspective. The result, however, is analytics that propel the business towards profit and gross margin growth that beats competitors.
Order to Deliver (Click to Deliver) - The single most important metric for ecommerce supply chains. The only thing that matters to a customer is when they get the thing they ordered. This is a composite of Order-to-Ship and Ship-to-Deliver.
Delivery Accuracy - Percentage of the time that you delivered on the date you said you would.
Delivery Cost -Percent of time that the delivery cost was what you quoted. Why is this customer-centric? Because if you are constantly over performing and coming in cheaper than you are quoting, those are savings you can pass onto customers and eventually get to “free” shipping which is a top customer preference.
“Where Is My Order?” (WISMO) - Total volume of customer support cases where the customer is asking for their order. If this is high, it means your supply chain is too slow or opaque, and could impact repeat purchases.
Out of Stock Rate - How often a product was out of stock when a customer visited the product page.
Out of Stock Bounce Rate - How often a customer immediately left your site after seeing a product was out of stock.
Availability - Customers want to buy things. How long it takes to go from manufacturing to being in stock on your site is the most customer-centric way to define the inbound supply chain.