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
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
-
My Domain Authority is 1 and has number "0" link from Root Domains! What is my fault?
My website has started from August of this year, but number of Domain Authority (DA) is 1 and has number "0" from root domains when i checked by moz addon on firefox. I find it very unusual and I am worried about it. does anyone can explain why is that ? My website is: https://adtvietnam.vn . I had 10 --> 20 keywords on page 1 of google.com.vn. p/s: i am really not good at english. i wrote that words by translate.google.com. I hope everyone can understand me and God i need your help ^_^
Link Building | | lthanhthe5s0 -
Www.partybox.co.uk - Why cannot improve the position for "party supplies"
About 4 Months ago I submitted a Disavow file to Google for www.partybox.co.uk which seemed to have improved the position across many terms. However the main term "party supplies" I cannot get to rank any higher than page 6 in the UK. I have no penalties in webmaster tools. Should I see if I can collect anymore links that could be holding the website back for ranking for party supplies or what should i be looking to do ? The website ranks well for other terms that the home page is optimised for such as party stuff but not for party supplies any advice would be great thanks Adam
Link Building | | AMG1000 -
Domain redirect math?
I’m thinking about buying the domain of a former competitor who is getting out of the business. His site has quite a few links, a healthy link profile from several hundred domains (a few common sites, but mostly different) and a Domain Authority of 44 (mine is a 55). His anchor text portfolio is very appropriate to my business, and the domain contains one of my most important keywords (one that’s in my own domain). His site ranks for a many of the same keywords as mine. Where mine is #3, his might be #4. I don’t want to operate his business (there’s a reason he’s getting out), but I was thinking that redirecting the domain to appropriate pages on mine would give a boost to the many long tail keywords which constitute a considerable part of my business. The question is how much of a boost? How much should I be willing to pay for his domain? If I get x visits/year from organic search and he gets y, and both sites rank for approximately the same terms, how much would you expect the two sites together get? Is there a rule of thumb for calculating this kind of thing involving some kind of logarithmic math? Does the combination of links of similar sites make 1+1=2, <2, or >2? Or is the only way to make this estimate to go through each of the major keywords trying to figure out what will happen to each? If, for instance, on average we combined our #3 & #4 rankings and got a #2 ranking, that would probably increase my clicks by 50% because of their higher SERP prominence. Based on my research, a visitor to my website is worth about $14. Assuming that his natural search visitors would be worth about the same amount if directed to my site, I would probably make 1/2 x * $14/year. I'm least comfortable with the first assumption. Is there a better way to evaluate this?
Link Building | | TREWS0 -
Guest Blog Etiquette & Re-using "Expired" Content
Hi everyone, There's two parts to this Q, which is why the title's sort of split in half. We wrote a guest blog post that we were really proud of, which took a good few hours of work. It went live about a month ago, but I just happened to notice recently that it had disappeared off the person's website - I now get a 404 error and I can't find it either using a 'site:' search in Google or via the site's own search tool. I've tried getting in touch with the webmaster, but he's no longer responding to my emails. I really don't know if a) it disappeared by accident (for whatever reason), or b) they purposefully wanted to remove it and now they're avoiding me. My two Q's: Do you think it's cheeky to re-use the content, by giving it to someone else? Or would you say it goes against guest blogging etiquette? It seems a shame to waste it, for it to disappear. If I were to re-use it, would there be any implications regarding Panda, given the fact that it was content that was once live (i.e. effectively 'duplicate', once upon a time), even if the 'original' content is no longer indexed by Google? Would it even be considered a duplicate if published again now? Many thanks in advance!
Link Building | | Gmorgan0 -
Links from erotic domains
hi.. I have purchased several domains which have had a lot of backlinks.. a lot of these backlinks are still active but mainly from pornsites.. do those backlinks affect the websites i links to from the domain? fx. lets say i have the domain abc.com which has a link from sex.com.. Now i want to link from abc.com to def.com - will the link from sex.com affect def.com in any way?
Link Building | | AdForce10 -
Best way to index backlinks
We have created many high authority back links for our clients and after several months we have noticed 10% or so have actually been indexed (via multiple sources). I am trying to find a way to easily get these backlinks indexed. There is a bunch of software out there, some create RSS feeds and others social bookmark these pages. Any suggestions?
Link Building | | waqid0 -
Most Powerful link in the entire world?
http://www.google.com/ Tribute to Steve Jobs on the homepage of Google. I couldn't help but check to see whether it was do follow. RIP Steve Jobs, a true visionary and pioneer.
Link Building | | seo-wanna-bs2