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
-
What are the SEO value of revolving or rotating lists of links?
What are the SEO value of revolving or rotating lists of links? For example the links at the bottom of the homepage of inlandnwopera.com. The links are based in images and I am not really sure Google would pick them up but they do appear on ahrefs.com. Thank you.
Link Building | | RandyHT0 -
Quote + Link from Associated Press
So almost everyone here has talked about the marvel (for a small business like me, at least) that is HARO. Recently, I was quoted in a story that was written by the Associated Press, by responding to a HARO inquiry. (story resides on their site here in case you want to look). So looking at it with a critical mindset, is this a glorified press release at this point (the thing shows up virtually everywhere since after all, it was written by the AP). Should I be expecting any SEO help from this?
Link Building | | MarkAselstine0 -
Disavow question
Hi there, I have 2 website's, and one of them will be redirected to the other. For both I need to do a disavow list, but I don't know how is better. I should make only one disavow list for the main site, and include the link from the site that I will redirect, or make a list for each website?
Link Building | | Silviu0 -
Backlinks from the Same Domain (But Different Pages)
Wayyy back when (in the days of yore) Mr Cutts spelled out in a video that page rank is distributed equally between the external links on the page. If there are two links on a page, each gets passed 50% of the available page rank etc. (Perhaps an oversimplification but bear with me). As a result of this, the company I worked for at the time (this was the dark ages when sidebar homepage links were in vogue) decreed that we would only ever approach a site about a link for a client once, as additional links had little extra SEO Value. Now you could argue that if there are 5 external links, each acquiring 20% of the power, and your site has 2 of those, you are getting 40% of the power, but lets forget the basic math for a minute. I have scoured the web and Mr Cutts' videos and I cannot find the answer to my question: If my site (Site A) has a backlink from SiteB Page 1, and a backlink from SiteB page 2 - does this count as two separate links in the eyes of Google? If the SAME site links out to my site, linking to different pages in different posts, does this give me more SEO benefit? Thanks for your time!
Link Building | | Turkey0 -
Disavow & nofollow from same IP
I'm a web developer, and as such, we run a bank of half a dozen dedicated servers. I have 2 questions with regards to nofollow links There's half a dozen sites linking back to us from the same bank of servers (across 3 different IP's but all in the same facility) because we have donated our web design services and we're a sponsor. It's not a paid link, it's a sponsorship. Should I still nofollow the link? I run a couple of personal blogs on the same bank of servers. There's an absolute tonne of original content and a handful of links back to my shop. Because I own both sites, should I nofollow these links as well? I am doing a massive cleanup before the Penguin pops his head out again.
Link Building | | sparrowdog0 -
Feeling "vision limited" in the linkbuilding process
Hi there! My client has a web about kitesurfing (he offers a bilingual kitesurf camp) and after thinking about linkbuilding actions I've come into conclusion that the only effective way of generating backlinks is make the sharing NATURAL via high quality CONTENT creation and distributing it through different digital channels as some of you told me before. The problem is that the website is much 1.0 (static) rather than 2.0 (there's no blog and there's neither time nor resources to mantain it). Therefore I feel I bit limited in the process. Does anyone share my statament? Any advice? Thanks in advance
Link Building | | juanmiguelcr0 -
Millions of links from one domain - unnatural?
I have a question: One of the sites that I work for has 3.1 million site-wide links (according to WM Tools) from one domain pointing to us. This domain has a Domain Authority of 93. We have (according to OSE) more than 3, 500 Domains linking to us. We have a Domain Authority of 88. In other words, one of those 3,500 domains is highly reputable, and is sending us 3.1 million site-wide links. This represents 60% of all the links pointing to us (again according to WMTools). Is this something to be worried about? Or delighted about? Would you consider it an unnatural link profile?
Link Building | | sichristie0 -
What constitutes a "paid link"?
I know that link building is one of the more important tools for great ranking and know that "paid links" may hurt a sites ranking. How do I know if a company offering link building will be classified as "paid links"
Link Building | | stevecounsell0