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
-
Moz bot not discovering important links (high DA sites link)
Moz bot is unable to crawl and discover my links on the high authority websites like microsoft, linkedin, pinterest, etc. Where is the problem?
Link Building | | TechG0 -
Subdomain links vs root domain links? Are the less valuable?
I am determining the value of links we get. Is a link on a subdomain less valuable vs one on the root domain? How less valuable would you consider a subdomain link? For example blog.site.com vs site.com/blog What other metrics would you take into consideration for the value of a subdomain link?
Link Building | | calf0 -
Link Value
My question is how valuable is getting a link from a PA 71 with roughly 20 links on it. I guess I am saying how many links from a PA of 30 would be a comparable indicator. I understand there is an almost exponential value of authority as they go higher, but I am looking for a good explanation from a technical aspect. Hypothetical Scenario Would a person be better off pursing 20 links from PA25 pages, or would you be better only getting 1 from the PA71 all things equal.
Link Building | | mbarden260 -
RSS feed links
Is this an RSS feed link? How was this page generated? http://blog.moregoodfoundation.org/category/technology/feed What causes it to show up as a backlink in open site explorer? And how would you go about removing these links? Lots of questions there 🙂 Thank you.
Link Building | | ThridHour0 -
Spammy Links in MOZ but when I go to the external link I can't find a link to us
I was going to try to contact webmasters to see if they would remove some of our spammy links. I see alot of them in MOZ but when you go to the site our anchor text is not there. Is this good? How often does MOZ refresh external links. Please see: http://www.opensiteexplorer.org/anchors?site=www.totalvac.com None of the links for the anchor text <a class="clickable title link-pivot" title="See top linking pages that use this anchor text." data-text="vacuum cleaner parts vacuum parts vacuum bags vacuum cleaner bags" data-id="46391436859">vacuum cleaner parts vacuum part...</a> in MOZ exist? We got hit extremely hard by Penguin in May
Link Building | | totalvac0 -
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 -
Is it a reciprocal Link ?
Hi, I found a great website and tought its content would be extremely interesting for our clients. I wrote about it on my blog (which has an URL with our website URL in it) , Facebook Page and even in Twitter. Meanwhile, I contacted them and offered to write an article about an interesting subject for them. They accepted and liked it so much that they decided to put 2 links for us on two of their pages. My questions are : Will this be a reciprocal link for Google? Did I make a mistake talking about them on my blog ? Did I «devaluate» the links they gave us?
Link Building | | Caru0 -
Blog traffic / link ratio? (Esimated of how much traffic will result in a link)
Hi, Was wondering if people could please tell me some estimates of how much traffic is likely to gain links to a blog post? For example 1,000 hits = 1 link, Hence 10,000 hits = 10 links to a blog post? I understand there is no magic ratio I just want to know what people have achieved. I’m after averages not just a one off really successful blog post too. Please specify the topic you achieve this in e.g. SEO, photography, business, heath... etc.
Link Building | | charles10