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
-
My Domain has a couple of badlinks decreasing my rankings, will disavowing them reduce my Domain Authority on Moz?
Good day Every Body, I have a heart aching issue, my site (nightwatchng.com) amassed a number carnivorous backlinks, I have lost rankings, i studied my search traffic and discovered that I have been hit by Google Penguin Algorithm Penalty, I was forced to believe that those backlinks were built to my site on purpose just so my rankings will drop, I know the importance of link building and thats why i follow the white hat technique. Now the big question is, IF I DISAVOW THESE TERRIBLE LINKS FROM GOOGLE SEARCH, WILL MY MOZ DOMAIN AUTHORITY DROP FROM WHAT IT CURRENTLY HAS?? I also want to know if the Algorithm Penalty will affect the subdomain (news nightwatchng.com) of my site?
Link Building | | Newswatchng0 -
Impact of "noopener" Links
Hey all, Recently got a PR piece published with a link back to our website. The link was not showing up in the Moz crawler, but I did find it under unlinked mentions. When I checked the page with the link, I saw that it contained rel="noopener". So a couple questions: Is this similar to a nofollow link? If the Moz Crawler is not registering it as a dofollow link, does that mean that Google will view it similarly? Thanks!
Link Building | | mostcg0 -
3 Month Delay in Domain Rank?
Our domain rank was around 40, then we hired an SEO company and our Domain Rank went up to 80, now we see it back down to 40. When we asked our SEO company, they said this was due to a 3 month delay in Domain Rank numbers. Is this true?
Link Building | | allurez0 -
To disavow or not?!
Hi, I've been rooting around my GWT account and noticed two what may be dodgy links, they look like a blog network - no contact details on the site and basically just blog posts about various subjects that all contain keyword rich links. The two that are pointing at me are two seperate articles on two sites that both contain around 3 keyword links to our website. I have no idea why these are linking to me as I have not requested them, so not too sure if someone has done this on purpose on what! Looked on the sites in question and there is no way of contacting the person responsible for the sites. Not had any warnings yet (touch wood) in GWT, how you you go about trying to get shut of links when there is no contact info on the sites? Bit wary of using the Disavow thing in Google as some people say go for it while others say avoid? Any hints/tips would be welcomed as this has got me a bit worried! Cheers Ted
Link Building | | Jon-C0 -
How to increase domain authority
How do I increase my Domain Authority and Page Authority? How do I increase my external links numbers? Regards, Nilesh
Link Building | | vedantcreations0 -
Does blocking domains help remove bad links?
I have affiliate websites that are harming for one of 2 reasons: 1. They are on adult websites (and I don't want to be in a bad neighborhood) or 2. They are using a Frameset (so their content appears identical to mine and I am getting "credit" for all their junk links) I cannot get these websites to remove our links so I have blocked their IPs on our production firewall. Is this an effective method or should I do something else with these links?
Link Building | | theLotter0 -
Better to redirect domain or to link from home page?
Hi, I have a niche directory and sometimes clients remove themselves because they have discontinued their business practice. If they sometimes provide me with their own website (as they will no longer use it either), is it wiser for me to: a) directly point their URL 301 to my own directory b) keep their website as is, and add a url link to my directory in their homepage c) keep their website as is, and add an anchored link with the industry keyword to my directory Thanks! D
Link Building | | Demosthenes0 -
Links per Site vs. Domain Authority
Here's a quaint one: 1. Posting follow links on another site helps increase one's domain authority. 2. If I post to the same site/forum with followed links each week, would my domain authority reap a domain authority increase benefit? In short, is there any domain authority benefit to continually post links to a site to which I've already posted a follow link?
Link Building | | GreenCupboards0