You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by S Ahmed <sa...@gmail.com> on 2013/07/21 01:05:51 UTC
funnel analytics, how to query for reports etc.
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.
Re: funnel analytics, how to query for reports etc.
Posted by aaron morton <aa...@thelastpickle.com>.
> Too bad Rainbird isn't open sourced yet!
It's been 2 years, I would not hold your breath.
Remembered there are two time series open source projects out there
https://github.com/deanhiller/databus
https://github.com/Pardot/Rhombus
Cheers
-----------------
Aaron Morton
Cassandra Consultant
New Zealand
@aaronmorton
http://www.thelastpickle.com
On 24/07/2013, at 4:00 AM, S Ahmed <sa...@gmail.com> wrote:
> Thanks Aaron.
>
> Too bad Rainbird isn't open sourced yet!
>
>
> On Tue, Jul 23, 2013 at 4:48 AM, aaron morton <aa...@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....@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 <sa...@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
>
>
Re: funnel analytics, how to query for reports etc.
Posted by S Ahmed <sa...@gmail.com>.
Thanks Aaron.
Too bad Rainbird isn't open sourced yet!
On Tue, Jul 23, 2013 at 4:48 AM, aaron morton <aa...@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....@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 <sa...@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
>
>
Re: funnel analytics, how to query for reports etc.
Posted by aaron morton <aa...@thelastpickle.com>.
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....@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 <sa...@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
Re: funnel analytics, how to query for reports etc.
Posted by Vladimir Prudnikov <v....@gmail.com>.
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 <sa...@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