Ahrefs keyword rank changes by page
“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”
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.
- FileAhrefs Organic keywords export - October 2026CSV export · 45 rows
- FileAhrefs Organic keywords export - November 2026CSV export · 45 rows
- StepSummarize pages to month end (October keywords)Step 1
- StepSummarize pages to month end (November keywords)Step 2
- JoinBring in November pages6 of 6 paired
- StepFlag page changesStep 4
- ResultOrganic Keyword Comparison6 rows
- ScheduleRuns when you sayProposed
On the sample files, every step runs and the result has 6 rows.
- Download Ahrefs Organic keywords export - October 2026 sample (45 rows)Ahrefs: Site Explorer > Organic keywords > Export
- Download Ahrefs Organic keywords export - November 2026 sample (45 rows)Ahrefs: Site Explorer > Organic keywords > Export
What you get back
The result of that run, the rows to look at first.
| Page | October Keywords | October Traffic | October Average Position | November Keywords | November Traffic | November Average Position | Keywords Lost from Top Ten | Flags |
|---|---|---|---|---|---|---|---|---|
| https://softwaveblog.com/blog/ai-writing-assistant | 8 | 155 | 9.75 | 8 | 83 | 17.25 | 4 | Lost keywords from the top ten and Estimated traffic fell by more than a third |
| https://softwaveblog.com/blog/project-management-software | 8 | 145 | 11.63 | 8 | 80 | 16.13 | 4 | Lost keywords from the top ten and Estimated traffic fell by more than a third |
| https://softwaveblog.com/blog/email-automation-guide | 8 | 112 | 13.25 | 8 | 118 | 11.88 | 0 | No flagged changes |
| https://softwaveblog.com/blog/product-led-growth | 5 | 105 | 7.40 | 5 | 102 | 8 | 0 | No flagged changes |
| https://softwaveblog.com/blog/remote-work-tools | 8 | 153 | 13.25 | 8 | 156 | 12 | 0 | No flagged changes |
| https://softwaveblog.com/blog/sales-crm-features | 8 | 129 | 11.63 | 8 | 137 | 10.63 | 0 | No flagged changes |
How it works
How to use the Organic Keyword Comparison workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and working on sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 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?
Which Ahrefs export should you use?
What happens to rows that do not match between months?
How do you change the rules?
Get early access to this workflow
It opens already built and working on sample files. Swap in your own exports to see your result.
Workflows like this
The number you report every month, rebuilt from the latest export, plus the forecast that follows from it.
- Customer lifetime value by cohortWork out customer lifetime value by signup month cohort from Shopify customers and orders exports, with revenue per customer and average order count.See the workflow Built by the agent
- Profit and loss by monthBuild a monthly profit and loss statement from a QuickBooks general ledger export, with revenue, COGS, gross profit, expenses, and net income.See the workflow Built by the agent
- Pareto (ABC) analysisEvery item ranked by its total, with its share, the running share and an A, B or C classSee the workflow Template
- Inventory turnover by SKURank Shopify SKUs by inventory turnover ratio using product, order, and inventory exports from the last 12 months.See the workflow Built by the agent
- Cohort retentionEach month's new customers, and the share still buying 1, 2, 3… months laterSee the workflow Template
- Customer segmentation by revenueSegment Stripe customers into revenue tiers from exported customer, charge, and threshold files, then count customers and revenue in each tier.See the workflow Built by the agent