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.
Copy the Pages Sitemap into Excel or Google Sheets
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.
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.
Copy into Batch Analyzer
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.
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