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
-
Refferal links
I have a site where I can pick up where my hits came from. So if somebody clicks from another website link to visit my website, I will then pick up from which website they came from and also which page they landed on. Will google penalize me for this and see this as paid advertising?
Link Building | | Heinwest0 -
Link Building
Are there any other webmasters in the MOZ community that are interested in creating multiple high quality link exchanges? Our company has a decent size client list we are interested in building links for.
Link Building | | WebMarkets0 -
Is providing a paid scholarship to schools and receiving a back link, classed as a paid link scheme?
I've always wondered if it is classed as paid links in Google's eyes?
Link Building | | ResumeGenius0 -
External links - link to third party sites
Greetings! Actually, got an doubt on linking to external site. The thing, i have working for roof marketers site. They have covered roof products. Each of the products have a page along with major keyword. Actually, i do link from other pages[internally]. Meaning,if i see any main keywords in different page then will link that to corresponding page/product[internally].This is what i am doing to get page rank. Now, my doubt. Some of the pages are having link with main keywords which directs to the third party site those who are really producing the products. But, i remove the third party-link which has with main keywords. Since already the site/my client site having pages for that main keywords. But client really want that link. meaning the links which they have given to direct to third party[product producer] site. So what should i do at this case. Can i just past RAW link like [http://www.thirdpartysite.com] or what do i do. But my client wants that link to be in content area. Hope you would understand my long explanation and case Please help us. Thank you
Link Building | | Webworld_Norway0 -
Root Domain Link for Affiliate's Link
It seems my affiliate link: http://www.hrmsplugins.com?partners=21 is not being considered as a "root domain" backlink when this link is used on their website. Is there a reason for this?
Link Building | | delphia0 -
Linking to a pdf
Hi All I have a pdf that people can download from my site, what I want to know is that when people link to the pdf does the pdf share link power to pages linked to from within the pdf (like a html page would) or is the link power being waisted going to the pdf and should I somehow get the links to a normal page? The pdf is a free downloadable resource to people in the party planning industry and so gets linked to quite a bit by sites telling their readers to get the information we provide. Thanks for your thoughts Sean
Link Building | | SKE0 -
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 -
Links on the same keyword
When is linking from one particular keyword to much. At what point could link building from one keyword be considered spam and potentially delist a site ? Is it possible for a site to be delisted for having to many links from the same keyword ? Heard linking from the website name is more important following recent changes. I try and link from a selection of 3 to 4 keywords. Thanks for your help
Link Building | | onlinemediadirect0
