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 when you want 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.

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: yourdomain.com/pages-sitemap.xml

    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

    programs

    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-07-25

Avatar for Isaac Adams-Hands

Isaac Adams-Hands

Isaac Adams-Hands is a man of many hats. He is an SEO Director, Full Stack Developer, and InfoSec enthusiast who has done stints in marketing positions at search portals, higher education, and addiction recovery agencies. Isaac received his Bachelor’s Degree from the University of Western Sydney before making his way into the world of technology.