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
-
Backlink and Citations: "Google my business" title name too long!?
Here is my situation.
Link Building | | H.M.N.
I am currently doing backlinks and citations for one of our clients. The title name of the client on "Google my Business" is 75 characters. However, for most citation or back link websites, the limit for the title is 50 characters. Here are my questions: How important is it to have the exact same title in citations and backlinks? If it is, is the only solution to change the name on google to have only 50 characters? Thanks in advance for your help!0 -
How to increase my website root domains?
Daily I am creating new root domain back links.. but my website root domains are not increased much.. I will use to check moz open explorer. Moz have any algorithmic for increasing root domains....Any body can answer my question? Please
Link Building | | mzakaria0 -
Domain authority vs. anchor text in backlinks
Hi - I launched a new blog ~3 months ago and I've managed to get some backlinks from Yahoo, Cnet, Huffington Post, Gimodo, etc. I created some compelling and unique content. However, all of the anchor text of all of the links is mywebsite.com or mywebsite. None of them are the actual keywords I want such as "this website is great for keyword blah and keyword blah" My question is....could I get more "juice" from these links if they had more specific anchor text or is their high domain authority enough as far as google is concerned?
Link Building | | garyislearning0 -
Our ranking strategy - what to add and would it work?
Hello everyone, this is actually my first time to ask here so please be kind to me. I won't consider myself an expert on SEO, I originally studied to become a writer. I've been learning SEO for the past 1 1/2 years but recently I've encountered a wall. One of our clients wanted to rank high on Google in DIFFERENT countries. So far here are what we're doing: Keyword research + integrating keywords in content Site optimization (inserting keywords on meta tags) Blog development (10+ times a month with use of keywords) Linkbuilding (Local directory submission, submission on free PR sites, making sure client is listed on their partners' pages) I've always thought developing more content would help the site rank higher. Should we build links for a specific page that has our main keyword so that it would also rank higher? Or building links for the root domain just as good? Your comments and suggestions will surely help! Thanks!
Link Building | | RMTA0 -
Are moderated external links in a "showcase" worth having?
We have some e-commerce software with several dozen websites that use our technology. The websites have links to the developer and design shops that made the site as well as the site itself. All of these sites are moderated so we don't have to worry about spam. My question is should some or all of these links be rel=nofollow? The links are definitely pointing to legit development shops but those sites aren't always strictly related to e-commerce or the keywords we're trying to rank for. Any thoughts on how to treat these links?
Link Building | | schof0 -
Footer Back Links Question "Site by built by"
Hi all I design and develop websites for clients within the UK. With each website I build, I always add a link to the footer of the website which links back to my website. I have always used the link anchor text "Site By Jump" but then decided to try to use the link anchor text to our benefit by changing the links across all of our portfolio of sites to be: "Graphic Design by Jump"
Link Building | | yousayjump
or
"Web Design by Jump" In the hope that this helped us rank better for those keyword phrases. Now something occurred to me the day. Most of the websites I build have no relevance to the content on our website. For example, I could build a website for Baby Food and add a backlink to our homepage which doesn't even mention the words "baby food". In some cases, the websites can have thousands of pages, each with this footer link appearing at the bottom of each page. My question is, could these backlinks potentially be seen as black hat or spam to a search engine? I.e. thousands of backlinks from websites that have no relevance in terms of content all linking back to my homepage? Thank you for reading and any advice would be greatly appreciated.0 -
List of links pointing out of my site?
What is the best way to produce a list of links pointing out of my site and the web page they appear on?
Link Building | | MiroAsh0 -
Ways to increase ranking positions?
Hi, I want to discuss the different methods for increasing ranking positions for a keyword using offsite SEO methods. If your targeting a keyword which gets 20,000 exact match searches a month for a new website then the first thing you are going to want to do is rank in the top 5 within Google for that term. I know onsite will come into play as well but lets just say you have used the SEOMOZ tools and your onsite SEO achieves a grade A. So what needs to take place in order for your website to start climbing ranking positions? I myself would be more inclined to spend a few days creating 4-5 nice articles and offer them up for guest blogging with anchor text links. I may also use the content on a hub page, squidoo lens, wordpress blog, blogger blog, weebly blog and so on with social bookmarking thrown into the mix. But will this alone over a period of time (depending on the competition) increase rankings? Am I missing a trick here??? Cheers
Link Building | | activitysuper0