Tracking new store distribution

You can track stores at which you are newly supplying products, so you can take actions to boost success in new locations such as organizing demos, running promotions, and ensuring your products are well stocked.

For most retailers and distributors, we recommend tracking new store distribution by downloading data from Crisp and analyzing it using an Excel template we created. If you are a UNFI customer, you can track new store distribution from the Retention dashboard. For more on this method, see the Tracking new UNFI distribution section of this article.

To track new distribution using Excel:

1. Before you begin, download the New Store Distribution Excel Template spreadsheet.

2. Log in to Crisp, then, from the home screen, select Dashboards.
   

3. From the dashboard menu at the top left of the screen, in the Harmonized section, select either the Distributor Sales or Retailer Sales dashboard.
   

4. Use the date filter to define what time period counts as new distribution (such as the most recent complete month, the current quarter, or the current year). In this case, we'll focus on the most recent month. 
   

5. Refresh the dashboard to apply your filters, then in the Stores tile, right-click the store count number and select Show all # stores.
   
   A window appears that provides the store count data.

6. Select the Download button at the top-right corner of the window.
   
7. From the window that appears, choose the Excel Spreadsheet (Excel 2007 or later) format, then select the Download button.
   
   Note: If you have a large number of rows, before you download the results, make sure you select Advanced data options, then in the Number of rows to include section, select All results. 
   
   
8. Select the Distributors | Store Worksheet or Retailers | Store Worksheet tab, depending on the type of data you are analyzing. 
   
9. Then, paste the Stores tile data you downloaded into the corresponding columns of the Selected Period section.

10. Set the date filter to the time period you'd like to compare against and refresh the dashboard. In this case, we'll compare against the previous quarter to see which stores are new since then.
    

11. With the new date filter set, follow the same process to download the Stores tile data again, then paste it into the Compared Period section of the worksheet.

In the Selected Period section, the stores highlighted in yellow will be net new stores (new stores distributed to/or that registered a sale in the selected period that were not in the compared period).

You can now use this list to support your products in these new stores to help ensure their success and keep sales growing.

Tracking new UNFI distribution

If you are a UNFI customer, you can track new distribution in a few clicks on the Retention dashboard.

Steps:

1. From the dashboard menu at the top-left of the screen, select UNFI > Retention. 
   
2. From the Current Status Date filter, specify the time period for which you want to track new store distribution.
   
3. From the Current Status Filter, select New. 
   
   The dashboard filters for net net stores for the selected time period. The Details table at the bottom of the dashboard contains a full list of new stores. 
4. If you want to share the new store list with others:
   • Select the Tile actions menu at the top-right corner of the Details table, then select Download data.
     
     
     
     
   • Choose an export format, then select the Download button.
     
     Note: If you have a large number of rows, before you download the results, make sure you select Advanced data options, then in the Number of rows to include section, select All results. 
     
     The file downloads and you can now share it with others. 
     
     
5. If you want to share the entire report, follow the instructions in Sharing saved reports.