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
-
disavow primary domain?
Hi friends is it possible to disavow primary domain? Like com or net? We currently see many incoming spam links with primary domain .xyz and i just wonder, why not block all these links with one rule domain:xyz? thanks
Link Building | | netcomsia0 -
Does domain authority to pass between countries?
When building dofollow links if the two websites are in different countries is the main authority still passed from the linking site to the destination?
Link Building | | seoman100 -
Links to "boring" pages
Hello Mozzers, EDIT: Is internal linking enough? This question is my head for a long time. Let's say I have a webdesign company and a website (really?). I have a blog and write quality content on a weekly basis. The content is great and people love it, they share it on social networks and other webmasters link to these articles. Now I have one optimized page, that brings me the business. Lets say: mywebsite.com/webdesign-service On this page I only have boring stuff like saying what I am offering and testimonials and stuff. So basically a page no one shares and no one links to. But it's important to rank with the keywords targeted on this site. How do I get to rank this page? A page that doesn't offer value to anybody. Normally, we shouldn't have pages like this, but some companies do boring stuff and creativity doesn't help. Maybe this question is stupid, forgive me but I don't get it. I am thankful for any answers on this!
Link Building | | grobro0 -
Domain Authority - quality scoring
Hey All:
Link Building | | Stephan_Boehringer
Got a question about domain authority value. I'm reviewing our link profile and I'm trying to figure out if there are any links to our domain we should disavow. I'm also looking at some of our competitor link profiles to see if we are missing out on any quality websites that could be linking to us. To evaluate this, I'm looking at the domain authoriy of any of the websites in question. Thus, my question is two-fold. At what point in time is Domain authority too low, necessitating us to get rid of the inbound link?2) How high should a DA value be to have us try to build an inbound link from to our website? FYI: our website home page has a page authority of 49 and a domain authority of 43. Thanks for your help Stephan0 -
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 -
Changing domain names... Bad idea?
We are re-doing a clients e-commerce website. Before I had entered them on SEO moz we had decided to change their domain name to one with a keyword inside. I had not known that they had an online marketing company previous working for them. They have a domain authority of 42 right now. It would be a horrible idea to switch their domain right? I looked at some of the links, they all have a variety of good anchor text. But alot of the links are coming from sites or directory categories that are not relative. We are also planning on doing 301 re-directs for the links. But this will not transfer the domain authority to the new domain right? Any thoughts?
Link Building | | DTOSI0 -
How quickly can I add links?
I have a site that is about 1-2 years old but I haven't worked on any backlinks yet. How many links is too many too quickly? I am looking to hire a firm to do my seo and I've received a lot of positive feedback from their customers and other seo experts in the area.
Link Building | | Webmaster1230 -
White Hat way to do blog commenting
Do you guys think careful blog commenting is still a valuable day-to-day linkbuilding tactic? If I create a list of relevant unspammed blogs, and spend maybe 30 minutes per day commenting on 3-5 of them per day, while making sure that they're not inundated with spammy comments - is that worth my time?
Link Building | | ilyaelbert0