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
-
Disavowing Links
I need some advice... I've noticed our link profile has increased with many comments links --- something I certainly have not pursued manually. I'm new to disavowing links. However, before I go ahead and disavow them, I'd like to ask how harmful these links are and would you recommend this is something I can do myself (relatively novice SEO) or if you'd recommend someone who could do this for a reasonable cost. In one instance, the link from this comment thread is with the anchor text, "porn"... Certainly not something we want to rank for, haha! I look forward to your advice
Link Building | | LukeBTDT0 -
What is Followed Linking Root Domains ?
Is it to just have different URLs pointing to my site? I understand that if 1 site posts 5 of my URLs, it only counts as 1. I am just not understanding how I increase this number if link building is now frowned up. Thoughts?
Link Building | | tiffany11030 -
Domain authority or page authority in ranking
Hi, sorry if this is an obvious one... I am doing some keyword research tool and have a few keywords I wish to ran for. Looking at the DA of the sites on the first page they are averaging 60ish, my site is 33. However, for the keywords I am targeting they seem to have PA of 1, or at best, 5. From what I can make it out appears they are ranking for the keywords because of their strong DA rather than any seo work. If I were to target these keywords and send backlinks to the individual pages and so build up a PA on my pages would this be enough to challenge the competitors or would I still be at a major disadvantage because of my lower DA? Hope that make sense? I know what I mean but hard to explain it Thanks
Link Building | | ccgale0 -
Example of a local "boring-niche" site in a relatively high competition area using strictly white hat tactics
I'm looking for an example of a site in a very boring service niche locally "let's say elevator doors in chicago" or something like that, that successfully using blogging, content generation, etc to achieve top rankings above its spammy competitors. Anyone care to give out a case study? I'm not talking about companies that submit to 100's of local directories like yelp, or google maps rankings. I'm talking about organic or blended serps.
Link Building | | ilyaelbert0 -
Different Ranking for "dermatology jobs"
Ranking for "dermatology jobs" (<cite>www.dermbuzz.com )</cite> on google.in (INDIA) is on first page whereas on google.com (USA) its on 6th page
Link Building | | getpromoted0 -
When good domain names go bad
We have created a website to distribute a niche product. About a year ago, another vendor decided to drop the product and did not renew their domain name. We tried to acquire the domain name, but a cyber squatter picked it up. The old domain name had a few decent back links, and there was probably some value to us with a 301, but the cyber squatter was asking $8,000 and we didn't even bother countering such an absurd figure. The old domain continued to rank reasonably well for one or our search terms, even though it was just one page of spammy links. Well, this week it appears that Google Panda may have finally killed it off. Which brings me to a couple of questions. 1. In addition to a simple Google search, is there a way to determine if Google has killed a domain? 2. Assuming that Google has indeed killed the domain, is there any value in trying to 301 the domain should it ever be released? Best,
Link Building | | ChristopherGlaeser
Christopher0 -
How do I get Bing to recognize my site as a "News" source?
We are a publisher printing a magazine with corresponding news on our website and would like to be included (obviously) into the Bing news area, any tips on getting Bing to notice and include us?
Link Building | | KenPiech0 -
What is best way to evaluate external links to my site?
What is the best way to evaluate external links coming in to my site? I have been working on trying to build links by commenting on blogs/forums and adding to directories, etc. I've run link reports through Open Site Explorer and Yahoo and they never seem to show the same links coming in. For example, i run link eport on Open Site Explorer and it will show links coming into my site that Yahoo doesn't show, and vice versa. I guess I'm trying to figure best way to monitor each week new links coming into my site to determine if my efforts are fruitful. Also, is there a certain period of time that should pass from time I put my link on another site (ie, a blog) until it will show up in OPen Site Explorer? Thanks! Oh, and I use the NoDoFollow Add-on for Firefox to only comment on those sites that do follow. Not sure if that's really effective or not.
Link Building | | leonenobleseate0