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
-
Redirects affect on page and domain authority
Hi - excuse me if this is stupid question but I'm rather new to this. Currently the PA for the home page is 16 and the DA 28 and I have some concerns that my efforts are being diluted. When I use OSE on www.sassandgrace.co.uk I get different link results to sassandgrace.co.uk but there is a redirect in place to sassandgrace.co.uk and cannot run a crawl report, for example, on www.sassandgrace.co.uk. The PA and DA are identical for each but the number of links different With a smallish number of links pointing to each but with a redirect in place, am I losing some of the effect or is having the redirect in place giving me all the credit for links to both addresses? Thanks
Link Building | | Sassandgrace0 -
Domain vs. page SEO
Hi I'm new to SEO and trying to optimize one of my pages. However this page that I'm trying to optimize is not the homepage. Does it mean that since I have collected links from other pages to my homepage that the specific page I'm trying to SEO doesn't get any "link juice"? And how could this situation be corrected? Is the only way to get direct links to the page I'm trying to optimize?
Link Building | | agentti0 -
Should you "rel=nofollow" picture links if you also have anchor text going to same page?
On our pages we are having icons that link to different pages. In order to make it more user friendly we are also having some anchor text that also link to the same page as the icon. Is it bad to have two links pointing at the same page. We have multiple icons on the homepage and don't want to pass double of the link power! Thanks!!
Link Building | | Restore0 -
Why is my domain authority so low?
Hello, a couple of years ago I started publishing on my site more than 10 posts a day of content that no one else had. For this reason, my competitors started paraphrasing my content without giving proper attribution, and they ranked better in Google. That's why I realized that apart from creating content I had to work on my SEO, so I started to get some backlinks, most of them via contests on blogs. I am getting about 1 high quality link from PR2, PR3 or PR4 blogs each week. According to Open Site Explorer, I have 20 root domain links (200 total links). In reality I have more backlinks but they don't show up (they do show up in Ahrefs, about 50 root domains). To my surprise, I only have 15 Domain Authority. This is the most evident example, take a look at this screenshot: http://imgur.com/dFk2rkx My website is on the far left, two of my competitors on the right. As you can see I win every category except total links and the most important, domain authority. Are total links that important for Domain authority, even if 99% are internal? By the way, I also have more posts than these guys, I don't know why the report says otherwise. Why is the site on the right ranking so high? The same thing happens with the rest of my competitors, they have a lot of low quality links from "lists of domain sites" and in general a lot of very spammy links. According to what I have been reading, my good quality links should be more helpful than my competitors' spammy links, which should in fact affect them. So what is going on? I have no idea if I'm doing things right. Why is my domain authority so low? Thanks for your help. dFk2rkx
Link Building | | ganapro0 -
Can you get "link juice" from an outside company's/organization's intranet?
Will you get the same "link juice benefits" from a University, Government Org, or public company's intranet that are linked to your webpages – vs the benefits that you would get from links from their public webpages? Assume that the external webpages have very high Domain Authority, MozRank/Trust etc.
Link Building | | MLR0 -
How to add extension to my site on the organic result ?
Hello, i am trying to add extensions to my site on the organic result. i just wandering if it can be done from the google web master tool or i need to contact my web developer? leKJK0z
Link Building | | steve2150 -
Somebody wants to share something with me?
Maybe somebody want to share a list from dofollow forums ? ( all high authority if is possible) Thanks in advance!
Link Building | | nyanainc0 -
Blogspot blog on sub domain
Hi, I have a blog on the blogger platform from Google and it currently sits on a sub domain which can be added into the settings. But I got a feeling Google wont see this as part of the website because when I add the sub domain into the main websites sitemap it kicks an error for it. So basically what I got is a website and an external blog. The external blog gets a post a day with an anchor text link back to the most relevant page on the main website but I have read on the SEOMOZ website that smashing one external blog is not anywhere near as effective as syndicating the content across a range of blogs. So I have an external blog with pr4 and 100 backlinks, I have to say I did not set this up it was handed over like this and I cant move the blog onsite either. I'm thinking it would have been better to have 10 blogs with pr2 with 10 backlinks on each instead. I need to double check this before I action this from now on.
Link Building | | activitysuper0