4 ms·
Thanks for your reply. I should have been more specific. I am actually looking at the second scenario (existing dataset).
by pawangupta11 11y ago
Thanks for your reply. I should have been more specific.
I am actually looking at the second scenario (existing dataset).
- ac2u 11y agoThere are many tools and tech for doing this ranging from not powerful but simple, to the opposite. Below are just a few of these options. If by dataset you mean CSV, you can always do a basic cohort analysis via spreadsheet software like Excel or Google Spreadsheets. For a basic example, have a look at Daisy Deng's post on http://www.quora.com/Is-there-a-way-to-do-cohort-analysis-via-Excel-for-Shopify-websites http://www.quora.com/Is-there-a-way-to-do-cohort-analysis-vi... , which links to https://docs.google.com/spreadsheets/d/1lD98hOCcpjsmxUmhUq8KtAlumPROLL746PL4A00ge-o/edit#gid=0 https://docs.google.com/spreadsheets/d/1lD98hOCcpjsmxUmhUq8K... for a step by step guide. If your data is in an actual database you can export to CSV first. Of course, you could always do the cohort analysis using SQL as well. A third option for more advanced use cases is processing your dataset with R, which is powerful but takes some learning https://www.r-project.org/about.html https://www.r-project.org/about.html
- pawangupta11 11y agoThanks ac2u. I think I will prefer R over excel to be able to perform some advanced analysis. I wish there could be an easy option in mixpanel where we could pull some User Profiles (already on Mixpanel) and perform a Cohort Analysis on them.