FMCG Merchandising Reports & Dashboards: What You Should Be Tracking

What does your shelf look like right now? Not yesterday. Not last week. Right now.

If your answer involves WhatsApp photos from a field supervisor and a three-week-old Excel spreadsheet, you have a visibility problem. You are making decisions about shelf presence, stock rotation, and competitive positioning based on data that is already outdated by the time it reaches you. In a retail environment where shelves change daily, that delay is costly.

The fix is not more reports. It is better reports - delivered through dashboards that give you real-time visibility into what is happening at the shelf across your entire retail network. Dashboards, not spreadsheets. Real-time data, not monthly summaries. Here are the 10 metrics that every FMCG brand should be tracking on their merchandising dashboard.

The 10 Metrics That Matter

1. Store Visit Completion Rate

This is the foundation metric. If your merchandisers are not visiting the stores they are supposed to visit, nothing else matters. Store visit completion rate measures the percentage of planned visits that were actually completed, verified by GPS check-in at the store location. A well-run merchandising programme should maintain a visit completion rate of 90% or above. Anything below that signals attendance issues, route planning problems, or insufficient team capacity. GPS verification is essential here - without it, you are relying on self-reported data that may not reflect reality.

2. Visit Duration

How long is each merchandiser spending in each store? Visit duration tells you whether your team is actually doing the work or just checking in and leaving. Too short (under 10 minutes) suggests they are not completing all tasks. Too long (over 45 minutes) suggests inefficiency or scope creep. The ideal range depends on your task list and store format, but tracking visit duration helps you identify outliers on both ends and ensures that the time spent in-store matches the work that needs to be done.

3. Shelf Availability / Out-of-Stock (OOS) Rate

Out-of-stock is the single most expensive problem in FMCG retail. Every empty shelf slot is a lost sale - and unlike a pricing error or a poor promotion, OOS often goes undetected until it has already cost you revenue. Your dashboard should track OOS rate by SKU, by store, and by region, with the target being to keep OOS under 5%. When OOS spikes in a specific store or region, the dashboard should flag it immediately so your team can investigate and resolve the root cause - whether it is a supply chain issue, a reorder failure, or a merchandiser not rotating stock properly.

4. FEFO Compliance Score

First Expiry, First Out compliance ensures that older stock is sold before newer stock, preventing near-expiry waste and protecting your brand reputation. FEFO compliance should be measured as a score - the percentage of stores where stock rotation follows FEFO principles, verified by photo proof of shelf arrangement. This metric is especially critical for categories with shorter shelf lives, where a FEFO failure can result in expired products reaching consumers or large quantities of stock being written off.

5. Planogram Compliance Score

Your planogram represents your category strategy at the shelf. Planogram compliance measures whether the shelf actually looks like the plan - tracking SKU presence, correct position, correct number of facings, and brand block integrity. A compliance score of 80% or above is a reasonable target for most FMCG categories, though high-priority accounts may warrant higher standards. Like FEFO compliance, planogram compliance should be photo-verified, not self-reported.

6. Near-Expiry Stock Flagged

This metric tracks the number of SKUs flagged as approaching expiry within 30, 60, and 90-day windows. It serves as an early warning system for your supply chain team, allowing them to take action - whether that means accelerating sales through promotions, redistributing stock to higher-velocity stores, or arranging returns - before the product expires and becomes a write-off. Near-expiry flagging should be part of every store visit, with the data feeding directly into your supply chain planning process.

7. POSM Deployment Status

Point of Sale Materials - shelf talkers, danglers, standees, display units - are a significant investment for FMCG brands. Yet many brands have no visibility into whether their POSM is actually deployed in stores, whether it is in good condition, and whether it is placed in the correct location. Your dashboard should track POSM deployment by type, by store, and by campaign, giving you a clear picture of where your marketing materials are and where they are missing. This metric helps you measure the ROI of your POSM investment and identify stores or regions where deployment is lagging.

8. Competitive Activity

What are your competitors doing at the shelf? Are they running promotions you were not aware of? Have they taken over an end cap in a key account? Are they offering trade schemes that are pulling retailers away from your brand? Competitive activity tracking turns your merchandising team into a real-time intelligence network. Every store visit is an opportunity to capture competitive data - new product launches, pricing changes, promotional displays, shelf space changes. This intelligence, aggregated across your network, gives you a strategic advantage that no desk research can replicate. It is real-time, store-specific, and directly actionable.

9. Retailer Feedback and Issues Logged

Your merchandisers are the people closest to your retailers. They hear complaints, concerns, and suggestions that never make it into formal feedback channels. Tracking retailer feedback and issues logged gives you an early warning system for problems that could affect your distribution - delivery delays, damaged goods, pricing disputes, competitor incentives. When a retailer raises an issue during a merchandiser visit, it should be logged, categorised, and escalated through the dashboard. This turns your merchandising programme into a retention tool, not just a shelf management function. It is an early warning for churn before it happens.

10. Photo Audit Summary

Every metric listed above benefits from visual verification, but the photo audit summary is a metric in its own right. It aggregates the visual evidence from every store visit - shelf photos, POSM photos, competitive display photos, issue documentation - into a single, browsable dashboard view. One glance tells you more than a hundred data points. A photo audit summary lets you see your shelf across the country without leaving your desk, spot patterns that numbers alone might miss, and validate that the data in your other metrics matches what is actually happening in stores.

From Data to Decisions

Collecting these 10 metrics is only valuable if they drive action. The best merchandising dashboards do not just display data - they trigger decisions. Automated alerts notify you when a metric falls below threshold - when OOS spikes in a region, when visit completion drops below 90%, or when near-expiry stock exceeds acceptable levels. These alerts ensure that problems get addressed while they are still small, before they compound into revenue-affecting issues.

Weekly reviews using dashboard data allow you to identify trends, compare performance across regions, and allocate resources where they will have the most impact. Is one city consistently underperforming on planogram compliance? That might indicate a training gap. Is near-expiry stock concentrated in a specific retail chain? That might indicate a supply chain routing issue. The dashboard gives you the data; the weekly review turns it into action.

An outsourced merchandising partner should provide these dashboards as a built-in part of their service - not as a premium add-on or a custom development project. The technology to track, photograph, and report on all 10 of these metrics exists today and should be standard operating procedure for any serious merchandising programme. You should be able to log in and see your shelf across India - in real time, with photo proof, at every store your merchandiser visits.

This guide is part of our complete FMCG Merchandising Services Guide.

Conclusion

The difference between brands that win at the shelf and brands that struggle is not always product quality or pricing - it is visibility. The brands that know what their shelf looks like today, in every store, in every city, are the ones that can act fastest when something goes wrong. Dashboards that track these 10 KPIs give you that visibility, turning your merchandising programme from a cost centre into a strategic advantage.

Stop relying on WhatsApp photos and monthly Excel reports. Invest in real-time dashboards that show you your shelf across India - with GPS-verified visits, photo-audited compliance, and automated alerts that tell you when action is needed. That is how you turn merchandising data into merchandising results.