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
-
We are moving to HTTPS and wanted to know if our link building efforts were in vain or will the link juice pass to HTTPS?
We are switching to HTTPS and want to make sure the links we've gotten in the past will still transfer since they are pointing to HTTP? I'd hate to go back through and ask people to please add an s to the link.
Link Building | | bryant25560 -
Link Auditing
Anyone have any useful ways to link audit? I'm stuck picking up the slack from a previous worker who decided buying links was a great idea for our clients.
Link Building | | CGR-Creative0 -
Link Building
Are there any other webmasters in the MOZ community that are interested in creating multiple high quality link exchanges? Our company has a decent size client list we are interested in building links for.
Link Building | | WebMarkets0 -
Link Pharming
My company has been using an SEO company for a while and have built up our pagerank to a 6. However, we have noticed that they're involved in link pharming - they're buildng extra websites and linking to our site on them. We are not happy with this as we know it will only be a matter of time before Penguin hits us. The contract with the SEO company is coming up for renewal soon and we're thinking of cancelling it. However, we are not sure if the company will delete all our backlinks, which will probably decrease our PageRank too. Has anyone here ever had a similar experience? What did the SEO company do when you cancelled the contract? Does anyone here work for an SEO company and what do you do when someone cancels your service?
Link Building | | AAttias0 -
Is link exchange a reliable source to get back links?
I read a latest post on seomoz that _“Do not buy or exchange link with anyone who contacts you. This is completely against Google's policies and if they were to find out, you could be penalized." So I went through Google's ''Link Schemes'' and found that ''Excessive link exchanging ("Link to me and I'll link to you")'' can negatively impact a site's ranking . _ So is it the ''excessive'' link exchanging that can cause a negative impact? Exchanging links with good quality, cached sites (without excessive doing) can do good or bad? Can anyone please explain to me in detail?
Link Building | | semvibe0 -
OSE shows links on sites but can't find links
Hi mozzers, I'm cleaning up our backlink profile and looking up anchortexts in OSE. I downloaded and selected one anchortext. However when I go to the sites OSE found, I can't find the links. I look in the source code and onpage keywords. Is it because of my lack of skills that I can't find the links 🙂 or isn't OSE working properly.
Link Building | | StephWeigert0 -
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 -
Back Links
Hi there, I have been guest posting on blogs trying to build some back-links into my website, which so far is going not too bad, however I was wondering when writing these guest posts should I limit my post to let's say 2 back-links per guest post? If 2 back-links are going to different pages on my website, does the first back-links in the guest post have more value than the 2nd back-link? Kind Regards,
Link Building | | Paul780