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
-
Does anyone know if it is possible to get a "dofolow" link from YouTube? All advice currently available seems a bit outdated,
I see that some competitors have links from youtube but i can not see ay advice on how to get do follow links from Youtube - is this possible and if so can anyone advise how? The only advice i can see is a little dated,
Link Building | | SimonButterworth0 -
Disavowing Links
I need some advice... I've noticed our link profile has increased with many comments links --- something I certainly have not pursued manually. I'm new to disavowing links. However, before I go ahead and disavow them, I'd like to ask how harmful these links are and would you recommend this is something I can do myself (relatively novice SEO) or if you'd recommend someone who could do this for a reasonable cost. In one instance, the link from this comment thread is with the anchor text, "porn"... Certainly not something we want to rank for, haha! I look forward to your advice
Link Building | | LukeBTDT0 -
Domain vs. page SEO
Hi I'm new to SEO and trying to optimize one of my pages. However this page that I'm trying to optimize is not the homepage. Does it mean that since I have collected links from other pages to my homepage that the specific page I'm trying to SEO doesn't get any "link juice"? And how could this situation be corrected? Is the only way to get direct links to the page I'm trying to optimize?
Link Building | | agentti0 -
Disavow Anchor and EMD
Lets say you have an legitimate EMD for a domain that is a ecommerce site with reasonable content. The site traffic was cut in half by Penguin. You think one of the main reasons that you were hit is old SEO black hat link building with Anchor that is exact match.....The catch 22 an exact match achor is the EMD. I want to disavow some of these old black hat backlinks and obviously I will nuke the ones from the spammy sites first and see what happens. What about the backlinks that have achor of emd.com (the company name and as it so happens a valid EMD) or just EMD. If the hit is coming from every single link becuase they are all exact match becuase that is the proper legit match and not some attempt to game the system......What the heck do you do? I get the War on spammy EMDs but I hope the legit ones are not hit even more. For one thing google should just have this ironic creteria for excluding EMDs....if they are running AdWords....they are 95% spam sites.....I love the irony of that one. I am betting lots of these mange to still get listed.
Link Building | | freestone0 -
What value do external broken links give to a domain?
I ask, as I've just used opensite explorer to look at external links a competitor has, and I've found the high value ones at the top of the list go to a page that no longer exists on their site. Are these stiill of value in the SERP's, or have they messed up by not putting a 301 redirect on them?
Link Building | | xposurecreative0 -
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 -
Is this a good way to create engaging content?
Hi all, I believe this is my first question in this forum, so be nice 🙂 I am an SEO consultant who has recently gone out and started my own SEO consultancy. Obviously, I now find myself in a place where I am trying to create good content for my website visitors. Maybe it's link bait, or more than likely it's a way to hold myself up as an expert in the industry, while providing visitors to my site some reason to keep on coming back. As I love whiteboard Friday, I did consider - and I'm not ruling it out in the future - creating my own whiteboard Friday videos discussing the SEO issues I was focussing on. In the meantime, I am thinking of posting up SEOmoz's whiteboard Friday videos and then making my own comments and insights for my website visitors. So, what I really wanted to ask - do you guys think this is a good idea, a valid way of creating good content and has merit/credibility? http://www.nustudio.com.au/local-seo-the-basics/ contains an example of what I am talking about. Cheers, Steve
Link Building | | stevedeane1 -
Custom Domain Vs Free Sub Domain for SEO
What is your take on custom domain vs free sub domain for SEO? (example.com vs example.blogspot.com) Say if I have 10 links from 10 different domains but all hosted on blogger.com, will it still have the same link benefit as ones hosted on different hosting account? I am assuming it might be less due to the same C class IP appearing for blogger hosting. What do you think?
Link Building | | jombay0