Systems and methods for determining impact of high-affinity baskets

A computer system comprising:

• a database configured to store a dataset representing historical transaction data for a plurality of items sold by at least one entity where the dataset comprises transaction data representing transactions associated with at least one promoted item during a time period;
• a computer configured to execute a browser application;
• and
• a server in communication with the computer and the database, the server configured to:
• retrieve the dataset from the database;
• execute a first filtering protocol to generate a first file comprising an affinity item where the affinity item is associated with a first attach rate to the promoted item and a first frequency of purchase rate satisfying a first threshold within the time period;
• execute a second filtering protocol to generate a second file comprising a cannibalized item where the cannibalized item is associated with a second attach rate to the promoted item and a second frequency of purchase rate satisfying a second threshold within the time period;
• automatically calculate an aggregated impact value for the promoted item, the aggregated impact value comprising an first impact value for the affinity item, and a second impact value for the cannibalized item where the first impact value and the second impact value correspond to a lift change value of the entity during the time period;
• and
• execute a browser application to display a graphical user interface comprising a representation of a total impact of a promotion where the graphical user interface displays the plurality of items sold by the entity including the promoted item, the affinity item, and the cannibalized item where each item of the plurality of items is represented by a circle arranged based on the respective item's attach rate to the promoted item, frequency of purchase rate, and a number of transactions comprising the respective item, wherein a radius of each circle corresponds to each item's aggregated impact value.