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
-
Building a Backlink Profile for a Brand New Domain
Hi there, Any advice on how best to build a backlink profile for a new website - I'm very keen to avoid penalisations or throttling from Google. Any advice on DA ratios to procure & frequency of procurement would be welcome. Please & thanks
Link Building | | jasongmcmahon0 -
Fixing broken links from old domain
Howdy Mozfans, I am fixing some broken links and I was wondering if someone could help me out. Multiple old domains (www.olddomain1.com, www.olddomain2.com and so on) have been migrated to www.currentdomain.com/olddomain1 and www.currentdomain.com/olddomain2 over a year ago. The old domains redirect to the current domain but we found that a lot of those were redirecting to 404 pages at the current domain. We now redirected all URL’s that were on the old domains correctly. Will those redirects ever get indexed (and passing linkjuice) since the old domains haven’t been used for such a long time? If not, would it be a good idea to redirect the 404 pages on the current domain (that were a result of the previous redirects)? Thanks in advance!
Link Building | | SEO-Bas0 -
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 -
Can a page be penalised by Google but not the entire site?
I have recently given some content to another site for a link. When I originally checked the site, it was indexed by Google and seemed ok. However, when I tried to check that the catergory page that my content was posted on was indexed, I received and error message from Google, however the homepage is still being indexed by Google. Is that the sign of a penalty or not?
Link Building | | AAttias0 -
Switching CMS and want to redirect links
Hi guys, I have a site that I run which has been around for a little while. It is actually in phpnuke, it also has a phpbb forum.. The site is so customized that I need to move it to something newer. So I am moving it to Joomla. I created a new domain just to get the joomla site created so I can move it to the main domain. My question is this. How should I go about switching from phpnuke to joomla without losing the links that are going to my site. Also, where can I find the links that are pointing to my site? Thanks for looking.
Link Building | | trumpfinc0 -
Sub domain names will they help with rankings
Hi, i have a site where i want to use sub domains to showcase the different areas in the country that we work, and i was thinking of having a couple of domain names with the city names to showcase the work we do in that city. I would like to know if by having a subdomain name and then linking it back to the main site if this will help me with the rankings for the main site. look forward to hearing from you
Link Building | | ClaireH-1848860 -
How would one get on the Huff Po's "Around the Web" list?
On the huffington post they often have lists of links related to the article, near the bottom just before the comments. This section, when present, is called "Around the Web". See this as an example: http://www.huffingtonpost.com/linda-bacon-phd-ma-ma/health-at-every-size_b_1314339.html Do the article authors choose these links, or are they auto-generated somehow? I had a relatively small competitor appear here, so I'm wondering if there are any tricks to gett included. Thanks! Edited to add hyperlink
Link Building | | AdoptionHelp0 -
Root domain registered in search engines, inbound links to www sub-domain. A problem?
I just discovered that our site is registered with the major search engines without the "www" sub domain. Both domains resolve directly to our site, which I need to get corrected. I had planned to have the root (honestabe.com) forwarded to the sub (www.honestabe.com). However, I then found that the sub-domain is not listed with the search engines. Of course, naturally almost all of our inbound links include www. Does Google differentiate between links with and without the sub-domain? In other words, if I forward the www address to the root, will I still get the SEO benefit of those inbound links using www? I'm trying to figure out how to approach this. I'm hoping someone is going to make me feel really stupid for asking this and say it's no big deal. However, I have a feeling this could be a mess.
Link Building | | honestabejosh0