This article explains how to add and manipulate product and store attributes in your Krunchbox reports to gain deeper insights into your data. Using Report 101 as an example, you’ll learn how to expand your report beyond the default category summary and how to group data by different features.
Overview
- Category as the Default View:
When you open Report 101, the results are summarized by Retailer and Category. This represents the top level of product information in your product master.
- Expanding the Report with Additional Attributes:
The report allows you to add more product information using the Column selection for Attributes. By expanding the drop-down box, you can view all available attributes in your Product Master.
Adding Product Attributes
Standard Product Attributes: Standard fields such as, Description, Brand, Subcategory, SkuNumber, Keycode, Barcode, Color, Size, replenishment Type, Product Status, Supplier, Purchase Price, RRP (including tax), Wholesale Cost (excluding tax).
Custom Product Attributes: Custom Product Attributes are attributes in your company’s Product Master that are unique to your company’s products. Custom Product Attributes are available in the Add Attribute dropdown and can be added to your report
Example – Adding Subcategory and Description:
Locate and expand the attribute drop-down.
Select Subcategory and Description.
Click the Krunch button to update the report.
Once processed, you will see the new columns Subcategory and Description added to your report.
Working with Store-Level Reports
Standard Product Attributes: Standard fields such as, State, City, Store Name, Store ID, Country, Post Code, Region, Territory, and Store Type.
Custom Store Attributes: Custom Store Attributes are attributes in your company’s Store Master that are unique to your company’s stores. Custom Store Attributes are available in the Add Attribute dropdown and can be added to your report.
If you want to analyze your data at the store level in the Classic Sales (0101) report, follow these steps:
Right-click on a field in the Attribute section of the report, such as Grand Total, Category, product.
Select Show me Store from the popup.
The report will now switch to a view based on store features.
Store Attributes Available: Once in store mode, additional fields become available. These may include:
Example – Adding Store ID and State:
Locate and expand the attribute drop-down.
Select Store ID and State.
Click the Krunch button to update the report.
Once processed, you will see the new columns Store ID and State added to your report.
Grouping Data and Analyzing Trends
By adding these attributes, you can group and analyze the information.
Grouping by Attributes: You can drag fields such as Category to the front of the report. Once grouped, you can collapse or expand details to see a summary by Category.
Grouping allows you to identify trends.
Shows where areas that may require further attention or performance improvement
Conclusion
By adding attributes—whether product or store-specific—into your Krunchbox reports, you can break down and analyze your data in various ways. This capability provides valuable insights, helps identify trends, and supports strategic decision-making. Explore the different attributes available, group your data as needed, and start uncovering the trends that impact your business.
Watch the following short video to learn more about adding attributes to krunchbox reports:
If you have any questions or need assistance with krunchbox, reach out to us at support@krunchbox.com