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
-
Backlinks from ads on parked domains? Is this possible?
Hello Moz Friends, So as I was researching some competitive backlinks and I noticed a lot of backlinks that a clients competitor has are on parked domains and they appear to be google ads from some point. You know the pages that this page no longer exists, or hey do you want to buy this domain? and it has like 6 google ads on it? Yep those pages. My clients industry is construction and their competitor has links from zombie websites, foreign, websites and more. But the links are no longer on the page. Like when it was crawled, their ad was showing. Does this make any sense and is it usually temporary? Thank you for your thoughts friends!
Link Building | | asbchris0 -
Best way to filter out the nofollowed links from WMT?
When I'm downloading links from WMT to audit them for my unnatural links clients I generally check each individual link. If it is a nofollowed link I make a note that it is nofollowed and move on. I'm thinking that there has to be a quicker way to find all of the nofollowed links so that I can filter them out from the beginning. How would I do that?
Link Building | | MarieHaynes1 -
Is it better to have a blog under your main website's domain or should the company's blog have its own domain?
Is it better to have a blog under your main website's domain or should the company's blog have its own domain? And if the blog is on its own domain, do links to the main site look good or bad to Google? Thanks! (And please feel free to add any other related advice you might have...)
Link Building | | Linda-Vassily0 -
Domain Question
Hello fellow SEOmozers! I'm trying to register a domain name that contains keywords for my business, however the .com is obviously taken (however its just a parked domain without a site) so I have an option to get either .co .us or .net I wanted to know if the domain extension makes any difference for the search engine or does having .com gives you an advantage over having .co .us or .net? Thanks for your input!!!
Link Building | | igor.pinchevskiy0 -
Footer Back Links Question "Site by built by"
Hi all I design and develop websites for clients within the UK. With each website I build, I always add a link to the footer of the website which links back to my website. I have always used the link anchor text "Site By Jump" but then decided to try to use the link anchor text to our benefit by changing the links across all of our portfolio of sites to be: "Graphic Design by Jump"
Link Building | | yousayjump
or
"Web Design by Jump" In the hope that this helped us rank better for those keyword phrases. Now something occurred to me the day. Most of the websites I build have no relevance to the content on our website. For example, I could build a website for Baby Food and add a backlink to our homepage which doesn't even mention the words "baby food". In some cases, the websites can have thousands of pages, each with this footer link appearing at the bottom of each page. My question is, could these backlinks potentially be seen as black hat or spam to a search engine? I.e. thousands of backlinks from websites that have no relevance in terms of content all linking back to my homepage? Thank you for reading and any advice would be greatly appreciated.0 -
Listings, paid profiles and directories
Hi, In the industry I am working in (education), we do have a lot of portals offering paid listings (for example profiles featuring a school, the courses you offer, sometimes with reviews etc). Almost all big competitors and big names normally do have these kind of listings. Besides from having to decide if these sites really bring the relevant conversions, I am wondering about their impact on SEO. An example for an offer:
Link Building | | ecnic
Our Top Picks listing is a 40 word listing and logo we put on any 30 pages of our web site, example.com for 12 months, for $595 US. You can choose the pages you want, or we can put you on all our [category] pages, or certain continents/countries you want to target. Now, I am wondering: Do I have to worry about my linking profile ? (All of sudden a bunch of links with the exact same anchortext and content embedding to our site?) Or can I just decide to go with a paid listing based on the link value the page offers me? Looking forward to reading what you think!
Nicole0 -
"Diverse" Links from same IP address worth the work?
Hi folks, This is my first posting, so please be nice with me 🙂 I have completed an all-new website (www.buy-hosting.net) , however the domain is bought and already exists since 2 years, but has no inbound links though. Now I start building links. I have some clients of my web design business, I could bring in links to my new site on their sites from different domains, some established and years old. However, they all are hosted at the same IP address. Is it a good idea for link diversity to post links on their site to my new one? I remember a thing, that only 1 link will be counted, originating from the same IP address. Is this worth the work of asking clients, posting links, etc.? Or is it even dangerous to my new site? Also, any other ideas about how to start link building are welcome. Is there a comprahensive list, something like a "startes guide with practical ideas" to link building? Thank you and kind regards
Link Building | | ie4mac0 -
Building Links to Exact Match Domains
What are the pros and cons having exact match domain and how can you create a brand name and build backlinks? Say we have a domain personalizedbirthdaygifts.com We are quite stuck with what anchor text we need to use and how do we vary it? I've heard that we have to stay away from using commercial keywords as anchor text heavily. We have to also use our brand name. And here we get stuck as we don't have a brand name. In this case Our brand name should be personalized birthday gifts but this is also commercial keyword. I have seen before similar websites droped from ranking because they have commercial keywords in their domain and most of their backlink anchor texts are commercial. If I had a website called twentyfive.com selling birthday gifts it would be a lot easier. But when you have a website personalizedbirthdaygifts.com and trying to rank for personalized birthday gifts and birthday gifts it's tough. OR isn't it? I hope I explained it well and didn't confuse anybody... Thanks
Link Building | | Jvalops0