Nicole Limson

Task 2 – Filtering Leads For this exercise, you are to narrow down a list of products extracted from a store on Amazon. Follow the instructions completely to yield the expected output. 1. Open this Google Sheet: Product Leads. 2. “Make a copy” of the template then rename the file from “Product Leads” to your complete name. 3. Set the sharing settings of your copy to “Anyone with the link” can “View”. Here are the products that we want:     Those that Amazon do not currently sell With Buy Box price of at least $10 With an estimated monthly share of sales of not less than 25 units With below 8 FBA sellers competing for the Buy Box Narrow the data by deleting the following 1. All lines that contain a Y in the column labeled: Amazon Is Seller? 2. All lines that have a value under $10 in the column labeled: BuyBox Price New $USD 3. All lines with a value less than 25 including blanks in the column labeled: Est. Share of Sales/Month 4. All lines with 8+ sellers in the column labeled: FBA sellers in BuyBox Contention You will also need to delete these columns:       Cost: 50% Storefront Price Pack Size Prime? Extra ASIN column Est. Share of Sales / Month Amazon is Seller? How many products were left?