Here's two good, free tools that will take a list of keywords that you're trying to rank for and find out where you stand in the SERPs.

1. Rank Tracker Firefox Plugin
   Part of the SEO for Firefox suite from SEO Book, just load up your domain + your keywords and fire away.
   
   
   http://www.seobook.com/download-your-free-seo-tools
   
   
2. Rank Tracker from SEO Spyglass
   I

...

Jack Duncan recently released an application which mines Google Trends that unfortunately sold out quickly. Looking over some of his earlier material, I found this nice gem for searching Amazon wish lists:



This is a nice way to finding out the hot products in your niche.
-------
2 more amazon search tips
1.Find bestsellers in amazon in a price range.
...

[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...

A great way to get links is to actually find where other webmasters are going to drop links. Everyone's favorite tool seems to be Yahoo Site Explorer, especially since Yahoo seems to do a much better job than Google in recording backlinks. I came across a site that had thousands of backlinks today and wanted to share a good way of using Excel to get a usable backlink picture.

1. In your web explorations you might come across someone who looks to be doing some aggressive linkbuilding....

One of the roadblocks in automating videos is the large file sizes: when using Magic Submitter to get video out into our distribution channels, Alex has put wait times into the automation process for video sites. This makes sure that you've given enough time for the upload to complete before moving onto the next automation step. But to be honest, it's still the roughest part of the program so far.

• It's missing sites. Here's a few that have been requested:
http://ecorptv.com...