Tools & Techniques To Automate Your SEO Empire.
[Excel How To:] Get Usable Data from Yahoo Site Explorer - Part 2
Posted 11th June 2010 at 05:10 PM by ThousandDollarDays
[This is Part 2 - for the 1st half please read Yahoo Site Explorer - Part 1]
Note that in the screenshot I've also pointed out the Remove Duplicates function. Now that we have our domains in a separate column we can choose to only have 1 row shown for each domain. This is basically because we only want to test out the viability of each domain for backlinking and only need 1 link for each domain to do this.
4. An extra thing you can do is to get rid of the rows that have country domains you're not interested in. We do this by referencing our B column (our domain column) with a function to get only the last three letters of the domain name:
Now we can sort by column C and all the domains that we don't want to look at will be grouped together - just select the rows and hit Ctrl and the - key to get rid of them:
So that's basically it ... in this particular example, we've gone from 912 links to 92 ... just put those in some kind of link checker and you can quickly weed out those that give you 404 errors, and the rest you can explore to add your own backlinks. Hope that helps!
-------
Roll you own Senuke with Magic Submitter! Get my Magic Submitter Bonus - free video training for Magic Submitter along with a custom SEO automation plan - when you sign up at MagicSubmitterVideos.com.
Note that in the screenshot I've also pointed out the Remove Duplicates function. Now that we have our domains in a separate column we can choose to only have 1 row shown for each domain. This is basically because we only want to test out the viability of each domain for backlinking and only need 1 link for each domain to do this.
4. An extra thing you can do is to get rid of the rows that have country domains you're not interested in. We do this by referencing our B column (our domain column) with a function to get only the last three letters of the domain name:
Now we can sort by column C and all the domains that we don't want to look at will be grouped together - just select the rows and hit Ctrl and the - key to get rid of them:
So that's basically it ... in this particular example, we've gone from 912 links to 92 ... just put those in some kind of link checker and you can quickly weed out those that give you 404 errors, and the rest you can explore to add your own backlinks. Hope that helps!
-------
Roll you own Senuke with Magic Submitter! Get my Magic Submitter Bonus - free video training for Magic Submitter along with a custom SEO automation plan - when you sign up at MagicSubmitterVideos.com.
Total Comments 0