How to find dead pages to optimize using Ahrefs

Ahrefs is one of the most popular tools in the SEO world. It’s a great tool to use to find page ranking for keywords and phrases related to your business, website, or industry. You can also use it to identify new link opportunities by finding websites linking back to competitors’ websites.

page optimization

Although Ahrefs is great at finding top content and keywords, it does lack the ability to find your worst content, content that doesn’t rank or have traffic.

In this exercise, I will show you how to identify your worst content, which needs optimization and improvement to help strengthen your business.

  1. Copy the Pages Sitemap into Excel or Google Sheets

    pages sitemap

    You will want to copy your XML Pages Sitemap into Excel or Google Sheets.

    You can find your pages sitemap under:

    When copying and pasting the URLs, if it does not format correctly when pasting, try selecting more of the page. I find this helps carry over the structure better. Then I delete those extra rows.

  2. In Excel/Sheets, pick the best pages


    Select your most valuable pages to start, typically your programs, products, or services.

    You select these pages because they convert better and have the highest ROI over a blog post.

  3. Copy into Batch Analyzer

    quick batch analysis

    Copy and paste the URLs into Ahrefs batch analyzer. Set the analyzer to exact match URL mode. This will ensure you only target the page and not its children.

  4. Select Analyze

    traffic results

    After selecting analyze, organize results by traffic. Focus on pages with zero to low traffic.

    Review pages with keywords and no traffic. Select pages to optimize that help in increasing sales.

I’ve recreated this process in a short video if that is a more productive way to learn this process:

The process I’ve outlined above is a great way to improve rankings and traffic constantly. If you need any help, please let me know.

Published on: 2021-07-21
Updated on: 2021-09-03

Avatar for Isaac Adams-Hands

Isaac Adams-Hands

Isaac Adams-Hands is SEO Director with SEO North, where he helps the team plan marketing goals that are keyword-optimized and measurable for over 30 clients simultaneously. He has worked at Microsoft, The institute of chartered accountants in Australia, Auto Trader, Le Cordon Bleu, and Algonquin College in various Digital Marketing Roles. Isaac is qualified as a Full-stack developer, Server Administrator, and Cyber Security expert, adding additional experience to his Search Engine Optimization knowledge. His Inuit heritage brought him to the Arctic to hunt and fish for most summers, which grew his passion for 4-wheelers and dirtbikes.