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
-
Spammy links
Hi Guys, I have a case which seems to occur more often for our customers. The websites of our customers seem to receive tons of backlinks from websites all over the world (China, Russia, Ukrain, etc). It’s spam we never asked for, we didn’t buy any dodgy linkbuilding packages or anything. Do any of you guys have experience with this matter? We try to disavow the links but it takes too much time and we will never manage to disavow 100% of all links. Examples are www.keukensduitsland.nl and www.m2beveiliging.nl Hope anyone has experience and maybe even solutions for this matter. Thanks!
Link Building | | Happy-SEO1 -
Internal Links - How to Increase them, Categories not being considered as Internal Links
Hi All: As per my understanding, Internal Equity Passing Links is a metric defining PA. Now my website has around 65 internal links while few of my competitors have more than 180 links. I am unable to understand how to increase the internal links passing equity on my website, because I can see, more number of links on my website than my competitors but opensiteexplorer does not show that. I am really confused. Please help out if anyone knows something about this issue. Thanks in advance.
Link Building | | sidjain4you0 -
Links to main landing category page or links directly to products
I have an ecommerce website and a manufacturer is providing links directly to my website from their products pages because they do not sell directly online. What is my best linking juice power for this situation:
Link Building | | dsmolinski
Manufacturer A has a number of different brands: brand1, brand2, brand3 and a number of different products in each of it brands. They are currently linking their individual products to my individual products on my website. My website is setup like this:
my.com/manufacture-A
my.com/manufacture-A/brand1
my.com/manufacture-A/brand1/product1
my.com/manufacture-A/brand1/product2
my.com/manufacture-A/brand2
my.com/manufacture-A/brand2/product1
my.com/manufacture-A/brand2/product2 What is the best practice for this situation:
--Linking manufacturer product to my product
--Linking manufacturer product to my associated brand page
--Linking manufacturer product to main manufacturer page
--or something else? Thank you and I can provide more details if need be. Denny0 -
Reciprocal links
I've heard that reciprocal links don't count anymore. If i stop linking to a person that links to me, will that link to my website start counting? Do reciprocal links count at all in google? Anchor text? anything? Thanks in advance! Ron
Link Building | | Ron100 -
Why are my inbound links not showing up?
According to Webmaster tools, I have about 150 linking to my web site. In the Open Site Explorer, none of them show up. Sorry, I am a newbie with SEOMoz. I sure appreciate someone helping me answer this question. Thank you. http://tampapaintingservices.com
Link Building | | combesinc0 -
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 -
Link or Ad
I recently requested a link back from a site that is ranking 2nd for a term that i'm working on and they said they would gladly give me the link and remove my competitors but would also like me to have an ad on the same page for an annual fee that i could link to a landing page. I know that paying for links is no good and google can penalize you. so do i pay them and do a no follow to the landing page from the ad and call it a day? and how does google differentiate an ad from a link?
Link Building | | CHiP_RuN0 -
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