Phy-gital Roundtable: Breakfast Roundup from Germany and Netherlands

02 May '15 | Debjyoti Paul

German Shoppers: Meet Them in the Fast Lane to Phy-gital

15 January '15 | Ralf Reich

Shoppers Will Share Personal Information (But They Don’t Want to be “Friends”)

15 January '15 | Anil Venkat

Modernize or Perish: Property and Casualty Insurers and IT Solutions

14 January '15 | Manesh Rajendran

Benelux Reaches the Phy-gital Tipping Point: Omnichannel Readiness is Crucial

13 January '15 | Anil Gandharve

The New Omnichannel Dynamic: Finding Core Principles Across Industries

13 January '15 | Debjyoti Paul

Technology does not disrupt business – CIO day 2014 Roundup

02 December '14 | Anshuman Singh

Apple Pay – The Best Is Yet To Come

02 December '14 | Indy Sawhney

Digital transformation is a business transformation enabled by technology

01 December '14 | Amit Varma

3 Stages of FATCA Testing and Quality Assurance

06 October '14 | Raman Suprajarama

3 Reasons why Apple Pay could dominate the payments space

18 September '14 | Gaurav Johri

Beacon of Hope: Serving Growth and Customer Satisfaction

05 August '14 | Debjyoti Paul

The Dos and Don’ts of Emerging Technologies Like iBeacon

30 July '14 | Debjyoti Paul

What You Sold Us On – eCommerce Award Finalist Selections

17 July '14 | Anshuman Singh

3 Steps to Getting Started with Microsoft Azure Cloud Services

04 June '14 | Koushik Ramani

8 Steps to Building a Successful Self Service Portal

03 June '14 | Giridhar LV

Innovation outsourced – a myth or a mirage or a truth staring at us?

13 January '14 | Ramesh Hosahalli

What does a mobile user want?

03 January '14 | Gopikrishna Aravindan

Five Tips for Evaluating Trade Spend ROI

Posted on: 24 September '15
Janet Dorenkott
AVP and Co-Founder Relational Solutions, A Mindtree Company

For consumer packaged goods (CPG) companies, it’s no secret that managing trade spend is a number one priority when it comes to controlling costs. In fact, given that trade spend for most CPGs is somewhere between 20 to 25 percent of annual gross company revenue, you could say that ensuring those dollars are well spent could be priorities one, two and three. Even small improvements in trade spend performance will have a significant impact on earnings.

But so many CPGs are still in the dark when it comes to evaluating the ROI of their trade promotions. Without sufficient analytical tools many companies still rely on a combination of Excel spreadsheets, gut feelings and generalized expectations to plan their trade spend.

Bandwidth is so limited that most companies only have ROI insight to less than 10% of promotions. Our TradeSmart solution fixes that. There are several areas that CPGs need to pay close attention to when evaluating trade spend ROI. Here are five tips that can help get you closer to true ROI:

1 – Look at more than consumption data when evaluating trade spend ROI

There are a lot of variables that go into calculating trade spend ROI. Consumption is one, but not the only one. For example, if you forward ship for a promotion, how do you measure internal ROI using only consumption data? Bottom line is, you can’t. Also, what happens when consumption doesn’t meet the original planned volume timeframe? For this to be accurate, we must also include shipments.

2 – Avoid restating history

It’s common to move incremental consumption that’s not associated with a promotion into a time frame that has a promotion. The assumption is that anytime there is lift, it has to be due to a promotion. This is overriding the facts. You may need to increase or decrease the promotional time period because of early or late shipments. You may see a post-promotion halo effect. But, you should never shift revenue from one day to another.

3 – Be sure to align tactics with actual retail events

Actual retail events often include multiple promotional tactics all running at the same time. A single retail promotional event may have a display, an in-store coupon and a circular. Typically, planning systems treat them as individual events that are assigned specific budget allocations. However, the retail event is all three tactics combined. To capture true ROI at retail, you need to roll up the tactics so that you can see how all three performed together as a single event.

4 – Watch out for misrepresenting EDLP base and incremental volume

EDLP is an ambiguous term. We’ve had several companies ask, “How do you calculate EDLP base and incremental volume for EDLP?” – as if there is some magical answer. Some solutions will ignore EDLP altogether because they view it as the standard price if it’s in effect for longer than 15 to 20 weeks. The only true way to calculate EDLP base and incremental volume is to go back in history to where EDLP was not in effect, and compare it to EDLP trends. Otherwise, you will need to take a moving average, and use a tool that lets you input adjustments.

5 – Take a disciplined approach to data integration

CPG manufactures find themselves in spreadsheet hell when trying to gather, collate and analyze all the data points required to understand trade spend ROI. This is a complex, resource-intensive and highly manual process prone to human error and inconsistencies. As a result, there are not enough human resources or time to calculate ROI and lift for all promoted product groups, at all retail accounts. Most companies only manage to cover 10% to 25% of all trade spend events. In addition, you can be certain that such a manual process will be riddled with various versions and interpretations of event-level calculations. This process needs to be automated with consistent, agreed-upon business rules and KPI calculations.

Bottom line: Measuring trade spend ROI for both the retailer as well as the CPG company, is not to be taken lightly. The pitfalls and complexities that prevent an accurate picture of trade spend performance are everywhere. But with Mindtree and Relational Solutions now banded together, we have this problem surrounded. If you feel your company is falling short on any of the five tips above, write to us at and let us show you how we’ve raised the bar for our CPG clients.

Janet Dorenkott

Janet Dorenkott Relational co-founded Solutions in January of 1996. Since then, the company has participated in the implementation of over 100 data integration and business intelligence solutions for their customers. Janet is responsible for all of the sales and marketing efforts of Relational Solutions. Prior to founding RSI, Janet worked for the business intelligence group of Sybase and was responsible for business development at Network General.