📁 E-commerce
Amazon Seller Prompt: Business Report to Action Plan
Turn Seller Central numbers into an ASIN health table: conversion, ACoS vs break-even, TACoS, weeks of cover, reorder math, and the three fixes to make first.
0Reviews
Prompt
Act as an Amazon marketplace account manager who reviews a private label seller's Seller Central numbers every week, computes every metric from the exported figures, and turns them into a short list of fixes the seller can make this week. Inputs: - Store snapshot: what you sell, number of ASINs, fulfillment method: [StoreSnapshot] - Business Report figures per ASIN for the period: sessions, units ordered, ordered product sales, Featured Offer (Buy Box) percentage: [ASINMetrics] - Advertising figures per ASIN: spend and ad-attributed sales: [AdMetrics] - Margin before ads per ASIN, as a percentage of price: [MarginBeforeAds] - Inventory: units available, supplier lead time, and reorder rule: [InventoryAndLeadTime] - Returns, return reasons, and review themes you have read: [CustomerFeedback] - This month's goal: [SellerGoal] Generate: 1. ASIN health table with the math shown: unit session percentage (units / sessions), ACoS (ad spend / ad sales), TACoS (ad spend / ordered product sales), break-even ACoS (equal to MarginBeforeAds), weekly sales rate, weeks of cover, and return rate. 2. Status per ASIN: healthy, watch, or fix now, with the one number that decides it. 3. The three fixes to make first, ranked against SellerGoal, each with the exact Seller Central place to check (for example the search term report or the Featured Offer column). 4. Reorder plan using the reorder rule in InventoryAndLeadTime, with the order quantity worked out. 5. Listing fixes suggested by CustomerFeedback (images, bullets, size or fit details), written as tasks, not new copy. 6. A neutral review request process and one Buyer-Seller Messaging template for a real order issue, following Amazon's review rules. 7. What to check again next week, with the target number for each. Rules: - Compute every metric from the Inputs. No market benchmarks, category averages, or predicted sales. - If a figure is missing, write "need: [figure]" instead of estimating. - No incentives, discounts, or refunds tied to reviews, and no review requests sent only to happy customers.
Instructions
Run this in ChatGPT (it also works in Claude or Gemini) with numbers you export yourself from Seller Central (Business Reports, Advertising, and inventory pages). Replace every [bracket]. Amazon's customer review policies ban offering anything in exchange for reviews and asking only happy buyers, so request reviews only in a neutral way (for example the Request a Review button) and contact buyers only through Buyer-Seller Messaging.
Generated Output
This image was generated using the prompt above.
Examples
Example Input
StoreSnapshot: kitchen tools brand, 3 ASINs, all FBA. ASINMetrics (last 4 weeks): - ASIN A, silicone baking mat 2-pack, $24: sessions 2,400, units 168, sales $4,032, Featured Offer 98%. - ASIN B, bamboo utensil set, $30: sessions 1,900, units 57, sales $1,710, Featured Offer 96%. - ASIN C, stainless chainmail scrubber, $16: sessions 650, units 39, sales $624, Featured Offer 71%. AdMetrics (last 4 weeks): A spend $620, ad sales $2,480. B spend $540, ad sales $1,080. C no ads. MarginBeforeAds: A 35%, B 40%, C 45%. InventoryAndLeadTime: available A 410, B 300, C 60. Supplier lead time 5 weeks for all. Rule: reorder when weeks of cover fall below lead time + 2 weeks; order enough for the lead time plus 12 weeks of sales, minus stock on hand. CustomerFeedback: B had 4 returns, reason "smaller than expected"; two reviews say the spoons are short. No returns on A or C. SellerGoal: grow profit this month, not just sales.
Example Output
1. ASIN HEALTH TABLE (last 4 weeks) | Metric | A baking mats | B utensil set | C scrubber | | Unit session % | 168 / 2,400 = 7.0% | 57 / 1,900 = 3.0% | 39 / 650 = 6.0% | | ACoS | 620 / 2,480 = 25% | 540 / 1,080 = 50% | no ads | | TACoS | 620 / 4,032 = 15.4% | 540 / 1,710 = 31.6% | 0% | | Break-even ACoS | 35% | 40% | 45% | | Weekly sales | 168 / 4 = 42 | 57 / 4 = 14.25 | 39 / 4 = 9.75 | | Weeks of cover | 410 / 42 = 9.8 | 300 / 14.25 = 21.1 | 60 / 9.75 = 6.2 | | Return rate | 0% | 4 / 57 = 7.0% | 0% | | Featured Offer | 98% | 96% | 71% | 2. STATUS - A: healthy. ACoS 25% is under its 35% break-even. - B: fix now. ACoS 50% is above its 40% break-even, so ad-attributed sales lose money before fixed costs. - C: fix now. Featured Offer 71% and 6.2 weeks of cover, under the 7-week reorder line (5 + 2). 3. THREE FIXES, RANKED FOR PROFIT 1) B ads: open the search term report for B's campaigns, lower bids or add negatives on terms with spend and no orders, and pause any that stay above 40% ACoS. This is the biggest profit leak: $540 spent for $1,080 in ad sales. 2) C Featured Offer: check the Featured Offer column in the Business Report by day and the offer listing for C. The share drops when another seller wins the offer, your offer is out of stock or suppressed, or your price is not eligible. Fix the cause before buying ads for C. 3) B listing: 4 returns for "smaller than expected" and two reviews about short spoons point to missing size information (see part 5). Fix this before raising B's ad budget again. 4. REORDER PLAN C: cover 6.2 weeks is below 7. Order = 9.75 x (5 + 12) - 60 = 165.75 - 60 = 105.75, so order 106 units now. A: 9.8 weeks, above 7. Check again next week (about 2.8 weeks above the line). B: 21.1 weeks. No order. 5. LISTING FIXES (B) - Add the length of each utensil to the first bullet. - Add one image of the set next to a common object for scale. - Check that the size chart or dimensions field matches the product. 6. REVIEWS AND MESSAGES - Use the Request a Review button in order details, once per order, 5 to 30 days after delivery. No incentives, no asking only happy buyers, no asking anyone to change a review. - Template for a real issue (Buyer-Seller Messaging): "Hi, thanks for your order [order ID] of the bamboo utensil set. We saw you returned it because it was smaller than expected. We're adding exact sizes to the listing. If you have a question about your refund, reply here and we'll help." 7. CHECK NEXT WEEK - B ACoS: under 40%. - C Featured Offer: back above 90%, and the reorder of 106 units placed. - A weeks of cover: still above 7. - B returns for size: none new after the listing update.