Domain × Keyword × Volume Tier SEO Analysis from Ahrefs CSV

Drop your Ahrefs CSV to classify search volume into 4 tiers and instantly run domain × keyword SEO analysis.

Before
KeywordVolumeCurrent_URLCurrent_position
project management tool14800https://example.com/tools/pm3
project management tool14800https://site-b.org/pm5
gantt chart maker450https://example.com/tools/gantt4
gantt chart maker450https://site-b.org/gantt9
After
Volume_TierKeywordVolumeexample.comsite-b.org
Tier1project management tool1480035
Tier3gantt chart maker45049

Drag & drop CSV files here, or browse files

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

Required Columns

Current_URLKeywordCurrent_organic_trafficCurrent_positionVolume

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 "domain"
  2. 2Add column "Volume_Tier"
  3. 3Pivot by Volume_Tier, Keyword, Volume × column axis: domain
  4. 4Metrics: Min(Current_position)
  5. 5Filters: Current_organic_traffic > 0, Volume > 100, domain is not empty