Skip to main content

How to analyze backlinks in Excel?

Hello 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.

submitted by /u/Solid_Switch
[link] [comments]

from Search Engine Optimization: The Latest SEO News https://ift.tt/2XfetwQ
Labels:

Comments

Post a Comment

Popular posts from this blog

Local seo vs. natiowide seo?

I've done SEO for local businesses but I recently got my first client that sells an item nation wide. ​ Any suggestions for doing nationwide SEO? ​ I am used to making geopages for local towns. I was going to do the same with some input from the client about what cities or towns he would like to show up in? submitted by /u/Letmeinterviewyou [link] [comments] from Search Engine Optimization: The Latest SEO News http://bit.ly/2JHy0k0
Post a Comment
Read more

Clients site has a weird issue with 302 redirects that I haven't seen before.

Site is in Drupal, hosted on Amazon CDN & Cloudflare. So here's a quick breakdown: The site itself works normally. It's a bit dated, but you can click on links and navigate around as you'd expect. Seeing no obvious issues, I run a Screaming Frog crawl to begin my audit. Only 5 pages were picked up by the crawl which was super weird, since all internal links are regular html and there shouldn't be any issues. So I go through the site and manually collect a bunch of URLs, which I submit to SF again as a list. Every single link bar the 5 originally crawled return a 302, with the 'redirect' pointing back to the home page. Except as I said, those pages don't browser redirect. Browser side, they work fine. I guess they redirect the crawl bot though, since the rest of the site is functionally invisible. Other tools I've looked at say that the pages return simultaneous 302 and 200s, which doesn't make too much sense. These 302s are also old enough ...
Post a Comment
Read more