7 Must-Have Shopper Marketing Reports (Part 2)

7 Must Have Shopper Marketing Reports Part 2.png

Last week, we shared with you the top reports for Finance, Brands and Sales, the most important internal constituents shopper marketers deal with on a regular basis. These reports help establish transparency and trust and will elevate your team’s reputation as a collaborative, strategic partner.

Today, let’s shift our focus to internal managerial reporting. The following reports, if properly setup and automated, will make you a smarter people-manager, a savvier marketer and will help you run your business smoothly.

 

4. Marketing Mix Reports

Knowing the building blocks of your marketing plan is essential for establishing budget accountability and strategic alignment of your team. Setting up-front expectations for the team — what types of marketing tactics they should be focusing on and tracking whether they comply with the guidelines — will help you avoid unpleasant surprises in the end of the year. Be transparent if you want your team to lean into mobile tactics, or if you want them to reduce reliance on coupon discounting. Here are the questions you should be able to quickly answer:

  • Are you investing enough in equity-building initiatives?
  • Are you discounting too much or not enough? What is the portion of coupon redemption in overall budget?
  • Is your digital marketing spend pacing along with the industry?
  • Do you have any gaps along the path-to-purchase where you should increase your presence?
  • What is the ratio of working vs. non-working dollars in your budget?
  • Is your marketing mix consistent across channels and retail accounts?

Data Considerations:

  • Align with your team and agency on naming conventions and codify tactics’ names to help all team members plan consistently.
  • Granularity is good. Capture detailed tactic definitions (There is a difference, for instance, between Catalina pay-for-performance program, targeted and basket-triggered offers, so simply saying “Catalina Offer” may not be enough) to help your teams decypher their own plans.
  • Clearly define and label coupon and working media spend to track them separately.
  • Map tactics, their spend and impressions against the path-to-purchase stages to help evaluate your brand’s presence in shopper’s journey.

 

5. Vendor Reports

Shopper marketing teams manage many existing suppliers, and they’re constantly discovering and are tempted to try new, emerging capabilities. Being able to clearly articulate who you spend money with, why certain vendors deserve to be on your short list, and what test and learn projects you should participate in is an important skill for a shopper marketing leader. To manage vendors effectively, you have to have a deliberate, consistent approach to gathering vendor info and evaluating their capabilities. Here are the questions a solid vendor management process will help answer:

  • What are the best  performing vendor capabilities your team should be relying on more heavily?
  • With which vendors do you spend most of your budgets?
  • With whom should you negotiate better rates?
  • What are the emerging tactics and capabilities you need to experiment with?
  • Do you pay a lot of expedite fees due to frequently missed deadlines?
  • Which vendors and tactics can be part of the “war chest”, i.e. implemented on a short notice, to stave off competitors.

Data Considerations:

  • Catalogue vendors’ capabilities in a centralized place where team members can add and update them, Wikipedia-style.
  • Capture the KPIs new tactics will be judged on. This will help track their performance and compare to existing alternatives. 

 

6. Program Performance Reports

Post-promotional analytics are the holy grail of shopper marketing and the most elusive and challenging aspect of our jobs. Not every shopper marketing team is able to do it well, but the key to getting shopper marketing analytics right is to collect as much data as you can. Start small and gradually adjust the analytics approach as you learn what KPIs work best for your industry and your team. Ask yourself:

  • What are the three most important KPIs that will help you differentiate successful programs?
  • What were your top performing programs last year, quarter, month, by customer? What drove their success?
  • What were your least successful programs? What went wrong?
  • Were you able to secure incremental merchandising for your promotions?
  • Did you generate enough sales to cover Shopper and Trade investment and return a positive ROI?

Data Considerations:

  • Be careful not to work on too many KPIs, or you run the risk of overwhelming the team.
  • Differentiate between fundamental metrics, such as impressions, sales lift, or profitability, that will apply to all programs vs. deep-dive metrics that will apply to only some, depending on program objectives.
  • Capture program-specific objectives up-front to reduce temptation to ‘spin’ the results.
  • Consider retail compliance as one of indicators of program performance, especially if your team leveraged shopper marketing support to sell-in programs in retail. While you can’t claim full credit for incremental sales due to solid feature and display support, flagging those events that had a robust shopper marketing component and analyzing their profitability holistically may prove eye-opening to your sales and shopper marketing teams.
  • To simplify on-going program analytics, find ways to dynamically overlay sales data, trade and shopper marketing investments, by program. This may require your team to step into other domains and systems, which is a long-term and complex endeavour, so find allies and team members who learn quickly and are tenacious enough to see things through.

 

7. Tactical Performance Report

Even the most brilliant strategic program can fail due to poor tactical execution. Sun Tsu, in The Art of War, says, “Strategy without tactics is the slowest route to victory, tactics without strategy is the noise before defeat.” And in Shopper Marketing you don’t have the luxury of a slow route to victory — you must be agile and prove your performance effectiveness at every step.

Knowing the ‘nuts and bolts’ of how your shopper marketing tactics perform in the context of your retail accounts and how they layer up to your over-arching shopper marketing strategy will give you and your team enormous insight.  Tactic-level performance insights will inform your marketing experiments and proactively optimize future spend. Build reports to help your team quickly understand:

  • Do our shopper tactics properly support or strategies? For instance, you would not want to invest in Kroger LCMs if your brand objective is to drive awareness and trial.
  • For a given tactic, what results have you achieved in the past? How can those results predict their future performance?
  • What shopper tactics tend to perform better at specific accounts?
  • What tactics deliver best CPI (cost per impression)?
  • Were there any suspiciously high coupon redemptions, a sign of potential fraud?
  • How did similar offers perform in the past? Can you predict redemption liability more accurately?

Data Considerations:

  • Together with the team and vendors, define each tactic KPIs and benchmarks in advance to set the expectations in order to quickly see whether the results met them.
  • Require vendors to submit program results in raw, pivot-ready format, instead of, or in addition to, traditional PowerPoints or PDFs. This will simplify tactic-level analytics down the road.
  • Streamline coupon redemption reporting and reconciliation by understanding your clearinghouse reporting interface, definitions and data structure.
  • Focus on the outliers to learn from the biggest mistakes and replicate the biggest successes.

 

Establish a Data System for Reporting Efficiencies

How many of these reports do you have ready at your fingertips today? How much time does it take for your team to pull and generate these reports? If you answer is more than 2 hours per month, you should re-think your shopper marketing data strategy.

Data collection strategy and sharing templatization is a must to unlock efficiencies. The solution to this problem is in establishing a data system, or a depository, where truth can reside and facts can be “summoned” and easily pivoted to answer most business questions. And that really is the key. Your data system must have robust and flexible reporting capabilities that will allow you to stop wasting time on manual reporting and instead take full advantage of the strategic thinking you and your shopper marketing team are capable of.

 

Introducing Easy Shopper Marketing Report Templates

OlgaYurovski

OlgaYurovski

After more than 15 years in Consumer Packaged Goods industry, I became a software entrepreneur. Today, I design and sell Shopperations, a web-based, collaborative planning software for Marketers on both CPG and Retail sides, to enable transparency, accountability and stronger Shopper Marketing promotional analytics. I am passionate about all things Retail and Shopper Marketing, love reading about Neuroscience progress as it relates to shopper research, and care about process improvement and marketing automation technology.
Become A Shopper Marketing Expert
Shopper Marketer Who Revolutionized Shopper Marketing