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
-
Link Exchange
Is link exchange always bad? What if I want to add a link for other related products on my site which I do not offer, and the other site does the same for me? Will it be better to rather an article for each other product and link to somebody, than have one page with a list of other products to other sites. For example. We do training. Lets say we offer computer training. We search companies that does health and safety training offer to put their course on our site with a link to them, if they do the same.
Link Building | | Heinwest0 -
Would it be a valid "link building' strategy to pay youtube video owners, to link to our company website in the decription of a certain video. ( For popular video's that are relevant )
I was wondering if it would it be a valid "link building' strategy to pay / work out a deal with youtube video owners, to link to our company website in the decription of a certain video they posted? ( For popular video's that are relevant to our business. ) Anyone have any thoughts on this? Thanks in advance! Steven
Link Building | | RockyMountainFlyboard0 -
Linking to each other: when companies merge
Here's the scenario: An AC company bought two plumbing companies. The plumbing websites and the plumbing company names will stay the same for at least a year. Then the two plumbing websites will merge and have a new domain and website. However, we will already make small modifications to the two plumbing websites to introduce the new owner. Is it okay to create the following links? AC Company < > Plumbing Company 1 (linking to each other)
Link Building | | grojoh
AC Company < Plumbing Company 2 (one way link) After the merge is completed: AC Company < > new Plumbing Company Inc
new Plumbing Company Inc < (301 redirect) Plumbing Company 1
new Plumbing Company Inc < (301 redirect) Plumbing Company 2 My questions: Could the links described above raise a red flag or cause any other issues? The links are not at all meant to be spammy. They are meant to advertise for the other company's services and let the customer know that the Plumbing and AC companies are under one roof. I am thankful for every opinion. Johannes0 -
Having a link from a foreign site
I just ran an OSE on a competitor of ours that they have a few links from this website, http://www.tz-online.de/ would this not damage there site?
Link Building | | ScottBaxterWW0 -
Links Dont show up
Hi I was building baclklinks on my site, from forums, blogs and some low quality other sites. This links dont show up on the site explorer and the site ranks for my specific keyword. Why this is happening? I should link only from the sites that are linking my competitors? Thanks
Link Building | | nyanainc0 -
Total Links vs Ext. Followed Links
Hi I'm fairly new to SEO and SEOMOZ. I've created a campaign for my own site and I've added 3 competitor sites. There are 1,385 total links to my site and a massive 49,450 links to one of my competitor's site. However under "Ext. Followed Links", there are 1,045 to my site and only 911 to the same competitor site. Am I correct that it is the "Ext. Followed Links" which are more important from an SEO point of view as the other links have the "no follow" attribute set? Or have I got this wrong? Thanks James
Link Building | | avecsys0 -
RSS links vs. contextual links
Which has more value? Passes more "link juice"? Auto generated rss links or contextual links?
Link Building | | nicole.healthline0 -
Link building diagram
is there a simple chart or diagram that explains the linkbuilding process from start to finish? thank you, Vijay
Link Building | | vijayvasu0