Limited SKU-Level ROAS Tracking

Link to the video: https://drive.google.com/file/d/1fLyLmeTlpzJ8ltJmRupX0pQZMDolBOTb/view?usp=drive_link

To solve this problem, I want to create a Nextjs based frontend with a fastapi backend that utilises Python to parse sheets and run calculation operations, and sends back insights which are charted by the frontend. The user can upload their own CSV and then manually choose which column refers to what kind of values. Then, the user can enter what SKU IDs refer to what category of products. Then, the results of the calculations made by the backend can help figure out which products are at high risks of stockouts, which ads are actually performing well, and which marketing strategies aren't working for the company.

With the charts, there will also be red/yellow/green signals to denote healthy / at risk / critical for each SKU.

Downloadable PDFs, Links and QR codes to reports generated based on these insights and data can be easily shared with users.

Gen AI will be used for plain text natural language insights and a chatbot

There will also be an algorithm to calculate client commissions based on Google Ads spendings. It will also have suggestions on how ad campaigns can be optimized to increase commissions by X%.