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
-
GWT Lists URLs with links to my site, but those URLs don't have links to my site
There are a number of URLs that show up for my website in Webmaster Tools as having links to my site when in fact they don't. I know this to be a fact because I actually wrote some of the sites that Google is saying are linking to my site and I know there isn't any links on the specific pages to that site. For example, the site in question is: https://www.liftproducts.com/ As an example, Google is saying that about 100 URLs from https://www.lift-tables.net/ are linking to it when, I'm fairly confident that there is only 1 link to it found here: https://www.lift-tables.net/info.php?countrytabs=3 Yet Google says links exist on this (and many more) page: https://www.lift-tables.net/liftproducts/max-lift/lpt4w-030-48.php I thought at first it might have been due to linking to a image file directly instead of locally hosting it, but after checking the source, that's not the case. I am also seeing this type of non-linking being reported on sites I have no clue what they are. For example, some Spanish site about tandem bicycles is being listed as linking to liftproducts.com: http://206-225-85-34.dedicated.abac.net/tandem/inc Yet I can find no evidence of an actual link existing. Am I missing something here? Any insight of why this is happening and how I can clean up my link signature would be appreciated.
Link Building | | Nivik231 -
When we use 'link:' for who get the link, how come google show us the same domain as a link.
the search result show the domain of its own. what is is? and is it meaningful as a link?
Link Building | | onedaykorea0 -
What is a good ratio of total links to linking root domains?
Is 100 total links for every linking domain too high? I suppose I could also look at ratios of sites that are doing well in the rankings.
Link Building | | ProjectLabs0 -
No inbound links ?
Hello I just got SeoMoz, started the whole thing and compared myself to my competitor. I'm writing for mayor national newspapers in latin america, been featured a few major sites, and got a whole lot of links directing to muy site. I recently moved domains about a month ago from rxmagaizne.mx to rxmagazine.co. Is this the reason i'm not seeing any links ? ibIPY.png
Link Building | | timi-do0 -
Links in the Classifieds
We rent apartments. One way we use to find clients is to advertize these apartments in Classifieds. Generally, we use free ads. Sometimes, for very popular sites ( like Kijiji), we pay so our ads can be seen first. Could this be a problem with Google? Some sites send us clients, many of them never do. We keep putting ads there because of their PR. What is the worth of this kind of links? Thanks for your answers.
Link Building | | Caru0 -
Should I get these links removed?
Hi, I am trying to clean up the seo of my website. Recently stopped using a professional which might have been using grey hat tactics. I am researching, researching , researching but having trouble pulling the trigger on what I am finding. I have a couple old link exchanges going on. They are quite old. Some of them are on the footer of a website, and therefore bring in a lot of links (ie every time a new page is created). I am wondering if I should ask to get these links removed.. My link profile is pretty bad(at least according to me), nothing extremely bad, but lots of leftover of links coming from petitions, forums etc.. that I can't get removed. I have recently gotten some mention on good website but they have a way around linking directly to any website so I dont get much help from that.. If you guys need my website I can share if need be. thanks!
Link Building | | CassisGroup0 -
Squidoo for link building?
Hello Mozzers I'm thinking about using squidoo as a part of my link building. I've never used squidoo before, I'd love to hear from Mozzers using sqidoo for link building and traffic generation.
Link Building | | Thommas0 -
C-blocks and linking
I'm just starting to learn about cblock root domains and linking. I'm wondering about the following: Are there articles or websites to learn about dos and don'ts about getting a large number of links from one cblock? How do I know when a site has too many links versus the number of unique cblocks? I've been using Link Harvester on SEO Book and it seems like not many sites have more than 170 unique cblocks. Is this the total number of unique cblocks on the web or am I using the tool wrong?
Link Building | | EricVallee340