We Bring You Expert Insights and Industry Data, Monthly.

Click Here For Current Issue!


Here’s how to harmonize marketing data and go from siloed to connected, thus saving time and producing better profits.

CPG commerce marketing is awash in data about finance, shipments, POS sales, media performance, shopper card info… the list goes on. The abundance of data points are siloed, overwhelming commerce marketers who spend up to half their time manually collecting, processing and disseminating reports.

In our conversations with both CPG C-suite executives and marketers in the trenches, the issue of disconnected and unstructured data comes up time and again. They believe that data harmonization must become a top priority to empower our industry with insights and enable agility. Marketers must own this problem and lead the charge to address it.

Old ways of planning and reporting in Excel and communicating via email and PowerPoint must be replaced with modern collaborative technology that supports and automates the commerce marketing process. That process must standardize the nomenclature and adopt a commonsystem of record with its own data model that integrates with other data sources, unleashing them and letting them flow.

Creating a system of record is a multi-step process that must be led by marketing alongside its IT partners. It requires a thorough analysis of your current data ecosystem, quantifying the data gaps and process pain points. The next steps involve documenting existing and future process changes, gathering requirements and seeking technology solutions.

The chart within this story presents some of the basics involved in data harmonization. Creating your own charts outlining the processes will be a godsend to your IT liaisons and an eye-opening insight for top management that may not have been in the commerce marketing trenches for awhile.

Keep in mind that your system must include an omni-channel vision, with your sales and marketing teams on board. Your team must also have a

clear understanding of proper investments and returns, based on individual retailers’ capabilities. Candid conversations with retailers on spending must take place. Unfortunately, media performance is not standardized, and not easily connected to financial or sales data. (And there’s increasing pressure to measure marketing results.)

All your pre-work will help you decide what your commerce system of record must do to fill the gaps and automate non-value-added work, which takes a huge amount of time. At this point, it’s important to involve future users of the system to define key functional requirements.

Apart from tracking spend by activity and brand, your system could include other important features such as calendaring, project management, file storage and collaboration features such as smart notifications. Now it’s time to research available technology systems, or learn about building a customized system. You’ll find the time spent in creating a data harmonization system will pay you — and your company — big dividends. n

Liz Mayer (lmayer@tpg-mail.com) is a partner in Omnichannel Commerce at The Partnering Group, Cincinnati. Olga Yurovski (olga@shopperations.com) is CEO of Shopperations, Loveland, Ohio. Both are


r CPG marketing executives. They offer half-day data harmonization workshops (info.shopperations.com/data-harmonization-workshop) for CPG commerce clients. This story is based on their recent webinar; a recording is available at this link: https://register.gotowebinar.com/register/1221876696522777357

FR Buyer Admin

FR Buyer Admin

Leave a Reply

Got News?

Let us know!

Email Warren at


On Key

Related Posts


Mississauga, Ontario-based Maple Leaf Foods reported sales up by 4.3% to $1,174.9 million (Canadian) for the first quarter ended March 31. Net loss was $57.7


Meijer, Grand Rapids, Mich., has opened two new supercenters in Warren and Wooster in Northeast Ohio. The new stores feature digital shopping solutions, including Shop

Refrigerated Mexican Entrees

MegaMex Foods, Orange, Calif., expands its Herdez (herdeztraditions.com) lineup with a pair of heat-and-eat refrigerated Mexican entrees. The newcomers include Chicken Shredded in Mild Chipotle


Blue Apron’s first quarter sales dipped 4.0% to $113.1 million compared to the year-ago period, although they were up by 5.9% when compared to the



contact us

Or reach us directly:

Paul Chapa, Co-Founder & Managing Partner
913-481-5060 or paul@frbuyer.com

Warren Thayer, Co-Founder & Managing Partner
603-252-0507 or warren@frbuyer.com