SEO

How to Quickly Find Unlinked Mentions and Build Links

Avatar
Tom English
June 23 5 COMMENTS

UPDATE: Since this article has been written, Ahrefs has added the functionality for exporting unlinked mentions

If you’re working with a popular brand, most likely, people are talking about that brand somewhere.

Wouldn’t it be great to find where people are mentioning your brand?

Also, wouldn’t it be great to build links from these mentions?

This process allows you to quickly find content that is mentioning your brand or you brand’s product and whether or not they are linking to your brand’s site.

This process can be used as a fast and easy way to prospect for link building.

In less than an hour you’ll be conducting outreach, politely asking for simple links back to your brand or product page.

People who are excited and loyal to your brand/product tend to be open to adding a links back to a brand they support.

First things first, set up your sheet using RankTank’s checkLinkBack script.

This will check if the url in a selected cell is linking back to the domain you are building links for.

To Get Started

Open up a new Google sheet (or you can use this one -don’t forget to select File > Make a Copy, so you have your own sheet) and go to: Tools > Script editor

function checkLinkBack(url,text) {
var counter=0;
do{
var response=UrlFetchApp.fetch(url,{muteHttpExceptions:true, method:"GET", followRedirects:true});
var myRegexp = /]*>/gi;
var elems = response.getContentText().match(myRegexp);
counter++;
}while(!Array.isArray(elems) && counter<=3) //if (counter>3){return response.getContentText();}

var output=[];
for(var i in elems) {
if(elems[i].indexOf(text)!=-1){
return true;
}
}
return false;
}

In the script editor, drop the above snippet:

Now it’s Time to Find Mentions

Next you want to use Ahrefs Content Explorer to search for content to check for backlinks.

For this I’d recommend using “Brand Name” or “Brand Name + Brand Product”.

This will give you a good amount of relevant content for your brand, but let’s take things one step further.

Make use of Ahrefs filters.

  • Set you Languages > English
  • Then Domain Rating > 20 to 100.
  • And then check the box next to “One article per domain”

This will keep multiple root domains out of your results, as you will probably only want conduct outreach on one link per domain.

 

You may be staring at that “Highlight unlinked domains” button and thinking to yourself,

“Well, this should do the trick right here, why am I even reading this?”

EXCEPT: when you export your list of content it does not highlight the unlinked mentions.

If your client has a good amount of products, you will want to find multiple lists fast and not have to go through selecting each unlinked mention.

After you’ve exported all you lists, import them into the google sheet with the RankTank script.

Insert a new column and put the domain you want to check links for in the header.

Use the following function in the cells below that to check for unlinked mentions.

=iferror(if(C2="","",if(checkLinkBack(C2,$A$1), "Yes" , "No" )),"N/A")

Replace “C2” with the cell that contains the url you want to check for a backlink and replace “$A$1” with the cell that contains your client domain.

Copy this formula down you sheet and let it do it’s magic.

This will tell you whether or not the urls you found in Ahrefs is linking to your client domain.

Now you have a list of prospecting urls as well as their DR.

Time to Make the Links

The final step is to now load this target list into your favorite link building outreach software, collect all the needed contact information – and you’re off to the races.

If you have any questions on how I use this process to mine for thousands of link opportunities each month, leave me a comment and I’ll get right back to you.

Avatar
Tom English

Tom is an SEO Analyst at I'm From The Future with a focus on link building. When not in the office, he can be found pedaling bikes around the Greater Philadelphia area.

COMMENTS (5)

Avatar
  • Avatar Alex says:

    Hey Tom,

    Thanks for this. Did give your code a try but something bugged out. Had our master techie look at it and it seems he fixed it by changing the regex. I don’t know much about coding, but his modifications definitely made things work for me so I thought I’d dump the code in here for your readers. Hope this helps anyone who might get stuck!

    ////CODE

    function checkLinkBack(url,text) {
    var counter=0;
    do{
    var response=UrlFetchApp.fetch(url,{muteHttpExceptions:true, method:”GET”, followRedirects:true});
    var texR = response.getContentText();
    var myRegexp = new RegExp(text,”gi”);
    var elems = response.getContentText().match(myRegexp);
    counter++;
    }while(!Array.isArray(elems) && counter3){return response.getContentText();}

    var output=[];
    for(var i in elems) {
    if(elems[i].indexOf(text)!=-1){
    return true;
    }
    }
    return false;
    }

    /////ENDCODE

    Thanks again, this is awesome!

    Alex

  • Avatar nilesh singh says:

    it’s really helpful to me …thanks you so much

  • Avatar Pranit Patil says:

    Hey ,
    thanks for sharing this info.

  • […] and can be really valuable as we’ll see here. We’re using a great snippet of code originally found here. That example shows how you can use exports of brand mentions from Ahrefs and check links. We just […]

  • […] Google Sheets has the ability to run scripts and can be really valuable as we’ll see here. We’re using a great snippet of code originally found here. […]

  • CONTINUE READING

    FREE VIDEO

    INCREASING CONVERSIONS WITH "KEYWORD INTENT"

    Our data driven approach to keyword research.