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
-
Results After a Disavow File Submission
Hi, I have a client who had a range of spammy links going to their website. The links were from exact match anchor text, from duplicate content and poor quality, irrelevant domains. They also had built a number of sites and linked to my client's site from each of the footers. All the domains they owned have been redirected to the site we're working on. We also disavowed all the spammy links going to the site. This was over a month ago and rankings haven't changed and in fact, have gone down slightly. Is there any other course of action anybody could suggest or should i wait longer in the hope the disavow is still yet to be accounted for? Any help I'd really, really appreciate! Thanks
Link Building | | SolveWebMedia0 -
Link building - unique root domains
Hi there, I was wondering when asking for a link, does where on this page it is? For example will someone's high traffic website (e.g. example.com ) provide more page authority than another link on this site ( e.g. example.com/blog ). If this is the case, is it best to get links from multiple pages if possible or will this not effect SEO? Thanks
Link Building | | charliedavi0 -
Purchasing local domains for SEO
Hi, I'm considering buying domains to help build our SEO traffic. But, I'm looking for some advice on whether or not this can hurt us. For example, if our site is www.brandname.com and the site is all about online education, would it beneficial for us to purchase a local domain like education.boston.com and optimize with unique content so we can point back to our own site (if "education boston" is a high volume keyword)? Thanks!
Link Building | | BenchPrepCourtney0 -
What value do external broken links give to a domain?
I ask, as I've just used opensite explorer to look at external links a competitor has, and I've found the high value ones at the top of the list go to a page that no longer exists on their site. Are these stiill of value in the SERP's, or have they messed up by not putting a 301 redirect on them?
Link Building | | xposurecreative0 -
Unique Domains vs. Total Links?
At what point is there diminishing returns from getting multiple links from one website? Edit: To clarify, when doing competitor research I come across lots of sites that have say 500 linking domains with 5000 total links. When setting goals and calculating the types of links I should go after, I'm not certain which number is the one actually helping the site to rank.
Link Building | | ErikDster0 -
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 -
Redirecting a previously expired domain - any SEO benefits?
Is there any SEO benefits from registering a previously expired domain name that is still linked to form an authorative source and 301 redirecting it to another site on a similar subject? Obviously first benefit is giving users who are clicking on the link to be sent to a site on a similar subject that just to a dead link.
Link Building | | Wardy0 -
Would you advise removing a "links" page?
I'm doing a site audit for someone and they have a links page full of reciprocal links for other similar businesses across the country. My gut instinct is to remove this page. How would you approach this if this was your client?
Link Building | | MarieHaynes0