Data-driven
Etsy shop audit grounded in hard numbers
Created by a verified developer holding Official Etsy Developer Access. Upload your EtsyListingsDownload.csv and EtsySoldOrderItems.csv exports to get back an empirical audit with Pareto revenue concentration, 10-point niche coherence scoring, diagnostic bottleneck classification, listing triage, and a 3-tier workplan. No API setup required.
Privacy first: 100% free. No registration or subscription needed. Runs inside your existing AI tool.
Quantitative analysis, not generic advice
Most shop reviews give vague opinions like "fix your photos." Our system analyzes actual listing data and CSV sales history to pinpoint structural bottlenecks.
CSV Data Extraction
Run scripts/csv_analyzer.py on your EtsyListingsDownload.csv and EtsySoldOrderItems.csv. Generates hard metrics on revenue skew, price distribution, and tag utilization.
Pareto & Niche Scoring
Calculates exact Pareto revenue concentration (80/20 rule) and evaluates 10-point Niche Coherence by clustering listing titles into clear customer segments.
Bottleneck Matrix
Classifies listings into 4 diagnostic buckets: Traffic Starved (low impressions), Click Starved (low CTR), Conversion Starved (low CR), and Champion Listings (scale ready).
3-Tier Action Workplan
Outputs a prioritized execution roadmap: Week 1 Quick Wins (tags & titles), Week 2–3 Refactorings (descriptions & pricing), and Month 2 Strategic Scaling (new products).
Copy & run inside Claude, ChatGPT, or Gemini
Paste this prompt along with your CSV data summaries or shop details to generate a complete empirical audit.
You are an expert Etsy Shop Auditor built by an Official Etsy Developer. Conduct a rigorous, quantitative audit of the Etsy shop data provided below using empirical CSV analytics. Perform the following 5 diagnostic checks: 1. PARETO REVENUE CONCENTRATION: Analyze revenue distribution across listings. Calculate what % of listings generate 80% of revenue. Identify top revenue anchors vs dead weight. 2. NICHE COHERENCE SCORE (1-10): Evaluate product catalog cohesion. Group listings into customer intent clusters and flag orphan listings that dilute store authority. 3. DIAGNOSTIC BOTTLENECK MATRIX: Classify listings into 4 performance states: - Traffic Starved (High CR / Low Impressions -> Needs Tag & Title SEO) - Click Starved (High Impressions / Low CTR -> Needs Main Image & Price Fix) - Conversion Starved (High CTR / Low CR -> Needs Listing Description & Guarantee Fix) - Champion (High Impressions, High CTR, High CR -> Scale & Expand) 4. LISTING TRIAGE TABLE: Create a prioritized table of top 10 listings needing immediate action with current metric vs target metric. 5. 3-TIER ACTION WORKPLAN: - Tier 1: Immediate Quick Wins (Days 1-7) - Tier 2: Core Refactoring (Weeks 2-3) - Tier 3: Strategic Catalog Expansion (Month 2+) Here is my shop data / CSV output: [PASTE YOUR CSV ANALYSIS OUTPUT OR SHOP SUMMARY HERE]📋 Copy Audit Prompt
Want a Personalized Expert Audit Review?
Submit your shop details through our confidential Google Form review request. We'll run full python CSV analytics and send you a custom diagnostic report.
Request Form Audit Review →