Your article reaches me at just the perfect time. I’ve been working on getting back to blogging and have been at it for almost a month now. I’ve been fixing SEO related stuff on my blog and after reading this article (by the way is way too long for one sitting) I’m kind of confused. I’m looking at bloggers like Darren Rowse, Brian Clark, and so many other bloggers who use blogging or their blogs as a platform to educate their readers more than thinking about search rankings (but I’m sure they do).
The thing that I liked the best about Ahrefs is that it contains a huge database of backlinks when I've checked my own website and my competitor's websites. This has allowed me to dig deeper and find out their exact linkbuilding and SEO strategies. Ahref contains a lot of tools and features that will make the life of an SEO professional or webmaster who wants more search engine traffic a lot easier. One of these features is the batch analysis feature. Basically, instead of entering your competitor's backlinks one at a time you could actually enter it once. This allows you to quickly check on the SEO metrics for a lot of competitor URLs in just one click.
One of the things that AHrefs is best at is helping with a content marketing strategy. Though it's best known as a backlink index (which it's great at and I'll get into that), coming up with good content ideas is one of the things I get the most use out of it with using the content explorer. I find articles that do well for the topics I want to target and it's clear what already resonates with your audience which is powerful.
The Intersecting Link Opportunity report we love could offer an automatic version that takes into account the top 20 listings for a given keyword phrase, saving the researcher copy/paste time and having to run multiple requests. Their Most Popular Content list is definitely helpful, but doesn't give us the semantic relevancy we get from the intersecting report.
Brian, I have a burning question regarding keyword placement and frequency. You wrote: “Use the key in the first 100 words … “. What else? I use Yoast and a WDF*IDF semantic analysis tool to check the content of the top10 rankings. Pretty often I have the feeling I overdo it, although Yoast and WDF/IDF told me I use the focus keyword not often enough.
In SEMrush, you can export to CSV and XLS right from Keyword Gap, Backlink Gap, Keyword Magic Tool, Keyword Difficulty Tool, Organic Traffic Insights, Bulk Analysis, Position Tracking, Ranks, Site Audit, Keyword Ad History, and PLA Research. SEO Content Template lets you export its ideas to DOC, On Page SEO checker and Log File Analyzer feature XLS, CPC Map and PPC Keyword Tool – to CSV, and Display Advertising allows exporting to ZIP.
Offer Details: Offer expires 9/30/2018 (midnight Pacific Time), and is available only to qualified advertisers who meet the following eligibility criteria: Open to new and verified Bing Webmaster Tools account holders who own their own Website and open a new Microsoft Advertising account; a “new” account is one that has been open fewer than 30 days prior to the date of coupon redemption. Your account will be evaluated daily to verify you meet the eligibility criteria. When criteria is met, a Microsoft Advertising coupon will be sent to each qualified advertiser by email in approximately 3 business days from date of verification. See full offer details here.
I work with legal websites and it makes it easy to see what the top law firm websites are using for backlinks. I can then export all the backlinks into an Excel file and decide what are the best ones for me to try and obtain for our clients. The reports section is nice too, it gives us an easy to understand solution for our clients and answers their question of where their money is going to.
We love the Intersecting Link Opportunity report, which helps us plan our link-earning strategy based on the semantic Web and relevancy. There really isn't a better way of finding industry websites to market with that could result in organic link wins. Our team has been using Ahrefs for as long as we can remember, mainly because it offers a higher volume of discovered links when weighed against similar tools.