Using High Order Attributes for Market Insights & Category Management

Label Insight High Order Attributes can be used in combination with Market Measurement Sales data to uncover insights in your category. Depending on your objective for your analysis, using Explore's Export functionality or an FTP delivered flat file of all attributes may be more appropriate.

*Note: Sales Data shown is for illustration purposes only.

Interested in a full Category Assessment against all Attributes? Leverage FTP Delivery to join LI data with your Category Sales data at the UPC level.

1. Download the spec.csv file from your Label Insight FTP folder location.
   1. To gain access to this folder, please submit a ticket via our support portal.
2. Join your own sales data using Excel's VLOOKUP off Label Insight's UPC code. 
   1. Please note, LI's UPC code includes a check digit. Users may need to remove the check digit to match on your internal UPC codes.
   2. For best analysis, be sure to include "Last 52 Week $ Sales", "Previous 52 Week $ Sales, "$ Change Sales", "% $ Change Sales" 
3. Leverage Excel's Pivot Table functionality to summarize sales by Characteristic & Value
   1. Include Spec, Segment, Characteristic, Value, along with all sales metrics 
4. Sort by "$ Change Sales" to identify attributes experiencing the most growth.
   1. Note: Please reference View Documentation for details on how products qualify for LI attribution. 
5. Pull out “Attributes that Matter” 
6. Summarize Insights & Make Recommendations 

Interested in a few target attributes? Pull data from Explore.

1. Filter Explore to a Shelf 
2. Click Export Products... 
3. Make Your Attribute Selection
   1. Due to Excel limitations analyzing exports, LI recommends selecting less than 10 attributes, plus identifying information like GTIN Formats. 
4. Click Export Products from Window 
5. Filter your data to an attribute Value in Excel 
6. Segment your data by High-Order Attribute 
7. Join your own sales data using Excel's VLOOKUP off Label Insight's UPC code.
   
   1. Please note, LI's UPC code includes a check digit. Users may need to remove the check digit to match on your internal UPC codes.
   2. For best analysis, be sure to include "Last 52 Week $ Sales", "Previous 52 Week $ Sales, "$ Change Sales", "% $ Change Sales" 
8. Summarize Insights & Make Recommendations