[av_one_full first min_height=” vertical_alignment=” space=” custom_margin=” margin=’0px’ row_boxshadow=” row_boxshadow_color=” row_boxshadow_width=’10’ link=” linktarget=” link_hover=” padding=’0px’ highlight=” highlight_size=” border=” border_color=” radius=’0px’ column_boxshadow=” column_boxshadow_color=” column_boxshadow_width=’10’ background=’bg_color’ background_color=” background_gradient_color1=” background_gradient_color2=” background_gradient_direction=’vertical’ src=” background_position=’top left’ background_repeat=’no-repeat’ animation=” mobile_breaking=” mobile_display=” av_uid=’av-1kbqd5y’]
[av_textblock size=” font_color=” color=” av-medium-font-size=” av-small-font-size=” av-mini-font-size=” av_uid=’av-l7kkm5ac’ admin_preview_bg=”]
BRdata Analytics: Item Affinities
[/av_textblock]
[av_textblock size=” font_color=” color=” av-medium-font-size=” av-small-font-size=” av-mini-font-size=” av_uid=’av-l76o6rm5′ admin_preview_bg=”]
Grocers operate in a complex retail environment with thousands of SKUs, only some of which might catch a shopper’s attention on any given visit, whether physical or digital. This presents an interesting, and difficult, problem: which items should be located near each other? Beyond simply organizing items by a grocer’s internal Categories–Category 1 Items together and so on–grocers want to know if there are powerful connections between items in different Categories such that placing these items near each other increases shopper satisfaction and the grocer’s bottom line.
[/av_textblock]
[/av_one_full]
[av_one_full first min_height=” vertical_alignment=” space=” custom_margin=” margin=’0px’ row_boxshadow=” row_boxshadow_color=” row_boxshadow_width=’10’ link=” linktarget=” link_hover=” padding=’0px’ highlight=” highlight_size=” border=” border_color=” radius=’0px’ column_boxshadow=” column_boxshadow_color=” column_boxshadow_width=’10’ background=’bg_color’ background_color=” background_gradient_color1=” background_gradient_color2=” background_gradient_direction=’vertical’ src=” background_position=’top left’ background_repeat=’no-repeat’ animation=” mobile_breaking=” mobile_display=” av_uid=’av-185t3752′]
[av_image src=’https://brdata.com/wp-content/uploads/2022/08/unnamed-chunk-6-1.png’ attachment=’11740′ attachment_size=’full’ align=’left’ styling=” hover=” link=” target=” caption=” font_size=” appearance=” overlay_opacity=’0.4′ overlay_color=’#000000′ overlay_text_color=’#ffffff’ copyright=” animation=’no-animation’ av_uid=’av-l76o781o’ admin_preview_bg=”][/av_image]
[/av_one_full]
[av_one_full first min_height=” vertical_alignment=” space=” custom_margin=” margin=’0px’ row_boxshadow=” row_boxshadow_color=” row_boxshadow_width=’10’ link=” linktarget=” link_hover=” padding=’0px’ highlight=” highlight_size=” border=” border_color=” radius=’0px’ column_boxshadow=” column_boxshadow_color=” column_boxshadow_width=’10’ background=’bg_color’ background_color=” background_gradient_color1=” background_gradient_color2=” background_gradient_direction=’vertical’ src=” background_position=’top left’ background_repeat=’no-repeat’ animation=” mobile_breaking=” mobile_display=” av_uid=’av-17w24612′]
[av_textblock size=” font_color=” color=” av-medium-font-size=” av-small-font-size=” av-mini-font-size=” av_uid=’av-l76o7ypn’ admin_preview_bg=”]
Affinity Analysis Report
BRdata offers its Cloud subscribers the Affinity Analysis report to assist grocers in identifying exactly these kinds of relationships. For example, imagine a grocer has noticed that there is some extra space in the cereal aisle of a specific store and they are wondering if they want to place one or maybe two retail displays of complementary items in the aisle. By clicking “Reports” > “Basket Analysis” > “Affinity Analysis” in the upper navigation bar, they would be presented with a screen where the grocer needs to input their desired parameters.
[/av_textblock]
[/av_one_full]
[av_one_full first min_height=” vertical_alignment=” space=” custom_margin=” margin=’0px’ row_boxshadow=” row_boxshadow_color=” row_boxshadow_width=’10’ link=” linktarget=” link_hover=” padding=’0px’ highlight=” highlight_size=” border=” border_color=” radius=’0px’ column_boxshadow=” column_boxshadow_color=” column_boxshadow_width=’10’ background=’bg_color’ background_color=” background_gradient_color1=” background_gradient_color2=” background_gradient_direction=’vertical’ src=” background_position=’top left’ background_repeat=’no-repeat’ animation=” mobile_breaking=” mobile_display=” av_uid=’av-17l1lh52′]
[av_image src=’https://brdata.com/wp-content/uploads/2022/08/AffinityAnalysisScreenshot.png’ attachment=’11755′ attachment_size=’full’ align=’left’ styling=” hover=” link=” target=” caption=” font_size=” appearance=” overlay_opacity=’0.4′ overlay_color=’#000000′ overlay_text_color=’#ffffff’ copyright=” animation=’no-animation’ av_uid=’av-l76o8ygr’ admin_preview_bg=”]
Affinity Analysis Screenshot
[/av_image]
[/av_one_full]
[av_one_full first min_height=” vertical_alignment=” space=” custom_margin=” margin=’0px’ row_boxshadow=” row_boxshadow_color=” row_boxshadow_width=’10’ link=” linktarget=” link_hover=” padding=’0px’ highlight=” highlight_size=” border=” border_color=” radius=’0px’ column_boxshadow=” column_boxshadow_color=” column_boxshadow_width=’10’ background=’bg_color’ background_color=” background_gradient_color1=” background_gradient_color2=” background_gradient_direction=’vertical’ src=” background_position=’top left’ background_repeat=’no-repeat’ animation=” mobile_breaking=” mobile_display=” av_uid=’av-16zz9nxi’]
[av_textblock size=” font_color=” color=” av-medium-font-size=” av-small-font-size=” av-mini-font-size=” av_uid=’av-l76o9ktk’ admin_preview_bg=”]
Our grocer is going to select 2022 Q2 for a single store and then choose their target items. By clicking on “Select UPC” in the “UPC” subsection, the grocer now has various ways to select their target SKU(s). In this case, we’ll click on the “UPC Query” tab in order to “Select UPCs where: Category = Cereal” simply by starting to type the word “cereal” in the “Description” search bar.
[/av_textblock]
[/av_one_full]
[av_one_full first min_height=” vertical_alignment=” space=” custom_margin=” margin=’0px’ row_boxshadow=” row_boxshadow_color=” row_boxshadow_width=’10’ link=” linktarget=” link_hover=” padding=’0px’ highlight=” highlight_size=” border=” border_color=” radius=’0px’ column_boxshadow=” column_boxshadow_color=” column_boxshadow_width=’10’ background=’bg_color’ background_color=” background_gradient_color1=” background_gradient_color2=” background_gradient_direction=’vertical’ src=” background_position=’top left’ background_repeat=’no-repeat’ animation=” mobile_breaking=” mobile_display=” av_uid=’av-16mpnqg6′]
[av_image src=’https://brdata.com/wp-content/uploads/2022/08/AffinityAnalysisCategoryScreenshot.png’ attachment=’11753′ attachment_size=’full’ align=’left’ styling=” hover=” link=” target=” caption=” font_size=” appearance=” overlay_opacity=’0.4′ overlay_color=’#000000′ overlay_text_color=’#ffffff’ copyright=” animation=’no-animation’ av_uid=’av-l76oabdg’ admin_preview_bg=”][/av_image]
[/av_one_full]
[av_one_full first min_height=” vertical_alignment=” space=” custom_margin=” margin=’0px’ row_boxshadow=” row_boxshadow_color=” row_boxshadow_width=’10’ link=” linktarget=” link_hover=” padding=’0px’ highlight=” highlight_size=” border=” border_color=” radius=’0px’ column_boxshadow=” column_boxshadow_color=” column_boxshadow_width=’10’ background=’bg_color’ background_color=” background_gradient_color1=” background_gradient_color2=” background_gradient_direction=’vertical’ src=” background_position=’top left’ background_repeat=’no-repeat’ animation=” mobile_breaking=” mobile_display=” av_uid=’av-15xi6u7a’]
[av_textblock size=” font_color=” color=” av-medium-font-size=” av-small-font-size=” av-mini-font-size=” av_uid=’av-l76ob162′ admin_preview_bg=”]
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 12.
[/av_textblock]
[/av_one_full]
[av_one_full first min_height=” vertical_alignment=” space=” custom_margin=” margin=’0px’ row_boxshadow=” row_boxshadow_color=” row_boxshadow_width=’10’ link=” linktarget=” link_hover=” padding=’0px’ highlight=” highlight_size=” border=” border_color=” radius=’0px’ column_boxshadow=” column_boxshadow_color=” column_boxshadow_width=’10’ background=’bg_color’ background_color=” background_gradient_color1=” background_gradient_color2=” background_gradient_direction=’vertical’ src=” background_position=’top left’ background_repeat=’no-repeat’ animation=” mobile_breaking=” mobile_display=” av_uid=’av-15eg2wo6′]
[av_image src=’https://brdata.com/wp-content/uploads/2022/08/AffinityAnalysisResultsScreenshot.png’ attachment=’11754′ attachment_size=’full’ align=’left’ styling=” hover=” link=” target=” caption=” font_size=” appearance=” overlay_opacity=’0.4′ overlay_color=’#000000′ overlay_text_color=’#ffffff’ copyright=” animation=’no-animation’ av_uid=’av-l76obyuv’ admin_preview_bg=”][/av_image]
[/av_one_full]
[av_one_full first min_height=” vertical_alignment=” space=” custom_margin=” margin=’0px’ row_boxshadow=” row_boxshadow_color=” row_boxshadow_width=’10’ link=” linktarget=” link_hover=” padding=’0px’ highlight=” highlight_size=” border=” border_color=” radius=’0px’ column_boxshadow=” column_boxshadow_color=” column_boxshadow_width=’10’ background=’bg_color’ background_color=” background_gradient_color1=” background_gradient_color2=” background_gradient_direction=’vertical’ src=” background_position=’top left’ background_repeat=’no-repeat’ animation=” mobile_breaking=” mobile_display=” av_uid=’av-154pvqna’]
[av_textblock size=” font_color=” color=” av-medium-font-size=” av-small-font-size=” av-mini-font-size=” av_uid=’av-l76ococ3′ admin_preview_bg=”]
While there are some uninteresting items in the results set, we did learn that bananas, tomatoes, broccoli, and avocados all met our thresholds. Our grocer can now decide whether any of these items is worth trying as a retail display in their cereal aisle.
Association Rules
One solution that BRdata’s Data Science team is playing around with, imagining it brings new value to our customers, is letting this grocer ask a slightly different question: which are the most powerful relationships between items, not merely using the cereal Category as our target, but in the whole store? We’re also going to add in a few other twists.
- We are going to focus on SKUs in the Grocery Department, excluding Produce, Dairy, Frozen, etc.
- Groups of items are allowed, for example, bananas, strawberries, plus both bananas and strawberries at the same time.
In 2022 Q2, there were about 30,000 baskets in this store that included Items from the Grocery Department. Let’s restrict our search to items that appear in at least 1 out of every 2,000 baskets. Let’s also require that if, for example, a cereal SKU is in a basket, the complementary SKU is also in the basket in at least 1 out of every 100 baskets. Having narrowed our search, now we take a look at the top 10 most powerful relationships in this store.
The way that we will define “most powerful relationship” is Lift. To say that bananas are lifted by apples is to say that it is more probable to observe bananas in a basket if there are also apples in the basket than it is to observe bananas in a random basket.
[/av_textblock]
[/av_one_full]
[av_one_full first min_height=” vertical_alignment=” space=” custom_margin=” margin=’0px’ row_boxshadow=” row_boxshadow_color=” row_boxshadow_width=’10’ link=” linktarget=” link_hover=” padding=’0px’ highlight=” highlight_size=” border=” border_color=” radius=’0px’ column_boxshadow=” column_boxshadow_color=” column_boxshadow_width=’10’ background=’bg_color’ background_color=” background_gradient_color1=” background_gradient_color2=” background_gradient_direction=’vertical’ src=” background_position=’top left’ background_repeat=’no-repeat’ animation=” mobile_breaking=” mobile_display=” av_uid=’av-26b2jc9y’]
[av_table purpose=’tabular’ pricing_table_design=’avia_pricing_default’ pricing_hidden_cells=” caption=’ Top 10 Association Rules by SKU’ responsive_styling=’avia_scrollable_table’ av_uid=’av-25t5v6g6′]
[av_row row_style=’avia-heading-row’ av_uid=’av-38nx2dye’][av_cell col_style=’avia-center-col’ av_uid=’av-3856bu2u’][/av_cell][av_cell col_style=” av_uid=’av-37mqny1y’]A1[/av_cell][av_cell col_style=” av_uid=’av-372t26me’]B[/av_cell][av_cell col_style=” av_uid=’av-36fo4rba’]Baskets_A[/av_cell][av_cell col_style=” av_uid=’av-bex7jt2′]Baskets_B[/av_cell][av_cell col_style=” av_uid=’av-35ps4sxy’]Lift[/av_cell][/av_row]
[av_row row_style=” av_uid=’av-bbsi6zq’][av_cell col_style=’avia-center-col’ av_uid=’av-34qh6rvq’]1[/av_cell][av_cell col_style=” av_uid=’av-34f2k3ye’]V8 LOW SODIUM[/av_cell][av_cell col_style=” av_uid=’av-342z1ixy’]KIND GF BFST BR HNY OAT[/av_cell][av_cell col_style=” av_uid=’av-33ecy3ba’]43[/av_cell][av_cell col_style=” av_uid=’av-332rj33a’]31[/av_cell][av_cell col_style=” av_uid=’av-32b7ks3q’]580[/av_cell][/av_row]
[av_row row_style=” av_uid=’av-31zzm65i’][av_cell col_style=’avia-center-col’ av_uid=’av-31iue3ba’]2[/av_cell][av_cell col_style=” av_uid=’av-30xvxlja’]KIND GF BFST BR HNY OAT[/av_cell][av_cell col_style=” av_uid=’av-avy97s6′]V8 LOW SODIUM[/av_cell][av_cell col_style=” av_uid=’av-303ys5vq’]31[/av_cell][av_cell col_style=” av_uid=’av-2zw37eg6′]43[/av_cell][av_cell col_style=” av_uid=’av-2zhupgx2′]580[/av_cell][/av_row]
[av_row row_style=” av_uid=’av-2yzj9rae’][av_cell col_style=’avia-center-col’ av_uid=’av-2ydt0bk6′]3[/av_cell][av_cell col_style=” av_uid=’av-2xta7izq’]V8 LOW SODIUM[/av_cell][av_cell col_style=” av_uid=’av-2xn9o69y’]NV GRNL BAR OAT HONEY[/av_cell][av_cell col_style=” av_uid=’av-2wu0e7za’]43[/av_cell][av_cell col_style=” av_uid=’av-2wcnuiee’]38[/av_cell][av_cell col_style=” av_uid=’av-2w4pw0jq’]380[/av_cell][/av_row]
[av_row row_style=” av_uid=’av-2vop14iu’][av_cell col_style=’avia-center-col’ av_uid=’av-2v22qkg6′]4[/av_cell][av_cell col_style=” av_uid=’av-2ulngzl2′]NV GRNL BAR OAT HONEY[/av_cell][av_cell col_style=” av_uid=’av-2uev2jra’]V8 LOW SODIUM[/av_cell][av_cell col_style=” av_uid=’av-a62sjuu’]38[/av_cell][av_cell col_style=” av_uid=’av-2t8e9oli’]43[/av_cell][av_cell col_style=” av_uid=’av-2srgyo3q’]380[/av_cell][/av_row]
[av_row row_style=” av_uid=’av-2sd3zzja’][av_cell col_style=’avia-center-col’ av_uid=’av-2s1z9492′]5[/av_cell][av_cell col_style=” av_uid=’av-2rclrqsm’]GLC VTM WTR ZERO XXX[/av_cell][av_cell col_style=” av_uid=’av-2r743tye’]GLC VTMN WTR ZERO POWER C[/av_cell][av_cell col_style=” av_uid=’av-2qlaospy’]62[/av_cell][av_cell col_style=” av_uid=’av-2q2g0s92′]56[/av_cell][av_cell col_style=” av_uid=’av-9re5rty’]260[/av_cell][/av_row]
[av_row row_style=” av_uid=’av-9pqbpja’][av_cell col_style=’avia-center-col’ av_uid=’av-9ou20jq’]6[/av_cell][av_cell col_style=” av_uid=’av-2odhnfxi’]GLC VTMN WTR ZERO POWER C[/av_cell][av_cell col_style=” av_uid=’av-2nuv52g6′]GLC VTMN WTR ZERO XXX [/av_cell][av_cell col_style=” av_uid=’av-2n8c8oiu’]56[/av_cell][av_cell col_style=” av_uid=’av-2mqhnjba’]62[/av_cell][av_cell col_style=” av_uid=’av-2ml0ac9y’]260[/av_cell][/av_row]
[av_row row_style=” av_uid=’av-2m129kpy’][av_cell col_style=’avia-center-col’ av_uid=’av-2lp0002u’]7[/av_cell][av_cell col_style=” av_uid=’av-2kwfjtpi’]DD MOCHA ICED COFFEE[/av_cell][av_cell col_style=” av_uid=’av-2khq7bra’]DD ICED COFFEE[/av_cell][av_cell col_style=” av_uid=’av-2jxp7e6e’]71[/av_cell][av_cell col_style=” av_uid=’av-2jrl3fty’]77[/av_cell][av_cell col_style=” av_uid=’av-2j3hp0li’]220[/av_cell][/av_row]
[av_row row_style=” av_uid=’av-2ilpsbly’][av_cell col_style=’avia-center-col’ av_uid=’av-2iaswdie’]8[/av_cell][av_cell col_style=” av_uid=’av-2hryl806′]DD ICED COFFEE[/av_cell][av_cell col_style=” av_uid=’av-2h9fng5i’]DD MOCHA ICED COFFEE[/av_cell][av_cell col_style=” av_uid=’av-2h01rycm’]77[/av_cell][av_cell col_style=” av_uid=’av-2gcftj52′]71[/av_cell][av_cell col_style=” av_uid=’av-2fxkp4me’]220[/av_cell][/av_row]
[av_row row_style=” av_uid=’av-2fdv4puu’][av_cell col_style=’avia-center-col’ av_uid=’av-2f7h4yva’]9[/av_cell][av_cell col_style=” av_uid=’av-2et4h03q’]GLC VTMN WTR ZERO SQUEEZED[/av_cell][av_cell col_style=” av_uid=’av-2e7r2j1i’]GLC VTMN WTR ZERO XXX[/av_cell][av_cell col_style=” av_uid=’av-2dpomgna’]58[/av_cell][av_cell col_style=” av_uid=’av-2d7togh2′]62[/av_cell][av_cell col_style=” av_uid=’av-2cvz5ip2′]190[/av_cell][/av_row]
[av_row row_style=” av_uid=’av-2c8nhw92′][av_cell col_style=’avia-center-col’ av_uid=’av-2bw5vc7a’]10[/av_cell][av_cell col_style=” av_uid=’av-2bcf1x2e’]GLC VTMN WTR ZERO XXX[/av_cell][av_cell col_style=” av_uid=’av-2b337apy’]GLC VTM WTR ZERO SQUEEZED[/av_cell][av_cell col_style=” av_uid=’av-2adhqpra’]62[/av_cell][av_cell col_style=” av_uid=’av-2a5npohy’]58[/av_cell][av_cell col_style=” av_uid=’av-29mcbdxi’]190[/av_cell][/av_row]
[/av_table]
[/av_one_full]
[av_one_full first min_height=” vertical_alignment=” space=” custom_margin=” margin=’0px’ row_boxshadow=” row_boxshadow_color=” row_boxshadow_width=’10’ link=” linktarget=” link_hover=” padding=’0px’ highlight=” highlight_size=” border=” border_color=” radius=’0px’ column_boxshadow=” column_boxshadow_color=” column_boxshadow_width=’10’ background=’bg_color’ background_color=” background_gradient_color1=” background_gradient_color2=” background_gradient_direction=’vertical’ src=” background_position=’top left’ background_repeat=’no-repeat’ animation=” mobile_breaking=” mobile_display=” av_uid=’av-1673qtpi’]
[av_textblock size=” font_color=” color=” av-medium-font-size=” av-small-font-size=” av-mini-font-size=” av_uid=’av-l76muyqg’ admin_preview_bg=”]
Although some of these relationships may not be strikingly unexpected, the grocer could simply remove the Drinks Category or otherwise tweak the universe of Items to eliminate relationships that are not of concern. But hold on, look at what our grocer has now learned. First, not only is V8 Low Sodium associated with cereal bars in 2022 Q2, but it is the strongest relationship among SKUs in the store. Moreover, it is 300 to 600 times more likely to see these SKUs together than apart–stockouts of one may significantly harm sales of the other. I would bet that very few readers expected a vegetable juice to cereal bar connection, and certainly not at this level of Lift. Lastly, although there are 10 rows, there are actually 5 pairs–where each row is flipped around in a different row. This means that it is not that when one adds V8 to the basket, one then adds a cereal bar (and not the other way around), but that one adds them together as a pair. This strongly suggests as well that these are complementary goods–a price decrease in either one increases sales of the other.
Now, to keep going, let’s imagine that the grocer reviewed the top 50 relationships and thought to themselves, “this is more fine-grained than I wanted.” Perhaps our grocer really intended to discover new relationships between Categories rather than between SKUs. Well, we can do that.
[/av_textblock]
[/av_one_full]
[av_one_full first min_height=” vertical_alignment=” space=” custom_margin=” margin=’0px’ row_boxshadow=” row_boxshadow_color=” row_boxshadow_width=’10’ link=” linktarget=” link_hover=” padding=’0px’ highlight=” highlight_size=” border=” border_color=” radius=’0px’ column_boxshadow=” column_boxshadow_color=” column_boxshadow_width=’10’ background=’bg_color’ background_color=” background_gradient_color1=” background_gradient_color2=” background_gradient_direction=’vertical’ src=” background_position=’top left’ background_repeat=’no-repeat’ animation=” mobile_breaking=” mobile_display=” av_uid=’av-15px7lc6′]
[av_table purpose=’tabular’ pricing_table_design=’avia_pricing_default’ pricing_hidden_cells=” caption=’ Top 10 Association Rules by Category’ responsive_styling=’avia_scrollable_table’ av_uid=’av-152tngpy’]
[av_row row_style=’avia-heading-row’ av_uid=’av-294laucm’][av_cell col_style=’avia-center-col’ av_uid=’av-28h2z5xi’][/av_cell][av_cell col_style=” av_uid=’av-81c4yme’]A1[/av_cell][av_cell col_style=” av_uid=’av-27n4p086′]A2[/av_cell][av_cell col_style=” av_uid=’av-273l0scm’]B[/av_cell][av_cell col_style=” av_uid=’av-26y8276u’]Baskets_A[/av_cell][av_cell col_style=” av_uid=’av-26cglw92′]Baskets_B[/av_cell][av_cell col_style=” av_uid=’av-2622y8zq’]Lift[/av_cell][/av_row]
[av_row row_style=” av_uid=’av-25gj4ali’][av_cell col_style=’avia-center-col’ av_uid=’av-252zxa9y’]1[/av_cell][av_cell col_style=” av_uid=’av-24evva9y’]FRUIT-PBJ-PANCAKE-HONEY-PROTN[/av_cell][av_cell col_style=” av_uid=’av-2488vw1y’]JUICE-TEA-GATORADE-WATER[/av_cell][av_cell col_style=” av_uid=’av-7k0u9eu’]CEREAL-POPTARTS-GRANOLA-OATML[/av_cell][av_cell col_style=” av_uid=’av-22xqr44m’]540[/av_cell][av_cell col_style=” av_uid=’av-22txp4o6′]2585[/av_cell][av_cell col_style=” av_uid=’av-22e35fnq’]4[/av_cell][/av_row]
[av_row row_style=” av_uid=’av-21w81006′][av_cell col_style=’avia-center-col’ av_uid=’av-21e2fc3q’]2[/av_cell][av_cell col_style=” av_uid=’av-20o6nydi’]COOKIES & CRACKERS[/av_cell][av_cell col_style=” av_uid=’av-20i3oq2u’]JUICE-TEA-GATORADE-WATER[/av_cell][av_cell col_style=” av_uid=’av-76lvfhi’]CEREAL-POPTARTS-GRANOLA-OATML[/av_cell][av_cell col_style=” av_uid=’av-1znk5e2u’]811[/av_cell][av_cell col_style=” av_uid=’av-1yu4i3ly’]2585[/av_cell][av_cell col_style=” av_uid=’av-1yksnh9i’]4[/av_cell][/av_row]
[av_row row_style=” av_uid=’av-1y2ntog6′][av_cell col_style=’avia-center-col’ av_uid=’av-1xpv6lpi’]3[/av_cell][av_cell col_style=” av_uid=’av-1x53gb2e’]COOKIES & CRACKERS[/av_cell][av_cell col_style=” av_uid=’av-1wsjx5vq’]PASTA-TOMATO-ETHNIC[/av_cell][av_cell col_style=” av_uid=’av-1w1em4di’]CEREAL-POPTARTS-GRANOLA-OATML[/av_cell][av_cell col_style=” av_uid=’av-1vlfpyna’]814[/av_cell][av_cell col_style=” av_uid=’av-1vj17og6′]2585[/av_cell][av_cell col_style=” av_uid=’av-1uoj82me’]3[/av_cell][/av_row]
[av_row row_style=” av_uid=’av-1u8potc6′][av_cell col_style=’avia-center-col’ av_uid=’av-1tx1y7uu’]4[/av_cell][av_cell col_style=” av_uid=’av-1tl5gjs6′]CEREAL-POPTARTS-GRANOLA-OATML[/av_cell][av_cell col_style=” av_uid=’av-1t4b0ezq’]DSD BREAD[/av_cell][av_cell col_style=” av_uid=’av-1shs412e’]FRUIT-PBJ-PANCAKE-HONEY-PROTN[/av_cell][av_cell col_style=” av_uid=’av-1s30dsp2′]699[/av_cell][av_cell col_style=” av_uid=’av-1rn8e9l2′]2635[/av_cell][av_cell col_style=” av_uid=’av-ms0kjq’]3[/av_cell][/av_row]
[av_row row_style=” av_uid=’av-1qunpikm’][av_cell col_style=’avia-center-col’ av_uid=’av-1q3lk2km’]5[/av_cell][av_cell col_style=” av_uid=’av-1pls7xqe’]COOKIES & CRACKERS[/av_cell][av_cell col_style=” av_uid=’av-1pes75d2′]DSD BREAD[/av_cell][av_cell col_style=” av_uid=’av-1oynrnpi’]CEREAL-POPTARTS-GRANOLA-OATML[/av_cell][av_cell col_style=” av_uid=’av-1od4tupy’]891[/av_cell][av_cell col_style=” av_uid=’av-1o2xu9fq’]2585[/av_cell][av_cell col_style=” av_uid=’av-1nlz3t3a’]3[/av_cell][/av_row]
[av_row row_style=” av_uid=’av-1n3xhqxy’][av_cell col_style=’avia-center-col’ av_uid=’av-1mn5b292′]6[/av_cell][av_cell col_style=” av_uid=’av-1mad9f46′]SPECIALTY[/av_cell][av_cell col_style=” av_uid=’av-1ltrbs9y’]JUICE-TEA-GATORADE-WATER[/av_cell][av_cell col_style=” av_uid=’av-1l7pvedi’]CEREAL-POPTARTS-GRANOLA-OATML[/av_cell][av_cell col_style=” av_uid=’av-1kxuywo6′]906[/av_cell][av_cell col_style=” av_uid=’av-1k6xp7ty’]2585[/av_cell][av_cell col_style=” av_uid=’av-1jv3gzuu’]3[/av_cell][/av_row]
[av_row row_style=” av_uid=’av-1jkb3xye’][av_cell col_style=’avia-center-col’ av_uid=’av-5icxap2′]7[/av_cell][av_cell col_style=” av_uid=’av-1incj1ba’]FRUIT-PBJ-PANCAKE-HONEY-PROTN[/av_cell][av_cell col_style=” av_uid=’av-1i1exyue’]PASTA-TOMATO-ETHNIC[/av_cell][av_cell col_style=” av_uid=’av-1heko79i’]VEG-BEAN-RICE-STUFFING-MEAT[/av_cell][av_cell col_style=” av_uid=’av-1h3dfb8m’]639 [/av_cell][av_cell col_style=” av_uid=’av-1gg9bw6e’]3374[/av_cell][av_cell col_style=” av_uid=’av-1g3pmbie’]3[/av_cell][/av_row]
[av_row row_style=” av_uid=’av-1fn14irq’][av_cell col_style=’avia-center-col’ av_uid=’av-1f1eyz46′]8[/av_cell][av_cell col_style=” av_uid=’av-1el2i4sm’]FRUIT-PBJ-PANCAKE-HONEY-PROTN[/av_cell][av_cell col_style=” av_uid=’av-1e88fm7a’]DSD BREAD[/av_cell][av_cell col_style=” av_uid=’av-1e15yy92′]CEREAL-POPTARTS-GRANOLA-OATML[/av_cell][av_cell col_style=” av_uid=’av-1da6do5i’]762[/av_cell][av_cell col_style=” av_uid=’av-1cwfsvxi’]2585[/av_cell][av_cell col_style=” av_uid=’av-1cid504m’]3[/av_cell][/av_row]
[av_row row_style=” av_uid=’av-1bujuy6e’][av_cell col_style=’avia-center-col’ av_uid=’av-1bpd14jq’]9[/av_cell][av_cell col_style=” av_uid=’av-1azj46sm’]CEREAL-POPTARTS-GRANOLA-OATML[/av_cell][av_cell col_style=” av_uid=’av-1agcu812′]JUICE-TEA-GATORADE-WATER[/av_cell][av_cell col_style=” av_uid=’av-1a6e09qe’]FRUIT-PBJ-PANCAKE-HONEY-PROTN[/av_cell][av_cell col_style=” av_uid=’av-4k4uvfq’]716[/av_cell][av_cell col_style=” av_uid=’av-19dwnjpi’]2635[/av_cell][av_cell col_style=” av_uid=’av-18o6ui12′]3[/av_cell][/av_row]
[av_row row_style=” av_uid=’av-4g69k1y’][av_cell col_style=’avia-center-col’ av_uid=’av-17p9009y’]10[/av_cell][av_cell col_style=” av_uid=’av-17f0reme’]COOKIES & CRACKERS [/av_cell][av_cell col_style=” av_uid=’av-16wrgurq’]SPECIALTY[/av_cell][av_cell col_style=” av_uid=’av-16f2nm4m’]CEREAL-POPTARTS-GRANOLA-OATML[/av_cell][av_cell col_style=” av_uid=’av-15xrlhk6′]759[/av_cell][av_cell col_style=” av_uid=’av-15rbxq2u’]2585 [/av_cell][av_cell col_style=” av_uid=’av-1581qapy’]3[/av_cell][/av_row]
[/av_table]
[/av_one_full]
[av_one_full first min_height=” vertical_alignment=” space=” custom_margin=” margin=’0px’ row_boxshadow=” row_boxshadow_color=” row_boxshadow_width=’10’ link=” linktarget=” link_hover=” padding=’0px’ highlight=” highlight_size=” border=” border_color=” radius=’0px’ column_boxshadow=” column_boxshadow_color=” column_boxshadow_width=’10’ background=’bg_color’ background_color=” background_gradient_color1=” background_gradient_color2=” background_gradient_direction=’vertical’ src=” background_position=’top left’ background_repeat=’no-repeat’ animation=” mobile_breaking=” mobile_display=” av_uid=’av-1673qtpi’]
[av_textblock size=” font_color=” color=” av-medium-font-size=” av-small-font-size=” av-mini-font-size=” av_uid=’av-l76muyqg’ admin_preview_bg=”]
Note that in the case of Categories, there are sometimes multiple Categories (A1 and A2) that lift another Category.
Now, one way we might adjust our results is to recognize that, depending on the number of baskets in which we find A and B, Lift is constrained to fall within a certain range. If we instead rank relationships based on how strong they are relative to how strong they could be, we see different results.
[/av_textblock]
[/av_one_full]
[av_one_full first min_height=” vertical_alignment=” space=” custom_margin=” margin=’0px’ row_boxshadow=” row_boxshadow_color=” row_boxshadow_width=’10’ link=” linktarget=” link_hover=” padding=’0px’ highlight=” highlight_size=” border=” border_color=” radius=’0px’ column_boxshadow=” column_boxshadow_color=” column_boxshadow_width=’10’ background=’bg_color’ background_color=” background_gradient_color1=” background_gradient_color2=” background_gradient_direction=’vertical’ src=” background_position=’top left’ background_repeat=’no-repeat’ animation=” mobile_breaking=” mobile_display=” av_uid=’av-15px7lc6′]
[av_table purpose=’tabular’ pricing_table_design=’avia_pricing_default’ pricing_hidden_cells=” caption=’ Top 10 Association Rules by Category, Standardized Lift’ responsive_styling=’avia_scrollable_table’ av_uid=’av-152tngpy’]
[av_row row_style=’avia-heading-row’ av_uid=’av-14vm6rae’][av_cell col_style=’avia-center-col’ av_uid=’av-14dr8r46′][/av_cell][av_cell col_style=” av_uid=’av-13ln851i’]A1[/av_cell][av_cell col_style=” av_uid=’av-135t3g5i’]A2[/av_cell][av_cell col_style=” av_uid=’av-131poirq’]B[/av_cell][av_cell col_style=” av_uid=’av-127y09vq’]Baskets_A[/av_cell][av_cell col_style=” av_uid=’av-3sv581y’]Baskets_B[/av_cell][av_cell col_style=” av_uid=’av-11h5i1vq’]Lift[/av_cell][/av_row]
[av_row row_style=” av_uid=’av-112kfvhi’][av_cell col_style=’avia-center-col’ av_uid=’av-10oyop9i’]1[/av_cell][av_cell col_style=” av_uid=’av-zw1bf2e’]VEG-BEAN-RICE-STUFFING-MEAT[/av_cell][av_cell col_style=” av_uid=’av-ztgk30m’]DRESSING-CONDIMENTS-OIL-VNGR[/av_cell][av_cell col_style=” av_uid=’av-zcc1q3q’]PASTA-TOMATO-ETHNIC[/av_cell][av_cell col_style=” av_uid=’av-ytwz9om’]852[/av_cell][av_cell col_style=” av_uid=’av-ybgyip2′]6581[/av_cell][av_cell col_style=” av_uid=’av-xr0u6cm’]2[/av_cell][/av_row]
[av_row row_style=” av_uid=’av-xdubp7q’][av_cell col_style=’avia-center-col’ av_uid=’av-3a0w7pi’]2[/av_cell][av_cell col_style=” av_uid=’av-w9r0oiu’]COOKIES & CRACKERS[/av_cell][av_cell col_style=” av_uid=’av-vx4bxty’]DSD BREAD[/av_cell][av_cell col_style=” av_uid=’av-vojkjie’]SALTY SNACKS[/av_cell][av_cell col_style=” av_uid=’av-uy109ba’]891[/av_cell][av_cell col_style=” av_uid=’av-unou72e’]8771[/av_cell][av_cell col_style=” av_uid=’av-u67pg4m’]2[/av_cell][/av_row]
[av_row row_style=” av_uid=’av-tpm6teu’][av_cell col_style=’avia-center-col’ av_uid=’av-t1w6nae’]3[/av_cell][av_cell col_style=” av_uid=’av-svrrz52′]COOKIES & CRACKERS[/av_cell][av_cell col_style=” av_uid=’av-s9mkk4m’]PASTA-TOMATO-ETHNIC[/av_cell][av_cell col_style=” av_uid=’av-rpu34hy’]SALTY SNACKS[/av_cell][av_cell col_style=” av_uid=’av-rjipokm’]814[/av_cell][av_cell col_style=” av_uid=’av-qwn6wme’]8771[/av_cell][av_cell col_style=” av_uid=’av-qgxtokm’]2[/av_cell][/av_row]
[av_row row_style=” av_uid=’av-q4jev6u’][av_cell col_style=’avia-center-col’ av_uid=’av-pho8y7a’]4[/av_cell][av_cell col_style=” av_uid=’av-p1oxscm’]JUICE-TEA-GATORADE-WATER[/av_cell][av_cell col_style=” av_uid=’av-olk9q1y’]DSD BREAD[/av_cell][av_cell col_style=” av_uid=’av-o9n06w6′]SALTY SNACKS[/av_cell][av_cell col_style=” av_uid=’av-2drk346′]1240[/av_cell][av_cell col_style=” av_uid=’av-n14qfom’]8771[/av_cell][av_cell col_style=” av_uid=’av-mru6yva’]2[/av_cell][/av_row]
[av_row row_style=” av_uid=’av-mczq546′][av_cell col_style=’avia-center-col’ av_uid=’av-7xo146′]5[/av_cell][av_cell col_style=” av_uid=’av-lfv91l2′]COOKIES & CRACKERS[/av_cell][av_cell col_style=” av_uid=’av-l1h5myu’]DRESSING-CONDIMENTS-OIL-VNGR[/av_cell][av_cell col_style=” av_uid=’av-kbv5rk6′]SALTY SNACKS[/av_cell][av_cell col_style=” av_uid=’av-20n0c9y’]821[/av_cell][av_cell col_style=” av_uid=’av-jr4bmbq’]8771[/av_cell][av_cell col_style=” av_uid=’av-j8gqnye’]2[/av_cell][/av_row]
[av_row row_style=” av_uid=’av-iqmg8jq’][av_cell col_style=’avia-center-col’ av_uid=’av-i01bsg6′]6[/av_cell][av_cell col_style=” av_uid=’av-htwmehy’]COOKIES & CRACKERS[/av_cell][av_cell col_style=” av_uid=’av-h56h7ye’]JUICE-TEA-GATORADE-WATER[/av_cell][av_cell col_style=” av_uid=’av-gr6o7uu’]SALTY SNACKS[/av_cell][av_cell col_style=” av_uid=’av-gbyzkh2′]811[/av_cell][av_cell col_style=” av_uid=’av-1klwvly’]8771[/av_cell][av_cell col_style=” av_uid=’av-1jet3eu’]2[/av_cell][/av_row]
[av_row row_style=” av_uid=’av-etywuva’][av_cell col_style=’avia-center-col’ av_uid=’av-ebyyt7q’]7[/av_cell][av_cell col_style=” av_uid=’av-e3umz6u’]IGA[/av_cell][av_cell col_style=” av_uid=’av-dmnqvuu’]DRESSING-CONDIMENTS-OIL-VNGR[/av_cell][av_cell col_style=” av_uid=’av-d4tkqrq’]PASTA-TOMATO-ETHNIC[/av_cell][av_cell col_style=” av_uid=’av-ckck90m’]828[/av_cell][av_cell col_style=” av_uid=’av-c2sih7q’]6581[/av_cell][av_cell col_style=” av_uid=’av-bneghnq’]2[/av_cell][/av_row]
[av_row row_style=” av_uid=’av-bg8f82u’][av_cell col_style=’avia-center-col’ av_uid=’av-atv4b8m’]8[/av_cell][av_cell col_style=” av_uid=’av-a6vyshy’]PASTA-TOMATO-ETHNIC[/av_cell][av_cell col_style=” av_uid=’av-9qp3f9i’]DSD BREAD[/av_cell][av_cell col_style=” av_uid=’av-99o9yau’]SALTY SNACKS[/av_cell][av_cell col_style=” av_uid=’av-wjtlwm’]1330[/av_cell][av_cell col_style=” av_uid=’av-8mphaiu’]8771[/av_cell][av_cell col_style=” av_uid=’av-80y34qu’]1[/av_cell][/av_row]
[av_row row_style=” av_uid=’av-7qjlh8m’][av_cell col_style=’avia-center-col’ av_uid=’av-72o69ie’]9[/av_cell][av_cell col_style=” av_uid=’av-6lq18rq’]PASTA-TOMATO-ETHNIC[/av_cell][av_cell col_style=” av_uid=’av-64rf2qu’]DSD BREAD[/av_cell][av_cell col_style=” av_uid=’av-lewb52′]DRESSING-CONDIMENTS-OIL-VNGR[/av_cell][av_cell col_style=” av_uid=’av-571v8ee’]1330[/av_cell][av_cell col_style=” av_uid=’av-4ri5mli’]6364[/av_cell][av_cell col_style=” av_uid=’av-4bb1opy’]2[/av_cell][/av_row]
[av_row row_style=” av_uid=’av-42744py’][av_cell col_style=’avia-center-col’ av_uid=’av-3ecl2ee’]10[/av_cell][av_cell col_style=” av_uid=’av-2z6152e’]PASTA-TOMATO-ETHNIC [/av_cell][av_cell col_style=” av_uid=’av-2q9f7t2′]JUICE-TEA-GATORADE-WATER[/av_cell][av_cell col_style=” av_uid=’av-1wgutie’]SALTY SNACKS[/av_cell][av_cell col_style=” av_uid=’av-1fkqo86′]987[/av_cell][av_cell col_style=” av_uid=’av-1c25x0m’]8771[/av_cell][av_cell col_style=” av_uid=’av-2oebwm’]2[/av_cell][/av_row]
[/av_table]
[/av_one_full]
[av_one_full first min_height=” vertical_alignment=” space=” custom_margin=” margin=’0px’ row_boxshadow=” row_boxshadow_color=” row_boxshadow_width=’10’ link=” linktarget=” link_hover=” padding=’0px’ highlight=” highlight_size=” border=” border_color=” radius=’0px’ column_boxshadow=” column_boxshadow_color=” column_boxshadow_width=’10’ background=’bg_color’ background_color=” background_gradient_color1=” background_gradient_color2=” background_gradient_direction=’vertical’ src=” background_position=’top left’ background_repeat=’no-repeat’ animation=” mobile_breaking=” mobile_display=” av_uid=’av-1673qtpi’]
[av_textblock size=” font_color=” color=” av-medium-font-size=” av-small-font-size=” av-mini-font-size=” av_uid=’av-l76muyqg’ admin_preview_bg=”]
Here I think we not only have the strongest inter-Category relationships in the whole store during 2022 Q2, but at least three other consequences.
- First, these relationships may suggest novel in-store arrangements to our grocer.
- Second, these relationships might motivate our grocer to spend more time disaggregating Categories according to shoppers’ habits–maybe “VEG-BEAN-RICE-STUFFING-MEAT” is too broad and obscures more useful relationships?
- Third, and something we might cover in a future post, whether finding relationships between SKUs or Categories, marketing may comb through these relationships in order to discover new strategies to satisfy shoppers’ demands with personalized outreach.
See you next time and don’t hesitate to let us know what you think!
[/av_textblock]
[/av_one_full]