Now, clicking on the bottom row and then clicking “Confirm” selects the “Cereal” category of interest. While they could continue to select further categories of interest, for now they simply click “Search” to find SKUs in that Category, tick the “Select All” box, then the blue “Select Item(s)” button to select the items of interest. Skipping the addition of other target items, our grocer clicks the “Confirm” button to finalize the target SKUs for this report.
The last parameters may be the most unfamiliar to readers. These are the “Minimum %” and “Minimum Affinity Gain %” in the “Affinity Threshold” section. To make things simpler, let’s start by defining “target baskets” as all baskets in which you find one or more of your target items. Briefly, if you set “Minimum %” at
8, the only SKUs returned by the report will be those found in \(\geq\) 8% of “target baskets.” If you set “Minimum Affinity Gain %” at
3, the only SKUs returned by the report will be those whose presence in “target baskets” is \(\geq\) 3 percentage points greater than their presence in “all baskets.” For example, if a specific SKU is found in 8% of “all baskets” in 2022 Q2, that SKU needs to be found in \(\geq\) 11% of “target baskets” in the same quarter to be included in the report. Note that if the results set is too large or too small, our grocer can always click “New Report” at the top right in order to load the last report’s parameters and then tweak the ones they would like to change, for example, raising the “Minimum %” to