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
-
Should I disavow these links?
Hi all, I have a site that is a year old, we have been building backlinks organically - probably around 50 or so - then almost overnight we had100s of spammy links. Screenshot here: https://ibb.co/cijiub My questions: Should I disavow these? What happens if I don't disavow these? Can I work out where they came from? If I disavow a few of them, is this a token offering to the Google Gods that will lower my risk of being penalised? Thank you. cijiub
Link Building | | Bee1591 -
Should I disavow links from Dead Domains?
Have a new client who hired a fly-by-night backlinking company. They made 500 links from directories and 160 of these are on domains that have been deleted. So should I inlcude the 160 dead links in my disavow?
Link Building | | dk50 -
Subdomain with higher domain authority vs. ccTLD with lower domain authority
Our website is active in many countries and we are considering if it is worth it to switch from ccTLD to subdomains.The reason is that our company.com domain has a domain authority of 65 and some of the ccTLD's like company.fr and company.de etc have a domain authority of 30. From what I have read, moving these to a subdomain structure like fr.company.com and de.company.com will give them all the same domain authority (of 65 vs 30) which is considerably higher. 1. Would a subdomain with domain authority 65 rank better than a ccTLD with authority 30 (considering all else is the same)? 2. When we 301 redirect all ccTLD's to the subdomains, will our domain authority increase (to more than 65) for company.com, given that it can benefit from all redirected links to our ccTLD's? Thanks in advance!
Link Building | | rens.vd0 -
What is Followed Linking Root Domains ?
Is it to just have different URLs pointing to my site? I understand that if 1 site posts 5 of my URLs, it only counts as 1. I am just not understanding how I increase this number if link building is now frowned up. Thoughts?
Link Building | | tiffany11030 -
Guest blogging: is there a safe way to do it?
Following Google's nuking of My Blog Guest, is there any way of doing (high-quality, small-scale) guest posting safely? Specifically, do the tips from Neil Patel here (written Jan 22) still stand up? Only post on relevant blogs – ideally these blogs should also be larger than your website. In other words, do it because it will help with branding, traffic, and sales. Posting on bigger blogs that are also relevant will provide you with more good exposure than posting on small, unknown blogs. Avoid using rich anchor text – rich anchor text will become a huge red flag and will probably cause your site to get penalized eventually, especially if you are building these links through guest posts. Share the love – you won’t be able to link out to your site only. From Wikipedia to your competitors, you’ll have to link out to whichever site benefits the reader the most. Build up your author rank – with Google Plus becoming more popular, it will be easier for Google to determine how good of a writer you are. So, you’ll have to focus on publishing only valuable content as you won’t want crap tied to your author account. Co-citations are valuable – even if you don’t get a link from a guest post, just having your site mentioned in the article can help with rankings. I think Google will place more emphasis on co-citations in 2014.
Link Building | | Jeepster0 -
Which Backlinks to Disavow?
I am a site owner just getting to learn more about managing things myself after outsourcing SEO to a firm a year back (they stopped all activities about 8 months back). The question I have is about disavowing the low quality links. After collecting all the data from many sites on the basis of this helpful posting - (http://moz.com/blog/ultimate-guide-to-google-penalty-removal), I am now left with around 2,800 back-links. I discovered most of the bad ones using ahrefs and majestic (and Google webmaster did not show many of the bad links). In fact, in the very first place, I realized that there was a spam problem when I saw the anchor cloud on ahrefs which showed many unrelated anchors for my site. I have three questions: **First, **Many URL's are actually from websites which have nothing to do with my line of business and I can sure spot them. What I get confused with is this - I can not say that these sites are downright spam. Some of them look to be good sites for example - a coffee machine vendor (with full business details and a fairly decent looking business), a Nike sports shoes mart etc. But they have nothing to do with my business. So my first question is - What is spam really? Would a back link from a high ranking website in the travel industry be considered spam from the point of view of someone who runs a website for medical equipment, specially if the back-link is from an unrelated anchor text like - "3 nights travel package" (which has nothing to do with medical business). I think I should disavow all the low quality back links with an erroneous anchor but Id like some views on this. Second, I see that in the disavow file, one could either upload a whole domain or a specific URL (could somebody please confirm this). I have some sites which have 8-12 (more in some cases) back links to my site. In most cases these sites are either really bad quality or have nothing to do with my business. I am tempted to disavow the entire domain for such sites instead of going by the URL's. Any views? Third, this is what I'd really like some help with. In case I delete the very pages (on my site) to which these back links point, should I still disavow the pointing domain? Finally: I have not created most of these backlinks. In fact, over the last 2-3 months we have started creating links from good sites in my industry. Most of the anchor cloud is good for me on ahrefs but there are these bad ones to which my question relates. I have not got any manual penalty from Google, though my traffic I think took a hit in the first week of October 2013.
Link Building | | sanar0 -
Searching for Quality "Follow" Back Links
I'm in a highly competitive national market where the top sites have links from between 325 and 1300 unique linking root domains, therefore, you have to have an aggressive approach just to get on the map. (I'm at 317) If we were talking about needing 50 good links, I could take the time to cultivate relationships, get to know people, and get 1 or 2 great links from each webmaster, but the scale of the challenge is out of control. My competitors, and myself, seem to all be getting links in the following ways: Hoards of directory links. Some high quality paid links from industry sites ($2,400 per each link per year) and hundreds from 9-$49 per year. At the bottom of the list of most all my competitors, there appears to be some links from their early beginnings that were reciprocal linking arrangements. Blogs where they submitted articles and have good links back to their sites. Paid ads on sites all over the internet that link back with their specific key words. Some from relevant sites, but mostly from sites that would give them a good deal and have high enough traffic and/or page rank. Blog comments with a link back to their site; sometimes with good anchor text and sometimes you're forced to have to use your web site address as the anchor text or even your name. (Does that even do any good?) My dilema is where to find 1,000 good places to get links and I don't do black hat? I can write good quality comments on blogs from a wide variety of industries, but most are now eliminating the possibility of using my anchor text other than my web site and my name. As I scour the playing field, it almost appears that it has become a "pay to play" proposition as far as getting links everywhere other than writing good blog articles, but then what good does it do to have 500 blog articles coming from a handful of linking root domains? You're just stuffing the ballot box! As for me, I'm in the teens with all the high value phrases I need and must come up with a better strategy for the home stretch. In all the other varied statistical measurements that I see on SEO Moz, I'm no lower than #5 out of the top 10 competitors in any of them except Alexa rank. So, I'm close but it seems so far away! Would appreciative and be grateful for some wisdom from the community! Lowell
Link Building | | lwnickens1 -
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