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
-
Not Receiving Credit for all Linking Domains
Hey guys, So I'm having trouble understanding why we aren't receiving credit for linking root domains by Moz. Our site URL is https://www.expertip.net Google states that we have 3,648 links - most of which were obtained by Yext indexing us for our locations. We don't seem to be getting credit for ANY of those links. Most seem to be reputable, like yellowpages.com, etc. and google shows 156 domains. Any help here can be appreciated. I believe that we've followed best practices as far as root domains and 301s go. I've attached images to show further. Thanks,
Link Building | | greg.lanier
Greg 9U0bG lwAdD0 -
Linking Root Domains www and non-www
I just ran our site through Open Site Explorer. If I run the non-www version I get 30 root domains, if I run www I get 177. Is it wise to try and contact those sites using the non-www version and ask them to update the links to www version? Will that make much of a difference?
Link Building | | Amueller0 -
Website title has domain name in SERPS but not in the website.
We are using the latest version of Wordpress for one of our website. Now every page in SERPS is like this: SEO Services, Link Building and Social Media - Oursite.com But when we look at our website's title tag its like this: <title>SEO Services, Link Building and Social Media</title> It's very strange, why the website's domain name is appended to the title in SERPS?? Any ideas? Thanks!
Link Building | | TheSEOGuy10 -
SEO Consultant Wants to Disavow Organic Links
Hi, We're working with a SEO consultant. They made a second check of our inbound links and want to disavow some of the links that seems organic to me. They claim they're bad by their characteristics. Should we act as they suggest or not? Or should we run from them?;-) Here are some links in question:
Link Building | | nikitin.i
http://www.wowresource.eu/index.php?showtopic=14942 http://answers.yahoo.com/question/index?qid=20080208070036AAE1ePo https://www.macupdate.com/app/mac/39144/visual-watermark All point to http://www.visualwatermark.com0 -
Feeling "vision limited" in the linkbuilding process
Hi there! My client has a web about kitesurfing (he offers a bilingual kitesurf camp) and after thinking about linkbuilding actions I've come into conclusion that the only effective way of generating backlinks is make the sharing NATURAL via high quality CONTENT creation and distributing it through different digital channels as some of you told me before. The problem is that the website is much 1.0 (static) rather than 2.0 (there's no blog and there's neither time nor resources to mantain it). Therefore I feel I bit limited in the process. Does anyone share my statament? Any advice? Thanks in advance
Link Building | | juanmiguelcr0 -
Backlink Lists
I am trying to create a valid list of backlink domain to disavow after a 50% traffic cut by Penguin......problem is I have now pulled lists from 4 tool and the lists are all different. I find a toxic domain from the tool run on LinkResearchTools and look on Google and Site Explorer and the toxic link does not even show. I look at the page and sure enough the link from year ago on a link farm is there. Is there really a rue definitive tool that will give me a list of all links? Better yet is there a tool that will help me evaluate which domain to disavow ? I want to follow Dr. Pete's advice and go slow but I am also anxious to cut ties with SEO work done by someone else in the hay day of link farm SEO and frankly looking at resent links some Bad SEO by competitors.
Link Building | | freestone0 -
What is the best way to obtain backlinks?
Im tryin to obtain backlinks to my website...what is the best way to accomplish this?
Link Building | | juniorbeagle0 -
More "new" root domains or more pages on older domains?
I have been slowly building links via personal/professional networking, press from art shows, blogging, and such. I work with several non related domains & local blogs & press outlets, it is pretty easy for me to add a few new pages of content along with text links. Or should I just concentrate on getting links from totally "new" domains that have never linked to me before?
Link Building | | Mcarle0