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
-
What MOZ domain authority are considered bad links?
As a general rule of thumb, what MOZ domain authority are considered bad links? Ie., is it for sites that are 20 and below? What is the DA floor where you should target links from?
Link Building | | jspinder150 -
Backlinks from a secondary domain
Hi i finally figured out why my link profile is out of wack. Apparently we had a second domain registered that for some reason was active and linking to us - somewhat duplicated site. no idea when or how that happened. I wasnt with the company then. anyhow Ive now pointed the domain to a blank folder since I dont know how to disable it in 1&1 Hosting (if anyone knows please let me know!). Im wondering if this is enough? will the links still be there indexed even though the domain points to a blank folder? also how can I get google to profile my backlinks again? so I can see if it worked. Currently waiting for a new Moz crawl so Ill see if at least there my profile is looking healthier. thanks in advance!
Link Building | | ACEmina0 -
Domain vs. page SEO
Hi I'm new to SEO and trying to optimize one of my pages. However this page that I'm trying to optimize is not the homepage. Does it mean that since I have collected links from other pages to my homepage that the specific page I'm trying to SEO doesn't get any "link juice"? And how could this situation be corrected? Is the only way to get direct links to the page I'm trying to optimize?
Link Building | | agentti0 -
Website title has domain name in SERPS but not in the website.
We are using the latest version of Wordpress for one of our website. Now every page in SERPS is like this: SEO Services, Link Building and Social Media - Oursite.com But when we look at our website's title tag its like this: <title>SEO Services, Link Building and Social Media</title> It's very strange, why the website's domain name is appended to the title in SERPS?? Any ideas? Thanks!
Link Building | | TheSEOGuy10 -
Multiple on-page links to single domain
Hi, the main focus of my question is to add a bit more information to my client as to where they are going wrong. Firstly they have a directory on a third party domain with subdirectories containing all their product listings. All the links need to be no-follow for sure. However, from a link juice passing perspective if there are per page say 20-30 links to varying URLs on the same domain is it still the same sort of calculation that the link juice is sufficiently weakened that each link has little value, or because the links are to the same domain there is an extra (potential) filter going on?
Link Building | | MickEdwards0 -
Easiest Way to get Wiki links
1.What is the easiest way to fetch a backlinks from wiki sites.Wiki answers.Wikipedia or any other site. Any one kindly guide me in detail how to do it?Not interested in creating and maintaining page. 2.What if I need multiple links?
Link Building | | csfarnsworth0 -
Domain Authority and nofollow links?
Hello, I'm wondering, are 'nofollow' links from websites with high domain authority beneficial? Would they boost our own DA? In essence, I'm wondering if there is added value (other than visitors clicking the link) to being linked to by a 'nofollow' link. Thanks!
Link Building | | yacpro130 -
Domain position on site:domain.com search
Hi, After the last week Google algotithm update, my web site index appears on 4th position when I search for site:www.domain.com If I make a simple search for domain or domain.com it ranks on first position. Is this a sign of a penalty ? What would be the cause ? Thanks
Link Building | | tranquilito0