Detect Keyword Cannibalization from Ahrefs CSV

Auto-detect keyword cannibalization (multiple URLs ranking for the same keyword) from Ahrefs Organic keywords CSV. Aggregate cannibalized keyword count, URL count, total traffic, and average position by directory to identify areas needing URL consolidation.

Drag & drop CSV files here, or browse files

.csv format (up to 10 files, 500 MB each)

Required Columns

KeywordVolumeCurrent_organic_trafficCurrent_positionCurrent_URL

Your data stays in your browser. By using this tool, you agree to our Terms and Privacy Policy.

How to Use This Template

Select Your File

Drag & drop a CSV file containing the required columns

Automatic Processing

Data is transformed and aggregated based on the template

View Results

Explore the aggregated results interactively on the Analyze page

Processing Details of This Template

  1. 1Extract from Current_URL via regex → column "directory"
  2. 2Rank by Keyword per Keyword (ROW_NUMBER) → column "url_count"
  3. 3Pivot by Keyword, Current_URL
  4. 4Metrics: Avg(Volume), Avg(url_count), Sum(Current_organic_traffic), Avg(Current_position)
  5. 5Filters: url_count >= 2, Current_URL is not empty