Hi Guys, I need to get user retention from Elasticsearch. My algorithm is:
retention_period = 60 days 1. start_registrations_date = today - retention_period - 30 days 2. end_registrations_date = today -retention_period 3. Get all users born in start_registrations_date to end_registrations_date 4. user_lifeTime = (day that user was last seen) - (day that user registered) 5. 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+unsubscr...@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.