Aggregate Performance by URL Directory from Ahrefs CSV

Auto-extract URL directory structure (/category/, /product/, etc.) from Ahrefs Organic keywords CSV and aggregate keyword count, total traffic, and average position by directory. Find out which directories drive the most organic performance.

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. 2Calculate percentage of → column "traffic_share"
  3. 3Extract from Current_URL via regex → column "subdirectory"
  4. 4Pivot by directory, subdirectory
  5. 5Metrics: Distinct count(Keyword), Sum(Current_organic_traffic), Avg(Current_position), Sum(Volume), Sum(traffic_share)
  6. 6Filters: Current_URL is not empty, Current_organic_traffic is not empty