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
-
How do I set "no follow"
I see some very spammy site linking to my site. How do I tell google to "no follow" those links in regards to my site?
Link Building | | Kuhliff0 -
Best Way to Filter Backlinks
When analyzing backlinks and trying to get the same one for another site there are a ton of backlinks to go through. I know that if the DA of the link is then pages on the site might be a good choice like adding an article or something of the sort to the site but as far a the same page goes you can typically only do this with a comment on the page. My question is, given a huge list of backlinks from multiple sites, is there an easy way to analyze the links and determine which ones I can copy without manually checking hundreds of links?
Link Building | | spyke010 -
Domain Change, loss of inbound links ...
We're strongly considering a domain name change; this is purely for marketing reasons. We think in the long term, this will be a good thing. I believe we can mitigate the page redirection, branding changes, etc. My concern are the inbound links: from 200+ domains, 3,000+ links. So, I guess we can contact each of the top sites linking to us and hope they update our links. I'm not hopeful. I believe we'll loose must of the links. Has anyone been down this road and have experience to share?
Link Building | | jmueller0823
What should I expect, worst case? Is there a way to mitigate? Thanks much.
Jim0 -
The best way to engage with bloggers these days?
What's the most effective/least risky ways to engage with bloggers these days in order to build links, gain exposure and refer traffic? I'm in a competitive niche (weddings), and there's no shortage of high quality and unique content being offered to bloggers. Currently, I do a mix of sponsorship, product giveaways, promotions etc. But, also have some ideas in the pipeline, such as collaborating with other vendors on styled shoots, etc. The latter is very time-consuming and, again, is something that has been done LOADS. So, needs to be very unique to stand out. Want to avoid things like guest blogs and riskier tactics. For obvious reasons. Any fairly easy-to-do ideas that I've missed before I explore the more complex ones??
Link Building | | Coraltoes770 -
Disavow Dead Links?
I haven't found a good answer to this yet. I know the whole "disavow" tool is still relatively new but we have a ton of dead links, actually most of the dead links are sites that have 404'd. Is it necessary to disavow these?
Link Building | | MattTrostle0 -
"Bad" backlinks
Hello dear community, I am new here and quite new to SEO. Perhaps someone could give me a hint on a following question: Which tools can help me to track "bad" baclinks, e. g. links which would rather downgrade my SEO performance?
Link Building | | hochzeitsfotograf0 -
Should I be Improving Domain Authority?
Hello I work for a company that deals in Collectibles and runs a collectibles news service. In the UK our site ranks on the first page for the keyword "collectibles". We wish to strengthen this position and increase our rank on the US Google. I'm going to be working on Keyword Optimisation for the site, to hopefully make many of our pages more relevant and improve the rank. However I feel we may be held back by our Domain Authority score. Our Google PageRank and MozRank are both low due to the fact we don't have a huge amount of external links to the site. Is this something that will potentially hold us back? Should I be working on improving this as before the site optimisation? We are well set up for a content based strategy due to "News" nature of the site. My ownly concern with link building is i've heard that it could potentially negatively effect us. Or is the risk of link building only really associated with black hat methods? One last thing. I've been using the Google keyword Tool to judge competition for specific search terms. Is this useful for organic search? Or is it only relevant for PPC? Sorry to be a pain with all these question! Thanks
Link Building | | PaulFraserCollectibles1 -
"Diverse" Links from same IP address worth the work?
Hi folks, This is my first posting, so please be nice with me 🙂 I have completed an all-new website (www.buy-hosting.net) , however the domain is bought and already exists since 2 years, but has no inbound links though. Now I start building links. I have some clients of my web design business, I could bring in links to my new site on their sites from different domains, some established and years old. However, they all are hosted at the same IP address. Is it a good idea for link diversity to post links on their site to my new one? I remember a thing, that only 1 link will be counted, originating from the same IP address. Is this worth the work of asking clients, posting links, etc.? Or is it even dangerous to my new site? Also, any other ideas about how to start link building are welcome. Is there a comprahensive list, something like a "startes guide with practical ideas" to link building? Thank you and kind regards
Link Building | | ie4mac0