Global FMCG Manufacturer reduces monthly promotional reporting time by 60% and transforms marketing intelligence capability.
Solution overview
Industry
Fast Moving Consumer Goods (Snack Retail)
Solution
Promotional Data Science Platform
Location
South Africa
Client
A world-leading food and beverage organisation that serves more than 200 countries and territories globally.
Requirement
The client needed to transform the way they managed and measured ROMI (return on marketing investment) across hundreds of stock-keeping units (SKUs) into thousands of outlets.
The Client
A world-leading food and beverage organisation that serves more than 200 countries and territories globally.
The Requirement
The client, a fast-moving consumer goods manufacturer (FMCG) managing some of the world’s biggest brands, needed to transform the way they managed and measured ROMI (return on marketing investment) across hundreds of stock-keeping units (SKUs) into thousands of outlets.
- Before Decision Inc. assisted, data was collected in an Excel spreadsheet that required manual calculations for each product line. Data volumes continued to grow, becoming too large for Excel to manage.
- KPIs such as sales-in versus sales-out and ROMI could not be seen at the point of impact, outlet and product, and it was difficult to compare the data against Annual Business Plan.
-
Collecting data across different departments was complex because differing reporting formats and calculations were being used.
We developed an automated system that allowed for the broader range of data – ABP, sales-in, sales-out – to be leveraged at a granular level. These data sets, combined with customer-level pricing and promotions, allow for the client to identify price sensitivity among customer segments and products and build a foundation for a recommendation system.
– Leandra Webb-Ray, Data Scientist & Information Engineer at Decision Inc.
The Solution
Decision Inc. developed an innovative Promotional Data Science Platform using Alteryx and Qlik Sense to deliver a solution that consolidated the required data and delivered it in a format where the return on investment of promotions could easily be visualised and interpreted.
The solution provided the FMCG with the following:
Automation of data collection
All teams now speak the same language and upload data in the same format, saving many hours of manual collection and consolidation.
Daily tracking of promotions
Sales are integrated into the model daily, providing teams with a view of planned and actual ROI, uplifts and profit and loss (P&L) per promotion. Comparisons can also be made with the product performance of competitors
Daily optimisation of promotions
Promotions are compared against the Annual Business Plan (ABP)to see how closely they align. Interventions can quickly be made to correct promotions that are not meeting targets or delivering according to their mandate
Greater processing speeds, transparency and quicker decision making
The OUTCOME
The engagement with Decision Inc. to deliver this solution not only transformed visibility across multiple silos, sales teams, departments and data, but allowed for consistent and strategic management of promotions through a single pane of glass.
The Promotional Data Science Platform optimised promotion management and insights to align with strategic business imperatives and succeeded in transforming revenue management parameters and ensuring ROI.
We used statistical methods before in Excel, but now it all sits in one tool so we have a lot of guard rails that keep our promotions on track. We didn’t have a tracker for auditing purposes, but now we have all the metrics calculated automatically and shown in one place, and that empowers our sales teams in the development and execution of promotions.
– FMCG Project Lead
The organisation now has:
INCREASED FORECAST ACCURACY
Forecasts are now based on statistical analysis and modelling, reducing risk of human error and increasing confidence in the forecast.
INCREASED EFFICIENCY AND PROCESSING SPEED
Saving time for both Demand Planners and Customer teams (to spend more time in front of their customers).
IMPROVED DATA QUALITY
Leveraging data directly from the IT infrastructure where it is housed.
DAILY FORECASTING
For quick decision making.
INCREASED TRANSPARENCY
Reports are generated automatically and circulated to key stakeholders.
A SINGLE SOURCE OF PROMOTIONAL ANALYTICS
Revenue management, Demand Planning, Commercial Finance all receive the same analytics.
The engagement with decision inc.:
Decision Inc. was phenomenal in managing business expectations around what was feasible and what wasn’t throughout the implementation phase. We picked up data quality issues and these were quickly resolved, and they have spent time with the sales teams to show them the value and really help them get the most from the solution.
– FMCG Project Lead
About Decision Inc.
Decision Inc. is a global leader in information-driven transformation with a core focus on data, digital and performance intelligence.
Our expertise in technology and industry specialisations have enabled us to help companies around the world make better decisions faster.
Our emphasis on local excellence and global scale enables us to bring clients best of breed technology solutions that enable significant improvement whilst leveraging our Global Research and Innovation teams to accelerate the time to insight. Our local consulting teams are experts in the implementation, support, and execution of these solutions and work with our clients to deliver real results and improvement.
To find out more about our Business Intelligence offerings view here.
Recent Comments