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
-
Linking Domain vs Domain authority : Do they related!!!? (Case study)
Hi everyone
Link Building | | serikozay
I just came across a website which I'm working on. As we know DA & PA directly related to each other. I'm building organic links through last year and the result is so odd !
As you see in Pic 1, number of linking domains is naturally increasing. But in Pic 2 DA gets negative impact through this process and decreases!
How are they related anyway? Can anyone helps?
site : didar.me 111.JPG
222.JPG0 -
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 -
Need referrals on expert to clean up "unnatural links" and submit reconsideration request
I just received a manual unnatural links penalty. I was shocked because other than maybe five links many years ago, I've not done anything to get links. The site is very powerful in it's own right and buying links is unnecessary. My first thought was a competitor has done the link spamming on my behalf, any my site is very profitable and the competitors are plentiful and ruthless (i.e. steal my content and use it) since we are #1 for our search term. I took a quick look at my links (via webmaster tools) just now and yes, in the last few months there are tons of links from very bad looking sites that are I've never heard of. It's obvious I've been purposefully hit by a competitor. (What's it called when they do this?) Does Google understand at all that this stuff goes on? Do they even care? On the eventual reconsideration request, if I say that I honestly didn't do those links, would they even believe me or even care? I have read several articles on what to do now. But this is so important to my income stream that I don't want to screw anything up trying to fix it, and I want to get it right the first time. Every day is very expensive to me. So, I'd like to get some recommendations on any experts that can handle this professionally and swiftly. Please let me know of anyone trustworthy that won't rip me off, and if you are such a professional yourself, please let me know. Thank you
Link Building | | bizzer0 -
How to add website to Dmoz?
Hello all, i'm a webmaster, i need add my website : http://itvseo.com to dmoz, before i add some website to dmoz but unscuccessfull, please help me thank all
Link Building | | ITVSEO.COM0 -
Paying to be listed on link directories... a little help?
So, I was perusing SEOMoz's suggested link directory list and noticed some sites there require paid links. I have a couple questions regarding this: Is paying for directory listings a good idea? I'm not crazy enough to buy a bunch of links; I want to create a sustainable SEO strategy. But I do know that most everyone does at least a little paid linking. Is there a budget or percentage of ones total links you would recommend for this? Is it REALLY ok to do this at all? Also, assuming I have about $200-$500/month I could spend purchasing links, what sites are best to get links for first? Just a bit of background: we're starting a content marketing strategy for our business and are spending about $2,000 per month "buying" content (design, data, writing, etc.) so purchasing links is definitely NOT our strategy and never will be. Thanks!
Link Building | | Kibin1 -
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 -
.com links for .co.uk domains
Hi, I was wondering whether .com links from the US for .co.uk domains increase the search engine visibility of .co.uk domain in the UK just as much as .co.uk links for .co.uk domains (assuming they are all top quality content links)? (Context: I have heard that it does from someone who should know, but I would like to double check on that) If half of the backlinks for a .co.uk domain are from .com domains in the US is this a dangerous pattern Google would pick up on?
Link Building | | linkbuildings0 -
Directory List -
Hi Mozzers, please write here the directories the strong directories you know please, make a fresh-list here. thanks
Link Building | | leadsprofi1