SERP Clustering Tool
SERP Clustering groups your keywords based on how much their search results overlap. Keywords that share similar ranking pages likely belong to the same topic and can often be targeted with a single piece of content.
What You’ll Learn
Section titled “What You’ll Learn”- How to upload and cluster keywords
- Understanding cluster results
- Working with past reports
- Reclustering with different settings
- Exporting your clusters
Getting Started
Section titled “Getting Started”Preparing Your Keywords
Section titled “Preparing Your Keywords”You can input keywords in two ways:
Option 1: Upload a File
Section titled “Option 1: Upload a File”- Prepare a CSV or Excel file with a column named “Keyword”
- Click Browse or drag-and-drop your file
- The tool will display keyword count and detect duplicates
Option 2: Manual Entry
Section titled “Option 2: Manual Entry”- Type or paste keywords in the text area
- Separate keywords with new lines or commas
- Duplicates are automatically identified
[!TIP] Remove duplicates before clustering to save credits and improve accuracy.
Configuration Settings
Section titled “Configuration Settings”| Setting | Description |
|---|---|
| Country | Target country for SERP data |
| Location | Specific city/region (optional) |
| Language | Search language |
| Overlap % | Minimum SERP overlap to group keywords (20%-90%) |
| Report Name | Name your report for easy identification |
Understanding Overlap Percentage
Section titled “Understanding Overlap Percentage”The overlap percentage determines how similar SERPs must be to cluster keywords together:
| Overlap | Result |
|---|---|
| 20-30% | Loose clustering, broader topic groups |
| 40-50% | Balanced clustering (recommended) |
| 60-70% | Tight clustering, specific topics |
| 80-90% | Very tight, nearly identical SERPs only |
Running the Analysis
Section titled “Running the Analysis”Starting Clustering
Section titled “Starting Clustering”- Upload keywords or enter them manually
- Configure your settings
- Enter a report name
- Click Start Clustering
Processing Stages
Section titled “Processing Stages”The tool processes keywords through several stages:
- SERP Fetching — Retrieves search results for each keyword
- Overlap Calculation — Compares SERPs for similarity
- Clustering — Groups keywords by overlap threshold
- Metrics Enrichment — Adds search volume, CPC, and competition
Processing time depends on keyword count. Large sets (500+ keywords) may take several minutes.
Understanding Results
Section titled “Understanding Results”Cluster Overview
Section titled “Cluster Overview”Results are displayed in a sortable table showing:
| Column | Description |
|---|---|
| Cluster # | Cluster identifier |
| Centroid | Main/representative keyword for the cluster |
| Keyword | Individual keyword in the cluster |
| Volume | Monthly search volume |
| CPC | Cost per click (USD) |
| Competition | Advertiser competition (0-1) |
| Similarity | How closely this keyword matches the centroid |
Centroids
Section titled “Centroids”Each cluster has a centroid — the keyword that best represents the group. Use centroids to:
- Identify your primary target keyword
- Name content pieces
- Structure site architecture
Viewing SERP Data
Section titled “Viewing SERP Data”Click any keyword to view its full SERP data:
- Top 10 ranking URLs
- SERP features present
- Additional metadata
Managing Reports
Section titled “Managing Reports”Current Report Tab
Section titled “Current Report Tab”View your most recent clustering results:
- Full cluster breakdown
- Export options
- Recluster capability
Past Reports Tab
Section titled “Past Reports Tab”Access all your saved clustering reports:
- Search reports by name
- View report date and settings
- Load any report to view results
Report Actions
Section titled “Report Actions”| Action | Description |
|---|---|
| Load | Open a past report |
| Delete | Remove selected reports |
| Recluster | Re-run with different settings |
Reclustering
Section titled “Reclustering”Already have results but want to try different settings?
How to Recluster
Section titled “How to Recluster”- Load an existing report
- Adjust the Overlap % setting
- Click Recluster
When to Recluster
Section titled “When to Recluster”- Results too broad → Increase overlap %
- Too many small clusters → Decrease overlap %
- Testing different topic granularity
[!NOTE] Reclustering reuses existing SERP data, so no additional SERP fetching credits are charged.
Exporting Data
Section titled “Exporting Data”Export Format
Section titled “Export Format”Click Export to download your clusters as Excel (.xlsx):
Exported Data Includes
Section titled “Exported Data Includes”- Cluster numbers
- Centroid keywords
- All keywords with metrics
- Similarity scores
- Search volume, CPC, competition
Use Cases for Export
Section titled “Use Cases for Export”- Share with content team
- Import into project management tools
- Build content calendars
- Inform site architecture decisions
[!TIP] Use your clusters alongside Topical Research data to build a structured Topical Map.
Best Practices
Section titled “Best Practices”Optimal Keyword Count
Section titled “Optimal Keyword Count”- Minimum: 20 keywords (enough for meaningful clusters)
- Sweet Spot: 100-500 keywords
- Maximum: 1,000 keywords per report
Keyword Preparation
Section titled “Keyword Preparation”- Use one topic area per report
- Include both head terms and long-tail variations
- Remove brand-specific or navigational queries
Interpreting Results
Section titled “Interpreting Results”- Single-keyword clusters may indicate unique topics
- Very large clusters may need higher overlap settings
- Check centroids match your content intent
Frequently Asked Questions
Section titled “Frequently Asked Questions”How is SERP overlap calculated?
Section titled “How is SERP overlap calculated?”The tool compares the top 10 URLs for each keyword pair. If 40% of URLs match (at 40% overlap setting), the keywords are clustered together.
Why are some keywords in their own cluster?
Section titled “Why are some keywords in their own cluster?”Keywords with unique SERPs that don’t overlap with others form single-keyword clusters. These may need dedicated content.
Can I combine multiple reports?
Section titled “Can I combine multiple reports?”Currently, each report is independent. Export both and combine in a spreadsheet for advanced analysis.
How accurate is the search volume?
Section titled “How accurate is the search volume?”Search volume data comes from industry-standard sources but should be treated as relative estimates, not exact numbers.
What does “Similarity” mean?
Section titled “What does “Similarity” mean?”Similarity shows how closely each keyword’s SERP matches the cluster’s centroid keyword. Higher similarity means stronger topical connection.
Can I cluster keywords from different countries?
Section titled “Can I cluster keywords from different countries?”Run separate reports for each country. SERP results vary significantly by region.