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 -
Does LinkedIn Pulse Backlinks add to domain authority?
I'm working on linkbuilding and content partnerships to drive referral traffic and boost our page ranking and domain authority. I wanted to check and see if Medium and LinkedIn Pule backlinking work just as well as other sites? Best, Jonathan
Link Building | | kjomalley0 -
Directory Listing without Permission... Was your company listed here also likes ours?
We just found a backlink for our site from a brand spanking new, week-old directory site. We did not create this, so aside from submitting a request to remove it through their contact form (which we already did), do you have any other tips to get this removed beside submitting a disavow request. http://seo-company-in.com//United_States/North_Carolina/whiteboard-creations-cary-and-raleigh-nc-web-design-and-seo-service-267 Also, check to make sure your company isn't listed as well without your permission (not providing a functioning link back for them, but enter in their domain to check it out. Let me know your thoughts. - Patrick
Link Building | | WhiteboardCreations0 -
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 -
To disavow or Not to disavow is the question?
OK, I have done some analysis of my site and it seems quite clear that I have been hit by Penguin and this is largely down to my link building strategy. My question now is; 1. Do I try to undo the damage by disavowing toxic links I have identified, or 2. Do I just accept what is and ensure that from here on in I follow natural backlink acquisition? Thanks
Link Building | | UnderMe0 -
Exact Domain Match URL
Hello I have a few competitors ranking VERY well for exact keyword match URL. They have a single hosted page, when a customer clicks to buy inventory ir re-directs to there main url. Will google eventually catch on to this? Excellent position, very little backlink/seo work. Is this something that I should also look into for my own site? Thank you!
Link Building | | TP_Marketing0 -
How do you identify "Power Pages"
Good Morning from postively tropical near double digits Celcius Wetherby UK 🙂 I've just read "5 Methods to improve, indexing crwaling & ranking". Tip number two says "Link for powefull pages to pages that need the juice" My question is please; "What tool / methodology exists to indentfy pages withing a site that could be deemed as "powerfull pges" ie deeper pages that receive more inbound links etc" Any insights welcome 🙂
Link Building | | Nightwing0 -
Domain split
Hey Guys We just got our selfs this domain: www.surfcampinportugal.com Is it possible for google to take out the two keywords "Surfcamp" + "Portugal" if someone is searching for it? as on this domain it can: www.portugalsurfcamp.com Thanks in advance... Simon
Link Building | | Rapturecamps0