Keyword Opportunity Score

How the Keyword Opportunity Score Formula Works

The Keyword Opportunity Score provides a clear, actionable metric from 0–100 that represents the "sweet spot" between high search volume and low keyword difficulty. A higher score indicates a better opportunity.

The calculation is a direct comparison of the two most important metrics for keyword selection:

function KEYWORD_OPPORTUNITY_SCORE(searchVolume, keywordDifficulty) {
  // If difficulty is higher than volume, it's not a good opportunity.
  if(keywordDifficulty > searchVolume) {
    return 0; // Returns 0%
  }

  // The core formula finds the ratio of "winnable" volume.
  let rawScore = (searchVolume - keywordDifficulty) / searchVolume;

  // The result is capped between 0 and 1 (or 0% and 100%).
  return rawScore;
}

How to Export the Right Report from SEMrush

To use this tool, you need a CSV export 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 and click Search.
4. Click the Export button and choose CSV.

Upload that exact file using the drag-and-drop tool above, and our system will handle the rest.