SEO

Cluster Keywords By Opportunity Score

Takes a raw keyword export CSV with search volumes plus your current site structure and turns it into page-ready clusters instead of a flat keyword list. It groups semantically related terms, maps each cluster to an existing page or flags where a new page is needed, and scores opportunity by combined volume, competition, and business relevance. The output also flags cannibalization risk between overlapping clusters and ranks the top five clusters worth pursuing first.

Prompt
[Input Data] Keyword export CSV: {keyword_csv} Current site structure: {site_structure}
[Goal Description] Given a keyword export [CSV], sort terms into clusters mapped to pages. Highlight the clusters that represent strategic opportunities. Note: When the export already contains search volumes from the tool, no additional validation step is needed.
[Task Description] Review the keyword list and group semantically related terms into clusters. Map each cluster to an existing page or flag the need for a new page. Compute opportunity scores based on combined search volume, competition indicators (if available), and business relevance. Give priority to clusters that represent untapped or high-value opportunities.
[Output Format] Deliver:
   * Keyword Clusters (grouped terms with total volume)
   * Page Mapping (cluster → existing page or "new page needed")
   * Opportunity Score (based on volume, competition, relevance)
   * Strategic Recommendations (top 5 clusters to pursue)
   * Cannibalization Warnings (overlapping clusters)
Download .md

Variables