1. Find what actually moved
Compare last 30 days to the previous 30 days. Show the 10 SKUs with the biggest drop in net profit, with net sales, ad spend, units and contribution margin for both periods.
Ranking by profit change rather than sales change filters out the SKUs that only look busy. The paired columns let you see instantly whether the cause is volume, price or spend.
2. Ask why, on one SKU
For the worst SKU in that list, explain the movement: traffic, conversion rate, average price, buy box share, promotions, ad spend and rank, this period versus last.
This is the follow-up that stops the guesswork. A conversion drop with stable traffic is a listing or price problem; a traffic drop with stable conversion is a rank or ad problem.
3. Catch the money-losers
List every SKU with negative net profit over the last 60 days, sorted by total loss, with units sold and the largest fee category for each.
The fee column turns a list into a plan: oversize fulfilment, storage and returns each imply a different fix.
Add one line to every analysis prompt
Finish with: "State any figure you could not retrieve rather than estimating it." Assistants are far better at flagging a gap when you give them permission to. It converts silent hallucination into an explicit missing data point.