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
-
Is it a good practice to get link for your original page by shorter URL links
Hello Moz Community, I have a question regarding getting links on bitly, tiny, or an other url shortner, Is it a good practice to get link for your page by shorter url I mean lets suppose i am getting natural guest post link from content for my blog home page
Link Building | | JoeySolicitor
https://coupontoaster.com/blog/ ; and shorten it with bitly and then hyper link so is it a good practice am I getting the same power and SEO consideration as if i would have done this without url shortener. And what anchor texts shall i be using like rich anchor text or any other like click here, visit here, bitly or etc Please kindly help me with this thanks1 -
Links from my Own Blog to my Own Website and Link Scheme
Hi There, I use my own blog to give advices and offer information related to my business service. Of course in terms of SEO my blog is useful not only to expand my brand presence but also to acquire long-tail traffic. I use to insert a maximum of one link with a relative matching anchor text in every article of my blog pointing to my own webpage. Said that, the questions are as follows: Am I involuntarily participating in a Link Scheme with my blog? And If so, how many links can I send to my own webpage ? Shall I limit the number of links to a minimum? Thanks a lot for your advices.
Link Building | | Midleton0 -
Paying for a Link
I realize it is bad to pay for a link but is it bad to pay for a link on a page that ranks you 1 to 10 againist your competitor, shows a screen shot of your and lists Pros and Cons of your site? Is this sort of paid link different somehow?
Link Building | | Studio330 -
About link from .edu website
If you have a website on designs is it worth getting a link from an .edu site
Link Building | | ksbnok0 -
Deep Links From Same Domain
I know that it is best to diversify your inbound link profile, but I would like to know the best practices for a domain as a whole as opposed to the domains component pages. If I have a good link source (say for example Squidoo) that can provide links to a website's home page AND a few of its lower tier pages, are all these links of more or less equal value (for seo purposes) to each of the link targets, or does Google simply use a "one source domain, one counted link" approach? Thanks Bill
Link Building | | veezer0 -
Which link should I use for link building?
I have an article which have high rank on Google. But recent, I use mod rewrite url so this article have new url. old: mywebsite.com/c1/p-1 new: mywebsite.com/c-e/p-1 Now, google is indexing old url. I want to ask when I build linking to my site, which link should I use for link building? I should build linking for new url or old url. Thanks
Link Building | | sonzin13040 -
If I write a PR release on a site such as PRweb with anchor-text links that is picked up and published by other news sites, do the engines consider this duplicate content or additional, beneficial links?
I recently wrote a news release on PRweb that was picked up identically by 8 other news websites, with the same anchor-text links as the original. Is the reproduction of duplicate content and links across different websites like this to the benefit or detriment of SEO and ranking power? Some of the links are: http://www.mynewsdesk.com/uk/view/pressrelease/eventa-new-eventa-christmas-parties-website-is-launched-648923?utm_source=rss&utm_medium=rss&utm_campaign=Alert&utm_content=pressrelease http://www.prweb.com/releases/christmasparties/neweventasite/prweb8562064.htm Many thanks!!
Link Building | | RobertHill0 -
Link Churn - where have all my links gone?
I am sure most of you have asked yourself the question I'm asking right now.. Where have all my links gone? I am starting to get twitchy now. I would estimate we have lost around 60% of our links in the past 3 weeks. Does anyone have any comeback stories? Feel like I am back to the start again. I have made a number of changes on the site not least removing a reciprical link page.. that had over 200 links on it but from reading one of Rand's tweets is it true that linking out could be good again?
Link Building | | robertrRSwalters0