Is there a way to easily add "domain:" in front of an entire list of domains you want to disavow?
-
I'm submitting some disavow reports for clients. As most of you likely know you can either disavow a URL or a domain. So, to disavow a url, you would enter into the text file:
http://www.example.com/this_page.html
and to disavow the entire domain you would enter:
domain:example.com
I find that in most cases you would want to disavow the domain. For example, if there is a backlink on www.exampledirectory.com/health/page24/, by the time Google goes to disavow that link it may be on page 25.
However, it is super time consuming to take my list of urls from a spreadsheet and type, "domain:" in front and also remove the http://www.
Is there a way this can be done programatically?
-
Great! I'll let you know how it works out. It'll be a couple of days before I'm done the current link audit so I'll report back after that.
-
Aw, thanks. Hopefully I can figure this out. But if not, I'll be in touch.
-
You should be able to use the concatenate formula in the same way except I am not sure if the $ will behave in the same way. Try it and see
-
I'm on a Mac as well Marie but have MS Excel so can't help you on the others I'm afraid.
However, if you get stuck, you are more than welcome to mail me the spreadsheet and I will do the find and replace for you, then mail it back again.
Andy
-
Thanks so much Andy and James! I really should invest some time in learning more about spreadsheets!
I work from a Mac...do you know if I can do the same thing either on Google Docs or on Numbers?
-
Hi Marie,
Quite easily actually...
In MS Excel, all you have to do is move your list of domains to column B and in column A enter domain: once say in this case in cell A2
Then in column C enter this formula =CONCATENATE($A$2,B2)
You should then be able to drag down in the usual way to replicate the formula. It will retain the A2 cell but change B each time and you'll get a list of domain:http://exampledomain.com in column C.
Andy (above) has explained how to do the other part of your question.
Let me know if you have any problems.
All the best,
James
-
Just do a find and replace in Excel...
Find http://www
Replace with domain:
Then hit "replace all" - It will go off and do them all for you.
Andy
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
-
Disavow data for non-manual penalty
I'm working on cleaning link profile for a client. He has lots of crappy links pointing to his site. I tried to contact site owners so that they remove those links. No go for the most part. Since it's not a manual penalty, there's no need to specify when exactly I tried to contact those site owners, add emails to my disavow file, etc. It's my understanding that it's OK to just add domains to Google's disavow tool to submit because there was no manual action and it won't be checked by a human being. Would that be the right way to go?
Link Building | | vitaliykolos0 -
Submitting Separate Disavow Files for Each Subdomain?
This question has to do with using Google's Disavow Links Tool. For sites having quite a few subdomains, where those subdomains are listed separately in Google's Webmaster Tools, do I have to upload a separate disavow file for each subdomain? Or, will the file that I upload for the main domain (root domain), also be evaluated by Google for all of the subdomains on that site? I've searched all over the Internet for an answer to this question, but can't find anything.
Link Building | | masterfish0 -
Best Way to Market a White Paper
Hello everyone, I had to write a white paper for an entirely different purpose than to drive links, but it did come out very well and I think it would be a fantastic tool in my SEO efforts. What do you guys think is the best way to market a white paper? Obviously I will let our email subscribers know about it and place a link to it in a prominent place on the website, but if anyone has any extra ideas, I would love to hear them. Also, what is the best way to host it? Taking the Moz beginners guide for example, I would love to just put it on my server like http://static.seomoz.org/files/SEOmoz-The-Beginners-Guide-To-SEO-2012.pdf but is it necessary that I make it web-friendly like http://moz.com/beginners-guide-to-seo? Can the former do anything for SEO? What if there are links to and from the site? Any advice would be great. Thanks
Link Building | | CleanEdisonInc0 -
Multiple on-page links to single domain
Hi, the main focus of my question is to add a bit more information to my client as to where they are going wrong. Firstly they have a directory on a third party domain with subdirectories containing all their product listings. All the links need to be no-follow for sure. However, from a link juice passing perspective if there are per page say 20-30 links to varying URLs on the same domain is it still the same sort of calculation that the link juice is sufficiently weakened that each link has little value, or because the links are to the same domain there is an extra (potential) filter going on?
Link Building | | MickEdwards0 -
Thoughts on using the disavow tool for removed links?
Our website has been penalized by Google for the past few months due to unnatural links. We have spent the past 2 months submitting link removal requests to the domain owners with success. However, the Google Webmaster Tools "links to site" has not updated the list. I understand that they update the list of links as they crawl the website, but it has been 6-8 weeks on a lot of them (mostly our biggest offenders). We attempted to send a reconsideration request anyways, hoping Google would see that even though it is still listed, the link isn't actually there. We received a response that it is still in violation, but I believe it is because the webmaster tools links have not updated and perhaps this is what they go off of. Would you recommend submitting these domains to the disavow tool even though our link has already been removed for the past 6-8 weeks? Or even just listing them with the "#" comment tag so they can see they had been removed? Or would you continue waiting for it to update? Of course, we would like the penalty removed as soon as possible and were concerned that the list hadn't removed these websites the past 6-8 weeks our link had been removed. Example: This domain shows we have 3,397 within this website. It was an affiliate that had this URL forwarding to our pages: http://www.binet.lv/go.pl?PID=49276714O2422 . This no longer forwards to our webpage and the affiliate has been expired, but the GWT still shows them at the top of the links list. I also noticed a lot of sites left the links up, but added the nofollow attribute. These are still coming up in the Links list and does not decipher between which do and do not have nofollow. Could the spammy sites with our links as nofollow still be hurting us? Thanks for any help and recommendations!
Link Building | | shopbloc0 -
Quick Question About Exact Matched Keyword Domain
if you have lets say tools.examplexxxx.com in which "tools" + "example" makes a good keyword together i.e [example tools] (a good key word). Is it wise to put 300 quality backlinks with exact matched anchor text containing keyword**[example tools]** from niche related domains and not worrying getting hit by penguin.
Link Building | | ksbnok0 -
Best way to use a cartoon as linkbait
I have an idea for a cartoon that, once created, is likely to be shared a lot in my niche. I'm currently hiring someone to draw the cartoon. My question, though, is the best way to get SEO benefit out of this. If you had a cartoon that was likely to go viral would you publish it as a blog post on your site? People tend to like sharing things that are on imgur or flickr, but these won't help my seo. (Other than perhaps if I end up getting good PR on a flickr image and then link back to my site.) I'm likely going to just publish this as a blog post on my site, but I thought I'd float this out there for other people to give their input. Have you ever used a cartoon or image for linkbait?
Link Building | | MarieHaynes0 -
Best Way to Analyse Linking Structure of My Site
My site http://www.taxproblem.org is now undergoing many changes due to bad report card scores from this site. I've had people tell me that my linking structure was obviously artificial, especially if most of my links are from "Mr. Wong - social site" O.K. stop laughing 🙂 Yes we use bookmarking demon and rss feed wp plug ins, etc. But haven't discovered how to best get links yet, although reading a lot and waiting on seomoz's DVD's I ordered. 1. What is the best way to analyse our sites linking structure to determine if Google will consider it bad (my site was trashed by Google twice in the last two years) probably for link farms and the like. I know the obvious, but I was looking for a program with guidelines to judge by. 2. The best source to review the many strategies for getting back links so I am not a victim of rehashed b/s based on someones fears of Google, but actually good methods that work. We offer something of value. (CPA firm doing IRS rep. and we have a free download so people can do their own IRS rep and save thousands, and know it's done right) I need to know the bast way to market this. I need good souces for info and for keeping up. Thanks in advance to all that can help.
Link Building | | joemas990