amazon-backend-report

# Amazon Backend Report Analyzer Automatically analyze Amazon Seller Central reports — business performance, inventory health, advertising, and financial data — and surface the insights that matter most for your business. Paste your exported report data. The agent processes it, identifies anomalies, highlights opportunities, and outputs a clear performance summary with prioritized action items. ## Commands ``` report business <data> # analyze business report (traffic + conversion) report inventory <data> # analyze inventory health report report advertising <data> # analyze advertising performance report report financial <data> # analyze financial/payment report report fba <data> # analyze FBA performance and fees report returns <data> # analyze returns and refunds report report search-terms <data> # analyze search term report from ads report compare <period1> <period2> # compare two time periods report digest # generate weekly management digest report save <period> # save analysis to workspace ``` ## What Data to Provide - **Report data** — paste CSV/text data from any Seller Central report - **Time period** — which date range the report covers - **Historical baseline** — prior period data for comparison (if available) - **Goals** — your targets (revenue, ACOS, margin, etc.) - **ASIN list** — specific products to focus on ## Report Analysis Framework ### Business Report Analysis **Key metrics in Business Report:** ``` Column What to track Benchmark Sessions Unique visitors Growing week-over-week Page Views Total product page views Ratio to sessions Buy Box % % of time you own Buy Box >90% Units Ordered Units sold per period Week-over-week trend Unit Session % Conversion rate >10% (varies by category) Ordered Product Sales Revenue by ASIN Growing trend ``` **Conversion rate diagnostic:** ``` CVR < 5%: Listing issue — images, bullets, or price problem CVR 5-10%: Below average — improve weakest listing element CVR 10-15%: Good — optimize further for incremental gains CVR > 15%: Excellent — scale traffic with ads ``` **Sessions dropping:** - External algorithm change - Out-of-stock event caused ranking loss - Competitor improved listing quality - Seasonal demand shift - Ad spend reduced **Sessions growing, revenue not growing:** - Price decreased (more traffic, same revenue) - Conversion rate dropped (traffic quality changed) - Returns increased (inflating gross revenue, but refunds eating margin) ### Inventory Health Report Analysis **Key inventory metrics:** ``` Metric Target Action if violated Days of Supply 30-60 days Reorder if <30 days Inventory Age (0-90d) >90% of stock Monitor aging inventory Inventory Age (91-180d) <10% of stock Run promotions to clear Inventory Age (180d+) <2% of stock Deep discount or removal Stranded Inventory 0 units Fix listing issues immediately Unfulfillable Units 0 units Remove or dispose Excess Inventory <30 days excess Reduce reorder quantity ``` **Long-term storage fee risk:** - Units stored >181 days incur additional fees ($1.50/cubic foot/month) - Units stored >365 days: $6.90/cubic foot/month - Action: identify aging SKUs and run promotions before 181-day mark **Inventory planning dashboard:** ``` ASIN | Units | Daily Sales | Days Cover | Reorder Point | Order Now? BXXX | 450 | 15/day | 30 days | 150 units | ⚠ Yes BYYY | 800 | 10/day | 80 days | 100 units | ✓ No BZZZ | 50 | 5/day | 10 days | 75 units | 🚨 Urgent ``` ### Advertising Report Analysis **Search Term Report (most important ad report):** ``` Analysis steps: 1. Sort by Spend descending — find where budget is going 2. Find terms with high spend, zero conversions → Negative match 3. Find terms with conversions, good ACOS → Add to Exact campaign 4. Find terms with high impressions, 0 clicks → Review bid or relevance 5. Compute true ACOS per term: Ad Spend / Ad Sales × 100 ``` **ACOS benchmarks by action:** ``` ACOS < 15%: Raise bids — underinvesting in profitable keywords ACOS 15-25%: Maintain — at break-even or profitable range ACOS 25-35%: Review — marginal, may be justified for ranking ACOS > 35%: Reduce bids or pause — unprofitable ``` **Campaign performance buckets:** ``` Bucket ACOS Impressions Conversions Stars: <20% High High → Scale budget Cash Cows: <20% Low Moderate → Increase bids Potential: 20-35% High Low → Improve listing Underperformers: >35% Any Low → Reduce or pause ``` ### Financial Report Analysis **Key financial metrics:** ``` Metric Formula Target Gross Revenue Sum of product sales — Amazon Fees Referral + FBA + storage + ads <40% of revenue Returns/Refunds Refund amount / gross revenue <5% Net Revenue Gross - Returns - Fees — Net Margin Net Revenue / Gross Revenue >20% ``` **Fee percentage benchmarks by category:** ``` Category Referral FBA Total Fees Net Margin Target Electronics 8% $5-8 18-22% >25% Home & Kitchen 15% $4-6 22-26% >20% Clothing 17% $3-5 22-26% >20% Beauty 15% $3-5 21-25% >22% ``` **Cash flow planning:** ``` Disbursement cycle: Every 14 days (typically) Reserved amount: Amazon holds ~7 days of sales as reserve Working capital needed: 45-60 days of COGS (production + freight + reserve) ``` ### Weekly Management Digest Format ``` WEEK OF [DATE] — PERFORMANCE DIGEST 📊 REVENUE This week: $XX,XXX | Last week: $XX,XXX | Change: +/-X% YTD: $XXX,XXX | YTD goal: $XXX,XXX | On track: Yes/No 📦 INVENTORY Total units: X,XXX | Days of supply: XX days ⚠ Low stock: [ASIN list] 🚨 Urgent reorder: [ASIN list] 📢 ADVERTISING Ad spend: $X,XXX | ACOS: XX% | ROAS: X.Xx Best performer: [term] at X% ACOS Worst performer: [term] at X% ACOS — ACTION NEEDED ⚠ ALERTS [List of any anomalies detected] ✅ TOP 3 ACTIONS THIS WEEK 1. [Highest priority action] 2. [Second priority] 3. [Third priority] ``` ## Workspace Creates `~/backend-reports/` containing: - `business/` — business report analyses by period - `inventory/` — inventory health tracking - `advertising/` — ad performance archives - `financial/` — financial summaries - `digests/` — weekly management digests ## Output Format Every report analysis outputs: 1. **Performance Summary** — key metrics vs. prior period with trend indicators 2. **Anomaly Detection** — unusual patterns that require attention 3. **Inventory Status** — stock health with specific reorder actions 4. **Ad Performance** — ACOS summary with specific optimization actions 5. **Financial Health** — margin and fee analysis 6. **Priority Action List** — top 5 actions ranked by expected business impact 7. **Next Week Forecast** — projected performance based on current trends