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
-
Why are my internal links up by thousands?
I recently carried out an internal link audit on our site and added around 100 links to other pages over relevant anchor text. One week later, Moz shows our internal links are up by 11k. Why?
Link Building | | AntelopeAgency0 -
Unnatural Links To Your Site — Impacts Links warning, Should I do something?
Hi, I got: "Unnatural Links To Your Site — Impacts Links Google has detected a pattern of unnatural artificial, deceptive, or manipulative links pointing to pages on this site. Some links may be outside of the webmaster’s control, so for this incident we are taking targeted action on the unnatural links instead of on the site’s ranking as a whole. " I don't see any dropping at rankings, could the best solution here to be, just to leave everything as it is and be more careful with the link building in the future? Or is there a danger that Google gives further penalties if I don't act on this one do something? I am little afraid that if I start removing links, my rankings will drop, even though they have remained same if don't do anything? Any help is appreciated.
Link Building | | pok3rplay3r0 -
How to analyse a big drop in external links
Hi! Can someone tell me the best way to determine what caused a big drop in External Followed Links? I have used tools like remove em in the past to try and get rid of exact match keyword links but I'm unsure if this was the root cause. Our rankings went up the 3 months after this period, but this year they have dropped back to levels from 2015. I'm wondering if this drop has anything to do with this decline. See attached. EHyIy
Link Building | | KerryK0 -
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 -
Footer Links And Link Juice
I'm starting to learn about link juice and notice in GWMT > Traffic > Internal Links, that the list is in this order by the links counted on each page. Some are in the footer and some are in the header, with some being more important than others commercially i.e. /register /privacy /terms /search /sitemap /disclaimer /blog /register So I am wondering if I should add a 'no-follow' attribute to the footer links i.e. privacy, terms, disclaimer and leave the others as they are? Does this help retain link juice on each page where the links appear? Or am I missing the point all together? This is my website: http://goo.gl/CN0e5
Link Building | | Ubique0 -
What are inbound links worth after Panda and Penguin, since a site ranks for the NATIONAL keyword "outdoor furniture" with ONLY 7 INBOUND LINKS!?!?
ARE INBOUND LINKS TODAY ALMOST WORTHLESS??!!? After having been the KING of SEO, down to the toilet? Today I got a great sample from a fellow SEO professional showing a site, rockymountainfurniture.com rank for "outdoor furniture" with ONLY 7 INBOUND LINKS FROM 3 DOMAINS and a domain trust of 14!!!! ON A NATIONAL, VALUABLE, HIGH QUERY VOLUME KEYWORD!! I was stunned, but is this the "NEW SEO WORLD" we live in, so we should skip spending hundreds of hours on link building? There are over 32 different types of inbound links but this is much MORE than a radical change, this is turning SEO as it was up-side-down. Any input, thoughts, ideas?
Link Building | | yvonneq0 -
Link values
I have an interesting question, it's more to see other peoples opinions than looking for an exact answer, as I know noone can give that. If you had a good link on harvard.edu.. how many very low quality links on low DA domains that are full of junk, would you need to match the harvard link... if all other factors were equal. I'm gonna go for 500.. I've had great results with a few high DA/trust links. I'm not looking for anyone to give me a definative answer, just curious as to the views of other SEOs 😄
Link Building | | PeterM220 -
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