Articles

5 Steps to Calculate Promotion ROI

A true Return-on-Investment (ROI) calculation is the holy grail of promotion key performance indicators (KPIs), but CPG companies struggle to understand both the forecasted ROI when planning a promotion and the actual ROI for promotions that have run. So, how do you create the proper processes to calculate ROI?

To be successful, it’s important to understand one fundamental requirement: Forecasted and actual base volume. Why? Because the “return” in ROI are the “extra” sales (incremental) you attribute to the promotion tactics that are used: reduced prices, displays, advertising. To calculate incremental, you need to establish what sales are when promotion offers are not present.

Read on to understand the information you will need to calculate the ROI of a promotion, and how to do it.

Step #1 – Determine ‘Base’ Volume.  The first decision point here is the type of volume you are using in the ROI calculation: shipments or retail sales (AKA POS, consumption). We recommend using retail sales as the volume basis so that the KPI reflects the effectiveness of the promotion offers to the shopper. If that is not possible, use shipments in your ROI calculation.

The goal in defining base volume is to establish how many units will be sold at their everyday price with no display or advertising. There are multiple methods for establishing base volume:

  • Store count * average weekly velocity. May include other factors like seasonality.
  • Prior year base sales. When retail sales are used and the source of the data is a syndicated service, this metric is usually available.
  • Predicted base volume. Vendors like UpClear have data science services that will provide a statistically modeled base volume.

Step #2 – Determine the two ends of a promotion. There are different dimensions to this. The first dimension is volume. As previously stated, you need to define the type of volume you’re using for promotion measurement and window of promotion. E.g. If this is retail sales, it is the start and end date of the promotional offers to the shopper. The second dimension is spending. The “investment” input to the ROI calculation needs to include all spending that supports the promotion. If this is a scan allowance, you must calculate the spending during the dates of the shopper offer. If the spending is a billback or OI, you must consider the spending that occurred during the shipment window of the promotion.

Step #3- Calculate “Return.” Return is the gross margin earned by the “extra” or incremental sales. To calculate this, you subtract base volume from total to identify incremental sales. You then, 1) calculate Incremental Gross Revenue by multiplying incremental sales by the list price of the product, and 2) calculate Incremental Cost of Goods Sold (COGS) by multiplying incremental sales by the COGS factor for the product(s). Return is calculated by subtracting Incremental COGS from Incremental Gross Revenue.

Step #4- Calculate “Investment.” Investment is spending required to generate the Return. For this calculate the total variable allowances (scans, OIs, billbacks) and fixed fees. Decide if you want to include EDLP in the investment. Determine if you want to include all EDLP or just incremental EDLP. Make sure you do this across customers.

Step #5- Calculate ROI. Divide the Return by the Investment.

How UpClear Can Help

Software like BluePlanner TPM by UpClear automates the management of the data, calculation of KPIs, and creation of reporting that enables you to understand the performance of promotions.

To see more on calculating ROI on promotions, see How to Calculate Promotional ROI – Start With 5 Key Building Blocks.

About UpClear 

UpClear makes software used by Consumer Goods brands to improve the management of sales & trade spending. Its BluePlanner platform is an integrated solution supporting Trade Promotion Management, Trade Promotion Optimization, Integrated Business Planning, and Revenue Growth Management.    

Schedule a Demo

More Resources

iHealth is Live on BluePlanner TPM 

iHealth, maker of Culturelle, AZO, Estroven, and other health and wellness brands, has ...

Nichols Plc. Picks UpClear for Trade Promotion Management  

Nichols Plc, maker of Vimto brand beverages in the United Kingdom, has chosen UpClear B...

Musco Family Olive Company Picks BluePlanner TPM

Musco Family Olive Company is an 80-year-old third generation family-owned company that...

UpClear Logo
UpClear © 2024
Privacy Policy