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
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
-
Buy domain, redirect, get all the good links (+link juice) and disavow the spammy ones?
There is a domain for sale that has a quite nice profile and a lot of good backlinks, but also quite a few spammy ones. This domain has a Spam Score of 14% acc. to Moz Link explorer, ours has only 2%. My questions: 1. The domain and the good backlinks are related to or close to our content/keywords. But we are worried whether the "spammy" ones will hurt us. Does anyone has experience with this? 2. Would it help if we disavow the spammy backlinks afterwards? And if so, how do we do that? Add new domain to search console, disavow the bad links and then redirect the entire domain to our domain or redirect the domain first and then disavow from our property? Many thanks for your help!
Link Building | | pissuptours0 -
Existing links on domain with previous history - keep or disavow?
Our client has bought a domain with a history for a different type of venue in another location. Inbound links exist related to this prevous venue - should we disavow these?
Link Building | | designlobby0 -
Disavow links returning?
Morning Mozzers, Happy Presidents Day. We submitted a disavow file about 4 weeks ago and in GWT saw that our links went from ~20k to about ~1300. Now this was good as majority were dubious at best. What is strange is I logged into GWT today and see many of the links that appeared to be 'disavowed' are back in our profile. I do not have any messages from Goog. Has anyone else seen this? Any thoughts? Thanks in advance for you help.
Link Building | | okuma0 -
My competitors all seem to use "junk" pages to rank / backlink, how to compete and not cheat
Hello, Page 1 of Google for the word "copier lease" and most other valuable copier leasing terms are dominated by the same 4-5 for organic (PPC too of course, but organic is what I want) They all use some SEO company, so when I go and look for good link oppertunities, most of the pages I find are just SEO companies who of couse would never be interested in a competitor's link. Examples: ajaxunion blogspot com or excellentpoly blogspot com and the list goes on, all just AjaxUnion "blog pages". blog homerenovationguide com /2011/06/15/repair-or-replace is just inhouse SEO making ranking pages for CostOwl. So, its hard NOT to want to throw up a blog farm and do as "the Romans do". What ideas do you all have to get backlinks in this market of Copier Leasing that would hold up. Thanks 6SW66.png 6SW66.png
Link Building | | einstein99992 -
Exact Domain Match URL
Hello I have a few competitors ranking VERY well for exact keyword match URL. They have a single hosted page, when a customer clicks to buy inventory ir re-directs to there main url. Will google eventually catch on to this? Excellent position, very little backlink/seo work. Is this something that I should also look into for my own site? Thank you!
Link Building | | TP_Marketing0 -
Does the ratio of external nofollow links to external "do follow" links matter in terms of SERPs ranking?
My site has an external link nofollow:dofollow ratio of approximately 1:1 That is, there are about as many nofollow external links as "do follow" external links. I have an impression that the ratio of no-follow to "do follow" links is a factor in the way that our website shows up in SERPs. I have the impression from reading a variety of sources, and from looking at Seomoz, that calculate "trust" factors as if they mattered (in SERPs), that seem to value a relatively low nofollow:dofollow ratio. Am I correct about that? Thanks,
Link Building | | tcolling
Tim PS - I don't know whether or not this matters, but our website is at: www.trustworthycare.com - Tim0 -
PR-7 Domain - NoFollow Links
Will the NoFollow link in this article help my rankings in Google? http://www.inc.com/articles/201109/business-intelligence-software-for-small-business_pagen_2.html
Link Building | | b4tv0 -
The ultimate top 10 directory list
Everyone loves a good list. If you could only submit your site to 10 directories which 10 would you choose and why?
Link Building | | IPIM0