Extract Top 5 Keywords per URL from Ahrefs CSV

Extract the top 5 keywords by traffic per URL from Ahrefs Organic keywords CSV.

Before
KeywordVolumeCurrent_organic_trafficCurrent_positionCurrent_URL
project management tool148007203https://example.com/tools/pm
best pm software65002805https://example.com/tools/pm
pm tool comparison32001507https://example.com/tools/pm
task tracking app99009502https://example.com/tools/tasks
team task manager41003804https://example.com/tools/tasks
After
Current_URLKeywordorganic_trafficpositionvolume
example.com/tools/taskstask tracking app95029900
example.com/tools/tasksteam task manager38044100
example.com/tools/pmproject management tool720314800
example.com/tools/pmbest pm software28056500
example.com/tools/pmpm tool comparison15073200

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. 1Rank by Current_organic_traffic per Current_URL (ROW_NUMBER) → column "traffic_rank"
  2. 2Sort by Current_organic_traffic (descending)
  3. 3Pivot by Current_URL, Keyword
  4. 4Metrics: Sum(Current_organic_traffic), Min(Current_position), Sum(Volume)
  5. 5Filters: traffic_rank <= 5