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 (50) GROUP BY ID

Amazon Sales Rank History and Trend | TicTap Blog
« Adding TicTap To A9.com’s OpenSearch
Yahoo Mail Slowdown - Possible Fix »

Amazon Sales Rank History and Trend

We received a suggestion today to improve our Amazon Sales Rank History feature.

The gentleman by the name of Barry suggested that we include some kind of trend feature to complement the history. This will make it easier to see how well (or badly) a product is selling at a glance.

We thought it was a great idea and implemented it. The sales trend is a moving average of the sales ranks from the last 5 days.

****** UPDATE - 14 Nov 2005******

We now present sales trends in 3 ways.

1) Best fit line based on the least square method.
2) 7-day moving average,
3) 30-day moving average. The 30 days MA may not appear unless more than 30 days of data is present.

You can see in it action here.

Related Posts:
»Amazon Sales Rank Tracker
»Attention Authors & Sellers! Track Prices and Sales Rank with 109things.
»Search History Limit Upped!
»Improved search history
»Search history archive

This entry was posted on Friday, November 11th, 2005 at 5:00 pm 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 = '50' AND comment_approved = '1' ORDER BY comment_date

Leave a Reply