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 to recover from the bad links?
Hello, I am the administrator of abarkavanco.com. My site DA drop down 16 to 13. How can I recover the Bad links for increasing DA? Thanks all
Link Building | | BillySeal0 -
If I disavow bad links on "disavow link webmaster" will they still show up on my moz reports?
We recently found out we have a lot of bad links linking back to our website from spam sites, I disavowed them through the google disavow link webmaster. On my moz report it still shows the links, is that normal?
Link Building | | Ryan.Cruz0 -
Does This Link Have Value?
Hi Mozzers, A client paid to publish a white paper, thinking that the link to the web site is beneficial. The link does redirect back to the web site, but is in a format that I've never seen: http://r20.rs6.net/tn.jsp?e=001YdyyLrzOQJxM87SJZkJYVbQKSdCmFpwqg1fuX3yqVqpGboUjdSaHv9IdW5HsQpgmvwOrg5N4T3DNHYV8e1UVe_YCua_XQCFykoSJvu1HzDyb-3x-aFcPU-ER-vwWxq4- Does this link have any value?
Link Building | | waynekolenchuk0 -
Link Campaign
I need to put together a link campaign, but am a new SEO in training. Any recommendations on how to start, even if it's just read certain articles or watch certain videos? Your help is appreciated!
Link Building | | cbeuoy0 -
When do my links show up?
For the last two weeks I have been working on linkbuilding. I have downloaded competitors link reports and started contacting or submitting links. In the last two weeks I have gotten about 50-60 or so. In the newest report it shows I went up four c-blocks. Why is that? It is kind of discouraging.
Link Building | | EcommerceSite0 -
5 Million Links?
Hi all, I've been hired as the chief marketer at a (very) high traffic web company. Ironically, I don't have much SEO experience but I have been able to figure out PPC, on-page SEO and SEO content generation pretty well over the last few months. What I don't get is link building. My question is this; we're trying to move from the 3-4 SERP slot to the 1-2 SERP slot for a short list of keywords. My boss asked me to get busy with link building. Our competitor has over 2 million external links and we have roughly 60 thousand. What do I do? How do I start? Is there a legit, white hat way to get this job moving? Any insights would be GREATLY appreciated. Thanks in advance!
Link Building | | SEOguppie0 -
Link Directories
Hi there, We're very shortly launching a new website so as part of our link strategy we will be linking to directories found with the Link Acquisition Assistant for various keyword searches. I was wondering at what point is it not worthwhile submitting to these directories with regards PA and DA? For example if a directory has a domain authority of 69 but the page authority for the keyword in question is only 1, would it be a waste of time? Cheers
Link Building | | TalarMade0 -
Removal of dodgy links
Examining the backlink profile of a new client I can see a large number of links developed by an offshore agency they used for link-building. The client is a reputable, professional company but some of the links are on very low-quality sites in-between viagra, online pharmacies, cosmetic surgery etc. It is unclear whether some of the links are paid or not. There is no indication that they have been penalised for these links but they are obviously unhelpful. Can I use GWT to request Google ignore them or should I just leave them and move on with more appropriate link building techniques?
Link Building | | bjalc20110