Logo - Keyrus
  • Playbook
  • Services
    Data advisory & consulting
    Data & analytics solutions
    Artificial Intelligence (AI)
    Enterprise Performance Management (EPM)
    Digital & multi-experience
  • Insights
  • Partners
  • Careers
  • About us
    What sets us apart
    Company purpose
    Innovation & Technologies
    Committed Keyrus
    Regulatory compliance
    Investors
    Management team
    Brands
    Locations
  • Contact UsJoin us

Make Data-Driven Decisions for Retail Promotion Strategies

Background

Several distribution companies in the grocery, durable goods, and cosmetic sectors want to understand which of their products are the most profitable, or which yield the highest returns versus their cost-of-goods and promotional investments. This granular view of dead net profit is an important data point that their pricing teams want to use to negotiate better deal-levels with their manufacturers and vendors.

Challenge

If companies sell hundreds or thousands of SKUs a month, and spend millions of dollars on procurement, promotions, discounts, marketing campaigns, and operational costs, it becomes difficult to pinpoint which products yield the highest net profits at the most granular levels in their data: Item, Location, and Point-in-Time. While sales data is transactional and typically available at these most granular levels, the cost-of-goods sold, lump sum funding, coupons, and other item promotional deals are typically struck at different levels in the product, geography, and time hierarchies. Costs often have convoluted freight, pallet, and distribution components. Lump sum funding can be given as a bulk amount, perhaps on a quarterly cycle, and be applied to promoting entire product categories from a given manufacturer. Item level discounts, coupons, and other promotions can be for specific SKUs only and last only a handful of days at a time. How can an organization allocate a specific amount of investment or promotion to a given SKU, for specific regions, in a given time period? Typically, the allocation of promotional funding is done as a percent of business share at the item or vendor level over regions and periods of time. Freight and pallet costs can be similarly allocated by fill percentage. When data volumes reach billions of rows, efficient pipelines and processing are crucial to providing allocated results to the pricing and procurement teams for the slices and selections in the data that they’re interested in. Once costs and promotions are aligned with granular sales data, net profit analysis can help procurement teams better understand the source of their margins.

Approach

Implemented a fully automated data extraction and processing system to collate all sales, costs, and promotional funding data from different tables and systems at a large grocery distributor. The pipelines processed large data volumes and calculated the dead net profit of thousands of SKUs across hundreds of retail stores. The results were displayed using custom-built frontline applications. Dead net profit could be analyzed by any relevant dimension such as SKU, category, and vendor.

Key results

01
Fully-automated data extraction and processing system
02
Easy-to-generate dead net profit reports so that analysts could make data-driven decisions
03
Custom-built analytic applications

Benefits

With new analytic applications integrated into their daily work streams, pricing and procurement analysts could make data-driven decisions for promotion strategies using the dead net profit reports. For example, category managers saw that the top five vendors in a specific category were yielding negative profits. They pressed for more promotional funding and more favorable splits on discount levels in the next purchasing cycle. Procurement can now use the quantifiable impact of activities on profit margins as leverage in price and promotion negotiations.

Technology partners

Alteryx

Alteryx automates analytics, data science, and processes in one unified platform to accelerate digital transformation. Organizations rely on Alteryx to rapidly upskill their workforces and deliver strategic, high-impact, business outcomes.

120+

certified consultants

8+

years of partnership

Share this key play

whatsapptwitter
linkedinfacebookworkplace

More key plays

Boost sales with targeted marketing campaigns and multi-channel communication
Gain new insights to optimize logistic processes and reduce costs by leveraging advanced analytics
Increase conversion rates for online customers
Optimize airplane cargo loading and improve shipment efficiency by leveraging advanced analytics
Using Alteryx to automate processes at an international bank
Create a Pan-European customer view to improve sales efficiency and increase profit margins
Improve customer retention strategy and business margins by leveraging customer profitability insights
Eliminate manual work for finance experts by automating Excel reports with Tableau
Connecting upstream planning processes for a life sciences company
Connected commercial planning using Anaplan: Gross-to-Net (GTN)
Logo - Keyrus
Shanghai

Unit 2306 Qiangsheng Building No. 145 PuJian Road Pudong District Shanghai China P.C. 200127

Phone:+86 158 2182 0209+86 (0)21 6886 0352

Fax:+86 (0)21 6886 0356