Quick Start

Input phrases: "boho earrings", "macrame wall hanging"

For each phrase:
1. Search Etsy Marketplace Insights
2. Record: searches, listings, top 5 buyer search terms
3. Add related terms >20 searches as new rows
4. Calculate opportunity score (searches ÷ listings)
5. Sort by opportunity score descending

Workflow

Progress:

• Access Etsy Marketplace Insights tool
• Input each target phrase
• Extract core metrics (searches, listings)
• Capture "Discover what buyers are searching for" top 5 terms
• Scan for related terms with >20 searches
• Calculate opportunity scores for all terms
• Categorize by search volume thresholds
• Sort final table by opportunity score (highest first)
• Format as clean table

Data Collection Steps:

1. Enter phrase in Marketplace Insights search
2. Record monthly searches and active listings
3. Note top 5 buyer search suggestions
4. Scan related/suggested terms for volume >20
5. Repeat for each discovered high-volume term

Calculation:

• Opportunity Score = Monthly Searches ÷ Active Listings
• Round to 2 decimal places

Categorization Rules:

• Primary: ≥10 monthly searches
• Secondary: 1-9 monthly searches
• Dead: 0 monthly searches

Examples

Example 1: Input: "vintage rings" Raw Data: 2,450 searches, 89,200 listings Top 5 Terms: "vintage engagement rings", "antique rings", "vintage gold rings", "estate rings", "retro rings" Related Terms >20: "vintage diamond rings" (156 searches, 12,400 listings)

Output Row:

Example 2: Input: "handmade soap"
Output Table:

Best Practices

• Access Required: Must have Etsy seller account with Marketplace Insights access
• Fresh Data: Use current month's data; insights update regularly
• Threshold Discipline: Stick to >20 search minimum for related terms
• Complete Extraction: Don't skip low-opportunity terms; include all for complete picture
• Sort Consistency: Always sort by opportunity score descending
• Clean Formatting: Remove special characters, normalize spacing

Common Pitfalls

• Don't skip zero-search terms - These reveal dead keywords to avoid
• Don't round opportunity scores prematurely - Keep precision for accurate sorting
• Don't ignore seasonal patterns - Note if data seems seasonally skewed
• Don't mix data timeframes - Use same reporting period for all terms
• Don't stop at surface level - Dig into related terms; often the best opportunities hide there
• Don't ignore high-listing terms - Even saturated markets can have profitable niches