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
-
Does this lose link value?
I have a link to my site from a post on an online forum. I now want to include the forum in a blog post about good industry-related e-forums. If I link to them in this article, will I lose the value from the link on the post in their forum, and could it be seen as spammy?
Link Building | | AHC_SEO0 -
Are links from charities really better than 'normal' links.
Hi Guys. Just wondering about this idea that links from Charities are particularly good. I've heard people say that links from .org sites are particularly strong. But anyone can get a .org domain, it's just that charities tend to use them more often. Right? I just don't get the logic. Can anyone give more detail about this? Is it a myth? Is there quality info on this topic I can check out? We're working with several charities at the moment, and they all seem happy to blog and link to us...so I just wanted to know a little more. Isaac.
Link Building | | isaac6630 -
Link building with PDFs
I created a manual for a popular piece of equipment and placed it, as a PDF-file, on my website. The PDF contains a clickable link to the root domain of my website. Other websites have downloaded the PDF and put it on their own website, hosting it themselves. Since Google indexes PDFs, does the link in the PDF count as a regular 'link' from an external website, and does it have comparable value? Can't find any thoughts or studies about this anywhere.
Link Building | | RBenedict0 -
What is good quality link?
Recently we did some job for our friend who promised us link from his page for to ours. His page is very well ranking for key word we try to rank as well and has good authority. What would be a good link for our website to get from his in order to help us to rank better but still did not steel his traffic? Thank you
Link Building | | VillasDiani0 -
Question about ranking and links
Hi, Some back ground info first: My DA/PA is 42, the competitors who show up in the search engines for the term I am after have DA/PA 55/60. I have been creating anchor text links which target the term im after through guest blogging usually blogs with DA/PA 40+, I did this consistently with a guest post every 3 days for about a month so that's around 10 guest posts. And I also did some brand name blog comments, but these were no-follow and added sig to some forums. This moved me from page 5 to page 1, position 4. I then stopped and over the last 3 weeks it slipped to position 6 then to position 8. The competition doesn't look to actively target this term looking at the data from opensite explorer there main anchor text is there brand names. Why would I be slipping through the results? Not moaning just want to understand why so I can counter it. I was thinking about going for social signals through a blog to help.
Link Building | | activitysuper0 -
A good link builder / link building agency for Spanish content
Hi, I am looking for a good link building agency or freelance to execute a link building strategy for the next months. The content is in Spanish. Could anyone recommend me a good agency or a good link builder for Spanish content? Thank you very much! Jorge
Link Building | | jorgediaz0 -
Will No Follow Links count toward your root domain links for Domain Authority?
I am wondering if no follow links help, hurt, or do nothing when it comes to increasing page and domain authority? I know they are not supposed to pass rank and I have read discussions that some people suspect they still might, but I am wondering if I have a mix of follow plus no follow, will the no follow ones increase the count of the root domains linking to me and help boost my authority? Assuming of course the no follow links are coming from quality sites with high page and domain authority of their own. Thanks.
Link Building | | FastLearner0 -
Link Churn - where have all my links gone?
I am sure most of you have asked yourself the question I'm asking right now.. Where have all my links gone? I am starting to get twitchy now. I would estimate we have lost around 60% of our links in the past 3 weeks. Does anyone have any comeback stories? Feel like I am back to the start again. I have made a number of changes on the site not least removing a reciprical link page.. that had over 200 links on it but from reading one of Rand's tweets is it true that linking out could be good again?
Link Building | | robertrRSwalters0