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: 2022-01-07

Avatar for Isaac Adams-Hands

Isaac Adams-Hands

Isaac Adams-Hands is the SEO Director at SEO North, a company that provides Search Engine Optimization services. Isaac has considerable expertise in Search Engine Optimization, Server Administration, and Cyber Security, which gives him a leg up as a Google Algorithm Analyst and SEO Expert.