Jonathon Posted March 10, 2013 Share Posted March 10, 2013 Hi, I'm building a little demo site in Yii. I wanted to give sellers some stats back on their items. These are the things i'd come up with so far. I haven't identified how I'm going to manage updating them and retrieving them yet. Just what i'm going to collect viewed items table: - id - session_id - user_id (For users that are logged in, NULL otherwise) - item_id - time_started - time_ended Through this I thought I could give sellers information on: - how many views - how many unique views - average time viewing the item - Also I could in some way through the session_id find "related items" or a "people who viewed this item also viewed this item" That's as far as i've got. Feel free to add or comment on them. Link to comment Share on other sites More sharing options...
HartleySan Posted March 10, 2013 Share Posted March 10, 2013 Good question. Maybe sign up for an Amazon seller's account, and see what kind of info they offer. Also, while not directly related, using Google Analytics and the like may give you some additional insights. Link to comment Share on other sites More sharing options...
Jonathon Posted March 10, 2013 Author Share Posted March 10, 2013 Yeah, I thought about having a look at my analytics account. Thanks Link to comment Share on other sites More sharing options...
HartleySan Posted March 11, 2013 Share Posted March 11, 2013 I'm thinking that you should include more information about the item itself. For example, what kind of item is it, what are the dimensions, etc. That way, sellers might be able to determine what kinds of items make the most profit. Link to comment Share on other sites More sharing options...
Jonathon Posted March 11, 2013 Author Share Posted March 11, 2013 Thanks Jonathan, I can just use a join to get that information. So that wouldn't be too hard. Thanks Link to comment Share on other sites More sharing options...
Recommended Posts