search

analyst-collective / analytics

Open source data models and analysis.
Apache License 2.0
46 stars 11 forks source link

Mixpanel models #30

Closed 3mei closed 8 years ago

3mei commented 8 years ago

@jthandy Please take a look the models and the analysis. I want to make sure we are on the same page regarding the cohort data model as there are number of ways to implement cohort analysis, depending on the application.

3mei commented 8 years ago

@jthandy Added retention analysis to this. Please have a look.

3mei commented 8 years ago

@jthandy I updated the models as per our conversation.

3mei commented 8 years ago

@jthandy Added the cohort analysis for mixpanel.

drewbanin commented 8 years ago

@3mei not sure if this is still active, but we changed the way models work. There should be one model per file, and the name of the file (sans .sql) should be the model definition (as a select statement).

Check here for an example and let me know if you need any help!

jthandy commented 8 years ago

This PR began prior to the dagnabbit PR. We'll need to make corresponding adjustments here, agreed.

3mei commented 8 years ago

@jthandy mixpanel models updated to conform to the latest dbt.