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
-
Refferal links
I have a site where I can pick up where my hits came from. So if somebody clicks from another website link to visit my website, I will then pick up from which website they came from and also which page they landed on. Will google penalize me for this and see this as paid advertising?
Link Building | | Heinwest0 -
Inbound Links not showing. Links are not no follow
Over the past several months I have definitely received inbound links to my website ( none of which are no follow). I have HubSpot as well s Moz and none of the links are showing. My competitors with the same link sources are showing though. I am completely dumbfounded. Why are my inbound links not showing and how much time does it take for them to show if they show at all? Thank you!
Link Building | | NPatt0 -
What is the process of link earning to avoid link building?
Hi All, I want process to earning links for new SEO 2014. Can anybody explain? Thanks, Akhilesh
Link Building | | dotlineseo0 -
Finding links online that already exist as link juice based on search results
I'm curious about this, I can't find anything on the net that talks about it. I wrote an article about it on squidoo and have had no responses so I am thinking this is very rare subject. The question is I have done some backlink research with my competitors with linkdetective.com and found many links (even follow ones) related to sites that provide search results. Here are a link about what I am talking about as an example, I have found many more besides this one. http://search.lphant.com/es/webResults.html?q=free%20scrabble%20dictionary&hl=en&page=1&src=hmp_es&ref=1 My site appears in those results. When looking at the source there is no "nofollow". I found this page because linkdetective.com had this link listed pointing to my competitor. Are these valid backlinks? What I have been doing is adding these links to http://www.google.com/addurl so that Google knows about them. Is there something I am missing or are these valid?
Link Building | | cbielich0 -
Are you careful about linking back to sites that link to you?
Suppose that a trusted website added you to their recommended links page. Do you worry that linking back to them from a page on your site will diminish the value of the original link?
Link Building | | Charlessipe0 -
For a new site, does it matter which sites I get back links from first? I.e., are the first back links more important than later ones?
I've heard that when a site is new, the sources from which it gets its first back links are very important -- that the early links are more important for ranking than later links. Is this true. If so, what would be some good places to get these very first links? Thanks.
Link Building | | sigma3x0 -
NEW LINKS
Hi If you plan to add new links to a site which currently has very few inbound links what is the maximum amount you could add in any one day before it is deemed by Google to be suspicious and unatural. I am referring ot manually added links, not robotic. Thank you 🙂
Link Building | | PH2920 -
Free link on a Paid Link Blog
Hi there, I have been doing some outreaching, and managed to have a blog post accepted on a authority blog. They included links to my website, and I was very pleased with the placement. However, having browsed through the site, I was worried to see that they openly admit they allow 'reviews' of websites, with backlinks included, for $50 per review. I am worried I might be penalised without actually doing anything wrong. I did not pay for my link, but the link has been placed on a site which openly admits they accept payment for links. Should I be worried? Should I ask them to take it down? To date I have been told countless times by bloggers I am outreaching that if I pay $10, $50, $100 etc I can write a blog post. I have never accepted because of the risk of penalization. Now, unwittingly, I am linked to from a paid link site with a blog post that would look like I have paid for it because of the placement and style of back link. What do you think? Thanks,
Link Building | | giveacar0