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
-
Is it better to have backlinks from domains with medium DA, UR, using same language and good relevancy, or backlinks from domains with high DA, UR but using another language and with less relevancy?
Dear all, while I understand that quality backlinks with high DA, UR, same-language and relevancy would be best, would backlinks with high DA, UR but less relevancy and using languages other than the one used in my website be something good? Or would they do more harm than anything else and still be outcompeted by backlinks with lower DA, UR but same language and/or more relevancy? Thank you Frank
Link Building | | Frank_Smith0 -
SEO Consultant Wants to Disavow Organic Links
Hi, We're working with a SEO consultant. They made a second check of our inbound links and want to disavow some of the links that seems organic to me. They claim they're bad by their characteristics. Should we act as they suggest or not? Or should we run from them?;-) Here are some links in question:
Link Building | | nikitin.i
http://www.wowresource.eu/index.php?showtopic=14942 http://answers.yahoo.com/question/index?qid=20080208070036AAE1ePo https://www.macupdate.com/app/mac/39144/visual-watermark All point to http://www.visualwatermark.com0 -
If i get link pointing to a specific page , will that link add up to the count of linking root domains too ?
If I create a fresh link pointing to specific page on my site, apart from adding a number to "page linking root domains" does it also add up to root domain linking ?
Link Building | | Techbate1 -
"New" Digg - SEO benefits?
Quick question for the group - I've not used the new Digg. Does it have SEO benefits? I wasn't sure if Google counted these or not. thanks
Link Building | | yandl0 -
Has anyone changed domain after "unnatural link message" from Google?
We received a "unnatural" email from Google approx 6 months ago and have tried removing all links but it is proving to be near impossible - has anyone undergone a domain change and moved their sites to get rid of the penalty?
Link Building | | jj34340 -
Multiple LInks from the same domain - how much benefit do they give?
I'm wondering how much added benefit there is to gaining multiple links from the same domain? For example when looking at a competitor in open site explorer I see they have 239 linking domains but 5,066 links. How much additional benefit are they getting over just having 239 links from 239 domains? Also how many links is an optimal number from a domain in that case before there become no more point seeking links from that domain? 5? 10? Thanks
Link Building | | performagen1 -
Is this a good way to create engaging content?
Hi all, I believe this is my first question in this forum, so be nice 🙂 I am an SEO consultant who has recently gone out and started my own SEO consultancy. Obviously, I now find myself in a place where I am trying to create good content for my website visitors. Maybe it's link bait, or more than likely it's a way to hold myself up as an expert in the industry, while providing visitors to my site some reason to keep on coming back. As I love whiteboard Friday, I did consider - and I'm not ruling it out in the future - creating my own whiteboard Friday videos discussing the SEO issues I was focussing on. In the meantime, I am thinking of posting up SEOmoz's whiteboard Friday videos and then making my own comments and insights for my website visitors. So, what I really wanted to ask - do you guys think this is a good idea, a valid way of creating good content and has merit/credibility? http://www.nustudio.com.au/local-seo-the-basics/ contains an example of what I am talking about. Cheers, Steve
Link Building | | stevedeane1 -
301 Direct with a deleted domain newbie
Hello I'm wondering if the 301 redirect to your money site with a high pr deleted domain still works post penguin. Will all the link strength pass on to the new domain? What if the domain has nothing to do with your niche? Does that affect it or no?
Link Building | | 6786486312640