You are leaving our main website to go to our chinese website hosted in China. For legal reasons there will not be any links pointing back to the main website.

Go to chinese website
Logo - Keyrus
Logo - Keyrus
  • Playbook
  • Services
  • Insights
  • Partners
  • Careers
  • About us
    Company purpose
    Innovation & Technologies
    Committed Keyrus
    Regulatory compliance
    Investors
    Management team
    Brands
    Locations

Blog post

Make data-driven decisions for retail promotion strategies

By Razvan Nistor

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

These companies engaged with Keyrus to implement the business logic and analytical systems that are capable of processing and aligning transactional sales data with costs and promotional funding.

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.

Solution

Keyrus 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 were able to process large data volumes and calculate 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.

Results

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.

whatsapptwitter
linkedinfacebookworkplace
newsletter.svg

Never miss an insight

Stay updated on the latest articles, events, and more

Your email address is only used to send you the Keyrus newsletter and for commercial prospecting purposes. You can use the link in our emails to opt-out at any time. Learn more about the management of your data and your rights.

Continue reading

Press release

Keyrus named amongst Top B2B Companies on Clutch

December 12, 2022

The Keyrus team is excited to announce that we’ve been named one of the top 1000 companies on Clutch’s platform in 2022! This is the second year that Keyrus has been recognized by Clutch as a top company and B2B leader. 

Webinar

PDF Parsing with Alteryx Intelligence Suite

December 1, 2022

In 20 minutes, we’ll teach you how to use Alteryx Intelligence Suite to eliminate common problems and inefficiencies in accessing data from .pdf files. In the past, you’d need to run custom Python and complex parsing logic to get any usable data from a pdf. Now, you can parse PDFs with out-of-the-box features in Alteryx Intelligence Suite.

Webinar

Modern Cloud Analytics in Action: Keyrus and Red Ventures

November 11, 2022

The cloud offers new opportunities to save you time and money, allowing you to shift focus from maintaining growing servers and upgrading infrastructure to making your data work for you and the success of your business. Watch the webinar and Q&A to learn how AWS, Tableau, and Keyrus worked together to help Red Ventures migrate to a powerful cloud BI tool that created new pathways for success and a modern data culture.

Event

Pharma/Biotech GTN Summit 2022

October 27, 2022

Keyrus & Anaplan Sponsor Life Science Gross-to-Net (GTN) Summit

Press release

Keyrus Achieves AWS Data and Analytics Competency Status

October 6, 2022

Keyrus achieved Amazon Web Services (AWS) Data and Analytics Competency. To receive the designation, AWS Partners must possess deep AWS expertise and deliver solutions seamlessly on AWS.

Webinar

Live Webinar: Lessons on workforce capacity planning and optimization from Optum (UnitedHealthcare)

October 19, 2022

Wednesday, November 9th, 2022 @ 12:00PM Central Time (US and Canada)

Webinar

Tableau Embedded Analytics: Optimizing insights from Salesforce data

September 20, 2022

Want to optimize your visual analytics in Salesforce? You need the right tools. Tableau Embedded Analytics can be used to help you build and visualize reports in Salesforce.

Success story

How C&S Wholesale Grocers maximized ROI with an analytics center of excellence

September 7, 2022

C&S Wholesale Grocers worked with Keyrus and Alteryx to implement an analytics center of excellence to help them efficiently and effectively achieve business objectives, maximize return on investment (ROI), and standardize best practices.

Success story

Implementing a cloud security automation tool at a global consulting firm

September 2, 2022

Keyrus partnered with a consulting firm to build an in-house cloud security solution that would automate their verification processes and keep their information safe.

Success story

Leveraging Salesforce to improve operations at Pajama Program

July 25, 2022

Keyrus partnered with Pajama Program, a nonprofit organization, to review their Salesforce architecture and improve overall operations.

Logo - Keyrus
New York City

252 West 37th st., Suite 1400 New York, NY 10018

Phone:+1 646 664 4872

LinkedInInstagram
PlaybookServicesInsightsPartnersCareersAbout us
Company purposeInnovation & TechnologiesCommitted KeyrusRegulatory complianceInvestorsManagement teamBrandsLocations
Legal notice & Terms of use
Privacy policy
Data protection