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 the powerful links of an old domain help my new domain?
I recently purchased a domain with over twenty years age, a few .gov links and A LOT of .edu links. Of course, the domain is relevant to my site's content. I'm hosting the domain on my shared server and have setup 301 redirects for each page that had external links pointing to it via the htaccess file within the domain's root directory. These 301 redirects, of course, point to my new domain, which is on a dedicated server. Specifically, they point to a directory on my new domain. I've also verified the purchased domain and my new domain on Google Search Console/Webmaster Tools. Finally, I've completed a google site change request for the old site to point to my new site. My questions: Should I also list my old domain on the dedicated server over the shared server or does it matter? Will the backlinks of the old site show up in my new site's links via Google's search console, Open Site Explorer, etc.? Will the backlinks of the old site improve the authority of my domain? Also, keep in mind that I have the 301 redirects pointing to a directory on my new site, not the root page of the new domain. Will the backlinks of the old site help my new domain's authority? In the eyes of Moz I've read, NO. I understand it's just a MOZ metric but from what I understand it also correlates with Google's actual 'authority' metric/method of giving value to a particular domain over another based on the backlinks. How exactly do the backlinks of the old domain benefit my new domain and is there a way to measure this/see the relationship? Thank you for any help you're willing to give!
Link Building | | ninel_P0 -
Many of our best links are to our old domain. Problem?
Hi, around 7 years ago the organization I'm with switched their domain name. When doing link analysis some of our best links are to the old domain including a followed link from an article on the BBC news site. The old domain has been 301 redirecting to the new domain for years. Is it worth the time to contact the sites that are linking to the old domain? Or, will all or the majority of the link juice be given to the newer domain with the 301 redirect? Thanks!
Link Building | | limited70 -
Moving blogs to different domain
Hey guys, We currently have some blogs on one of our pages (fraserisland.com.au) and we are launching a complete rebranding of our sites. We want to move the blogs from fraserisland.com.au to the new parent page of travelfreedom.com.au (but still link it to fraserisland.com.au), however I don't know what affect this will have on the ranking of the blogs. The biggest thing I'm worried about is that the domain will be completely different, and not a sub domain, but I'm not sure what impact this will have on the effectiveness of SEO on the blog. Thanks guys
Link Building | | Mysites0 -
Can you get "link juice" from an outside company's/organization's intranet?
Will you get the same "link juice benefits" from a University, Government Org, or public company's intranet that are linked to your webpages – vs the benefits that you would get from links from their public webpages? Assume that the external webpages have very high Domain Authority, MozRank/Trust etc.
Link Building | | MLR0 -
Two Links in one Article to One Domain
Will multiple links in a single article to one target domain (but seperate pages) count, or just the first link of that article? Thanks, Chris
Link Building | | Diderino0 -
Do "Sponsored Posts" links get discounted by google?
Do "Sponsored Posts" links get discounted by google? A feture post that is tagged by the site as "featured' or "sponsored" are they discounted as paid links by google?
Link Building | | DavidKonigsberg0 -
Urls rewriting "how to" with .htaccess
hi, Please i would need advices (links, tips, tool:generator ?) regarding url rewriting through .htaccess (newbee about it). It's a "refurbishing" website case , the domain doesn't change. But the CMS does ! I've got a list of urls (800) with which i don't want to loose rankings on : Here the type of old url syntax : http://www.mydomain.com/home/newscontent.asp?id=1133 Here the new url type would be: http://www.mydomain.com/name-of-the-article
Link Building | | mozllo
or/and
http://www.mydomain.com/category/Page-2 Tks a lot...0