Reorganizing Links
-
Hello Guys,
Im Reorganizing my link building list in excel. I have tons of good links that I found in the last 3 months. What I want to ask is if there is a way to put those links in my excel list in a automatic way with the folowing fields:
- Domain
- Pagerank
- DA (from moz)
- Type
- Submission link
Im doint it manual and is driving me crazy
Tks in advance!
Regards,
MM
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
-
Third part http links on the page source: Social engineering content warning from Google
Hi, We have received "Social engineering content" warning from Google and one of our important page and it's internal pages have been flagged as "Deceptive site ahead". We wonder what's the reason behind this as Google didn't point exactly to the specific part of the page which made us look so to the Google. We don't employ any such content on the page and the content is same for many months. As our site is WP hosted, we used a WordPress plugin for this page's layout which injected 2 http (non-https) links in our page code. We suspect if this is the reason behind this? Any ideas? Thanks
White Hat / Black Hat SEO | | vtmoz1 -
Disappearing Links Black Hat ?
I have seen reports of Black hat spamming with dodgy links but we have another issue with a clients site. The site had a small number of solid following links about 60 which had been in place for years and in the past few weeks all but those directly under their control have ceased to link. At the same time a very aggressive competitor has entered their market which is owned by the officers of an SEO company. Could it be that they have somehow disavowed the links to the site to damage it how do we find out? there are now just 10 following links?
White Hat / Black Hat SEO | | Eff-Commerce0 -
How to ignore spam links to page?
Hey Moz pals, So for some reason someone is building thousands of links to my websites (all spam), likely someone doing negative seo on my site. Anyway, all these links are pointing to 1 sub url on my domain. That url didn't have anything on it so I deleted the page so now it comes up with a 404. Is there a way to reject any link that ever gets built to that old page? I don't want all this spam to hurt my website. What do you suggest?
White Hat / Black Hat SEO | | WongNs0 -
Someone has built low quality links to my site - what should I do?
Hey guys, I was wondering whether you could offer me some help on something. One of the site's I'm working on has a blog attached to it and we sometimes accept guest posts from authors. A month or so back we published a blog that has been attracting a number of low-quality backlinks. Having looked into the matter further, it turned out that the client who had created the guest post was doing something called "tiered link building" and was building crappy links to their guest post content on other websites. I have subsequently deleted the blog post in question - will this devalue/cancel out the inbound links pointing to the original URL? Or do I need to do something extra? Disavow even? Comments appreciated!
White Hat / Black Hat SEO | | Webrevolve0 -
Footer Link in International Parent Company Websites Causing Penalty?
Still waiting to look at the analytics for the timeframe, but we do know that the top keyword dropped on or about April 23, 2012 from the #1 ranking in Google - something they had held for years, and traffic dropped over 15% that month and further slips since. Just looked at Google Webmaster Tools and see over 2.3MM backlinks from "sister" compainies from their footers. One has over 700,000, the rest about 50,000 on average and all going to the home page, and all using the same anchor text, which is both a branded keyword, as well as a generic keyword, the same one they ranked #1 for. They are all "nofollows" but we are trying to confirm if the nofollow was before or after they got hit, but regardless, Google has found them. To also add, most of sites are from their international sites, so .de, .pl, .es, .nl and other Eurpean country extensions. Of course based on this, I would assume the footer links and timing, was result of the Penguin update and spam. The one issue, is that the other US "sister" companies listed in the same footer, did not see a drop, in fact some had increase traffic. And one of them has the same issue with the brand name, where it is both a brand name and a generic keyword. The only note that I will make about any of the other domains is that they do not drive the traffic this one used to. There is at least a 100,000+ visitor difference among the main site, and this additional sister sites also listed in the footer. I think I'm on the right track with the footer links, even though the other sites that have the same footer links do not seem to be suffering as much, but wanted to see if anyone else had a different opinion or theory. Thanks!
White Hat / Black Hat SEO | | LeverSEO
Jen Davis0 -
People buying links to their profiles on my site
As we have a major Penguin update looming in the background, I am looking for expert advice on how to deal with professionals buying into link programs whether they are doing it deliberately or not. Our site provides detailed profile information on hundreds of 1000's of professionals and some professionals apparently believed that buying into link program will lift their profile in the SERPS. About 10 professionals have paid shady link building companies to buy links to their profiles on our site. The biggest offender bought over 1,500 links to his profile. Aside from adding the known toxic links to our disavow file, what else can we do to avoid any link penalties? I can think of three distinct options and would love to hear feedback especially based on actual experience. Option 1. 404 the existing profile - "http://www.anysite.com/jones_smith" and create a new URL "http://www.anysite.com/jones_smith_1". Option 2. Keep the existing URL and fully rely on the disavow file. Contact the professionals and kindly ask them to stop buying links and to contact their link building companies to remove the links. Any other ideas?
White Hat / Black Hat SEO | | irvingw0 -
How to know if a link in a directory will be good for my site?
Hi! Some time ago, a friend of my added our site to a directory. I did not notice it until today, when in the search results for my domain name, the directory came in the first page, in the four position. My friend wrote a nice article, describing our bussiness, and the page has a doFollow link. Looking at the metrics of that directory, I found the following: Domain Authority: 70; main page authority: 76; linking domain roots: 1383; total links: 94663 (several anchor texts); facebook shares: 26; facebook likes: 14; tweets: 20; Google +1: 15. The directory accept a free article about a company, does not review it before it is published, but look for duplicated articles representing spam; so one company can only have one listing (in theory). Is there any formula to know if a directory is safe to publish a doFollow link? If they don't review the link I would say is not a good signal, but is there any other factors to take into account?
White Hat / Black Hat SEO | | te_c0 -
How to handle footer links after Penguin?
With the launch of Google's Penguin I know that footer links could possibly hurt rankings. Also too many links on a page are also bad. I have a client http://www.m-scribe.com That has footer links creating well over 100 links on many of their pages. How should I handle these footer links? Suggestions are greatly appreciated.
White Hat / Black Hat SEO | | RonMedlin0