DataSentics

Portfolio & Revenue Management

Introduction

Revenue management is a crucial part of planning for FMCG Producers, companies with a vast customer base, as they need to understand the long-term impacts of trade terms, discounts, and pricing. With our solution, you can optimize your product mix and rearrange segmentation.

Business case

For the eCommerce scope it is natural to study the effect of market cannibalism on your enterprise, distinguish the products defining your segments, and products that should be replaced by others. Furthermore, our solution will help you to understand what causes the leakage in your discount structure.

Solution

Using advanced business intelligence, we can construct smart portfolio management by analyzing historical sales, digitalized trade terms, and market data. The approach allows identifying revenue leakage, unfavorably stipulated terms, and key-value items and categories, enabling businesses to see their products from another perspective and optimize their portfolio.

Data we use:

Collecting of data in most cases is done by Retail Smart Data Model combining primary compound key of Outlet x Week x SKU, and joined data, e.g.:

  • Financials
  • Sell-in
  • Sell-out
  • Outlet info
  • Product info
  • Weather info
  • Nielsen
  • Leaflets
  • Promotions

Benefits

With optimization of the portfolio, you can:

  • eliminate ineffective products
  • navigate negotiations
  • manage campaign ROIs
  • find the best-selling product options