Your Seller Labs MCP server connects your Amazon data directly to Claude. Instead of building reports manually, you ask questions in plain English and get instant, data-backed answers.

This prompt library gives you 55 copy-paste prompts organized by what you're trying to accomplish. Each prompt is designed to pull data from your Data Hub tables and return actionable insights.

How to use: Copy any prompt below, paste it into Claude, and hit enter. Claude will query your Seller Labs data through the MCP and return the results. Modify the time ranges or thresholds to fit your business.

1. Campaign health check

Show all my active campaigns for the last 30 days sorted by ACOS (highest first). Include spend, sales, impressions, clicks, and ACOS. Highlight campaigns with ACOS above 40%.

2. Find wasted ad spend

Find search terms where I spent more than $20 in the last 30 days but had zero sales. Group them by campaign and ad group. These are candidates for negative keywords.

3. Top performing keywords

Show my top 25 keywords by total sales for the last 30 days. Include impressions, clicks, spend, ACOS, and conversion rate for each.

4. Keyword harvesting opportunities

Find search terms from the last 30 days that generated at least 2 sales but are NOT currently set up as exact or phrase keywords in any campaign. List them with sales, ACOS, and source campaign.

5. Negative keyword audit

Pull all my negative keywords across all campaigns. Cross-reference with search term performance. Flag any negatives that are blocking search terms that actually converted in the last 90 days.

6. Bid optimization recommendations

For all campaigns, show current average CPC and ACOS. Based on a target ACOS of 25%, recommend which campaigns need bid increases vs. decreases.

7. Ad spend vs. actual profit

For my top 15 advertised ASINs, show ad spend, total revenue (organic + paid), all fees, COGS, and true net profit for the last 30 days. Which ASINs are actually profitable after ad costs?

8. Day-of-week performance

Break down my ad spend, sales, and ACOS by day of the week for the last 90 days. Which days perform best? Should I adjust bids by day?

9. Auto vs. manual campaign comparison

Compare all auto-targeting campaigns vs. manual campaigns for the last 30 days. Show spend, sales, ACOS, and conversion rate for each type.

10. Keyword cannibalization check

Find keywords that appear in more than one campaign. For each duplicate, show campaign, match type, bid, spend, sales, and ACOS. Flag cases where the same keyword performs very differently across campaigns.

11. Search term mining by ASIN

For my top 5 ASINs by revenue, show the search terms driving the most ad sales in the last 30 days. Which search terms are converting best for each product?

12. Budget pacing analysis

Identify campaigns where daily spend consistently hits the daily budget. For those, show their ACOS — if ACOS is good, I should increase budget. If ACOS is high, I should lower bids.

13. Portfolio performance summary

Show each portfolio with its total spend, total sales, and ACOS for this month vs. last month. Which portfolios are improving?

14. New-to-brand customer analysis

Using purchased products by keyword data, show what percentage of my ad-driven purchases are from new-to-brand customers. Break this down by my top 10 campaigns.

15. ACOS trend over time

Show my weekly ACOS trend for the last 12 weeks across all campaigns. Is my advertising efficiency improving or getting worse? What changed in the weeks it spiked?

16. Review gap analysis

For all my active listings, calculate the ratio of reviews to units sold in the last 90 days. Show the 20 ASINs with the lowest review-to-sales ratio — these need review request priority.

17. Products with rating problems

Flag any products with a star rating below 4.0. Show current rating, review count, units sold, and revenue. Sort by revenue so I know which ones to fix first.

18. Review rate by product

For my top 20 ASINs by units sold, show: units sold (last 90 days), current review count, star rating, and estimated review rate. Which products are getting reviews and which aren't?

19. High-value orders for follow-up

Pull my top 50 orders by revenue from the last 30 days. High-value customers are more likely to leave detailed reviews — these are priority candidates for custom follow-up messages.

20. Top repeat-purchase SKUs

Analyze my order items for the last 180 days. Which SKUs have the highest number of repeat orders (same SKU appearing in multiple separate orders)? Show the top 20 SKUs by repeat order count, along with total units sold and revenue. These high-repeat products are the best candidates for review request campaigns since buyers clearly like the product.

21. Review requests vs. eligible orders

How many orders were placed in the last 30 days? How many have reached the review request eligibility window (5-30 days after delivery)? This tells me the maximum review requests I could be sending.

22. Negative review impact on sales

Pull my product reviews data and cross-reference with sl_daily_sku_profit by ASIN and date. For any ASINs where the star rating dropped in the last 30 days, show daily sales for the 7 days before and 7 days after the rating change. Note: the exact date a review was posted may not align perfectly with when the rating changed on the listing page, so look for the general trend rather than a single-day correlation.

23. Marketplace review comparison

For each connected marketplace, show total orders (last 30 days), review count, and average star rating. Which marketplaces have the weakest review profiles?

24. SKU profitability breakdown

For my top 20 SKUs by revenue (last 30 days), break down: gross revenue, referral fees, FBA fees, ad costs, COGS, and net profit. Show profit margin for each. Which SKUs are losing money?

25. Complete fee breakdown

Show my total fees for last month broken into categories: referral fees, FBA fulfillment, storage, advertising, and other charges. What percentage of gross revenue does each category represent?

26. Weekly profit trend

Show weekly revenue, total fees, COGS, and net profit for the last 12 weeks. Is profit growing faster or slower than revenue?

27. Monthly P&L statement

Generate a profit and loss statement for last month: gross revenue, returns, net revenue, all fee categories, COGS, and net profit. Compare to the previous month with dollar and percentage change.

28. Unprofitable products

Find all ASINs where net profit margin is below 5% or negative for the last 30 days. For each, show revenue, all fees, COGS, and net margin. These products need pricing or cost adjustments.

29. FBA fee analysis

Calculate the average FBA fee per unit for each ASIN. Show which products have the highest FBA fees relative to selling price. Sort by FBA fee as a percentage of revenue.

30. COGS impact calculator

Show which ASINs have COGS entered and which don't. For ASINs missing COGS, show estimated margin at 30%, 40%, and 50% COGS so I can see the range.

31. Revenue by marketplace

Show monthly revenue per marketplace for the last 12 months. Which marketplaces are growing and which are declining?

32. Return rate and cost

Calculate return rate (returned units / sold units) for each ASIN over the last 90 days. For the top 10 by return rate, show units sold, units returned, refund amount, and estimated lost profit.

33. Price vs. margin analysis

For my top 20 ASINs, show current price, all fees as percentages, COGS, and net margin. If I raised prices 5% on the lowest-margin products, what would the new margin be?

34. Seasonal profit patterns

Show month-by-month revenue and profit for the last 12 months. Which months are my peak and which are slow? For my top 5 SKUs, when do they sell best?

35. Ad spend ROI by product

For each advertised ASIN, show total ad spend, ad-attributed sales, organic sales, and net profit after all costs. Calculate the true ROI of advertising for each product.

36. Stockout risk alert

Pull my fba_inventory table (use afn_fulfillable_quantity for current stock) and calculate average daily units sold from sl_daily_sku_profit for the last 30 days. For each ASIN, show current FBA quantity, daily sales velocity, and estimated days of supply remaining. Flag anything under 14 days — these are stockout risks.

37. Overstock identification

Using fba_inventory (afn_fulfillable_quantity) and daily sales velocity from sl_daily_sku_profit, find ASINs with more than 180 days of inventory supply. Show current units in stock, daily sales rate, and days of supply. These are tying up capital and may incur long-term storage fees.

38. Inventory health dashboard

Join fba_inventory with sl_daily_sku_profit to calculate days of supply for all ASINs. Bucket them into: critical (under 14 days), low (14-30 days), healthy (30-90 days), and overstock (over 90 days). Show the count and total estimated value in each bucket.

39. Reorder planning

For my top 20 ASINs by revenue, show current FBA stock (afn_fulfillable_quantity), daily sales velocity, and the projected stockout date at the current pace. Note: you'll need to enter your own lead time per product — use 30 days as a default if unsure. Flag any ASIN where the stockout date falls within the lead time window.

40. Sales rank trends

Show my sales rank changes for the last 30 days for my top 10 ASINs. Are any products losing rank consistently? Correlate rank drops with any changes in price, reviews, or ad spend.

41. Weekly business summary

Give me a business summary for the last 7 days vs. the previous 7 days: total revenue (% change), total orders, total profit, overall ACOS, and top 5 SKUs by revenue. Keep it brief.

42. Year-over-year comparison

Show monthly revenue and orders for this year vs. last year. Calculate YoY growth rate for each month.

43. Cross-marketplace comparison

For all connected marketplaces, show a comparison for the last 30 days: total orders, revenue, average order value, profit, and margin. Rank by profitability.

44. Buy Box analysis

Show Buy Box percentage for each ASIN from my business reports. Flag products below 90% Buy Box or where it dropped more than 5% week-over-week. Show the estimated revenue impact.

45. Conversion rate analysis

From my business reports, show sessions, page views, and conversion rate for my top 20 ASINs. Which products have high traffic but low conversion? These need listing optimization.

46. Account health overview

List all connected venues with their status. For each, show when it was connected, which data tables have records, and the most recent data date. This tells me what's synced and what isn't.

47. Transaction data check

Show the latest transaction dates in my data. How many days is the data lagged from today? Group recent transactions by settlement period to explain timing.

48. SQP (Search Query Performance) report

Pull my latest Search Query Performance data. Show the top 20 search queries by impressions with click share, purchase share, and conversion rate.

49. Product catalog overview

Show total active ASINs, then my top 20 by revenue. What percentage of total revenue comes from my top 10 products? How concentrated is my business?

50. Full business diagnostic

Give me a complete diagnostic: (1) Revenue trend and profit margin for last 6 months, (2) Top 5 and bottom 5 SKUs by profitability, (3) Overall ACOS and worst campaigns, (4) Stockout and overstock risks, (5) Products with ratings below 4.0, (6) The single biggest opportunity to improve profitability right now.

51. Return reason analysis

Pull my returns data for the last 90 days. Break down returns by reason code (defective, not as described, no longer needed, etc.). For each reason, show the number of returns, total refund amount, and the top 3 ASINs. Which return reasons are within my control to fix?

52. FBA reimbursement audit

Pull my fba_reimbursements_data for the last 90 days. Show total reimbursements received, broken down by reason (lost, damaged, customer return, fee correction). Are there ASINs with unusually high reimbursement activity? How much has Amazon reimbursed me in total?

53. Seller feedback health

Pull my seller_feedback data. Show my overall seller feedback rating, total feedback count, and the breakdown of positive vs. neutral vs. negative feedback for the last 90 days. Flag any recent negative feedback and the associated order so I can investigate.

54. Upcoming FBA fee impact

Pull my fba_fee_preview data. Show which of my ASINs will be affected by upcoming fee changes. For each affected ASIN, show the current fee, the new fee, the dollar difference, and the impact on my per-unit margin. Which products will be hit hardest?

55. Subscribe & Save performance

Pull my sns_performance_data. Show all ASINs enrolled in Subscribe & Save with their subscription count, subscription revenue, and discount tier. Which products have the most active subscribers? Are there products with high sales but low S&S enrollment that I should promote?