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
-
Linkbuilding backlinks list to linkpartnes embed in website?
We do backlinking for clients. And for this we also create a backlink page for linkingpartners (afcorse not all link have a backlink). For easy maintaince it would be handy if we can create a page on our server that is embed on the website of our clients. Is it possible to do this so there is no negative SEO? (google will rate this page and the content perfectly) best regards, Vincent
Link Building | | Aquaster1 -
Backlink level of domain authority
Hi, we are trying to build on the number of good quality links. One idea we had is to provide testimonials for a number of suppliers websites. Which would include a link from our company name back to our site. Is there a certain level of domain authority we should only do this for? For example if a supplier only has a domain authority of 11 should we not get a back link? Many Thanks
Link Building | | danieldunn100 -
What is the Best Way to Select a Company for Linkbuilding?
We need a few more links, who doesn't, and I've been looking at outsourcing it. Having checked out Moz posts to get an idea of best practice it seems that most link builders that responded to my Elance advert would give me links that would get me penalised either now or in the next update or two by Google. Leaving aside the frequent mentions of link wheels on potential SEOs sites, the main problem seems to be that I cannot believe that any content generated will be of any value to anyone other than as a pseudo contextual basis for the link "Bats are a flying mammal. They use sound waves to navigate. Sound is used in hearing aids. blah blah. blah." So how do you find decent link builders? How do you validate them? What are the key questions to ask? What are the red flags?
Link Building | | Zippy-Bungle0 -
Sub domain names will they help with rankings
Hi, i have a site where i want to use sub domains to showcase the different areas in the country that we work, and i was thinking of having a couple of domain names with the city names to showcase the work we do in that city. I would like to know if by having a subdomain name and then linking it back to the main site if this will help me with the rankings for the main site. look forward to hearing from you
Link Building | | ClaireH-1848860 -
Why my domain authority is dropping
Hi, I think I've been doing every right here. I just got a lot of nice backlinks from relevant sites ( pr 5 and higher), I also have been doing guest blogging for weeks. But suddenly, my domain authority dropped from 35 to 33. Traffic from searches also dropped a little bit. I didnt do anything blackhat yet so I dont know what is the reason why this happen. I update my site regularly, get more and more natural backlinks, do guest blogging. Or perhaps it was because I give links to my friends' affiliate sites and got penalized?
Link Building | | brian.jerimy0 -
Where can I go to find the latest links to my domain?
I have checked the link analysis section and looked at link history. I have also checked Open Site Explorer but I can't seem to find a way to just show me the most recent links to my site . . .
Link Building | | BlueLinkERP0 -
Cost affective way to automate linkbuilding?
I have done manual link submissions to directors and other places in the past. As a business owner i find it extremely tedious and find no time for it at all. I have outsourced it since and seen moderate results. There are systems like linkvana etc which promise to give high pr links, are they good? is there any other way to get niche relevant links automatically & cost affectively? Thanks
Link Building | | SamBuck0 -
Do Expired Domain Retain Their Page Rank ?
I am a little bit confused about buying expired Domain Names because i have got mixed advice over the internet. Some Say That They Lose Their Page Rank And Some Say That They Don't. So I would really love to hear what PRO Members have to say about it! Also is it a Good Idea to use Expired Domain names for Link Building ? Rishi
Link Building | | RishiSeo0