For background on rollup analytics: Twitter Rainbird http://www.slideshare.net/kevinweil/rainbird-realtime-analytics-at-twitter-strata-2011 Acunu http://www.acunu.com/
Cheers ----------------- Aaron Morton Cassandra Consultant New Zealand @aaronmorton http://www.thelastpickle.com On 22/07/2013, at 1:03 AM, Vladimir Prudnikov <v.prudni...@gmail.com> wrote: > This can be done easily, > > Use normal column family to store the sequence of events where key is session > #ID identifying one use interaction with a website, column names are TimeUUID > values and column value id of the event (do not write something like "user > added product to shopping cart", something shorter identifying this event). > > Then you can use counter column family to store counters, you can count > anything, number of sessions, total number of events, number of particular > events etc. One row per day for example. Then you can retrieve this row and > calculate all required %. > > > On Sun, Jul 21, 2013 at 1:05 AM, S Ahmed <sahmed1...@gmail.com> wrote: > Would cassandra be a good choice for creating a funnel analytics type product > similar to mixpanel? > > e.g. You create a set of events and store them in cassandra for things like: > > event#1 user visited product page > event#2 user added product to shopping cart > event#3 user clicked on checkout page > event#4 user filled out cc information > event#5 user purchased product > > Now in my web application I track each user and store the events somehow in > cassandra (in some column family etc) > > Now how will I pull a report that produces results like: > > 70% of people added to shopping cart > 20% checkout page > 10% filled out cc information > 4% purchased the product > > > And this is for a Saas, so this report would be for thousands of customers in > theory. > > > > -- > Vladimir Prudnikov