Ahrefs Position Movement Matrix

Generate a keyword movement matrix from previous to current position bands using Ahrefs Rank Tracker CSV. Instantly see how keywords shift across ranking tiers.

Before
KeywordPrevious_positionCurrent_positionPrevious_URLCurrent_URL
seo tool52https://example.com/seohttps://example.com/seo
keyword research128https://example.com/kwhttps://example.com/kw
backlink checker15https://example.com/bl
site audit31https://example.com/audithttps://example.com/audit
rank tracker2545https://example.com/rankhttps://example.com/rank
domain checker11https://example.com/domainhttps://example.com/domain
After
previous_position_label01: 102: 2-303: 4-604: 7-1005: 11-2006: 21-10007: 101+
01: 11000000
02: 2-30100000
03: 4-60100000
05: 11-200001000
06: 21-1000000010
07: 101+0000100

Drag & drop CSV files here, or browse files

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

Required Columns

KeywordVolumePrevious positionCurrent positionPrevious URLCurrent 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. 1Add conditional column "previous_position_label"
  2. 2Add conditional column "current_position_label"
  3. 3Pivot by previous_position_label × column axis: current_position_label
  4. 4Metrics: Count(Keyword)