Overview

Starting on May 24, 2022, you can try out new versions of the UNFI & KeHE core dashboards that include the following data enhancements:

  • Cleaned up store and chain naming to improve readability. 
  • Geocoded stores to provide a more accurate address. 
  • Consolidated duplicated data from the source.

What's changed?

We also performed the following actions to enhance the data:

  1. Manually inspected and cleaned anomalies/ambiguities:
    • isolated blank or “unknown” UNFI chain codes
    • identified independent stores
    • stripped special characters
    • normalized common name variations (e.g. “MKT” becomes “Market”)
    • assigned each store a unique key so that duplicates could be removed
  2. Parsed chain and store names from store description, extracted store numbers from store description and placed them in separate field 
    • Data referencing “Sprouts #1 FZN” and “Sprouts Farmers Market 1” both get identified as store name “Sprouts Farmers Market” and store number “1”
  3. Geocoded all stores to give them a more accurate address 
  4. Match store data against publicly available data on the web (grocer websites) to fill in blank address or store number information
  5. Reformatting store names whenever possible to unify naming conventions across all connected data sources

How do I see it? 

From the dashboard menu, under UNFI or KeHE, select Distribution V2, Sales V2, or Velocity V2.

Calculation Changes

As we've enhanced the data that feeds into your distributor dashboards, you may notice some changes. Namely, you may see POD counts for certain chains/banners change because we've improved the geolocation data. Additionally, because POD count is an input into our velocity calculation, you may also see changes to your velocity numbers. In most cases, if your velocity does change, it will go up rather than down.

Example

The following example demonstrates how POD counts may change and how it would impact velocity.

Note: This example is for demonstration purposes only and may reflect changes that are greater than the norm.

KeHE connector looking at the last 52 weeks of sales:

Sales quantity = 619981

Sales amount = 1140192

Current store count = 2677

Current PODS (unique store product combination) = 8344

Current Unit per store per week (velocity) = 619981 / (2677 * 52) = 4.45

New store count = 1541

New PODS = 6419

New Unit per store per week = 619981/ (1541 * 52) = 7.73