🔍 Low competition keyword finder
What it does:
Discovers all keywords a domain ranks for and analyzes their difficulty, trends, and intent. Identifies opportunities based on actual ranking data rather than suggestions.
How it works:
- Reads domain seeds from Google Sheets (with location/language settings)
- Fetches all keywords the domain ranks for (Keywords For Site API)
- Gets keyword difficulty scores for each keyword (Bulk Keyword Difficulty API)
- Combines data with search trends, intent classification, and backlink metrics
- Writes comprehensive results to keywords_opportunities sheet
Setup Requirements:
- DataForSEO API credentials (Basic Auth)
- Google Sheets with input columns: seed, location_name, language_name, limit
- Output sheet: keywords_opportunities
Data Captured:
- Keyword & Search Volume
- Monthly/Quarterly/Yearly Trends
- Keyword Difficulty (0-100)
- Search Intent (main + foreign)
- Average Backlinks
- Last Updated Time
- SE Type & Location/Language codes
Best For:
- Competitor keyword analysis
- Content gap identification
- Monitoring domain keyword portfolio
- Finding keywords you already rank for
