Keyword Research Assistant

Upload your and a competitor's SEMrush keyword reports to instantly find ranking gaps, content opportunities, and strategic advantages.

How the Keyword Research Assistant Works

This tool performs a "VLOOKUP" or "INDEX/MATCH" style comparison between two keyword lists: your competitor's and your own. It takes every keyword from your competitor's list and checks to see if you also rank for it.

The final table merges this data, showing you side-by-side comparisons of ranking positions, URLs, and calculates the difference in rank. This helps you quickly identify:

  • Keyword Gaps: Keywords your competitor ranks for that you don't.
  • Ranking Weaknesses: Keywords where your competitor significantly outranks you.
  • Content Opportunities: High-volume, low-difficulty keywords you can target to gain an edge.
  • Oppertunity Score: Our proprietary metric in determining the overall strength in re-creating the page for your own strategy.

How to Export the Right Reports from SEMrush

To use this tool, you need two separate CSV exports from SEMrush's Organic Research → Positions report:

  1. Log in to your SEMrush account.
  2. Navigate to Domain Analytics → Organic Research → Positions.
  3. Enter your competitor's domain, click Search, and export the list as a CSV. This is your "Competitor Keyword List".
  4. Repeat the process, this time entering your own domain. This is your "Client Keyword List".
  5. Upload both files to the designated dropzones above.

How to Interpret the Results

The combined table gives you a complete competitive overview. Use the powerful filter controls to narrow down the data:

  • Show Only Keyword Gaps: Instantly see all the keywords your competitor ranks for that you don't. This is your primary list of content opportunities.
  • Striking Distance: When viewing keyword gaps, use this filter to find keywords where your competitor is already ranking in the Top 3, 5, 10, or 20. These are proven terms with traffic potential.
  • Position Difference: When comparing keywords you both rank for, a large positive number means your competitor is winning. A negative number means you're ahead.
  • Keyword Opportunity Score: This score (0-100) helps you prioritize. A high score means the keyword has a great ratio of high search volume to low difficulty, making it an ideal target.