How to Find Guest Blogging Sites and Easy Keyword Targets with Content Explorer

How to Find Guest Blogging Sites and Easy Keyword Targets with Content Explorer

In this video, I’m gonna show you 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 show you one bonus tip on finding highly relevant influencers in your niche. Stay tuned! [Music] Hey everyone, it’s Sam Oh here with Ahrefs. First things first, we need to talk about Content Explorer. 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 these metrics with fresh data. Plus we find about 5 million new pages
each day, so it’s just constantly growing. At this point, I’m gonna stop flexing our
big data muscles and let’s just jump right into these cool SEO tactics. The first hack is a way to find thousands of guest blogging sites with Content Explorer. So first, you go to the Content Explorer tool and then you’ll type in a keyword phrase
that’s closely related to your industry. So for example, I might type in something
like ‘video marketing’ as a phrase match. And here, you can see that there are
about 77,000 highly relevant results. You can see that there are
multiple articles from the same sites, but all we need right now is a
list of unique websites to guest post for. So you can use this filter right
here, one article per domain, which is going to give us only the unique
domains that match our search query. Now we’re down to about 19,000 results. Next, you’re gonna want to set one more filter and that’s the ‘highlight unlinked domains’ filter. If you click here, then you can enter in your domain. So I’ll just type in my own personal
domain,, and click ‘highlight’. Content Explorer will then highlight only the
domains that have never linked to you. In general, earning backlinks from websites that have never linked yours, it’s
gonna bring you more value than a second, third, or even fourth link from
previously linking domains. So basically, the highlight unlinked domains
filter, it’s gonna save you a ton of time from pitching websites that you already have links from and that you might not actually know about. So in this case, I probably wouldn’t pitch Buffer, Entrepreneur, Contently, Top Rank Blog, and a few others. Finally, you can hit the export button to
get all of these results in a spreadsheet. Just make sure that this checkbox
here is selected to only export the unlinked websites and click the start export button. From here, you can start pitching the different websites that are blogging about your topic. Now, if you’ve never posted a single guest
post before, you may want to try pitching websites that aren’t as “high profile” so that you can get some experience, refine your pitch, and find what 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 a lot of the bigger sites that
you might want to write for. Alright, so another cool way to find guest posting opportunities is to ‘stalk’ the people you’re constantly seeing popping up on other blogs. And I’m using air quotes here on ‘stalk’ because I don’t literally mean to stalk them in that sense. So the way that you do that in Content Explorer is by using the search operator, “author:”
and then the name of the blogger. So I’ll use Kristi Hines as an example, since I know that she’s written about topics like social
media marketing and video marketing. And there are about 250 results here. From here, you can use the same filters as I did in the previous example, so I’ll set
it to one article per domain, and then use the highlight unlinked
domains feature with my domain. And finally, I’ll click highlight. You can then export it, making sure that this checkbox is checked and we are done. This works particularly well if you are a solopreneur or if you have a small
team of content creators. Using the ‘author’ search operator,
it’s a really good trick to use because it’s basically proof of results, right? 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 blogging articles. Pretty cool, right? Alright, so let’s move on to a really unconventional way to come up with new content ideas. And this keyword research tip that I’m about to show you, is a super cool way to find extremely low competition
topics with high traffic potential. And you’re gonna love this because it’s a data-driven approach with a little proof of concept. Okay? So here’s how it’s done. So again search for a pretty generic keyword related to your industry. So I’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 that we’re going
to 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 at all. Then we’ll set gonna set is the organic traffic filter to have a minimum of a thousand
search visitors per month. Now, when you try this, you
might have to play around with the numbers a little bit, but since gardening is a pretty big topic and there’s nearly 600,000 results here in the Content Explorer results, you know, I’d say that it’s a pretty good number here. After we set the final filter, you’ll see that there are over a hundred pages that have zero referring domains and they get over
a thousand search visitors per month like 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 alone. And if I click on the details button and then the organic keywords, you can see
the keywords and SERP positions that this page is ranking for. So you’ll see that they rank for ‘garden quotes’ which has a search volume of 4500 and they’re
currently in position 5 and there’s ‘gardening quotes’ which has 2,700
searches per month and currently in position 6, and so on and so forth. You get the point, right? Now, 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 these pages. And to put the cherry on the top, you’ll see that this one has a pretty
low to medium domain rating of 44. And, if you keep going through this
list, there are a ton of really low competition keywords you can start
creating content around. Like this one here. This one ranks for ‘succulent care’,
(I’m not sure if I said that right), but it has 9,300 searches per month and ranks
in position 5 right now. When Tim showed me this hack, I knew
that I had to use it and I’ve gotten some pretty insane results like, I’ve ranked
on page one in Google in three days from publishing the article and I can’t
remember the exact numbers now but I think that page that I’m thinking of
gets around 500-600 visitors per month from like only a couple weeks
in publishing with zero links. Now, one more bonus hack if you’re interested in doing some influencer marketing and prospecting. So within Content Explorer, you
can actually find influencers who might be interested in the content that you’re creating. So if we search for ‘link building’, then you’ll see that
Content Explorer finds over 75,000 articles related to the topic. And this article looks interesting here. How long does link building
take to influence rankings? And since we have a ton of data here at Ahrefs and some of our own unique case studies like this one on how long it takes to rank
in Google, basically the same topic, we could probably find some influencers
who would be interested in our research. You’ll see that this post has just over 500
Twitter shares. And 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, which might be interesting or the total number of lists. I’m sure we could find some pretty influential people who would be interested in some unique
data and share the article with them. Now, if we go back to the search results page,
you can actually select a few of the articles from here too. So I’ll just choose these
ones here for demonstration purposes. And then if we scroll back to
the top, we can click the ‘who tweeted selected articles’ button to get an even
bigger list of prospects that we could then reach out to. So I hope you found
this SEO tutorial helpful and that you’ll start using Content Explorer to
find some solid guest blogging opportunities and find those low
competition keywords that no keyword research tool could ever find. Now give me a thumbs up if you like this video and let me know in the comments
which Content Explorer hack you’re going to try. That’s it for this SEO tutorial,
make sure to subscribe for more actionable videos like this one and I’ll see you soon. Bye. [Music]

43 thoughts on “How to Find Guest Blogging Sites and Easy Keyword Targets with Content Explorer


  2. Content Explorer is probably THE most powerful for SEO/topic research of ANY tool in the sector. Simple reason is because this is where all the many wide and deep metrics ahrefs offers all come together in one vector.

  3. Ahrefs is by FAR my favorite SEO tool not only for getting accurate matrix, but for all the various methods you guys teach on how best to use your software. You're making all other SEO software obsolete!

    Love the new features and the training. Keep it up!

  4. Wow a YouTube video that actually has some real-life applications! I use content explorer every week but there were a few tips in here I didn't even think of trying. Great stuff guys! Within a second I found a crazy high traffic post/keyword with low comp 🙂 I never subscribe to anything on YouTube… but you got my sub.

  5. Amazing!!! I really like the way you find out post to outrank with low backlinks. Really interesting video tutorial. Thanks!!

  6. I loved this. Sam Oh, I'm doing the 7 Day trial AND I'm going to sub per month. This is great stuff, just subbed to your YouTube Channel.

    My agency just picked up some SEO work and your tool will be helping me help others. Thank you so much, GIVE THIS MAN A RAISE

  7. Thank you for this video. Can you explain why we limit the organic traffic to 1000? What does this accomplish in terms of limiting our results?

  8. This is great, but… Most of the results after filtering are porn and I mean really vulgar porn that no one should probably ever see. Well except maybe the cops who need to arrest some folks.

    Is there a way to filter the porn out of the results? I think if you could do that then I could use the tool more effectively. As it is there are usually 1-3 results worth evaluating out of the list. And why am I getting so much porn looking for JavaScript keywords in the first place??????

  9. I loved this video because I didn't know a lot of things of content explorer. After watching this video, I really got some amazing tricks of content explorer. Thanks a lot, Sam Oh.

  10. Hey Sam – some good points here, but the low competition KW hack may not be work if the page is on a powerful site with Good Internal Linking. For example, this ranks #3 for "marketing" with no referring domains to the page, but the power of the domain powers that ranking.

  11. This is an amazing feature. I’ve been sleeping on it, definitely going to use that part of the more frequently now for my research, guest posting and keyword targeting 🙌🏾🙌🏾Thank you ahrefs!!

  12. Sam, You nailed it brother. Never thought about this. Its really helpful info. I will try it right now.

  13. I have a powerful message and a substantial percentage of all proceeds will go directly towards life coaching for low income students. That being said, would you consider housing any guest posts from me? Thanks in advance.

  14. Sir why my payment is failed by paying through PayPal account.Please make a video on how to create account on ahref

  15. As a recap of this awesome video, here's the filter settings for content explorer's low competition, high traffic search:
    Referring Domains: 0
    Organic Traffic: 1,000 (Needs to be tweaked based on niche)

  16. Hi! If I have URL of my competitor then if I will place in "site explorer" so it will show the number of referring domain. My question is: How can I identify that how many referring domains coming from guest posting and how many from business listing /just profile/commenting without checking all one by one?

  17. A problem with content explorer that stops it being an AMAZING tool – on a backlink report Ahrefs lets you sort the sites into categories (blogs, Ecommerce, CMS,) so Ahrefs knows what sites are – So why can't this be passed over to Content Explorer?? All ecommerce sites now have blogs and It's very unlikely your Ecommerce rivals will place your link on their blog – You really only want to be reaching out to blogs or content sites…… Why oh, why cant content explorer let you do this???

  18. Hi Guys,

    I am new to the world of blogging. I have a simple blog –, it is a content sharing blog, where I have been writing about quick read stories on things I learned from life, events, etc.

    My Question is – I want to invite guest bloggers, writers or contributors to come and contribute short stories on things they have learned from their life, experiences, etc. Can you guide me how to invite guest writers in the site?

    Just for reference – I have updated some benefits for the guest bloggers in 'About Us' –

    Also, created a guideline for the writers –

    Kindly guide.

  19. is there any free alternative for the tool he showed?? i'm just starting and can't really afford spending on such tools.

Leave a Reply

Your email address will not be published. Required fields are marked *