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 root domains to your own site
I have been using the moz open site explorer tool and glancing at my competition. I noticed most sites if not all in the linking domains section have a link to there own site. How do i do this? On my site i have no established links and my score is only 1/1. Even with lower ranking sites that have there own site linking to there self have a 16/16. Any help would be appreciated I am pretty new to all of this. thanks
Link Building | | unlimitedairbrush0 -
Ranking Multiple Domains Simultaneously
What kind of strategy would one implement to rank multiple domains in SERPs? (One domain per keyword) I am looking more into link blocking and that, but I don't know the effectiveness and consistency of the strategy. Does anyone have any recommendations? I really can't be arsed giving every single site it's own full SEO treatment 🙂 Thanks very kindly and in advance for your thoughts 🙂
Link Building | | Ultra_Valves0 -
Backlink count is WAY high vs. competitors
Hi all! My site was managed by a SEO company that is no longer around. I started to look for a new agency and in the process, found Moz and decided to try out the report. While running the report, found out that my I have 3K links vs 173/1600/6344 links that my three other competitors have. Any simple guidance will be appreciated.
Link Building | | fullerton0 -
Tool to use to build disvow list?
opensiteexplorer has hardly any of the links listed. Is there a tool that I can use that will I search google for
Link Building | | Adsau
"If you are looking for the top provider of digital signage in Australia, visit today"
and I get 177 absolutely crap links to my site, is there a tool that can give me all the urls of the result of a google search? When I disvow does it do much? there is no hope of getting these forum post links removed0 -
Why my domain authority is dropping
Hi, I think I've been doing every right here. I just got a lot of nice backlinks from relevant sites ( pr 5 and higher), I also have been doing guest blogging for weeks. But suddenly, my domain authority dropped from 35 to 33. Traffic from searches also dropped a little bit. I didnt do anything blackhat yet so I dont know what is the reason why this happen. I update my site regularly, get more and more natural backlinks, do guest blogging. Or perhaps it was because I give links to my friends' affiliate sites and got penalized?
Link Building | | brian.jerimy0 -
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 -
.com links for .co.uk domains
Hi, I was wondering whether .com links from the US for .co.uk domains increase the search engine visibility of .co.uk domain in the UK just as much as .co.uk links for .co.uk domains (assuming they are all top quality content links)? (Context: I have heard that it does from someone who should know, but I would like to double check on that) If half of the backlinks for a .co.uk domain are from .com domains in the US is this a dangerous pattern Google would pick up on?
Link Building | | linkbuildings0 -
Do Expired Domain Retain Their Page Rank ?
I am a little bit confused about buying expired Domain Names because i have got mixed advice over the internet. Some Say That They Lose Their Page Rank And Some Say That They Don't. So I would really love to hear what PRO Members have to say about it! Also is it a Good Idea to use Expired Domain names for Link Building ? Rishi
Link Building | | RishiSeo0