
seo-pseo-planner
by ahonn
๐ My vim/neovim, nix, git, and tmux configuration files
SKILL.md
name: seo-pseo-planner description: Plan and design Programmatic SEO (PSEO) strategies for scalable content generation. Use when planning to create hundreds of pages automatically, building content directories, galleries, or curation sites. Helps identify opportunities, design page structures, and plan data pipelines. allowed-tools:
- WebSearch
- Read
- Write
- mcp__gsc__search_analytics
- mcp__gsc__enhanced_search_analytics
Programmatic SEO (PSEO) Planner
Plan scalable SEO content generation strategies that can create hundreds of pages automatically using code.
What is PSEO?
Programmatic SEO leverages programming to generate SEO content at scale. Instead of manually creating each page, you:
- Acquire substantial data
- Shape it into various formats
- Display it to users via automatically generated pages
When to use PSEO:
- You can generate 100+ unique pages
- Content follows a repeatable template
- Data is available or can be collected
- Keywords have clear patterns (e.g., "{style} tattoo ideas")
When NOT to use PSEO:
- Only 3-5 pages needed โ Create manually
- No scalable data source available
- Content would be too shallow/thin
The Six-Step PSEO Framework
Step 1: Identify Opportunities
Criteria for PSEO viability:
โก Can generate 100+ unique pages
โก Clear keyword pattern exists (e.g., "{city} photographers")
โก Low keyword difficulty (KD < 20) for long-tail variations
โก Sufficient search volume across variations
โก Data source available or creatable
โก Content can provide REAL value (not just scraped data)
Good PSEO opportunities:
- Directories (photographers, agencies, tools)
- Inspiration galleries (designs, templates, examples)
- Idea generators (tattoos, names, prompts)
- Comparison pages (tool vs tool)
- Location-based listings
Questions to answer:
- What's the main keyword category?
- How many long-tail variations exist?
- What data will populate each page?
- Can users find this data elsewhere easily? (If yes, add more value)
Step 2: Establish Page Structure
Define your keyword hierarchy:
Main Keyword (head term)
โโโ Category Level
โ โโโ Subcategory Level
โ โ โโโ Individual Pages
Example - Tattoo Ideas:
tattoo ideas (main)
โโโ dragon tattoo ideas (category)
โโโ flower tattoo ideas (category)
โ โโโ rose tattoo ideas (subcategory)
โ โโโ lotus tattoo ideas (subcategory)
โโโ name tattoo ideas (category)
Example - Landing Page Inspiration:
landing page inspiration (main)
โโโ saas landing page (industry)
โโโ product landing page (industry)
โโโ marketing landing page (industry)
โโโ pricing page design (page type)
URL Structure:
/[main-category]/
/[main-category]/[subcategory]/
/[main-category]/[subcategory]/[item]/
Critical: Ensure keyword alignment. Each page targets a DISTINCT keyword to avoid cannibalization.
Step 3: Gather Content (Data Collection)
Data Sources:
| Source | Example | Pros | Cons |
|---|---|---|---|
| User Generated Content (UGC) | User submissions via your tool | Unique, scalable | Needs initial users |
| APIs | Google Maps, Product Hunt | Structured, reliable | Rate limits, costs |
| Web Scraping | Screenshots, competitor data | Rich data | Legal considerations |
| AI Generation | GPT-generated descriptions | Scalable | Quality control needed |
| Public Datasets | Government data, open APIs | Free, authoritative | May need processing |
UGC Strategy (Best for unique content):
- Build a free tool that generates user value
- Collect user inputs and outputs
- Aggregate into categorized pages
- Automated via cron jobs
Example - Tattoos AI:
- Users describe tattoo โ AI generates image
- Cron job collects prompts daily
- Auto-categorizes: "black cat tattoo" โ cat category
- Creates page when category hits 100+ items
Step 4: Shape the Content
Content Processing Pipeline:
Raw Data โ Cleaning โ Enrichment โ Categorization โ Formatting
Enrichment Methods:
| Method | Use Case | Tool |
|---|---|---|
| AI Summarization | Condense long content | GPT-4 |
| Auto-tagging | Categorize items | NLP/Keywords |
| Image Processing | Screenshots, thumbnails | Puppeteer, APIs |
| Data Aggregation | Combine multiple sources | Custom scripts |
| Review Extraction | Ratings, highlights | Scraping + AI |
Tagging Strategy:
- Extract keywords from content
- Map to predefined categories
- Allow multiple tags per item
- Create pages when threshold met (e.g., 50-100 items)
AI Content Guidelines:
- Use AI to ASSIST, not REPLACE human quality
- Always add unique value beyond raw AI output
- Human review for quality control
- Avoid generic, templated descriptions
Step 5: Setup Display Structure
Page Template Components:
โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ
โ SEO Title: "111 Best {Category} Designs" โ
โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโค
โ Meta Description (150-160 chars) โ
โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโค
โ H1: Main Title โ
โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโค
โ Introduction (100-200 words) โ
โ - What this page offers โ
โ - Why it's valuable โ
โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโค
โ Content Grid/List โ
โ - Items with images/data โ
โ - Pagination if needed โ
โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโค
โ [CTA: Your Product Promotion] โ
โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโค
โ Related Categories (internal links) โ
โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโค
โ FAQ Section (optional) โ
โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ
Dynamic Elements:
- Title with count: "111 Best {X}" (updates automatically)
- Fresh date indicators
- Category navigation
- Search/filter functionality
- Infinite scroll or pagination
Content Depth Requirements:
- Minimum 100-200 words of text per page
- Unique intro/description per category
- Internal links to related pages
- Avoid thin content at all costs
Step 6: Promote Your Offering
Monetization Integration:
| Position | Strategy | Example |
|---|---|---|
| In-content CTA | Button after X items | "Design your own tattoo" |
| List insertion | Your product as #3 option | "Try HeadshotPro instead" |
| Sidebar | Persistent promotion | Free tool banner |
| Exit intent | Popup on leave | Newsletter/product signup |
| Related section | Your tools as related | "Also try our generator" |
Example - Tattoos AI:
- Browse tattoo ideas โ See CTA "Design Your Own"
- Click โ Goes to paid AI generator
- Result: $4,000/month passive revenue
Example - Landingfolio:
- Free inspiration gallery โ Build traffic
- Later add: Figma/Tailwind component library for sale
PSEO Anti-Patterns (What NOT to Do)
1. Shallow Content
โ Bad: Just list names and addresses from Google Maps โ Good: Add reviews, photos, analysis, unique insights
HeadshotPro Failure Case:
- Listed photographers from Google Maps
- No unique value over Google Maps itself
- Result: Failed to rank
2. AI Content Spam
โ Bad: 100% AI-generated pages with no human review โ Good: AI assists, humans refine and add value
3. Crawl Budget Abuse
โ Bad: Publish 1,000 pages at once โ Good: Spread over weeks/months, let Google index gradually
4. Keyword Cannibalization
โ Bad: Multiple pages targeting same keyword โ Good: Each page targets distinct long-tail variation
5. Duplicate Content
โ Bad: Same description across all pages โ Good: Unique intro, unique meta, unique content per page
6. Thin Content
โ Bad: Title + 3 images + no text โ Good: 100-200+ words of valuable context per page
PSEO Planning Template
Opportunity Assessment
## PSEO Opportunity: [Name]
### Concept
[One sentence description]
### Keyword Analysis
- **Main Keyword**: [keyword] ([volume]/mo, KD [X])
- **Pattern**: "[variable] + [main keyword]"
- **Estimated Pages**: [X]+
- **Long-tail Examples**:
- [variation 1] ([volume], KD [X])
- [variation 2] ([volume], KD [X])
- [variation 3] ([volume], KD [X])
### Data Source
- **Type**: [UGC / API / Scraping / AI]
- **Collection Method**: [description]
- **Update Frequency**: [daily/weekly/manual]
- **Unique Value Added**: [what makes it better than raw data]
### Page Structure
[URL hierarchy diagram]
### Content Template
- **Title Pattern**: "[Count] Best [Category] [Type]"
- **Content Components**: [list]
- **Minimum Content**: [X] words + [X] items
### Monetization
- **Primary**: [strategy]
- **Secondary**: [strategy]
- **CTA Placement**: [where]
### Technical Requirements
- **Stack**: [technologies]
- **APIs Needed**: [list]
- **Automation**: [cron jobs, pipelines]
### Risk Assessment
- **Thin Content Risk**: [low/medium/high]
- **Cannibalization Risk**: [low/medium/high]
- **Competition**: [analysis]
### Timeline
- Week 1: [milestone]
- Week 2: [milestone]
- Week 3: [milestone]
- Week 4: [milestone]
Success Metrics
| Metric | Target | Measurement |
|---|---|---|
| Pages indexed | 80%+ of published | Google Search Console |
| Organic traffic | Growing monthly | GSC / Analytics |
| Ranking keywords | 50%+ in top 20 | Ahrefs / GSC |
| Bounce rate | < 70% | Analytics |
| Time on page | > 1 min | Analytics |
| Conversions | Defined by monetization | Analytics |
Reference Files
- CASE-STUDIES.md - Detailed success and failure case studies
Score
Total Score
Based on repository quality metrics
SKILL.mdใใกใคใซใๅซใพใใฆใใ
ใฉใคใปใณในใ่จญๅฎใใใฆใใ
100ๆๅญไปฅไธใฎ่ชฌๆใใใ
GitHub Stars 100ไปฅไธ
1ใถๆไปฅๅ ใซๆดๆฐ
10ๅไปฅไธใใฉใผใฏใใใฆใใ
ใชใผใใณIssueใ50ๆชๆบ
ใใญใฐใฉใใณใฐ่จ่ชใ่จญๅฎใใใฆใใ
1ใคไปฅไธใฎใฟใฐใ่จญๅฎใใใฆใใ
Reviews
Reviews coming soon


