Category KPI Scorecard Builder

Example output

Category KPI scorecard — RTD coffee, Cascade Roasters, Daybreak Mart:

Metric set, organized by what it serves

Sales health
1. Dollar and unit sales, category and Cascade Roasters, trended monthly. Source: retailer POS or syndicated data. Target: track growth rate against the category average, not an absolute number. Red flag: two consecutive months of growth below the category average.
2. Household penetration rate. Source: panel data (Circana or similar) if available; loyalty-card data as a proxy if not. Target: directional growth quarter over quarter, since this is your stated top priority. Red flag: flat or declining penetration for two consecutive quarters — this is the earliest signal that sales growth is coming from existing buyers drinking more, not new households, which is a weaker growth pattern.

Distribution and space health
3. Facings and store count versus Brightwave and Roast & Co. Source: internal store audits or retailer-provided planogram data. Target: hold or grow share of facings relative to your share of category sales. Red flag: facing share falling behind sales share, which signals a space-productivity argument is overdue.
4. Out-of-stock rate at peak day-parts. Source: retailer inventory data if shared, otherwise periodic store checks. Target: below the category average. Red flag: any single-digit percentage climb month over month, since RTD coffee's impulse-driven purchase pattern makes stockouts costly.

Price and promotion health
5. Price gap versus Brightwave and Roast & Co., tracked monthly. Source: shelf-price audits or retailer price feeds. Target: hold within your stated brand-position gap (define the acceptable range once you know your intended positioning). Red flag: gap narrowing or reversing without a deliberate pricing decision behind it.
6. Percent of volume sold on promotion. Source: retailer or syndicated promo data. Target: directionally stable or declining, consistent with a healthy pricing posture. Red flag: rising promo dependence, which erodes margin and trains deal-seeking behavior.

Shopper health
7. Basket size when RTD coffee is present versus category average basket. Source: retailer basket-level data if available. Target: at or above the average, since this strengthens your space argument. Red flag: falling basket association, which weakens the case for maintained space.

Reporting cadence
- Weekly: out-of-stock rate only — the one metric that needs fast action.
- Monthly: dollar/unit sales, facings and store count, price gap, promo volume.
- Quarterly: household penetration, basket association, and a full scorecard review against the strategic priorities.

Red-flag summary sheet
Two consecutive months of below-category sales growth, flat penetration for two quarters, facing share falling behind sales share, rising stockouts, an unplanned price-gap shift, rising promo dependence, or falling basket association — any one of these triggers a deeper look; two or more triggers an off-cycle category conversation with Daybreak Mart.

One-page scorecard template

A single table: metric name, current value, target/range, trend arrow, red-flag status, and data source — seven metrics, one page, refreshed on the cadence above.

Note on data gaps: you mentioned only tracking monthly dollar sales today. Household penetration and basket association will likely require syndicated panel data or a retailer data-sharing conversation — flag these as the two metrics to prioritize sourcing first, since they map directly to your stated top priority.

Want me to build the actual one-page scorecard table, ready to drop into a monthly report?