Products

Products shows every product in your subsections, week by week, with the plans and stores each one is in and the space it holds. Where your data includes sales, it sets that space against what the product sells. Use it to quantify distribution gaps and turn them into a sales case.

Explore covers the dropdowns, tables, details panel, view buttons and map that Products shares with Plans and Stores.

The space chart

Until you select a product, a chart above the table shows how space is shared out across all stores. Each box is a subsection, and the boxes inside it are its brands. The bigger a box, the more space it holds.

• The line beside the chart’s title says what it is showing: the number of subsections, and what sets the size of a box.
• The chart shows up to 25 subsections, those with the most space, and up to 10 brands in each. With one subsection in your data, it is one box of brands.
• A subsection’s box is sized by all of its space. The brands shown are stretched to fill it, so compare the sizes of brands within one subsection, not between two.
• Products with no brand are left out, though their space still counts towards their subsection.
• The colour follows the size. A stronger colour means a subsection with more space, as the Low to High key shows.
• Hover over a brand to see its space and its share of the subsection’s space. Hover over a subsection’s name, at the foot of its box, to see the same for the subsection.
• Metric, at the top right of the chart, sizes the boxes by Linear, Quadratic or Cubic space. It starts on Quadratic. Measurements explains the three.

Sales vs Space

Where the products in the chart have sales in the chosen week, the chart is Sales vs Space instead. A box’s size is then its sales for each unit of space, and the chart shows up to 25 subsections, those that sell the most for their space. A stronger colour means more sales for the space. A subsection, brand or product with no sales or no space that week is left out.

The chart’s title says which one you are looking at. If you choose a subsection that sold nothing that week, the chart goes back to space.

Hover over a box to see its sales, its space and its space productivity index, where 100 is a fair share:

Index = share of sales ÷ share of space × 100.

The shares are of the group the box belongs to, which the hover names: every subsection for a subsection, and its own subsection for a brand or a product. A brand with 2% of its subsection’s sales on 1% of its space has an index of 200: it sells twice what its space would suggest. An index under 100 means the brand holds more space than its sales earn.

Look at one subsection

Choose a subsection in the dropdown at the top, or select a subsection’s name at the foot of its box in the chart. The chart then shows the products in that subsection in place of the brands, and the table lists the subsection’s products. In the space chart, the size of a box is the space the product holds in the subsection across all stores.

The chart always covers all stores. Choosing an area in All Locations narrows the table, not the chart, so the two can then show different products.

The cog at the top right of the chart opens Product display. Choose By Brand to see a box for each brand instead, and By Product to go back.

Select a product’s box to open that product on its charts.

The products table

The table lists each product’s ID, Name and Brand, and the number of Stores and Plans it is in. Where your data includes sales, the table adds Total Spend and Total Units for the week. With an area chosen in All Locations, the table lists only the products stocked there, and its counts and totals cover that area alone.

Look at one product

Select a product in the table. The details panel, headed by the product’s name, holds:

• ID;
• Stores and Plans, the number of each that week, with a View link;
• Sales Spend and Sales Quantity for the week, where your data includes sales;
• Subsections, the subsections the product is in;
• the brand, and whatever else the retailer supplies about its products, such as a category or a manufacturer;
• the product’s dimensions, and its linear, quadratic and cubic space;
• Media, the product’s images, where your account has them.

Selecting a store or a plan in the View lists opens it in Stores or Plans, and leaves the product.

The view buttons at the top right are Details, Map and Chart. Details shows the product’s image, or No image available.

The plans a product is in

Select Chart to see a box for each plan the product is in, within the chosen subsection. The size of a box is the space the product holds in that plan multiplied by the number of stores the plan is in. It is not the product’s share of the plan.

Total quadratic space = (the quadratic space of each of the product’s sites in the plan, added together) × number of stores the plan is in.

• Hover over a box to see the plan’s ID, the number of stores it is in and the total space.
• Select a box to open that plan in Plans, with the product selected on it. This leaves Products.
• Where your data includes sales of the product that week, the chart is Sales vs Space instead. A box’s size is then the product’s sales for each unit of space in that plan, and the hover gives its index against all the plans in the chart.

To see every plan the product is in, clear the subsection dropdown. This also clears the product, so select it again in the table and select Chart.

A product over time

Below the plans, Space over time shows the product’s space week by week. The 4W, 12W, 26W and 52W buttons choose how many weeks, up to the chosen date, and start on 12. Where your data includes sales:

• the chart is Sales and space over time;
• Price over time shows the Mean and Modal price each week, and the Discount per unit. The modal price is the one the product most often sold at;
• Weekly sales per cm² against similar products plots the product with the 20 products closest to it in space and sales. The unit in its title follows Metric. The line under the title ranks the product, by its weekly sales for each unit of space, among the products of the chosen subsection, or of every subsection the product is in. Select another product’s dot to open that product.

Download chart data, the button under the view buttons, downloads the figures behind these charts as an Excel file.

Where a product is stocked

Select Map to see the map of the stores the product is in. Purple circles are stores that have the product. Black circles (white in dark mode) are stores that do not, which are its distribution gaps.

Map display, the cog at the top right of the map, narrows it to Matches Only or Non-Matches Only.