The Sales Pack manual

The Sales Pack gives you a quick overview of the sales within the category, your own performance, and the performance of your brands and products. It is intended as a quick overview, without in-depth analyses, which you can find in the Category Report.

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, but you can choose multiple categories at the same time using the 'ctrl' key.

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?

At the top, you will find various filters that you can use to customize the report:

  1. Reference Month: This is the same as on the first page. It allows you to easily adjust the last period of your analysis, for example, to look at a year earlier.
  2. Length of the Period: You can choose from the last X months, the performance since the beginning of the year (YTD), or the performance over the last 12 months (MAT).
  3. Period Type: In graphs with a data period, you can adjust this. By default, it is set to month, but you can also choose the Nielsen period (13 times 4 weeks), week, or promo period (14 days that coincide with the promotions in the folder).
  4. KPI: You can choose from Out-of-Pocket (as the customer pays, value including VAT, discounts deducted), Volume in kg, liter, pieces, meter, … or in units. We count units on the lowest scannable EAN. If you package 2 products that can be purchased separately together, it will count for 2.
  5. Xtra users: the results from 
    • Only the Xtra Users. Customer KPIs are only available for Xtra customers.
    • The total of all cash register tickets. These consist of:
      • Xtra users: customers who show their Xtra card at the cash register and do not object to the use of their data.
      • Professionals: customers with a professional card or who request an invoice with a company number. Some of these customers also receive the Xtra discount.
      • Customers who do not identify themselves at the cash register. In some cases, also customers without a card receive the Xtra discount (when scanning the QR code at the cash register or if the customer has requested not to use their data).    
  6. SPAR: For Spar reports, you can filter by the type of Spar: Spar (Compact) CG and Spar Other. The latter are stores that are still awaiting their final rebranding to Spar (Compact) CG.

The tabs to the reports can be found on the left side.

What data is in the report?

In the report, you will find a lot of data from total Category to product level:

  • Performance of the category versus your performance: on the left you will find the total performance, in the middle this result is split according to Product Group, Segment, Brand or total category and on the right the performance per period. You can adjust this period at the top, in quarter, month, Nielsen, week or promo period. 
  • Performance of your brands and articles, each time with the current performance and growth compared to last year. 

All data in the graphs is standard on ‘Out-of-Pocket’, but via the filters at the top, you can adjust this to volume or units, or you can hover over it and then you discover more details. You can also adjust the period length of the ‘current’ and ‘growth’, which is standard on MAT.

How do I find a product?

In the reports, we use the product segmentation of Colruyt, because it facilitates the conversations with purchase. To be sure where a product is in our segmentation, you can look up all products in this list. For each product, you can also find the Colruyt article number, the EAN code and also in which value the volume is. This is especially important in categories where different volumes are mixed (and you don’t compare pieces with kg).

You can use the filters above the table to find the product faster.

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.