The Sales Pack Non Food manual

The Sales Pack gives you insights into the sold volumes, both for your total performance and per product. 

How do I get started?

Before you start your analysis, it’s important to select two things:

  1. Which period do you want to analyze? Up to 5 years of data is available. You can select the period you want to analyze via the reference month. The selected month is always the last period of your analysis. For example, if you select ‘Dec 2023’, you will get data up until the end of December.

  2. What do you want to analyze? Here you choose which banner you want (Colruyt, Okay or Spar) and which category. It is not possible to select multiple banners or categories, you can choose one of each.

Finally, you will find a lot of information on specific topics in the reports on the page, such as: Is Collect&Go included in the figures? What does ‘a unit’ mean?

How do I customize the report?

Through the filters at the top of the report, you can adjust the settings of the reports:

  • Reference month: a repetition of the filter from ‘How do I get started?’ This way you can easily adjust the period of your analysis. 
  • Period length: adjust the length of the period, so you can quickly compare short and long term results 
  • Kpi: Volume in pieces, weight, liters,… or units (sales unit). On the last page of the report, the detail of the products, it is indicated in which type of volume the product is measured. 
  • Detail of the product category: determines the detail on the right chart on the ‘Overview’ sheet

What data is in the report?

In the report, you can find a lot of data. To keep it organized, we provide an overview tab by tab. 

Overview of the sales

This chart provides an overview of the sales.

  • On the left side, you will find the sales figures per product for the period you have selected at the top. The color indicates the evolution compared to the same period a year earlier. 
  • On the right side, you will find the sales figures, broken down by period. The colors show the details. You can adjust the level of detail via the ‘detail on product category’ filter.

When you click on one of the bars of the products in the left chart, the charts on the right will be filtered on that specific product. If you do not select any product, the table will show your total weekly sales.

Sales per product

This table displays the sales of all products. All products from the same segment and subgroup are grouped. For each product, we mention the Colruyt Article number, your reference number, what the volume of the article is and whether it is expressed in liters, kg, pieces, …

For each article, the sales per period is dispalyed, combined with the evolution compared to the same period a year earlier.

You can easily download this table, by using the button at the top right. This enables you to use the figures in internal reports.

Do you want some tips & tricks?

Export your insights

All data used in the report can also be downloaded, via pdf, photo, PowerPoint, and Excel (crosstab). You do this via the button at the top right. The Excel option only allows you to export only one chart per download. You have to select from a list of tables which graph you want to download. If you don't know which one to select, you can first click on the chart and then go to download. The correct table is then selected for you, you just have to click on the download button.

Save your filters

Do you have filters that you often use or would you prefer a different selection as a start screen, then you can go to the bottom of the report and click on ‘view original’. There you can give your selection a name and save it. If you want to consult them next time, you can find them just below where you enter the name.

Need extra information

You have doubts about the definition of a KPI or a term used? By clicking on the question mark at the top right of the report, you conjure up a handy overview with information about the methodology, the KPIs, and the terms used in the report.