WordPress database error: [Incorrect file format 'wp_comments']
SELECT ID, COUNT( comment_ID ) AS ccount FROM wp_posts LEFT JOIN wp_comments ON ( comment_post_ID = ID AND comment_approved = '1') WHERE post_status = 'publish' AND ID IN (32) GROUP BY ID

Searching Amazon.com’s Long Tail | TicTap Blog
« Improved Recommendations
Amazon’s Random Long Tail Items »

Searching Amazon.com’s Long Tail

We have all heard of the long tail right?

I was captivated by the concept and wondered what hidden gems might be available if I could search the long tail.

The problem was, How do I search the long tail?

It wasn’t clear to me at all how I could do that at Amazon.com, and their web API doesn’t allow it either.

So we’ve gone about to build one.

There is now a little checkbox below the search box. It’s labeled ‘Search the long tail’. If you check it, TicTap will search for products with sales ranks of at least 100,000 that matches all and some of the keywords.

Why 100,000? It turns out that between 25-36% of Amazon’s sales occur within their long tail, which are (probably) products with sales ranks of at least 100,000.

For an example, try this long tail search on George Bush.

Tell us what you think about our long tail search, and how we can improve it.

Related Posts:
»Amazon’s Random Long Tail Items
»Amazon Sales Rank Tracker
»Listmania Search
»Related searches
»Images for TicTap Mobile

This entry was posted on Tuesday, August 23rd, 2005 at 2:15 am and is filed under General (talk). You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

WordPress database error: [Incorrect file format 'wp_comments']
SELECT * FROM wp_comments WHERE comment_post_ID = '32' AND comment_approved = '1' ORDER BY comment_date

Leave a Reply