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
-
linking domain issues
Hello guys. I am having issues with my linking domains. These domains are made outside of my website. I have tried to disavow these links but not able to do it. These are mostly from google redirects links. Here is the```
Link Building | | Rom1988z
code_text0 -
Sites with more than 18,000 links to my!
Tem um site enviando mais de 18 mil links para o meu site, como eu posso bloquear esses links e isso me prejudica ?? São Mais de 18 mil links com o texto acompanhantes RJ, isso prejudica meu posicionamento no google ? Have a website sending over 18mil links to my site, how can I block these links and this harm me? More than 18,000 are links to the text accompanying RJ, it undermines my position in google?
Link Building | | WebMaster210 -
Internal links
hey guys, these days should internal links within your site carry no-follow tags? or does it really matter? thanks!!
Link Building | | tm46150 -
Link Ratio
Hello, When Building backlinks is there a specific ratio I should try to follow to avoid any issues with google? Thank you!
Link Building | | TP_Marketing0 -
Changing links
Hi guys i wanted you views on changing the anchor text of links. I have quality links coming in but with year terms such as 2012 in there, if i want to change them all to 2013 for example would it be badly seen by Google? I cant say i feel comfortable about doing it but they are my links and are related to our products. Any advice much appreciated.
Link Building | | pauledwards0 -
Link building for rankings VS Link building for relationships
A Big Shout To Everyone -- Good Morning and What's Up 🙂 As I read today through seomoz professional guide to link building and the section why link building matters and in addition to this a newsletter I received today that changed my whole thinking towards link building for rankings vs for relationships. It is already happening on social networks if you are active there, but what about on your website. What are your thoughts on the following ? Google's job is provide the most relevant results to surfers online, and looking the link profile of a site & the page itself is the key to determining which page to serve on plate to the surfers link query ! Webmasters Site Objective:
Link Building | | helpwanted
I think that we as webmasters have to ask ourselves what do we want to achieve with link building. To get quick traffic or build slow authority links, high rankings, lead generation, sales & other things here I may be missing etcccc Other Objective Networking & Relationship Building Alliances : What I discovered today is that building links for 1st page rankings are great and will provide me with steady traffic, but not all of it is targeted traffic, but what else can I do to bring targeted traffic and at the same time try to build alliances with other related non competing business owners online. The idea... is to apply old school networking / relationship building alliances to get targeted traffic to my site that can actually benefit from my services. How Do We Achieve This I become a editor for approving resource links for me site, only the best will be placed on my site as a resource. Build a valuable tightly themed categorized resource section with related non competing resources that can help my sites visitors find what they are looking for, send visitors to non competing resources that may purchase their services which helps me build a relationship with them, and may can with rankings as well, provided I am selective with my qualification process. Questions & Concerns Below : What should I be thinking about when creating a resource categorized links page How many outgoing do follow links should I allow from this links partner page How will this links resource page affect my own SE 1st Page Rankings and is it worth it based on getting targeted traffic Any pros / cons I may be missing here0 -
Link building monitor
Hi i am trying to find a good link building monitoring tool, all the ones I have looked at are terrible. Basically i want to import my list of links so they can be monitored then emailed when failing. Can anyone suggest one they have used?
Link Building | | TomBarker820