-
How to analyze backlinks in Excel?
Posted by on May 30, 2020 at 2:04 pmHello everyone,
I had recently used the Ahrefs trial to download competitor backlinks. Since I am a bit of a noob to link building, I was a bit overwhelmed by the tens of thousands of backlinks in the CSV files.
I have been trying to see which ones are relevant to my industry, and it seems to be a never ending process to manually research each referring domain on google for relevancy.
I wanted to know if anyone had any tips on analyzing competitor backlinks in Excel, as that would be quite helpful to me.
Appreciate any responses.
-
4 Replies
-
I have the same issue. Advice would be greatly appreciated.
-
If they link to your competitors, they should already be largely in your industry. Second option they are general news sites, which is still good.
If not, they are shitty links and you don’t want them anyway, regardless of their authority.
The process of checking which sites you want a link from is indeed manual, long process requiring a lot of expertise.
So what I’d do if I were you: take your list, split it in tiers by Domain Authority. All the +50 are good to get in touch with (I say 50 as a random number, on the safe side, cause I don’t know the context). The others, again to keep safe, leave them be. Your Backlink profile should indeed have those, too: but they might be dangerous if you don’t have solid basics of analysis. -
Pull authority stats for the page and domain for each link, sort descending by page authority, and look at the most important links first. If a site has no authority, and no page authority for the page linking, no need to review them. You’ll probably end up with a more manageable list of links to review.
-
I like to to filter for in content and do follow links within a domain rating window of greater than 30 and less than 70 with at least five backlinks.
That’s going to exclude a lot of possibly lucrative targets but also get rid of a lot of time wasters as well.
Log in to reply.