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
-
Sending Domain Authority from Root www domain to *
Hello all Some advice please. Im working with a friend who has a website (obviously). Its based on wordpress and is accessible by the link http://exampledomain.com. The problem is he has some good links out there which are pointing at http://www.exampledomain.com. As yet Im uncertain how he has setup his DNS, he maybe is doing a forward which would leave the DA back with the www subdomain. What is his best practice to inherit those links into his actual domain? Thanks
Link Building | | DarrenMOB0 -
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 -
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 -
Do links in hosted documents help with domain authority?
When giving presentations in our industry, we often find that the PDF or PPT document is then hosted on the origination's domain for download by event attendees. If these files have links, do they count as inbound followed links?
Link Building | | ULCRobotics0 -
Why don't some external links "count"?
A car-dealer client advertises through DexKnows, and the entry includes a link to the client's website. That link is not listed as a linking domain through OpenSite Explorer for the client's site. A competing car dealer also advertises through DexKnows, but that link is counted as a linking domain for the competitor. Why the difference? (I'm new and still learning -- linkbuilding appears to be my weakness.) Thank you!
Link Building | | TheOptimizer690 -
Bloggers "no_follow"
Hi Guy's, We have been sending bloggers products to review and in return we ask for a link back to our website to the relevant product. As I now understand it, Google is no longer giving this any weight & bloggers are being advised to use the "no follow" tag. So have I understood the new rules correctly? If so is it worth us continuing to send bloggers products to review? Thanks Daniel
Link Building | | LushDuck0 -
Yahoo Directory unable to access a domain for submission
Tried submitting a website to Yahoo!'s directory but each time no matter how i input the domain i get the following error: We were unable to access your web page. Please double-check your URL. Is there anyway to contact Yahoo! to request a manual submission?
Link Building | | EAOM1 -
Brainstorming - Unusual Ideas to get links in the "short term loan" industry
Hello, I would like to hear your strange/unusual/funny ideas for link building campaigns for a website targeted in the short term lending industry. It doesn't matter how easy/complicated it is to apply them, but the more realistic the better. Please don't post anything that was covered in detail somewhere else or something that does not have at least a small/tiny level of realism. An example: Extract the funniest/smart quotations related to money. Create an article where you explain that "even if you are in the short term loan industry" you care about your customers and you want them to educate them so in the future they can avoid getting in a situation when they have very few alternatives.
Link Building | | zoicaremus0