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
-
Ran a backlink competitor analysis and found that the competitor has their links coming from various linkedin and youtube posts but my client does the same thing and im not seeing any links coming from those sources for them?
Ran a backlink competitor analysis and found that the competitor has their links coming from various linkedin and youtube posts but my client does the same thing and im not seeing any links coming from those sources for them?
Link Building | | Stongex0 -
Question about inbound links
Hi! Hi have a little doubt. I'm interested in getting higher positions for a landing page with a long tail keyword. Now the page (ecommerce product page) appears in position 5 and have a low authority domain site and page. My intention is to put more original text in the page and write a blog post with a link pointing to the product page. My doubt is: What is better? Building the blog into the same domain or build it into a high authority external domain (like wordpress), what link could be better for my objectives? Thanks! (And sorry for my English)
Link Building | | Empatica0 -
Linking between properties
I own 3 domains. One is my blog, one is my photography business site, and one is my graphic/web design site. They are all hosted on the same VPS account. I link between each site. Also, since the links are either in the nav, footer or sidebar, all pages from one page link to the homepage of each other. Is this an issue for SEO? Should I not be doing this? Would it be beneficial to use a no follow link instead if I'm to keep them?
Link Building | | studio35design0 -
The No of Sites linking to www.apollopowersystems.com is 50 as per Alexa, but Moz shows that the no of sites linking is 23\. The no has increased in Alexa but in Moz the no is 23 since 3 months. Why is this Difference?
Hi There, As I am new to SEO, so the problem that I am listing below may seem very naive. Please help me out. Please explain me the difference between the no of backlinks of the website, www.apollopowersystems.com as per the websites below. The nos are completely different as per the websites below: As per www.moz.com the no is 23 As per www.ahrefs.com the no currently is 586 As per www.alexa.com the no is 50 Please tell me why these nos are different. Looking forward to hear from you at the earliest. Thanks in advance.
Link Building | | KDKini0 -
Link over-building?
Hello all. One of the first things we do for our clients is to claim their local listings, include them on a set of selected directories (8-10), and blog directories (5), if applicable. Since they will all be linked to the client site, could doing all of this at once run us into problems with unnatural link growth? Thanks! Frank
Link Building | | FrankSweeney0 -
Link Exchange
Hi everyone, I just started working for a client in a new niche. After reviewing the backlink profiles of his competitors I can see that the top sites are using a ton of link exchanges. They are from really spammy sites too. The kind that will link to anyone that provides a link back. Anyone else seeing much of this?
Link Building | | SixTwoInteractive0 -
Do links from the second page of an article pass link juice?
I have been writing for some sites with a high overall page rank and the articles are being viewed as quality by search engines as well. However, they usually put a link to my site at the very end of the article and then break the article down into two pages to increase ad revenue. It seems that I'm not getting much credit for that link even if the page has a high SEOmoz/PR score. I want to know if I am getting the benefit from these links. If not, how do I make sure I get the most bang, even if my link is on a second page of the article? Here is an example of what I mean: http://www.forbes.com/sites/theyec/2012/08/22/kanban-for-customers-how-to-increase-transparency-in-your-business/
Link Building | | LawrenceWatkins0 -
Back link pyramid
Excuse me for such a newbie question but is using a backlinking pyramid black hat seo. I was trying to find out but every site gives you different advice on this subject. Also If there is a type of backlinking structure that is best please let me know. thanks
Link Building | | JasonRae0