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 ads on parked domains? Is this possible?
Hello Moz Friends, So as I was researching some competitive backlinks and I noticed a lot of backlinks that a clients competitor has are on parked domains and they appear to be google ads from some point. You know the pages that this page no longer exists, or hey do you want to buy this domain? and it has like 6 google ads on it? Yep those pages. My clients industry is construction and their competitor has links from zombie websites, foreign, websites and more. But the links are no longer on the page. Like when it was crawled, their ad was showing. Does this make any sense and is it usually temporary? Thank you for your thoughts friends!
Link Building | | asbchris0 -
Empty href damages SEO? (href="#")
Hello, I'm analyzing a website with thousands of pages.
Link Building | | prozis
I realized that on many of them they have empty links such href="#". I wonder if that will cause any SEO damage, or if Google will just ignore it as there isn't any link? I was reading about it and people seems to not be sure, although they recommend on forums to user the CSS pointer clickable instead of empty link. Let me know your opinion on this please! Thank you in advance!0 -
Link value from high authority domains vs low authority domains. How big is the difference?
Hi Guys. Could you send me in the direction of some quality information on link value. i.e) How much 'link juice' do you get from high authority domains vs low authority domains. Also, I understand the Moz value for DA is logarithmic, not linear. Does this also mean that a link from a site with a really high DA would be exponentially higher value than a site with a low DA. You know....like orders of magnitude better? Cheers in advance, I love you guys 😉 Isaac.
Link Building | | isaac6630 -
Does google really care if anchor text is the "brand name"?
I have read a lot about how it is a good idea to build links with your "brand name" as the anchor text. I am somewhat skeptical about all this. I suspect that the only thing that you need to do is have a wide variety of anchor text, some no follow links, and some links without any anchor text at all or just your URL. IDoes anyone have an opinion on this? Also I am somewhat confused about what a "brand name" is anyway. Obviolusly it applies to words like "Apple Computers" or seomoz but can I "make" my own name, i.e. Paul W. Matthews, into a "brand Name" aulby putting it in the title of my home page and just using it a lot as anchor text? If yes, is this a good idea? thanks, Paul
Link Building | | diogenes0 -
Publish content on current domain for content boost or new domain for links?
I have about 1000 unique and organically generated articles. My quote compare business has had briefs submitted by clients for over two years. The content has only been accessible to registered members. I want to polish it ASAP. Is it better to publish the content on the existing website in a sub folder or set up a new website to publish the content and have every article link back to the main website? Content is around 300 words x 1000.
Link Building | | designquotes0 -
Back links from more then one page from one domain
howdy SEO peeps, quick question. If i get a back link from two different pages from one domain, and both pages have different PR values. does google take both into its value PR or does google only take one of the links as PR juice to your site. thanks guys
Link Building | | david3050 -
How do you identify "Power Pages"
Good Morning from postively tropical near double digits Celcius Wetherby UK 🙂 I've just read "5 Methods to improve, indexing crwaling & ranking". Tip number two says "Link for powefull pages to pages that need the juice" My question is please; "What tool / methodology exists to indentfy pages withing a site that could be deemed as "powerfull pges" ie deeper pages that receive more inbound links etc" Any insights welcome 🙂
Link Building | | Nightwing0 -
Links per Site vs. Domain Authority
Here's a quaint one: 1. Posting follow links on another site helps increase one's domain authority. 2. If I post to the same site/forum with followed links each week, would my domain authority reap a domain authority increase benefit? In short, is there any domain authority benefit to continually post links to a site to which I've already posted a follow link?
Link Building | | GreenCupboards0