Merchandising, CPG KPIs & Reporting

Retail Audit Checklist: 37 Advanced Metrics to Track at the Shelf

For CPG companies selling at retail, retail audits are an important part of maintaining a strong shelf presence. This checklist covers 37 different metrics that you're reps should be measuring every time they conduct an audit to ensure you have the most accurate and valuable data available. 

 

Demographic

Demographic info to measure

  1. Name of outlet and other location information like address, zipcode, etc.
  2. Type of neighborhood: urban, suburban, or rural?
  3. Sales territory: which territory is the client under?
  4. Type of outlet: convenience, gas, pharmacy, grocery, etc.
  5. Economic group: upper, middle, working class?
  6. General condition of store during visit: in store traffic, number of onsite employees, etc.

What to look for

You should know as much about the retail outlet as possible so you can cross-reference and find correlations when doing your market analysis. These key pieces of demographic data should be associated with every Audit Report that is completed in the field. Ideally, this data exists within your CRM and can be automatically connected to the reports filled in by your rep. 

 

 

 

Product Condition

Product info to measure

  1. Photos of on shelf: before and after merchandising activities
  2. Backstock level: what is the stock level in storage?
  3. Adjacent products: who are your neighbors?
  4. Shelf tag presence: any shelf tags missing?
  5. Product damage: record any damage to products
  6. Stock level on shelf: highlight out-of-stock situations
  7. Planogram compliance: slotting, shelf, and facings?
  8. Retail price: how much is the product retailing for?
  9. Location of product: which locations can the product be found?
  10. Consumer feedback: consumer feedback on products

What to look for

Product condition includes everything from stock levels to position on the shelf to planogram compliance and locations in the store. This data can help you identify particular outlets or chains where store personnel need coaching regarding how your product should be displayed, and can aid in identifying correlations between product velocity and positioning.

 

Trade Promotion Compliance

Compliance info to measure

  1. Photos: document compliance issues with photos
  2. Promoted price: what is the promoted price?
  3. Product locations: are products in agreed locations in the store?
  4. Fully stocked displays: are displays fully stocked?
  5. Product promotions: is the product being promoted?
  6. Promotional materials: are agreed upon promotional materials displayed? (i.e. posters, shelf talkers, stickers)
  7. Promotion references: is the promotion referenced in the circular?
  8. Feedback on promo: any consumer feedback on promotions 

What to look for

CPG companies spend a huge portion of their marketing budget on trade promotion, and the effectiveness of those promotions is directly impacted by how well they are executed in the store. If you are giving retailers a substantial trade allowance, you deserve to have the agreed actions taken and supported in the store. Your merchandising reps should confirm compliance in stores, and rectify any deficiencies they find. A good Merchandising Software solution will allow you to create audit forms that match the in store promotion agreements and allow you to make those audits available to reps when they visit outlets with an active promotion.

 

Competition

Competitive info to use

  1. Photos: document competitive activity with photos
  2. SKUs on sale: which SKUs of the competitor are sold in the outlet?
  3. Promotions: are the products on promotion? Type of promotion?
  4. New SKUs: any new SKUs from competitor? Details?
  5. List of brands: which competitors are carried in the outlet?
  6. Pricing: what is the price?
  7. Stock level: what is the stock level of your competitor’s product compared to yours?
  8. Feedback on competitor: any consumer feedback on your competitors’ items?

What to look for

Having merchandising reps in the field is a great way to see first hand how well your competition is executing. The data that you collect about competitors should combine structured data that you can analyze and report on, as well as unstructured data that allows reps to report things that you are not yet aware of. 

 

Rep Process and Efficiency

Team efficiency info to measure

  1. Time of arrival: what time did the rep arrive at the store?
  2. Interaction with customers: record any interactions with customers
  3. Time of departure: what time did the rep leave the store?
  4. Interaction with store manager: record any interactions with the store manager
  5. Completion of on site forms -- what forms and activities did the rep complete in the store? (Audits, surveys, etc.)

What to look for

Running a field team of merchandisers is an expensive proposition, and managing remote workers is by its very nature a difficult task. Being able to coach reps remotely, hold them accountable, and make them as efficient as possible is critical to ensuring the success of retail field operations. The Retail Audit itself can be instrumental in all of these areas if it is constructed and executed well.

Melissa Sonntag

Melissa is a recent graduate of Northeastern University and a content marketing specialist at Repsly, Inc. She is committed to applying her skills in order to bring value to Repsly readers and customers. Outside of work, Melissa enjoys practicing yoga, making music, and anything dog-related.

Add to the conversation below

Comments

Latest Posts

7 Min Read

4 Ways to Elevate In-Store Promotions

Ben Weiner

In today’s world of retail, CPG companies spend on average up to nearly one-third of its revenue on trade promotions, and for good reason – it’s an easy and great differentiator to set themselves..

2 Min Read

Territory Management

How to Increase Chain Penetration with Data

Ben Weiner

Mastering the retail channel is a massive opportunity for CPG brands, but those who have played in the space before know it takes a committed investment to reap the benefits. To make the most of..

4 Min Read

Repsly News

Repsly Celebrates 10 Years of Empowering CPG Teams

Ben Weiner

Repsly is proud to celebrate our 10th year in business providing retail execution to thousands of brands that record more than 5 million activities per month.