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
-
Unnatural Links To Your Site — Impacts Links warning, Should I do something?
Hi, I got: "Unnatural Links To Your Site — Impacts Links Google has detected a pattern of unnatural artificial, deceptive, or manipulative links pointing to pages on this site. Some links may be outside of the webmaster’s control, so for this incident we are taking targeted action on the unnatural links instead of on the site’s ranking as a whole. " I don't see any dropping at rankings, could the best solution here to be, just to leave everything as it is and be more careful with the link building in the future? Or is there a danger that Google gives further penalties if I don't act on this one do something? I am little afraid that if I start removing links, my rankings will drop, even though they have remained same if don't do anything? Any help is appreciated.
Link Building | | pok3rplay3r0 -
No follow external links
Hi all, Our blog utilizes a fair amount of guest blog articles. Each article includes a link to the authors site. Some memebers of our team believe it is best practice to no follow all of these links while others believe we should follow the links, Our page rank and domain authority are almost always much higher then the guest blogger's site so we want to know the pros and cons of nofollow vs follow of these links. Since the domain authority and page rank of guest blog sites are low will this have a negative effect on our site? They aren't spammy and are legitimate sites covering similar content. Any feedback would be greaty appreciated!
Link Building | | STP_SEO0 -
Should I Disavow a Link Like This?
I just saw this link appear for my website (www.webhostinghero.com) in ahrefs.com this morning: http://freedatingsiteregistry.com/tag/website-template/ (search for text anchor "hosting reseller") Obviously it's a scraper site. Other than that, my link profile is clean. Should I disavow this?
Link Building | | sbrault740 -
Ecomerce: Would 4 link sections leak too much link juice?
Hello, In my content management for our ecomerce site, I've found that there are sometimes links to sites in our industry that have "helpful links" sections. Several strong sites link directly to these resource sections. There are 4 different topics that fit this trend in our industry. Would it leak too much link juice to make 4 comprehensive link sections and place a link to them on our "Useful Articles" page? Or should I stick to one comprehensive link section? Or perhaps a small link section? Or none at all? Thanks.
Link Building | | BobGW0 -
Link or Ad
I recently requested a link back from a site that is ranking 2nd for a term that i'm working on and they said they would gladly give me the link and remove my competitors but would also like me to have an ad on the same page for an annual fee that i could link to a landing page. I know that paying for links is no good and google can penalize you. so do i pay them and do a no follow to the landing page from the ad and call it a day? and how does google differentiate an ad from a link?
Link Building | | CHiP_RuN0 -
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 -
Linking Root Domains V.s Total Links
When analysing a company's inbound links, what is more important to note: The number of linking root domains, or the total number of links? And why?
Link Building | | SEOrookie170 -
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