homepage Welcome to WebmasterWorld Guest from 54.161.175.231
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Visit PubCon.com
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderators: physics

Databases Forum

    
How does Amazons "Customers Who Bought This Item Also Bought" work
saarah




msg:3604917
 5:25 am on Mar 19, 2008 (gmt 0)

Guys,

Just wanted a high level understanding of how the feature "Customers Who Bought "This Item" Also Bought" on amazon work:

1) Is this just a simple query that searches for orders that contain "This Item" - and return other items in those orders.
2) What if a customer bought "This Item" in one order and bought "Another Item" in a different order -- Is this "Another Item" also returned in this list.
3) The #2 makes me think that the query first searches for customers that bought "This Item" and then return other items that were purchased by those customers.
4) How are these results sorted?

I keep hearing that they have a special algorithm for this. So I'm just curious.

If anyone can share their insight into how this works - I would great appreciate it.

Thanks

 

LifeinAsia




msg:3605386
 3:53 pm on Mar 19, 2008 (gmt 0)

I have no inside knowledge of the actual algorithm. But I always assumed it was just a simple query of all the customers who bought that book, then aggregate all the book purchases by those customers. I doubt there is any specific filtering on purchases made at the same time.

saarah




msg:3606073
 4:55 am on Mar 20, 2008 (gmt 0)

Thanks for your reply. so according to you, they will find all customers who bought that book, then find other books that those customers bought and suggest it to the user.

It makes sense. So they are filtering the suggestions by category. For instance if another customer who bought that book and other books and also some other items, then you are only interested in the other books purchased by that user and discard the other items.

But I've also seen that when you are browsing for a TV - in that section of "customers who bought this also bought" - it will list other items like DVD players, home theater systems, remote controls and even cables - not just TV's.

Well if u think abt it - all those items do fall under the parent category of electronics - but not in the sub category of TV. But what is interesting to note is that all these items are related to a TV-they are not showing stuff like digital cameras or camcorders which also fall under the parent category of electronics.

Thanks for your opinion though.

LifeinAsia




msg:3606434
 3:49 pm on Mar 20, 2008 (gmt 0)

I'm sure they do some sort of category-based filtering. Or, unrelated items fall out just from "popularity" numbers. (For example, if 500 people bought that TV, and those 500 people colelctively bought 300 DVD players, 400 DVDs, 100 VCRs, and 1 Tivo, the Tivo probably wouldn't make the "also bought" list.)

whoisgregg




msg:3606450
 3:57 pm on Mar 20, 2008 (gmt 0)

category-based filtering

Not always. I recently bought a "Health & Personal Care" item that had a few books shown in the "customers also bought" section. The books shown were a perfect accompaniment, so I ended up buying one of them. :)

LifeinAsia




msg:3606585
 6:17 pm on Mar 20, 2008 (gmt 0)

OK, "related category-based filtering" :)

bateman_ap




msg:3606598
 6:36 pm on Mar 20, 2008 (gmt 0)

Collaborative filtering is prob what they are using
[en.wikipedia.org...]

whoisgregg




msg:3606700
 8:28 pm on Mar 20, 2008 (gmt 0)

Great link, thanks bateman_ap! :)

peterdaly




msg:3606706
 8:34 pm on Mar 20, 2008 (gmt 0)

Why do you need a category filter?

If the query is done based on items in an order, and not really everything a customer has ever purchased, the items will have a tendency to filter themselves, sometimes better than an algorithm could probably figure out.

I've done similar things myself. When the sample of data is large enough, the statistical trends can be quite accurate.

georgeek




msg:3606727
 8:51 pm on Mar 20, 2008 (gmt 0)

Greg Linden designed and developed the recommendation algorithm at Amazon.

Forget Wikipedia try Amazon.com Recommendations: Item-to-Item Collaborative Filtering, Greg Linden, Brent Smith, and Jeremy York [computer.org].

- George



saarah




msg:3607836
 4:49 am on Mar 22, 2008 (gmt 0)

Thanks for all your responses guys.

George - thanks for the link - thats very helpful information. Thanks for sharing.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved