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
-
Requesting udpate's from old domain to new domain
Hey guys, We had a domain change three years ago now which was redirected. Many of the old domains have not been updated to the new domain. The redirect is in place. I'm just wondering if there would it be a worthwhile exercise to reach out to sites to request an update of the URL link from an SEO perspective? Many thanks Rob
Link Building | | Griffith0 -
Why did I lose my rankings for a keyword "CRM" even after getting quality backlinks?
Initially my website is ranking on third page of Google.com for the keyword "CRM". So to improve rankings I got good number of quality backlinks by guest posting in various websites. But now my website is ranking on 6th page, which is a big concern for me. But for Google.in there was neither any improvement nor any fall in the ranking. I have following doubts in my mind 1. Does the sudden increase in backlinks (quality backlinks in the from of guest posts) effect rankings in a negative way? 2. Why did it effect on Google.com and not on Google.in? 3. What needs to be done on urgent basis to recover from this? Kindly help me with all your suggestions. Thanks
Link Building | | sandeep.clickdesk0 -
Best Way to Filter Backlinks
When analyzing backlinks and trying to get the same one for another site there are a ton of backlinks to go through. I know that if the DA of the link is then pages on the site might be a good choice like adding an article or something of the sort to the site but as far a the same page goes you can typically only do this with a comment on the page. My question is, given a huge list of backlinks from multiple sites, is there an easy way to analyze the links and determine which ones I can copy without manually checking hundreds of links?
Link Building | | spyke010 -
Paying for listing rather than a link
Hi If you pay to have a website listed within a web page as it will be beneficial to have it there for both the business and website audience, is this considered a dangerous tactic? The link is relevant to the situation and its not being done simply for a link Thanks in advance
Link Building | | TheZenAgency0 -
Domain redirect math?
I’m thinking about buying the domain of a former competitor who is getting out of the business. His site has quite a few links, a healthy link profile from several hundred domains (a few common sites, but mostly different) and a Domain Authority of 44 (mine is a 55). His anchor text portfolio is very appropriate to my business, and the domain contains one of my most important keywords (one that’s in my own domain). His site ranks for a many of the same keywords as mine. Where mine is #3, his might be #4. I don’t want to operate his business (there’s a reason he’s getting out), but I was thinking that redirecting the domain to appropriate pages on mine would give a boost to the many long tail keywords which constitute a considerable part of my business. The question is how much of a boost? How much should I be willing to pay for his domain? If I get x visits/year from organic search and he gets y, and both sites rank for approximately the same terms, how much would you expect the two sites together get? Is there a rule of thumb for calculating this kind of thing involving some kind of logarithmic math? Does the combination of links of similar sites make 1+1=2, <2, or >2? Or is the only way to make this estimate to go through each of the major keywords trying to figure out what will happen to each? If, for instance, on average we combined our #3 & #4 rankings and got a #2 ranking, that would probably increase my clicks by 50% because of their higher SERP prominence. Based on my research, a visitor to my website is worth about $14. Assuming that his natural search visitors would be worth about the same amount if directed to my site, I would probably make 1/2 x * $14/year. I'm least comfortable with the first assumption. Is there a better way to evaluate this?
Link Building | | TREWS0 -
Domain Authority has a value of 1, why is this?
I am having trouble understanding why my Domain Authority has a value of 1. I have already made more than a hundred links to/from my website, though nothing seems to showing in this Link Analysis. I have attached an image. Also if it helps here is the domain name - http://davincidrivers.com/ Thanks in advanced for any help. Grazie, Maria Screen%20Shot%202012-02-14%20at%2010.03.34%20AM.png
Link Building | | MariaPerrone0 -
Blogging to add SEO value to site... recommendations
Hi Mozzers! A client has a high authority website in the travel industry, and needs any and all advantages to get ahead in very competitive keywords. The send out a newsletter bimonthly, but have no blog, so I recommended at the very least, they publish online their emailed newsletters to add informational and relevant content. The question is, for max SEO value, should they... create a blog as a subdomain or subfolder of their existing site? should they self host a blog with a separate domain? or should they simply use a blogger/wordpress.com free blog? Consider that just adding on a blog to their existing site isn't easy. It's some old CMS that's apparently a nightmare to deal with. Plus, branding a WP install to match the site isn't something they want to spend a lot of time on. Your insight is welcome and appreciated!
Link Building | | rosstaylor0 -
Page authority vs domain authority
when evaluating a website for a potential link request, do you focus more on page authority or domain authority? do you use them together? what about when the two numbers are very far apart?
Link Building | | slazarus0