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
-
Links
Hi, im wondering if links that is not exact anchor links gives any boost for rankings? Example if lets say somebody links to my site http://domain.com/category/article with anchor: domainname or url link.
Link Building | | Rob_I0 -
What is the number of links do you require your link builder to attain each week or month? What is a reasonable goal?
Hello Mozzers... I would like to get a survey or feedback from other Mozzers who owns an SEO company or manages / hire link builders. **What is the average number of links does your link builder need to attain per week or month? what is their goal? ** I understand quality over quantity but I want to make sure there is a reasonable average to provide them goals and something to achieve on. Of course reward them more if they exceed or get .edu links. What do you institute? What do you think is fair and achievable per website? PS. There is no right or wrong answers here. I am looking for a measurable answer not subjectable. Again just gathering MEASURABLE GOALS.
Link Building | | ChatterBuzzMedia0 -
Disavow links
I am working on an account that has had several seo companies
Link Building | | JasperSEO
over the past year so around every corner I discover something new. One the
things I have found are that majority of links to the site is coming from an
outside blog but digging deeper I found that the blog is actually on the same
server as clients. Should I disavow links from that blog or should I leave it
alone?0 -
What is the difference between external followed links and internal followed links.
I have almost 3,000 external links followed and only a tiny amount of internal followed links. My website is doing really badly on google at the mo. I am also an SEO beginner and learning new stuff every day, but am not sure exactly what the difference is! Thanks!
Link Building | | heleni0 -
Over 47.000 inbound links from one site - can it hurt my rankings?
Im currently having some banner commercials on a relatively large Danish forum. I talked the forum owner into maing the banner "dofollow" so i could get the "juice" from the site, however im in doubt if this is good or bad for my SEO. Webmaster tools is telling me that i now have over 47.000 links from this forum. it seems like a Lot of links considering that i only have external links from about 5 other sites and the fact that my site is quite new. It seems like my site is not ranked very good yet(as mentioned in another question). I hope someone has some input 🙂 Best reguards
Link Building | | Havalina0 -
Link exchanges
I have quite a few legal clients and 90% of my clients top competitors are doing 1:1 link exchanges and they have been doing it for years. Other industries Dont seem as prevalent. I am just boggled every time someone says link exchanges don't work, will get penalized, or value is not passed. Its been working for my competitors....Legal SEO's seem to focus heavily on link exchanges. I have yet to do link exchanges, but am about to get started with a resourceful directory of local businesses on my clients site. Some will be linking back, but not all. Fear of penalization is lurking in my mind. Does anyone have any real data on this? Does anyone have an example of doing this properly and an example of how not to do it? I appreciate any feedback you can give. Thank you,
Link Building | | waqid0 -
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 -
Links from .edu sites
I have a band website and was thinking of making some link bait pages specifically designed to get links from high page rank music colleges and then funnel that page rank to my landing pages on my band site. I am planning on finding out what these colleges link to and create great information on pages on my site that the high page rank college websites will link to thereby boosting my trust and authority. How much will the trust and authority boost my site in the search engines? Because the colleges will be music colleges they should be relevant to my band site. Does this sound like a good strategy? Take care, Ron
Link Building | | Ron100