How to Find Guest Blogging Sites and Easy Keyword Targets with Content Explorer
I’m going to tell you about two super cool tactics to find thousands of guest blogging opportunities and an extremely effective technique to find low competition keywords using Content Explorer.
Plus, I’ll give you one bonus tip on finding highly relevant influencers in your niche.
Alright, first things first.
What is Content Explorer anyway?
Content Explorer is one tool within Ahrefs’ SEO toolset. It’s basically a mini search engine that’s extremely helpful for SEOs and marketers.
Right now, our content index is at about 870 million pages and we're constantly updating the metrics with fresh data. Plus, we find about 5 million new pages each day, so it’s constantly growing.
Ok, enough flexing our big data muscles, let’s jump right in to these cool SEO tactics.
The first hack: how to find thousands of guest blogging sites with Content Explorer.
First, go to the Content Explorer tool and then type in a keyword phrase that’s closely related to your industry.
For example, you might type in something like “video marketing” as a phrase match.
And you can see here that there are over 77,000 highly relevant results.
You will see multiple articles from the same sites, but all you need is a list of unique websites to guest post for.
So you can use "One article per domain" filter, which is going to give you only the unique domains that match your search query.
And boom. You’re down to about 19,000 results.
Next, you’re going to want to set one more filter. And that’s the “Highlight unlinked domains” filter.
If you click it, you will be able to enter in your domain. We put moneyjournal.com, as an example.
After that you need to click highlight.
Content Explorer will then highlight only the domains that have never linked to you.
So, in general, earning backlinks from websites that have never linked to yours will bring more value than a second, third, or even fourth link from previously linking domains.
The “Highlight unlinked domains” filter is going to save you a ton of time from pitching websites that you already have links from that you might not know about.
Finally, you can hit the export button to get all of these results in a spreadsheet.
Just make sure that the checkbox is selected to only export the unlinked websites. And click the start export button.
Now you can start pitching the different websites that are blogging about your topic.
Never guest posted before? Read which sites to pitch & succeed
If you’ve never posted a single guest post before, you might want to try pitching websites that aren’t as high profile to get some experience and refine a pitch that works for you.
You can do that by setting the domain rating filter to something with a maximum DR of around 30.
And a lot of these sites are more likely to accept your pitch since they probably don’t have hundreds of requests coming in each day like some of the bigger sites.
“Stalk” people to find guest posting opportunities
Alright! Another cool way to find guest posting opportunities is to “stalk” the people you’re constantly seeing popping up on other blogs.
And We are using air quotes here on “stalk”, because we don’t mean it in a literal sense.
The way you do that in content explorer is by using the search operator, “author:”, and then the name of the blogger.
So we’ll use Kristi Hines as an example, since we know she’s written about topics like social media and video marketing.
Hit search. And there are about 250 results.
You can use the same filters as we did in the previous example. Set it to one article per domain.
And then use the highlight unlinked domains feature with your domain. And click highlight.
You can then export it, making sure that this checkbox is checked. And you’re done.
This works particularly well if you’re a solopreneur or if you have a small team of content creators.
Using the “author” search operator is a really good trick to use because it’s basically proof of results.
The people you’re searching for here are likely guest authors. It’s not like they own every blog that they write on.
So even if they don’t have a ‘write for us’ page, they’re clearly accepting guest blog articles.
Pretty cool, right?
How to find extremely low competition topics with high traffic potential
Let’s move on to a really unconventional way to come up with new content ideas.
This keyword research tip that we are about to tell you of is a super cool way to find extremely low competition topics with high traffic potential.
You’ll love it because it takes a data-driven approach with a little proof of concept.
Here’s how it’s done.
So again, search for a pretty generic keyword related to your industry. We’ll use “gardening” as an example.
And since we know that quality backlinks help you rank in Google and that the overall strength of a website’s backlink profile can help your pages rank too, we can set two filters to find low competition keywords.
The first filter we’ll set is the “Referring domains.” And we’ll set it to only find results with a maximum of zero referring domains. So no linking websites.
Then we’ll set the organic traffic filter, to have a minimum of, 1,000 search visitors per month.
When you try this, you might have to play around with the numbers, but since gardening is a pretty big topic and there are nearly 600,000 results in the Content Explorer index, we’d say this is a pretty good number.
After we set the final filter, you’ll see that there are over 100 pages that have zero referring domains and get over 1000 search visitors per month.
Look at this one:
This one here, “171 Inspirational Gardening Quotes and Sayings.”
Content Explorer shows that they get 1,400 organic search visitors each month from this post.
And if we click on the details button, and then organic keywords, you can see the keywords and SERP positions that this page is ranking for.
You also see that they rank for “garden quotes”, which has a search volume of 4,500 and they rank in position 5.
“Gardening quotes” has 2,700 searches per month and is currently in position 6.
And so on and so forth.
If you run a gardening blog, then this might be a good topic to cover and it probably wouldn’t take too many links, or any at all, to outrank this page.
And to put the cherry on the top, you’ll see that this one has a pretty low to medium domain rating of 44.
Keep going through the list and you will find a ton of really low competition keywords you can start creating content around.
Here’s an example. The page ranks for “succulent care”, has 9300 searches per month and ranks in position 5 right now.
Try out this hack and you will get some insane results. Like ranking on page 1 of Google in 3 days from publishing.
Bonus hack: how to do influencer marketing and prospecting
Now one more bonus hack if you’re interested in doing some influencer marketing and prospecting.
Within Content Explorer, you can find influencers who might be interested in the content that you’re creating.
If we search for “link building”, then you’ll see that Content Explorer finds over 75,000 articles related to the topic.
The article “How long does link building take to influence rankings?” looks interesting.
And since we have a ton of data at Ahrefs and some of our own unique case studies, including the one on how long it takes to rank in Google, we could probably find some influencers who would be interested in our research.
This post you see below has just over 500 Twitter shares.
If we click on the "Who tweeted" button, we can see all of the unique people who have shared this article on Twitter.
From here, you can click any of the columns to sort by the tweet date, the total number of tweets on the account, the number of people they're following, the total number of followers they have, or the total number of lists.
We are there are some pretty influential people who would be interested in some unique data to share the article with.
If you go back to the search results page, you can actually select a few articles there. So we’ll just choose some for demonstration purposes.
And then if you scroll back to the top, you can click the "Who tweeted selected articles" button to get an even bigger list of prospects that you could then reach out to.
We hope you found this SEO tutorial helpful and will start using Content Explorer to find some solid guest blogging opportunities as well as low competition keywords that no keyword research tool could ever find.