Pareto Efficient

In search of pareto improvements

Posts Tagged ‘cj

COUPONGOOD Release Notes: 08/11/08

leave a comment »

As we gear up for our beta release and the start of the marketing kick (August 18th), we started digging into some of the coupon quality issues surrounding automatically scraped coupons displayed on the site.

We soon discovered some issues.  Two big ones were hurting coupon quality on the site:

  1. Linkshare re-uses ids for its coupons.
  2. Both Linkshare and CJ have occasional duplicate coupons with different ids.

We learned a valuable lesson: never trust the integrity of your data to an external data source, especially not one you are screen scraping!  We’ve spent the past few days re-architecting the way data is collected, stored and displayed in order to:

  1. Reduce or eliminate the possibility of redundant or duplicate coupons.
  2. Filter out all non-coupons (eg remove things like “Summer Clearance Sale!”).

Coupon Quality Controls

  • We added better grouped uniqueness checks to the db in order to eliminate duplicates.
  • Then, Tyson took one for the team and manually reviewed 3,254 coupons — making sure only the real coupons made it through to the site.
  • We’ll manually approve all coupons from now on to make sure the offers are actually coupons.

Site Performance

  • We added 13+ db indexes to improve site speed (should be 41%+ faster now).
  • Benchmarked the webservers to get an idea of the concurrent load we can handle — it all checks out.

Bug Fixes

  • Fixed the “new comment create” and “new comment view” bugs

Next up…

  1. New UI
  2. New About Us content
  3. General Categories for stores
  4. Other marketing goodies…

Written by thetyson

August 11, 2008 at 6:42 pm

Posted in

Tagged with , ,