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
-
Houzz Comment Links
A company I am working with has been posting pictures and links to their website in the comments section of Houzz articles. I notice many companies have been doing this in general. While it generates decent amounts of traffic, I am wondering if google sees 30 links coming from article comments that it will deem that as spam? My gut tells me to send these comment links to the Houzz member profile, then direct them to your own website. Thoughts? ***Anyone in home design, decor, etc. should really get involved there. Fantastic source of business for professional in that field.
Link Building | | RandyEpp0 -
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 -
Reciprocal links
I've heard that reciprocal links don't count anymore. If i stop linking to a person that links to me, will that link to my website start counting? Do reciprocal links count at all in google? Anchor text? anything? Thanks in advance! Ron
Link Building | | Ron100 -
Buy links
I know that many of you are against the whole thing with buying links. Your feelings put aside. Will it be better for my site to buy links or even do link exchange? Haven´t the crawlers been thought by now how to find these untrue links? I have read somewhere that the stop after 100 links, aren´t they smarter than that?
Link Building | | mato0 -
Links in the Classifieds
We rent apartments. One way we use to find clients is to advertize these apartments in Classifieds. Generally, we use free ads. Sometimes, for very popular sites ( like Kijiji), we pay so our ads can be seen first. Could this be a problem with Google? Some sites send us clients, many of them never do. We keep putting ads there because of their PR. What is the worth of this kind of links? Thanks for your answers.
Link Building | | Caru0 -
How to recover from bad links?
I come to know about this blog post by recent blog post on Penguins, Pandas, and Panic at the Zoo! I have very good experience with example number 6. Honestly, It's working without any issue towards performance and ranking. But, I have very critical issue after implementation. I bought new home but, I have to hang Sign board with my old address. 🙂 I want to give live example with Google search result. I have removed my old website and set 301 to new category page due to duplication issue. Honestly, Who will like to mesh up performance in panda update? There are 56,311 links & 551 source domains pointing to my old home page. Just see this one! I'm creating quality links to my new category page where 301 redirect set from old home page to category page. I have big mind bubble about display of URL in search result. Why Google shows old home page URL in search result? Does it require to create 56,311 + 1 links or 551 + 1 source domains to get appear my new address?
Link Building | | CommercePundit0 -
Too Many Links???
SEOMOZ is telling me I have more than 100 links on quite a few of my pages, and I cant seem to find out what links they are finding. Like for instance on this page http://standupguys.biz/what-we-haul/commercial-junk-removal-services/computer-removal-recycling/ It is telling me that I have 117 hyper links (which is WAY too high). Can anyone explain to me where these are coming from, and how I can avoid this?? Please and thank you.
Link Building | | Caseman0 -
A good link builder / link building agency for Spanish content
Hi, I am looking for a good link building agency or freelance to execute a link building strategy for the next months. The content is in Spanish. Could anyone recommend me a good agency or a good link builder for Spanish content? Thank you very much! Jorge
Link Building | | jorgediaz0