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
-
Exact Domain Match does it help or distract?
Does owning / buying an exact domain match help or not necessary? For example our main website ranks for nearly 14,800 Keywords but one KW we are trying to get in the top spot for we are currently at the bottom of page #1. We do see an exact domain match available so we purchased it but i don't know if it would actually help us or distract us. I was thinking we could create an article about the keyword on that exact domain then do some on page seo and back linking. But would that be more of a distraction VS. just focusing on getting more high quality back links to the main website we have ranked on Page 1 at the bottom? Any ideas or benefits to use an exact domain match to help boost also?
Link Building | | Cfarcher0 -
Missing Inbound Linking Domains
For some reason, our websites seem to be missing a number of authoritative inbound linking domains which seems to be a primary driver in lowering our domain authority as compared to our competition. Does anyone have any feedback as to why this might not be populating or is there something additional we need to do to have these show up? If it doesn't show up in MOZ is it likely that Google might also not be seeing these as inbound link domains? Thanks as always MOZ Community!
Link Building | | Leithmarketing0 -
Quickest way to build links?
I'm in furniture e-commerce. I'm not new to e-commerce but I am new to SEO as I used to just hire everything out. What is the quickest way to build or should I say earn links? So far I've just been contacting bloggers and I've built about 4 links through guest posts in the past month. The problem is I can't tell if this is good or bad. I also contacted a niche directory and they liked my content so they are going to include my website in their directory for free next week. Should I continue doing what I'm doing? Do I need to be more aggressive? Suggestions? Thanks guys.
Link Building | | The_Kiwi_Man0 -
Backlink Disavow strategy
Hi, I would like to know what are the things to check when Disavow backlinks? Should we disavow all the low PR and DA backlinks ex: disavow all the backlinks under 4PR? Thanks alot !
Link Building | | bigrat950 -
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 -
Easiest Way to get Wiki links
1.What is the easiest way to fetch a backlinks from wiki sites.Wiki answers.Wikipedia or any other site. Any one kindly guide me in detail how to do it?Not interested in creating and maintaining page. 2.What if I need multiple links?
Link Building | | csfarnsworth0 -
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 -
Does the feature "Competitive Domain Analysis " include subdomains?
Hey guys, I have set our domain as www.domain.com at the campaign settings, but i'm not sure if the link analysis ("Competitive Domain Analysis") does include subdomains? Does anybody know this? Greez Chris
Link Building | | lordcyphon0