incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From S Ahmed <sahmed1...@gmail.com>
Subject Re: funnel analytics, how to query for reports etc.
Date Tue, 23 Jul 2013 16:00:35 GMT
Thanks Aaron.

Too bad Rainbird isn't open sourced yet!


On Tue, Jul 23, 2013 at 4:48 AM, aaron morton <aaron@thelastpickle.com>wrote:

> 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.prudnikov@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 <sahmed1020@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
>
>

Mime
View raw message