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
-
The No of Sites linking to www.apollopowersystems.com is 50 as per Alexa, but Moz shows that the no of sites linking is 23\. The no has increased in Alexa but in Moz the no is 23 since 3 months. Why is this Difference?
Hi There, As I am new to SEO, so the problem that I am listing below may seem very naive. Please help me out. Please explain me the difference between the no of backlinks of the website, www.apollopowersystems.com as per the websites below. The nos are completely different as per the websites below: As per www.moz.com the no is 23 As per www.ahrefs.com the no currently is 586 As per www.alexa.com the no is 50 Please tell me why these nos are different. Looking forward to hear from you at the earliest. Thanks in advance.
Link Building | | KDKini0 -
I am getting links on people's wordpress blogs but are not showing up on the just discovered tool. Is it true that wordpress links are no-follow links that do give off any link-juice?
A blogger told me that "wordpress.com does not allow blogs to show advertisements or use links to sites that sell merchandise of any kind" is this true? Am i wasting my outreach time trying to get links from wordpress operated blogs?
Link Building | | odegi0 -
"gimme links" = easy to fill out profile/personal reputation links that offer a do-follow anchor text flexible link
I'm doing some SEO for small niche service sites...and aside from niche directories and some light article marketing and local search directories (yelp, etc) there really isn't a budget for content generation. I really only have a budget for profile/submission links. What are some sites where you can quite easily fill out a personal profile with an anchor text variable link that may not be THAT juicy but will stick (i.e. not a spam/fake profile type of link, but something like Linkedin). I'll start with giving away 1 www.istockphoto.com Any others that aren't obvious?
Link Building | | ilyaelbert0 -
10,000 links in 2 minutes
Hey guys. A belated happy new year to everyone who reads this! I had a strange experience yesterday with linking from a clients website footer. Basically, the client currently has a serious duplicate content problem caused by a multiple language plug in. It has made Google believe that there are 10 different versions of the clients website online (one for each language). It is a real estate website and there are quite a few pages anyway, but with the error, I would suggest the page count is now around 10,000. We are waiting for the developer who installed the plug in to repair the problem and without thinking it through really, yesterday, we made a text link to our home page in their footer. Overnight, our rankings for the keyword we used for the text link have dropped from pos. 2 page 1 down to halfway down page 2. Is this basically a sign that it is not good have this footer link from their site? I guess it is kind of like 10,000 weighted links being added in one day right? For now we have removed the link, but any help would be greatly appreciated. Cheers, Mark
Link Building | | Nextman0 -
So I ran into a site that was not ranking 4 days ago and has over 2 million links to it on some keywords. My guess is this is a link bomb, but the issue is this is pushing one of my sites down. Does anyone know a good way to over come a bomb like this?
So I ran http://www.riogrande.com/ into this site not that long ago and wanted to see if any other SEO's have an opinion on it. I've seen a Google bomb before, but the amount of links going into this URL  is insane. The thing is how does one over come a Google Bomb? Do you just wait to see what Google does or do you just hope to rank under that URL? I should also note that it appears that all the keywords to it are relevant to the sites content. Let me know your thoughts. Thanks
Link Building | | kateG12980 -
Java Script Link
Hello, We are due to get a link on the daily telegraph page (UK Newspaper) very shortly. We have just noticed there links are within javascript, what do you think of this link? | |
Link Building | | ScottBaxterWW0 -
Nofollow blog links
Does a nofollow blog link pass any link juice back to the site the link is pointing to?
Link Building | | azguy0 -
Link Directory
I am not an SEO expert by any means, just trying to improve the ranking of my own personal real estate site. Are directory links good for backlinks, or are they a waster of time?
Link Building | | CalgaryRealtor390