Retail and consumer goodsBI, AI and ML for the business
Promotions measured with stock in view
A promotion that does not sell looks like a bad promotion, until you look at the shelf. In Muvia discount, sales and stock sit in the same analysis: you see what each point of discount brings and which promotions failed only because the goods ran out.
Illustrative scenario: it describes a typical case, not a customer project.
A promotion with empty shelves looks like a bad promotion.
When a campaign ends, marketing looks at the category's sales and decides whether the promotion worked. Every so often the number disappoints: 35% off, sales barely moving. The conclusion seems obvious, and that discount is never run again.
Often the reason is a different one: the shelf was empty. But stock levels live in a different system from sales, and nobody puts them side by side. So one week of stock-outs drags down the average and hides what the discount really brings.
- Who it's for
- Marketing and trade marketing, category managers, supply chain and store managers.
In Muvia, step by step
Real product screens, recorded on a project with sample data.
The video · A promotion that does not sell looks like a bad promotion, until you look at the shelf. In Muvia discount, sales and stock sit in the same analysis: you see what each point of discount brings and which promotions failed only because the goods ran out.
What you get
- The discount that pays
- You see up to which discount sales grow and from where on the discount gives away margin without bringing units.
- Promotions judged for what they are
- A promotion that failed for lack of stock is no longer mistaken for a bad promotion.
- Marketing and warehouse on the same data
- Discount, sales and stock sit in the same analysis, with the notes of whoever has already read it.
- Next time, stock first
- The alarm on stock during promotions arrives while the promotion is running, not at the post-mortem.
For the technical team
How it is built in Muvia
- 1
Connect sales, promotions and stock
Till files are appended to the same table, the promotion calendar comes from Excel, stock levels are copied every night from the warehouse system. A query sets out, per store, category and day, the discount running, sales against normal and stock on hand.
- 2
Discount against sales in Analysis
The XY chart puts discount on the horizontal axis and sales uplift on the vertical one: the curve rises up to a certain discount, then flattens. The points off the curve jump out.
- 3
Find the odd weeks
The week-by-week distribution and the trend over time show where a promotion did not deliver; a condition on stock isolates the days with an empty shelf, and a note stays on the analysis for whoever opens it next.
- 4
Measure the real relationship
The correlation view measures how discount and sales move together. Take out the weeks with no stock and you see what the promotion brings when the goods are there.
- 5
Warn before the next one
An alarm on stock for the categories on promotion opens an episode when goods drop below the threshold: in the register, whoever picks it up notes what they did.
- The data it needs
- Daily sales by store and category, from the till files
- Promotion calendar with category, discount and dates, from an Excel file
- End-of-day stock by store and category, from the warehouse system on SQL Server
- Parts of Muvia used
More cases in this line
All use cases- Every store's sales on one pageTill sales, orders and store master data sit in different systems, and the picture of the network arrives after month end. In Muvia revenue, growth, units and customers for every store sit in one dashboard, week by week, from the grand total down to a single department.
- Bought together: market basket analysisReceipts show which products are bought together, but they stay in the till system. In Muvia a Python function computes the support, confidence and lift of every pair each night, and the dashboard says what to do with them: bundled promotions, neighbours on the shelf, suggestions at the till.
- Price elasticity and the price-list proposalA price rise can cost a third of the units or almost nothing, and you find out after the fact. In Muvia a model your team writes estimates every item's elasticity each week and prepares the price-list proposal: what to raise, what to cut and how much margin it brings.
Bring us a question you can't answer today.
We start from a real question your business has and walk the path from source to dashboard with your systems, not a demo dataset.