n8 / cohort_me Goto Github PK

View Code? Open in Web Editor NEW

318.0 318.0 39.0 183 KB

Provides tools to Ruby and Rails developers to perform cohort analysis.

License: MIT License

Ruby 100.00%

cohort_me's People

Contributors

Stargazers

Watchers

cohort_me's Issues

wrong results for extra long intervals with mysql

steps to reproduce:

CohortMe.analyze(period: "months", ...)

produces:
419 users 100% 16% 17% 55% 0% 0% 0% 0% 0%

when there should be no 0% results.

The problem lies with TIMEDIFF. From http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_timediff

The result returned by TIMEDIFF() is limited to the range allowed for TIME values.

Not compatible with mongoid

I tried using this with my app that uses Mongoid and got the following error:

>> CohortMe.analyze(activation_class: Hackathon)
NoMethodError: private method `select' called for Hackathon:Class
    from /Users/theycallmeswift/.rvm/gems/ruby-1.9.3-p194/gems/cohort_me-0.0.1/lib/cohort_me.rb:34:in `analyze'
    from (irb):2
    from /Users/theycallmeswift/.rvm/gems/ruby-1.9.3-p194/gems/railties-3.2.12/lib/rails/commands/console.rb:47:in `start'
    from /Users/theycallmeswift/.rvm/gems/ruby-1.9.3-p194/gems/railties-3.2.12/lib/rails/commands/console.rb:8:in `start'
    from /Users/theycallmeswift/.rvm/gems/ruby-1.9.3-p194/gems/railties-3.2.12/lib/rails/commands.rb:41:in `<top (required)>'
    from script/rails:6:in `require'
    from script/rails:6:in `<main>'

Still working?

Hey Cohort Me Team,

Love the idea of this tool! Curious, is it still working? Or too outdated at this point for a more modern rails app? e.g. rails 5+

Thanks again for this useful idea!

Activations from same user counted multiple times in a cohort

CohortMe.analyze(period: 'months', activation_class: Transfer.unscoped) results in this query

SELECT DISTINCT transfers.user_id, transfers.created_at, cohort_date, FLOOR(extract(epoch from (transfers.created_at - cohort_date))/2592000) as periods_out FROM "transfers" JOIN (SELECT transfers.user_id, MIN(transfers.created_at) as cohort_date FROM "transfers" WHERE (created_at > '2014-04-18 11:31:53.062696') GROUP BY "transfers"."user_id") AS cohorts ON transfers.user_id = cohorts.user_id WHERE (created_at > '2014-04-18 11:31:53.062696')

If I make couple of transfers as a user in a cohort, then the count will increase by the number of transfers (activations) instead of just 1. That is, starting with this [2, 0, 0, 0, 0, 0, 0, 0, 0, 0] and then after multiple transfer by the same user results in [2, 0, 0, 0, 0, 0, 0, 0, 2, 0] instead of [2, 0, 0, 0, 0, 0, 0, 0, 1, 0].

I'm using Rails 4.2.1 and Postgresql 9.4.1. Please advice!

n8 / cohort_me Goto Github PK

cohort_me's People

Contributors

Stargazers

Watchers

Forkers

cohort_me's Issues

wrong results for extra long intervals with mysql

Not compatible with mongoid

Still working?

Activations from same user counted multiple times in a cohort

Recommend Projects

React

Vue.js

Typescript

TensorFlow

Django

Laravel

D3

Recommend Topics

javascript

web

server

Machine learning

Visualization

Game

Recommend Org

Facebook

Microsoft

Google

Alibaba

D3

Tencent