Hi Guys,
I need to get user retention from Elasticsearch.
My algorithm is:
retention_period = 60 days
-
start_registrations_date = today - retention_period - 30 days
-
end_registrations_date = today -retention_period
-
Get all users born in start_registrations_date to end_registrations_date
-
user_lifeTime = (day that user was last seen) - (day that user
registered) -
Retention = ((#users with user_lifeTime > retention_period ) / #users)
- 100
I have registration event that looks something like this :
{
userId : "raz",
createDate : "10-10-2014T11:00:00"
}
.
.
.
And ping event that looks something like this:
{
userId : "raz",
createDate : "10-10-2014T13:00:00"
},
{
userId : "raz",
createDate : "10-10-2014T14:00:00"
}
.
.
.
Now to my question:
How do you recommend to achieve the retention using the aggregation
platform?
Is there away to aggregate users life time > some retention period in the
system?
I hope solving this issue will help someone here because calculating
retention/churn is a very common analytic.
Thanks,
Raz.
--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/49fd4b68-c454-4862-9e9e-f82183bc974d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.