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 a link as a "do follow"?
I have a page from a state agency linking to my website. They have good PA and DA. How do I tell google to "do follow"? It is already showing up as linked to my site, I just want to make sure I'm getting the SEO juice! 🙂
Link Building | | Kuhliff0 -
Should I disavow these links?
Hi all, I have a site that is a year old, we have been building backlinks organically - probably around 50 or so - then almost overnight we had100s of spammy links. Screenshot here: https://ibb.co/cijiub My questions: Should I disavow these? What happens if I don't disavow these? Can I work out where they came from? If I disavow a few of them, is this a token offering to the Google Gods that will lower my risk of being penalised? Thank you. cijiub
Link Building | | Bee1591 -
Disavow question
Hi there, I have 2 website's, and one of them will be redirected to the other. For both I need to do a disavow list, but I don't know how is better. I should make only one disavow list for the main site, and include the link from the site that I will redirect, or make a list for each website?
Link Building | | Silviu0 -
Linkbuilding backlinks list to linkpartnes embed in website?
We do backlinking for clients. And for this we also create a backlink page for linkingpartners (afcorse not all link have a backlink). For easy maintaince it would be handy if we can create a page on our server that is embed on the website of our clients. Is it possible to do this so there is no negative SEO? (google will rate this page and the content perfectly) best regards, Vincent
Link Building | | Aquaster1 -
Need referrals on expert to clean up "unnatural links" and submit reconsideration request
I just received a manual unnatural links penalty. I was shocked because other than maybe five links many years ago, I've not done anything to get links. The site is very powerful in it's own right and buying links is unnecessary. My first thought was a competitor has done the link spamming on my behalf, any my site is very profitable and the competitors are plentiful and ruthless (i.e. steal my content and use it) since we are #1 for our search term. I took a quick look at my links (via webmaster tools) just now and yes, in the last few months there are tons of links from very bad looking sites that are I've never heard of. It's obvious I've been purposefully hit by a competitor. (What's it called when they do this?) Does Google understand at all that this stuff goes on? Do they even care? On the eventual reconsideration request, if I say that I honestly didn't do those links, would they even believe me or even care? I have read several articles on what to do now. But this is so important to my income stream that I don't want to screw anything up trying to fix it, and I want to get it right the first time. Every day is very expensive to me. So, I'd like to get some recommendations on any experts that can handle this professionally and swiftly. Please let me know of anyone trustworthy that won't rip me off, and if you are such a professional yourself, please let me know. Thank you
Link Building | | bizzer0 -
Exact Domain Match Ranking Very Well
Hello, I have some competitors that purchase targeted keywords, host a single page, and do a re-direct on to their inventory page. The problem Im having is getting above them, along with other competitors that have a high DA. They have little or no content on the page but rank very well. Is there anyway around sites like this? ex-bluewidgets.net bluewidgets.org Thank You
Link Building | | TP_Marketing0 -
Does the feature "Competitive Domain Analysis " include subdomains?
Hey guys, I have set our domain as www.domain.com at the campaign settings, but i'm not sure if the link analysis ("Competitive Domain Analysis") does include subdomains? Does anybody know this? Greez Chris
Link Building | | lordcyphon0 -
Best way to combat spammy links
Hi folks. A client of mine has taken to building spammy links from commenting on forgein blogs etc. Since hes started this his site has totally dispeared from the SERPS apart from company name searches. I'd be really interested to hear your thoughts on how to bets combat this? Many thanks in advance
Link Building | | EclipseLegal0