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
-
How do websites get links here...
Does anyone know how people get into the "Top Links on This Topic" section of the Huffington Post? I can see that the "Around the Web" section is curated by someone, in this case "Jeff Muskus" but there is no indication how the Top Links on This Topic appear on a page. The only thing I noticed is that the original article appearing in HP is almost a year older than any of the referenced links. Image: http://epicscripts.com/HuffPo.jpg Original link: http://www.huffingtonpost.com/2010/04/23/abuse-victim-lawsuit-trea_n_549542.html
Link Building | | cgman0 -
OSE shows links on sites but can't find links
Hi mozzers, I'm cleaning up our backlink profile and looking up anchortexts in OSE. I downloaded and selected one anchortext. However when I go to the sites OSE found, I can't find the links. I look in the source code and onpage keywords. Is it because of my lack of skills that I can't find the links 🙂 or isn't OSE working properly.
Link Building | | StephWeigert0 -
10,000 links in 2 minutes
Hey guys. A belated happy new year to everyone who reads this! I had a strange experience yesterday with linking from a clients website footer. Basically, the client currently has a serious duplicate content problem caused by a multiple language plug in. It has made Google believe that there are 10 different versions of the clients website online (one for each language). It is a real estate website and there are quite a few pages anyway, but with the error, I would suggest the page count is now around 10,000. We are waiting for the developer who installed the plug in to repair the problem and without thinking it through really, yesterday, we made a text link to our home page in their footer. Overnight, our rankings for the keyword we used for the text link have dropped from pos. 2 page 1 down to halfway down page 2. Is this basically a sign that it is not good have this footer link from their site? I guess it is kind of like 10,000 weighted links being added in one day right? For now we have removed the link, but any help would be greatly appreciated. Cheers, Mark
Link Building | | Nextman0 -
What are the new ways of Link Building which will get quality links?
Hi We are doing following kinds of Link Building: 1. Article marketing 2. Directory Submission 3. Guest Blogging 4. Press Release submission 5. Infographics (Viral Marketing) I know blog commenting and links from discussion forums are considered as greyhat / blackhat by google. So I want suggestions on some other ethical(Whitehat SEO) ways of Link Building to get quality Links. Also suggest me some Free article submission sites which give " dofollow-links" Thank You
Link Building | | Virrtuo0 -
Do sites on the same c-block and same server count as seperate linking root domains when linking to each other?
Lets say there are 50 businesses who have their website on the same server and are on the same c-block but the owners of the individual sites are different (i.e. they are all completely different sites not relevant to each other). Each of those sites are linking to each other due to a feature on the sites. This obviously increases the number of total links to each site but does it also increase the number of linking root domains? Or does this just show up as one linking root domain due to all of them being on the same server and the sharing the same c-block?
Link Building | | cinternicola0 -
Link building monitor
Hi i am trying to find a good link building monitoring tool, all the ones I have looked at are terrible. Basically i want to import my list of links so they can be monitored then emailed when failing. Can anyone suggest one they have used?
Link Building | | TomBarker820 -
Linking articles to each other
I've been using white-hat article marketing to post original content about my niche to credible article directories (yes, I realize many of them were recently devalued). My question is: Is it a good or bad idea to have future articles link to older articles, as a way to increase the chances of having the older articles indexed, or increasing the amount of link juice they pass to my site (since they point to my site)? I get 2 links per article and was thinking of using 1 to point to a prior (related) article, and the other to point to my site.
Link Building | | scanlin0