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
-
Should I disavow links from Dead Domains?
Have a new client who hired a fly-by-night backlinking company. They made 500 links from directories and 160 of these are on domains that have been deleted. So should I inlcude the 160 dead links in my disavow?
Link Building | | dk50 -
Requesting udpate's from old domain to new domain
Hey guys, We had a domain change three years ago now which was redirected. Many of the old domains have not been updated to the new domain. The redirect is in place. I'm just wondering if there would it be a worthwhile exercise to reach out to sites to request an update of the URL link from an SEO perspective? Many thanks Rob
Link Building | | Griffith0 -
How much Domain Authority is enough?
I will clean my backlinks removing those with low DA and keeping medium and high DA. Since which number of Domain Authority is good to focus my efforts? Thanks!
Link Building | | estebanseo1 -
Domain Question
Hello fellow SEOmozers! I'm trying to register a domain name that contains keywords for my business, however the .com is obviously taken (however its just a parked domain without a site) so I have an option to get either .co .us or .net I wanted to know if the domain extension makes any difference for the search engine or does having .com gives you an advantage over having .co .us or .net? Thanks for your input!!!
Link Building | | igor.pinchevskiy0 -
Somebody wants to share something with me?
Maybe somebody want to share a list from dofollow forums ? ( all high authority if is possible) Thanks in advance!
Link Building | | nyanainc0 -
Iaquire.com "off-page seo" service reviews?
Hi, has anyone used this firm for their link placement and content syndication services? Thanks!
Link Building | | partnerworks0 -
Reciprocal Links Or One Way Links?
After reading a recent blog post on guest blogging and ways to build relationships for link building purposes, I began to wonder about something. It is my understanding that one way backlinks are superior to reciprocal linkage, but reciprocal is better than no link at all. So is it still worthwhile to do reciprocal guest blogging, and will the value of the links be worth it when completed? Or should we just be of the opinion that: One Way Link > Reciprocal > No link
Link Building | | dignan990 -
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