Skip to content

Sub Popularity Report

Menu Location: Products > Reports > Sub Popularity Report

Last Updated: 2026-07-27

Overview

The Sub Popularity Report shows which products customers ended up with most often as a substitution ("sub") inside their boxes for a single delivery week. A "sub" here means a box menu slot that did NOT go out as the default item, either the customer swapped it for a similarly-priced product themselves, or the system automatically substituted a different product into that slot (for example, when the default item was unavailable).

This is a per-week report, not a date-range report. You pick one delivery week from a dropdown and see subs for that week only.

What it tells you:

  • Which products were most frequently the item customers/the system subbed IN, for the selected week
  • For any one of those products, exactly which original box items it replaced, broken out separately for customer-made subs and system-made (automatic) subs

Page Layout

  • Week selector: a single dropdown to choose the delivery week (Select Week button submits the form). There is no date-range picker and no "quick select" options.

Main Table

A single table listing every product that was subbed into at least one box that week, one row per product:

Column Description
Rank Row number, ordered by Subbed In Count (highest first)
Product The product that was given to the customer as the sub (the box menu item, by name)
Subbed In Count Number of order lines that week where this product was the sub (customer-chosen + system-chosen combined)
% of All Subs This product's count divided by the total number of subs that week

The table is always sorted by Subbed In Count, highest first. There is no alternate sort option, no search box, and no minimum-occurrence filter on this main table.

Sub Details Popup

Clicking a product name in the table opens a popup titled "Sub Details for [Product] / Week of [date]" with two side-by-side breakdowns:

  • Customers: how many times customers themselves chose this product as their sub that week, and a ranked list (top 10, with "...and N more" if there are more) of the original products it most often replaced, each with its own count.
  • The System: the same breakdown, but for subs the system made automatically rather than the customer.

If there is no data for either side, it says "no customer subbing found" or "no system subbing found." The popup closes with a "Dismiss" button.

What This Report Does NOT Have

To avoid confusion with other reporting tools in the admin, this report does not include:

  • A date range, it is always scoped to one delivery week at a time
  • Product/brand/category search or filters
  • A minimum-occurrence or acceptance-rate filter
  • CSV/Excel export
  • Any acceptance rate, complaint rate, reorder rate, or price-difference/customer-satisfaction rating; none of that data is tracked or shown here
  • Customer names or free-text customer feedback

If you need those things, see Related Pages below.

Common Use Cases

See what's substituting well this week

Pick the delivery week from the dropdown. The table is already sorted so the most-subbed-in product for that week is Rank #1.

Understand what a product is replacing

Click any product name in the table. The popup splits out, separately, what customers chose to swap out for it and what the system auto-subbed it in for, along with counts for each original product.

Compare a past week to this week

Change the week dropdown and reselect. Each week's data is calculated independently; there is no built-in week-over-week comparison view.

Troubleshooting

Report shows "No results"

The selected week has no order lines with a customer- or system-made substitution. Try a different week, or confirm subs actually occurred that week (e.g. via the No Sub Found Report, if the system was failing to find a sub automatically).

This just means all of that product's subs that week came from the other mechanism (all customer-driven, or all system-driven). It is not an error.

Numbers look different from the No Sub Found Report

This report counts subs that succeeded: the customer or the system actually landed on a replacement product. The No Sub Found Report tracks the opposite case: orders where the system could not find an automatic sub at all. The two reports are not meant to reconcile to the same totals.

  • No Sub Found Report (kiv/reports/no_sub_found.php): orders where the system couldn't find an automatic sub
  • Sub Un-Popularity Report (kiv/reports/sub-unpopularity-report.php): the least popular things customers sub OUT

End of Documentation