Report Columns / Terms Glossary

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

This is a catch all column which should be broadly understood to represent the number o stores contributing to the sales or inventory metric being shown in the same row of data. For example - in the Item Distribution report, this refers to the recent average stores stocking the item or items reported.

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

A catch-all term referring to the adjacent column percentage of change between the current and previous time period. Most often this refers to the growth of sales or inventory in a year-over-year perspective.

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

ASP is an abbreviation for Average Selling Price of Average Sales Price. In the context of reporting, it provides the user with the average retail sale price of the item during the time chosen and region chosen based on the options in the report requested.

See ASP, synonym.

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

This is a composite metric representing the average inventory units multiplied by the unit cost of the goods to the retailer. Most retailers use this to evaluate their inventory investment commitment. Home Depot values their inventory at retail price however, so be cautioned. In many cases you'll have the opportunity to select cost value or retail value as a result.

Avg Inventory refers to the average of reported values for the item or items in the given period. This is often used as a component for Turns and GMROI and is a good measure for overall inventory spend commitment. It can also mask large swings in inventory such as out-of-stocks and so should not be utilized to interpret stocking levels or investigate out-of-stock issues.

Very similar to the above inventory cost - but this is the retail price multiplied by the average reported inventory during the year. Mostly applicable for Home Depot to match how they value inventory, this can be useful nonetheless for other retailers for trend analysis and evaluation.

Synonymous with Average Inventory, this explicitly refers to the average unit total of a given item or items on hand over the time period chosen.

Average Price refers to the average retail price sold to the customer during the time period chosen in the region chosen for the given item. This is often not the list price as certain stores may apply limited discounts which will have the affect of slightly lowering this below list price.

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

This refers to the count of cart bases recorded by the user when performing and inventory. Bases are a component of the entire CC Cart.

Calendar period refers to the name of the calendar period. In a 4-4-5 or 4-5-4 calendar quarters are divided up into three month periods which in turn are divided up into weeks corresponding to the number of weeks in the naming 4-4-5 or 4-5-4. For example, in Q1 of a given year, the first part of the 4-4-5 is January, which is allotted 4 weeks. February is as well, and March is allotted a 5th. In this scenario, January, February, March are the calendar periods, even though each only refers to the requisite number of weeks in the year.

Category is a generic term to refer to the categorization type of a given item. The system has 24 categorization slots available and each can be aliased to a meaningful term describing the values in the given categorization type. Without aliases this column is displayed with this header.

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

City refers to the city of the retail location being reported on in the report.

City, State is a composite of the retail location city and state being reported in the report. Tip - this can often be separated in Excel by using Text to Columns and the comma as a delimiter.

This column is a composite which refers to the city, state, and zip code of the reported retail location. Tip - Excel can help you separate these values through use of "Text To Columns" and the comma separator.

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

This refers to the cost value reported during the current year time period of the report. It's counterpart PY or LY refer to the same for the period in the prior year comparable timeframe.

This column provides the year-on-year growth of the value of sales or inventory valued at the cost sold to the retailer.

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

This represents the current unit cost of the item or items being reported as sold to the retailer.

This is the current retailer price to the consumer of the item or items being sold during the period.

• This is an upcoming feature. Stay tuned!

This is the name of the custom region chosen in the given report. Custom regions are named and chosen by users and represent arbitrary groups of stores. They can be shared and edited and in certain reports where custom region analysis is being done, its possible if the same store is present in two custom regions in the report, that the contributing sales data will be present in the total for each custom region.

CY is an abbreviation for Current Year. this is used interchangeably with TY which is an abbreviation for This Year. Both columns refer to the value reported during the current year time period of the report. Regardless of whether the time period is a day, week, month, or 102 weeks - this value always represents the total during the time period for the current year. It is found nearly always with the complementary column abbreviated either PY or LY representing Previous Year or Last Year or Prior Year respectively.

This represents the current time period cost value of sales in the report.

See Current Year Cost, synonym.

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

This represents the current year retail value of sales in the given report.

This represents the current year unit total sold in the given report.

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

Description is a catch-all term that generally refers to the Item # it is accompanied with or other column to help elaborate on an otherwise terse numerical code.

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

GMROI (Gross Margin Return on Inventory) is a composite metric used by retailers and investors to gauge an items productivity. It is commonly associated with the metric Turns and extends turns simply through the multiplication of the gross margin percent with the turn. The importance of the metrics in addition to turns is to allow the merchant to compare items which may have greater or lesser rates of sale and inventory turns equally once the margin dollars each brings at sale are included. In this evaluation and item may sell slowly, but have a high margin and outperform and item which sells and turns rapidly, but the retailer makes little or no margin in doing so.

Growth % is an abbreviation for the growth in the relevant metric between the current year period and the prior year period.

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

Item # nearly always refers to the retailer's item number. This item number is usually unique to the retailer and is often the unit basis for reporting in conjunction with the store #.

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

The Market column refers to the common grouping method of many retailers, most often based on a similar contiguous geography and / or pricing zone.. In Lowe's parlance this is called a Patch.

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

MC% is an abbreviation for Margin Contribution Percent. This value details how much profit is made selling the item or items being represented. This is nearly always representing the profit from the retailers perspective.

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

• This is an upcoming feature. Stay tuned!

Store # refers to the unique location code assigned to a given retailer's location. In the case of Wal-mart, this is not referring to the GLN (Global Location Number) but is instead the legacy numerical code. The Store # is the other elemental building block for POS sales data and is present in reports providing a high level of granularity.