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
-
Does "external noopener" still pass on link equity
Just wondering what the consensus WRT "external noopener" passing on link equity?
Link Building | | jasongmcmahon0 -
Would you consider these domains spammy or at risk for penguin penalty?
I'm doing a bit of competitor backlink auditing and am curious how you view these domains? I also am doing this for others as a comparison and growing reference maybe of domains that they can crosscheck with their own backlink profile and make sure these aren't on there, in preparation for penguin algo release to core. Either chime in with known domains to be spam, and I will create a live list based on answers here. Domain Domain Rating directoryworld.net 64
Link Building | | Deacyde
prlog.ru 60
torchbrowser.com 60
jzip.com 58
localbiznetwork.com 58
gimpsy.com 54
pageonepower.com 52
nashvillelife.com 49
2thetopdesign.com 49
seocounsel.com 48
healthywealthyaffiliate.com 48
hollinslegal.com 48 On a working Disavow list either in root domain or extended url form seocourt.com
wldirectory.com
onpaco.com
lostdirectory.com
ligginit.comligginit.com
alivedir.net
tiptopdirectory.com
onemilliondirectory.com
submittolinkdirectory.com I've read that sitewide footer links even from parent company sites will only count as one, regardless of how many links they have, I was wondering if that was true as well?0 -
Root-Domain vs Subdomain Linkbuilding
Hello Mozzers! Couple of days ago I received a request to start optimizing a wordpress website, the domain itself has been around for around 10-12 years so it's it can be considered as one that has real history behind it. The page has been moved from HTML/FLASH to wordpress about 3 - 4 years ago and hasn't been any SEO maintenance on it. The site used to rank for first position with several keywords, but now understandably, it has greatly decreased. My main question would be, that when I've checked the root domain's and the subdomain's metrics with MOZ Open Site Explorer, the sub domain (with "www.") showed a PA 40 and 90 external links while the root domain (without "www.") only has 27 PA and 6 External links. I know that the 301 or server redirects only transfers about 90% of the link juice to the targeted URL but the difference between the 2 results seem way too big for me. What do you think? Is this normal?
Link Building | | adamdankhazi
During future link building is it more beneficial to target the root domain so the page won't lose that "10%" by redirecting the new link from sub-domain to root domain?
Is it possible to get more juice transferred? Thank you very much,
Adam0 -
Bad Links to New Domain - Do I Disavow?
About 2 months ago a new client of mine bought a domain and we built him a nice new site; however, it appears the previous owner of the domain used some spammy SEO tactics. I've had to redirect about 30 pages and now I've found some spammy links. I've only discovered a few of them, but he doesn't have that many links yet so I'm wondering what kind of impact this will have. Is it worth disavowing a half dozen links? The sites are in Chinese and appear to be unmanaged link farms so getting the webmaster to remove them is unlikely. Also wondering what else is lurking out there that I haven't discovered yet... I suggested to the client we consider a different domain since the site is new, but he's become pretty attached to it. Any ideas?
Link Building | | Dino640 -
Disavow links from questionable blog
Hi everyone, I noticed today that we are getting quite a few backlinks from a blog that promotes some rather seedy ideals (it's called zoklet). Specifically, they are linking to some products we sell that prevent shoplifting, so I'm drawing some conclusions about their motives. I don't think the blog itself is spammy, but I'm just assuming that it's a bad neighborhood and we should distance ourselves from it. The only reason I'm questioning the disavow is because of the warnings involved and that it might affect our rankings if we do it. Any thoughts? Thanks.
Link Building | | Matt10 -
Directory listing and open site explorer
As per my previous post regarding my new client. I am dissecting all the previous seo companies docs and basically there are hundreds of directory listings on paper however site explorer does not show any. my question is this does site explorer not list directories site or are they worthless?
Link Building | | Shuffled0 -
Do press releases add any link juice?
I've been told by PR Web that anchor text in their press releases will add SEO value and increase our page rank. They even charge more for releases that include the ability to link specific keywords to specific pages (anchor text keywords). So - do such press releases really add any page rank to our site? Here's our press release: http://www.prweb.com/releases/2011/5/prweb8289567.htm Thanks, Alex
Link Building | | tennisround1 -
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