How to Use a Large Data Set to Analyze Profit on a Weekly Basis Based on Whether or not a Product Is Featured

Hi all,

I have a large data set for sales information (Profit, quantity sold, profit %, etc.) that is broken down on a weekly basis. I am looking to take that data and change it in a manner that allows me to analyze if an item is more profitable when it is "featured" or not. This is associated with a tag of "yes" or "Not" in the data set. Essentially I am lookin to compare Profit $ sold on items when they have the "Yes" tag and when they do not have the "not" tag. Is there a way that I can manipulate the data to make this a little more straight forward and "automated"?

For example. I want to compare the average profit/week on Product A for weeks that it was featured compared to the average profit/week for when it was not featured. The link has a current example of what I have as well as an example data set. But this is all manual addition and is too much to maintain on a regular basis. There is also a link below with an example data set. I have 2 items listed per month on the data set, but my actual data set will have ~150 items/month.

Currently, I have an excel program that runs and pulls the sales data from my inventory management system. This excel sheet I then dump into Sheets (I like the remote functionality of sheets more so I use sheets). So this data is manually dumped into the data sheet at the beginning of each week.

I am open to any suggestions that could make this process easier

https://docs.google.com/spreadsheets/d/1LO0g3E3lxwxQOfO5nMngxiZxoueCqErzjdtZu-Si3GU/edit?usp=sharing