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
-
Does Yext Directory Listings Help with Links?
Question: Does Yext Directory Listings Help with Links? They have 53 directories and I am trying to find out if this service is going to help building our links?
Link Building | | Tim_Jacquet0 -
Keyword Domain URL structure
Hello all, We have a domain with one of the primary keyword within the domain itself (audisite) and reading through some of the topics, having a keyword within the domain itself seems to be not as significant as we had assumed. We currently have a URL strucuture ( http://audisite.co.uk/new-audi/a4 ) which we were thinking of modifying to something like audisite.co.uk/a4 based on the premise that the 'audi' keyword is already in the domain itself. Also in terms of URL optimization, which of these will be the most effective URL (if the content is exactly the same). Or is my whole approach incorrect to URL optimization fundamentally incorrect? /a4 /new-audi-a4 /new/audi-a4 /new-audi/a4 /new/audi/a4 I will be very grateful for any advice/suggestions/pointers. Thank you very much for your time.
Link Building | | nirpan0 -
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 -
Disavow links returning?
Morning Mozzers, Happy Presidents Day. We submitted a disavow file about 4 weeks ago and in GWT saw that our links went from ~20k to about ~1300. Now this was good as majority were dubious at best. What is strange is I logged into GWT today and see many of the links that appeared to be 'disavowed' are back in our profile. I do not have any messages from Goog. Has anyone else seen this? Any thoughts? Thanks in advance for you help.
Link Building | | okuma0 -
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 -
Removal of "bad" incoming links
I have had my site registered for a long time (since January 1995) and in that time we have built a good number of incoming links. We have a vendor database that we expose as a service to our visitors, which numbers around 5,500. These sites vary dramatically from low-end, Mom-and-Pop type web sites (some ugly in the extreme :)) to nationwide, established vendors. Back in the day, we had the basic tactic to request a link to our site if the vendor wanted to be listed in our vendor database. We stopped that practice years ago but still have many sites linking to us. The quality of some of these sites is very poor. I want to come up with a strategy for dealing with these. To that end, some questions: How "costly", from an SEO perspective, is a poor quality site that links to our site? What metric(s) should be used to assess the quality of sites linking to us? If possible, for the aforementioned metric is there a "bar" we might try to hit? For example, would it be useful to request removal of links where <metric>is less than x? What is x?</metric> Given that we have thousands to assess, is there any report I can create to identify these sites? Is it generally preferred to have vendors link simply to our home page or is it more effectice to have them link to particular pages on our site (each vendor can generally be associated with a "topic" on our site). In short, I am willing to go through this process if there is real value in it. Thanks. Mark
Link Building | | MarkWill0 -
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 -
Link value of :"
Very recently linkedin changed the way they link. The links in the profile are no longer "nofollow" the new links are like this: <a href="[/redirect?url=http%3A%2F%2Fwww%2Estramark%2Enl%2F&urlhash=dWm-](view-source:http://www.linkedin.com/redirect?url=http%3A%2F%2Fwww%2Estramark%2Enl%2F&urlhash=dWm-)" target="_blank" title="New window will open" name="overviewsite"> (http://www.linkedin.com/redirect?url=http://www.stramark.nl/&urlhash=dWm-) Question: What impact does this redirect have for the linkvalue of a link from linkedin. ( it is better than nofollow but what is the impact of this redirect? what actually happens and is the value? URL for the profile i mentioned it on. http://www.linkedin.com/in/blomwouter
Link Building | | Stramark1