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
-
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 -
Requesting udpate's from old domain to new domain
Hey guys, We had a domain change three years ago now which was redirected. Many of the old domains have not been updated to the new domain. The redirect is in place. I'm just wondering if there would it be a worthwhile exercise to reach out to sites to request an update of the URL link from an SEO perspective? Many thanks Rob
Link Building | | Griffith0 -
Disavow data for non-manual penalty
I'm working on cleaning link profile for a client. He has lots of crappy links pointing to his site. I tried to contact site owners so that they remove those links. No go for the most part. Since it's not a manual penalty, there's no need to specify when exactly I tried to contact those site owners, add emails to my disavow file, etc. It's my understanding that it's OK to just add domains to Google's disavow tool to submit because there was no manual action and it won't be checked by a human being. Would that be the right way to go?
Link Building | | vitaliykolos0 -
Best way to set up a support site - sub domain, separate site or com/support?
My company is setting up our support site. It has been suggested that we set it up as a separate domain - www.company-support.com, rather than setting it up as a sub-domain (www.support.company.com) or the usual www.company.com/support. The person who proposed this believes it wlll create link juice, but i wonder if splitting the traffic will create more harm than good? Opinions please!
Link Building | | googilvie0 -
Renting Directory Listings
Is anyone aware of services that allow the renting of directory listings? Someone explained the concept to me and I am trying to find a good source for directory rental links. Thanks
Link Building | | jenadams0 -
What is the Best Way to Site Structure My New Content?
I am about to start adding some serious content to my site in hopes of providing more info to my visitors and to build organic traffic. I am looking for the best structure and places to put my inbound links. My website is tradethink.com and we specialize in trading systems for the commodities markets. I am going to be adding content about the particular commodities markets we follow; gold, soybeans, crude oil, etc. From my research I see it is best to place as many inbound links as possible to the content pages. On the other hand I see that it is important for the site to be user friendly and not have to much link clutter on the home page. I have a few options. Lets use "gold trading" instance. 1. Have individual links on the home page and most other internal pages that link directly to tradethink.com/gold-trading.html (lots of link clutter, but best SEO?). Problem is that I am doing this for like thirty pages and would have an additional thirty links on all of my pages. A possible work around is to place these individual links at the bottom of my pages. 2. Have home page and other internal pages link to tradethink.com/trading/ (just 1 link to add to each page), with the individual link still going to tradethink.com/gold-trading.html. Here I am adding a folder "/trading/" to place all of the links in, but when you click on the link inside the trading folder it goes to tradethink.com/gold-trading.html and bypasses the /trading/ folder to get better SEO, shorter url? 3. Have home page and other internal pages link to /trading/, with the individual link going to /trading /gold-trading.html This seems the proper way, but am I giving up link juice by going to trading/gold-trading.html vs #2 above going direct to /gold-trading Any advise/questions appreciated.
Link Building | | trader2470 -
301 Redirect Domains with old links
I came across a nice discovery of about 20 old domain names that each have many root domains and a bit of DA. I want to know the best way to utilize them without any type of penalty. Currently, (as of an hour ago) I am 301 redirecting all of them to the most relative pages on a single domain. Will i get the majority of the link juice from the domains? I'm excited to see what will happen here. Thanks in advance, Daniel
Link Building | | seoninja200 -
"Diverse" Links from same IP address worth the work?
Hi folks, This is my first posting, so please be nice with me 🙂 I have completed an all-new website (www.buy-hosting.net) , however the domain is bought and already exists since 2 years, but has no inbound links though. Now I start building links. I have some clients of my web design business, I could bring in links to my new site on their sites from different domains, some established and years old. However, they all are hosted at the same IP address. Is it a good idea for link diversity to post links on their site to my new one? I remember a thing, that only 1 link will be counted, originating from the same IP address. Is this worth the work of asking clients, posting links, etc.? Or is it even dangerous to my new site? Also, any other ideas about how to start link building are welcome. Is there a comprahensive list, something like a "startes guide with practical ideas" to link building? Thank you and kind regards
Link Building | | ie4mac0