Promotion Management in FMCG: How to Move Beyond Excel and Control Every Cent

A company sells 300 SKUs through 8 retail chains. Every month — up to 50 promotional campaigns with different mechanics and individual terms for each partner. Effectiveness calculations are done in Excel.

And each department has its own version of the file.

Sound familiar? This is exactly where most FMCG companies are when they start thinking about automating trade marketing.

This article explains what a modern promotion management system in Creatio CRM looks like, what pains it solves, and how Sales’Up addressed this challenge with a specialized product for the FMCG sector.

Why Promotion Management Is More Than Just “Tracking Campaigns”

In FMCG, a promotion is not just a one-time discount on the shelf. It’s a complex business process with several interconnected stages.

Planning The company defines the promotion mechanics (2+1, discount, volume bonus, tasting), timelines, assortment matrix, and target sales volumes. This also includes calculating the baseline — an estimated level of sales without the promotion. The difference between baseline and actual sales shows the real promo effect.

Agreement of Terms Each retail chain involves separate negotiations and contracts. Terms may include discounts on specific SKUs, volume bonuses, shelf placement fees (“golden shelf”), or pay-on-sell mechanisms. These conditions are not standardized — they are unique for each partner.

Operational Launch The product must be on shelves before the promotion starts. Shipment, receipt, shelf placement — each step is a control point.

Field Execution Control Company representatives physically check shelf compliance. Data is collected in the field and must be entered into the system.

Financial Closure After the promotion ends, actual shipments and costs are recorded, invoices are issued. If the client pays less than expected, the system must detect it and initiate a dispute.

Analysis Comparison of plan vs. actual by SKU, mechanic, retail chain, and manager. This becomes the basis for planning the next cycle.

Where Excel Breaks Down

At every stage described above, data is generated. The issue is not Excel itself — the problem is that this data is scattered:

1. Effectiveness calculations — in spreadsheets, often with different versions across departments
2. Contract terms — in ERP systems or paper documents
3. Shipment data — in accounting systems
4. Agreements with retailers — in emails or messengers
5. Field reports — in mobile apps or sent manually

If even one element falls out of the picture, the entire promo analytics breaks. Miss two or three elements — and the company can no longer answer a basic question: how much did we actually earn from this campaign?

Another challenge is scale. When the assortment matrix includes 400–800 SKUs and the number of retail outlets reaches hundreds, consolidating monthly reports turns into a separate project lasting 2–4 weeks.

SalesUp FMCG Management: Product Concept

SalesUp FMCG Management is a specialized product for Creatio CRM that automates the full trade marketing cycle — from initial planning to performance analysis.

The product was developed by Sales’Up, a certified Creatio partner, based on real FMCG manufacturer and distributor processes. It is not generic CRM functionality, but an industry-specific solution tailored to working with retail chains.

The core idea: the entire process — from planning to reporting — is handled in a single system. Managers see the full picture in real time. Owners or commercial directors see aggregated KPIs on dashboards.

Key Modules

Promotion Activities (Core Entity) The central object of the system. Each promotion is a separate record with attributes: mechanics, timelines, status, budget, responsible manager. All performance metrics are aggregated at this level.

Products in Promotion Activities The most granular planning level — each SKU within a promotion is tracked individually. Includes: regular price, discounted price, planned volume, costs, planned revenue, margin, and baseline. This enables visibility into which SKUs are profitable and which are loss-making.

Contracts and Terms The system stores individual conditions for each retail chain: price lists, budget agreements, bonus and compensation mechanics. When planning a new promotion, these terms are automatically applied — no manual copying needed.

Budgets A four-level structure: total amount, reserved funds, available balance, and transfers between budget lines. Once a promotion is approved, the budget is automatically reserved — preventing double allocation.

Retail Outlets Tracking activity not only at the chain level but also at the individual store level. This enables analytics by region, format, and geographic distribution — critical for companies with large store networks.

Shipments Registration of actual shipments linked to promotions. A promotion is considered launched only after delivery is confirmed — an automatic control checkpoint.

Planning Enables sales planning using Gantt charts, viewing all activities in a calendar format, and adjusting plans without affecting already approved items.

Analytics and Control

Management analytics in SalesUp FMCG Management is built on aggregated data across all system levels:

1. Total number of active promotions and their statuses
2. Plan vs. actual by manager, chain, product, and region
3. Deviations between planned and actual margin
4. Budget utilization as of the current date

Dashboards allow commercial directors or owners to instantly see: how much the company earned this month, where deviations exist, and which chain or product is underperforming — in real time, not weeks later.

Related Products in the Package

SalesUp FMCG Management includes or integrates with other Sales’Up products on the Creatio Marketplace:

1. Gantt and Kanban views for promotion activities, contracts, and budgets — SalesUp Data Views
2. Data synchronization, enrichment, and deduplication — SalesUp Data Management
3. Flexible approval workflows for activities, budgets, and fund transfers — SalesUp Approval
4. Calculation of individual price lists and promotion mechanics — Calculator

Conclusion

Promotion management in FMCG is not a typical CRM task. It is a financial mechanism that directly impacts company margins. If this mechanism relies on fragmented spreadsheets, risks remain invisible until losses are already realized.

SalesUp FMCG Management moves the entire process into Creatio — with flexible configuration tailored to each company’s specifics: promotion mechanics, budget structures, contract terms, and performance calculation formulas.