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
-
Many of our best links are to our old domain. Problem?
Hi, around 7 years ago the organization I'm with switched their domain name. When doing link analysis some of our best links are to the old domain including a followed link from an article on the BBC news site. The old domain has been 301 redirecting to the new domain for years. Is it worth the time to contact the sites that are linking to the old domain? Or, will all or the majority of the link juice be given to the newer domain with the 301 redirect? Thanks!
Link Building | | limited70 -
Looking for a dedicated Backlinks/Disavow Platform
Hi Guys, Can anyone recommend a good backlinks program. One which is able to detect spammy backlinks and which has a disavow feature. I've tried Monitor Backlinks, Would appreciate any further suggestions. Priorities are ability to monitor new links and their value, loss of links, link opportunities, with the ability to create recommended opportunity lists and disavow files - ideal if can be used in some way for client reporting also - dashboard or pdf etc. Help with access to contract link builders (perhaps star rated for quality and efficacy) to go after the opportunity lists also a bonus etc. Basically what are people using out there and really liking!? NB: we use moz for some stuff and have a mix of other tools available but nothing seems to be really nailing this for us. Thanks!!
Link Building | | OnlineAssetPartners0 -
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 -
Exact Domain Match Ranking Very Well
Hello, I have some competitors that purchase targeted keywords, host a single page, and do a re-direct on to their inventory page. The problem Im having is getting above them, along with other competitors that have a high DA. They have little or no content on the page but rank very well. Is there anyway around sites like this? ex-bluewidgets.net bluewidgets.org Thank You
Link Building | | TP_Marketing0 -
Ebay listing SEO
Hi, I am wondering if there is any point building backlinks etc.. to ebay listings? How do I improve them in terms of SEO apart from the listing titles?
Link Building | | Mediaowl0 -
What are "naked backlinks"?
Hello SEOmozers! I have a question for you all. What are "naked backlinks"? Can you also give an example? Thank you! woo aka STPseo
Link Building | | STPseo0 -
Will No Follow Links count toward your root domain links for Domain Authority?
I am wondering if no follow links help, hurt, or do nothing when it comes to increasing page and domain authority? I know they are not supposed to pass rank and I have read discussions that some people suspect they still might, but I am wondering if I have a mix of follow plus no follow, will the no follow ones increase the count of the root domains linking to me and help boost my authority? Assuming of course the no follow links are coming from quality sites with high page and domain authority of their own. Thanks.
Link Building | | FastLearner0
