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
-
Value of Links? What is each link worth?
Morning Everyone, I just had this thought and wondered what everyone's opinions were in terms of link value in monetary terms. We'll assume for the purposes of this that the links come from contextually relevant sites and that the sites in question have got the Moz DA from being high quality and have a good quality incoming link profile. Its a bit of a theoretical question, but i guess imagine if the only way you could get links was to pay for them, what would they be worth to you. This is link value for SEO purposes, they will have in addition value from traffic from good sites, that no doubt varies wildly depending on topic. I assume everyone also agrees on: The first link from a domain is the most valuable High DA sites are worth more than low ones. So could anyone who has an opinion on the link value suggest a monetary value for links. Its really just using a monetary amount to see how best to target my time. Here is my example of what might be expected, but I am hoping people with more knowledge will perhaps correct it. DA Rating First Link 2nd-5th Link 5th-10th Link 10Plus Links 5 $5 $2 $1 $0 15 $7 $3 $2 $1 25 $25 $10 $5 $2 35 $45 $20 $7 $3 45 $65 $30 $11 $4 55 $95 $45 $19 $5 65 $200 $100 $45 $6 75 $350 $120 $65 $9 85 $700 $240 $95 $15 95 $1100 $450 $200 $30
Link Building | | wellandpower1 -
Spammy links
Hi Guys, I have a case which seems to occur more often for our customers. The websites of our customers seem to receive tons of backlinks from websites all over the world (China, Russia, Ukrain, etc). It’s spam we never asked for, we didn’t buy any dodgy linkbuilding packages or anything. Do any of you guys have experience with this matter? We try to disavow the links but it takes too much time and we will never manage to disavow 100% of all links. Examples are www.keukensduitsland.nl and www.m2beveiliging.nl Hope anyone has experience and maybe even solutions for this matter. Thanks!
Link Building | | Happy-SEO1 -
Link removal
We were hit by penguin and have been going through the process of removing bad links. Things were looking up but then wasa 20% jump in our bad links. They all seem to be related. There are over 100 different domains that all seem to go back to mbiz. examples include http://www.5stone.com.cn/Literature-holders-.html http://www.building-stone.com/Display-furniture.html http://www.china-tombstone.com/Display-exhibition-products-.html It looks like they have automatically gathered data from google to create these pages. I would hope that the guys at Google are clever enough to be aware of these sorts of links. But if not I need to get them removed. I have tried whois but I cant find out how to contact these guys. Has anyone got any bright ideas? Thanks
Link Building | | Discountdisplays0 -
Link Exchange
Hi everyone, I just started working for a client in a new niche. After reviewing the backlink profiles of his competitors I can see that the top sites are using a ton of link exchanges. They are from really spammy sites too. The kind that will link to anyone that provides a link back. Anyone else seeing much of this?
Link Building | | SixTwoInteractive0 -
How do I stop Spammy links?
I've just taken over a clients site, and they are clearly being penalized for theier previous agency having purchased from a link network. They have thousands of low value links. Once I have identified them, how do I stop them? Is there a code, or a blocker or something that I can use to reject the links? Thanks in advance guys.
Link Building | | Dekoda_Jones0 -
Link exchange Trick?
As a lot of you people doing link building may have encountered most people we approach want a link exchange Ex: "I am willing to put a link on my site if you put one on yours." Now the question I had from this ... if I link to a specific website with rel="nofollow" and they link to me normally. Would it be of any value or because the 2 websites link to each other regardless of follow or nofollow the links have no value?
Link Building | | mosaicpro0 -
There is a New link to my Site but I can see it on link report ?why ?
Hi I found out using link campaign and Open site explorer that my competitors where getting links from this page http://www.visitgreece.gr/en/activities/land_sports/golf So I conatc the admins and added our golf courses too Is the dunes and the bay course in the middle of the page But this happened 3 weeks ago and still this linking domain is not appaering in my campaign why is that any ideas ? does it take so much time to appera to SEOmoz ? Or the problem is because they are linking 2 diffrent sites ? my site is www.costanavarinogolf.com Thanks a lot in advance for your help
Link Building | | grzontan0 -
Does linking to a subdomain give link juice to the main domain?
I have a few domains that I'm going to use for link building, will the link juice from the sub domains transfer to the main domain?
Link Building | | Vsky0