Build your Amazon product, not the SP-API pipeline

• product_metrics
• orders
• listing_health

Price against real margin, with every fee already mapped to the SKU.

SELECT sku, contribution_margin, amazon_fees, referral_fee, cost_of_goods
FROM product_metrics WHERE metric_date = yesterday();

Trap you skip: Amazon renames fees, and splits the same fee across two APIs. See every trap

• advertising
• advertising_campaigns
• advertising_targets
• advertising_search_terms
• advertising_placements
• advertising_negative_targets
• advertising_impression_share
• product_metrics

Read spend down to the search term and placement, next to the margin it drives.

SELECT search_term, SUM(spend) AS spend
FROM advertising_search_terms
GROUP BY search_term ORDER BY spend DESC LIMIT 10;

Trap you skip: The legacy ads API counts spend twice when two brands share one account. See every trap

• inventory
• inbound_shipments
• orders

Forecast from sellable stock, inbound units and today's orders.

SELECT sku, stock_region, fba_sellable, awd_onhand
FROM inventory WHERE snapshot_date = today();

Trap you skip: Pan-EU stock appears once per country. Sum it and you count five times too much. See every trap

• product_metrics
• orders
• account_costs
• sku_costs
• cost_dictionary

Show profit by SKU and day, with every cost in a named category.

SELECT metric_date, sku, product_sales, net_profit
FROM product_metrics WHERE metric_date >= today() - 30;

Trap you skip: The same fee arrives tax included in one API and net plus VAT in the other. See every trap

• sqp_weekly
• sqp_monthly
• listing_health

Track search volume and purchases per query, and which listings can't be bought.

SELECT search_query, search_volume, your_purchases
FROM sqp_weekly ORDER BY search_volume DESC LIMIT 10;

Trap you skip: Listings reports arrive in the account's language, not the marketplace's. See every trap

• Nova MCP
• or the tables above

Give your agent 43 tools on the same data, in Claude, ChatGPT or Gemini.

AskWhich SKUs lost margin this week, and why?

Trap you skip: An agent reading raw reports answers with the wrong day's numbers, because of time zones. See every trap