28,000 links - How to analyse sensibly
-
Hi
My client has a large amount of back links. Does anyone have a simple way of analysing these and making sense of such a large dataset.
Thanks
-
Hi Neil,
A direct link to download the program mentioned previously can be found here. What the previously user likely meant in regards to your question is to extract the data to a CSV file using Open Site Explorer, and then to use the aforementioned PowerPivot (a data analysis tool for Microsoft Excel) to help sort and gather information for your data. This tool is designed to help organize large datasets, so it would be worth a try.
-
Hi Keri
Sorry, never got any decent responses
Neil
-
Hi Neil,
We're following up on old, unanswered questions. Did you ever figure out a good way of analyzing the backlinks that you could share with us?
-
Hi Rishi
Extract how, pivot to what?
-
extract, and use excel - pivot tables are your friends
http://www.powerpivot.com/
Got a burning SEO question?
Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.
Browse Questions
Explore more categories
-
Moz Tools
Chat with the community about the Moz tools.
-
SEO Tactics
Discuss the SEO process with fellow marketers
-
Community
Discuss industry events, jobs, and news!
-
Digital Marketing
Chat about tactics outside of SEO
-
Research & Trends
Dive into research and trends in the search industry.
-
Support
Connect on product support and feature requests.
Related Questions
-
Sites with more than 18,000 links to my!
Tem um site enviando mais de 18 mil links para o meu site, como eu posso bloquear esses links e isso me prejudica ?? São Mais de 18 mil links com o texto acompanhantes RJ, isso prejudica meu posicionamento no google ? Have a website sending over 18mil links to my site, how can I block these links and this harm me? More than 18,000 are links to the text accompanying RJ, it undermines my position in google?
Link Building | | WebMaster210 -
I want to design SEO link building strategy for my website? Is wordpress.com, squidoo, tumblr, blogger, typepad - Good option for link building?
I am currently concentrating on 8 keywords, for e.g (A, B, C, D, E, F, G, H). I will be writing blogs with 2 of any related keywords present in it. I am thinking to post 5 blogs on 5 different platforms as (wordpress.com, Squidoo, Typepad, Tumblr, blogger) respectively. I am thinking a strategy as: Monday: Keyword A,B on Wordpress/ C,D on Squidoo/E,F on Typepad/G,H on Blogger/ A,C on Tumblr. Tuesday:C,D on Wordpress/E,F on Squidoo/ etc.... and will rotate these keywords through out the week and the cycle restarts on Monday. The URL for every keyword will be different and relevant to that keyword. I need quick suggestion on this topic..Please..
Link Building | | Christain0 -
Reciprocal links
Are they worth anything, if they are from relevant sites? I'm I better off avoiding linking back wherever possible?
Link Building | | littlesthobo0 -
Linking to sites that link to porn or casinos, my site getting penalized?
I have some link exchanges with some sites to get web traffic but when i ran the bad neighborhood link checker, i found that one site links to some casinos and another site has one link to a porn site. Is this getting me penalized? should i remove the links to these sites? Thanks, Ron
Link Building | | Ron100 -
Link Builder Recommendations
I've been looking for a link building company-person for ages now and can't seem to find someone worthwhile. The reason of course is that most of what I have seen is that they don't actually know what they are doing. I can link build but don't have enough time, I am looking for someone to build links to inner pages of my site to get its authority up without risking getting hit by any update or banging my head against the wall 6 months from now. Im on a shoestring budget but I think it would be enough to get someone worthwhile to do some long term link building. Anyone have some good recommendations for lets say $500 or less a month ?
Link Building | | NikolasNikolaou0 -
JavaScript is crawled by search engines, isn’t it? Does it mean that links embedded in JavaScript pass link juice?
I wonder If links embedded in JavaScript from an external Website pass link juice to the linked page and thus have a positive effect on google rankings. I read that JavaScipt is craweld. Does it mean that also the link juice is passed? I'm looking forward to your answers.
Link Building | | Tabea0 -
How do you determine a quality link?
I have a question about quality of links I'm seeing with my linkbuilding program. I just noticed that my 2nd ranked backlink contained the keyword as the username with a link back to my site. There was no relevant text in the comment itself with the keyword linking back to my site. My question is this good practice? I wanted to get your opinion of these kind of links for a linkbuilding program. Here's the backlink and our keyword is the username Cat Control: http://bytesizecss.com/blog/post/fix-haslayout-with-one-line-of-css. It looks like everyone posting on this page is just linking their username back to their site... I'm not an SEO expert by any means, but if everyone is doing this same type of link building on a directory type page such as this. Could these type of links eventually become a target like what happend with the farmer/panda update?
Link Building | | Woodstream0 -
Link Building
I've been hearing about going after niche directories, and my question is most of them have a ton of links on any given page. Is it even worth taking the time to approach these sites knowing they won't pass a lot of link juice?
Link Building | | azguy0