AI Skill Report Card
Analyzing Etsy Market Structure
Quick Start
Search your seed phrase in ProfitTree with filters: Digital only, Sort by Monthly Sales, Under 24 months old. Extract top 5-10 listings into this table:
| Rank | Title | Price | Mo. Sales | Mo. Revenue | Total Revenue | Views | Listing Age |
|---|
Calculate revenue concentration: (Top 3 revenue / Total revenue) × 100
Workflow
Step 0: Multi-Phrase Search Execution
- Search EACH phrase variation individually in ProfitTree
- Apply standard filters to all searches
- Capture top 5-10 listings per phrase
- Merge results and remove duplicates
- Create master dataset
Output Search Coverage Map:
| Phrase | Listings Found | Top Listing Revenue | Notes |
|---|
Step 1: ProfitTree Structure Analysis
- Extract structured data table
- Calculate revenue concentration percentage
- Map pricing band distribution (Low <$12, Mid $12-25, Premium $25+)
- Identify market type (Bundle-dominant, Single-sheet, Premium, Race-to-bottom)
Step 2: Product Structure Extraction
- Open top 3-5 listings
- Extract format stack (Excel, Sheets, PDF, Word, Bundle)
- Assess functional depth (Auto-calc, Dashboard, Multi-sheet, Industry-specific)
- Map value positioning language (Template, System, Toolkit, Pro, Ultimate)
Step 3: Thumbnail Deconstruction
- Analyze hero strategy for top 3 listings
- Extract messaging themes
- Score mobile legibility (1-5)
- Assess saturation patterns
Step 4: SEO Structure Mapping
- Break down title structures
- Map tag clusters (Core phrase, Industry, Format, Benefit, Adjacent)
- Identify SEO patterns
Step 5: Review Intelligence
- Extract buyer feedback patterns
- Map complaints to specific gaps
- Identify what buyers love vs. complain about
Progress tracking:
- Step 0: Multi-phrase search complete
- Step 1: Structure analysis complete
- Step 2: Product extraction complete
- Step 3: Thumbnail analysis complete
- Step 4: SEO mapping complete
- Step 5: Review intelligence complete
Examples
Example 1: Input: "invoice template" seed phrase Output:
MARKET STRUCTURE SUMMARY
- Demand strength: High (847 listings)
- Revenue concentration: 23% (top 3 control)
- Pricing dominance: Mid-tier ($15-20)
- Bundle penetration: 67%
STRUCTURAL WEAKNESSES
- Product gaps: Auto-calculation missing in 80%
- Visual gaps: Text-heavy thumbnails dominate
- SEO blind spots: Industry-specific modifiers underused
- Premium opportunity gap: Yes
Example 2: Input: "purchase order tracker" Output:
SEARCH COVERAGE MAP
| Phrase | Listings Found | Top Listing Revenue | Notes |
| purchase order | 34 | $2,400/mo | Strong demand |
| PO tracker | 12 | $890/mo | Different product type |
| order tracking | 67 | $3,200/mo | Fragmented demand |
MARKET COVERAGE SUMMARY: Demand fragmented across variations
Best Practices
- Only analyze allowed categories: Business templates, operational tools, service business documents
- Focus on revenue structure: Don't interpret strategy, just expose patterns
- Extract, don't recommend: Map what exists, don't suggest what to build
- Use exact ProfitTree data: Don't estimate or assume metrics
- Score mobile legibility objectively: 1=unreadable on mobile, 5=perfectly clear
- Map tag clusters systematically: Group by function, not personal preference
Common Pitfalls
- Don't recommend products - Only analyze existing market structure
- Don't suggest pricing - Only report current pricing patterns
- Don't analyze banned categories - Reject planners, habit trackers, wedding templates, fitness, aesthetic designs
- Don't interpret buyer intent - Only report what reviews explicitly state
- Don't calculate ROI - Focus on revenue patterns, not profitability advice
- Don't validate search volume - Only analyze ProfitTree monetization data
Hard rejection criteria: If phrase doesn't fit business template categories, immediately state why and stop analysis.