Skip to content
Workflow · Track and forecast · Opening soon

Ahrefs keyword rank changes by page

Export this month and last month from Ahrefs, then load both files into the workflow. It groups the rows by page, compares the two months, and marks pages with top ten keyword losses, traffic drops of more than a third, and new pages that started ranking.

Early access opens shortly. Check back soon.

Someone typed

“compare this month's ahrefs organic keywords export with last month's and give each page its keywords, traffic and average position both months, and flag pages that lost keywords from the top ten, pages whose estimated traffic fell by more than a third, and new pages that started ranking”

The agent read it as

compare this month's Ahrefs Organic keywords export - November 2026 with last month's Ahrefs Organic keywords export - October 2026 and give each page its keywords, traffic and average position both months, and flag pages that lost keywords from the top ten, pages whose estimated traffic fell by more than a third, and new pages that started ranking

What the agent built

4 steps, each one an ordinary Mammoth step you can open and change.

  1. File
    Ahrefs Organic keywords export - October 2026
    CSV export · 45 rows
  2. File
    Ahrefs Organic keywords export - November 2026
    CSV export · 45 rows
  3. Step
    Summarize pages to month end (October keywords)
    Step 1
  4. Step
    Summarize pages to month end (November keywords)
    Step 2
  5. Join
    Bring in November pages
    6 of 6 paired
  6. Step
    Flag page changes
    Step 4
  7. Result
    Organic Keyword Comparison
    6 rows
  8. Schedule
    Runs when you say
    Proposed

On the sample files, every step runs and the result has 6 rows.

What you get back

The result of that run, the rows to look at first.

Organic Keyword ComparisonSample data6 rows
PageOctober KeywordsOctober TrafficOctober Average PositionNovember KeywordsNovember TrafficNovember Average PositionKeywords Lost from Top TenFlags
https://softwaveblog.com/blog/ai-writing-assistant81559.7588317.254Lost keywords from the top ten and Estimated traffic fell by more than a third
https://softwaveblog.com/blog/project-management-software814511.6388016.134Lost keywords from the top ten and Estimated traffic fell by more than a third
https://softwaveblog.com/blog/email-automation-guide811213.25811811.880No flagged changes
https://softwaveblog.com/blog/product-led-growth51057.40510280No flagged changes
https://softwaveblog.com/blog/remote-work-tools815313.258156120No flagged changes
https://softwaveblog.com/blog/sales-crm-features812911.63813710.630No flagged changes
6 rows in the result. Sample data: illustrative figures, not business results.

How it works

How to use the Organic Keyword Comparison workflow

  1. 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and working on sample files.
  2. 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
  3. 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Organic Keyword Comparison: questions

How do you compare Ahrefs keyword rank changes by page?
Export this month and last month from Ahrefs, then load both files into the workflow. It groups the rows by page, compares the two months, and marks pages with top ten keyword losses, traffic drops of more than a third, and new pages that started ranking.
Which Ahrefs export should you use?
Use the organic keywords export for each month you want to compare. Export one file for the current month and one for the earlier month, then bring both into the workflow.
What happens to rows that do not match between months?
Rows that appear in only one month are kept as additions or removals, so you can see new pages and pages that no longer appear. Matching rows are compared across the two exports by page.
How do you change the rules?
You change the rules by editing the steps in words, for example by changing the month range, the page field you group on, or the thresholds for keyword loss and traffic drop. Then rerun the workflow on the exports you want to compare.

Get early access to this workflow

It opens already built and working on sample files. Swap in your own exports to see your result.

Early access opens shortly. Check back soon.

Workflows like this

The number you report every month, rebuilt from the latest export, plus the forecast that follows from it.

All track and forecast workflows →