Cohort Analysis: The Ultimate Resource List
The original post was published here: Cohort Analysis: The Ultimate Resource List
I figured I'd share a version of it with the community here:
Introducing: The Ultimate List of Cohort Analysis Resources
- Chapter 1: Cohort Analysis for Newbies
- Chapter 2: How to Understand and Interpret Cohort Charts
- Chapter 3: FREE Templates to Create Your First Cohort Chart
- Chapter 4: Awesome Tools to Take Your Cohort Analysis Skills to the Next Level
- Chapter 5: How to Visualize Cohort Charts
- Chapter 6: How to Use SQL for Cohort Analysis
- Chapter 7: How to Use R for Cohort Analysis
- Chapter 8: Incredible Books & Resources About Cohort Analysis
Chapter 1: Cohort Analysis for Newbies
OK. So you have no idea what cohort charts are, or why they are important. Don’t worry, these resources will help you grasp the fundamentals.
- Cohort Analysis 101 | RJMetrics
- Cohort Analysis for Startups 101 | Nikos Kalliagkopoulos
- Churn 101: What is Cohort Analysis? | Framed.io
- Cohort Analysis: A (practical) Q&A | Christoph Janz
- The Ultimate Cohort Analysis Cheat Sheet | ChartMogul
- Cohort Analysis: Introduction | Custora U
- What exactly is cohort analysis? | Quora
Chapter 2: How to Understand and Interpret Cohort Charts
You’ve learned what cohort analysis is. Now it’s time to know how to get insights from those charts. Here are some fantastic resources for analyzing cohort charts.
- Use this spreadsheet for churn, MRR, and cohort analysis (Guest Post) | Andrew Chen
- Interpreting Cohort Data: The 3 Key Analyses For Measuring Your Startup’s Product Performance | Tomasz Tonguz
- | Youtube
Chapter 3: FREE Templates to Create Your First Cohort Chart
You’ve learned a lot about cohort analysis already. Now it’s time to create your first cohort chart. Here are some awesome cohort analysis templates by some of the best analytical minds on the planet.
- Cohort Analysis Spreadsheet | Christoph Janz
- 3 min Cohort Analysis Example | Daisy Deng
- Quick Cohort Analysis Template | GoSquared
- Sample Cohort Analysis for Ecommerce | LSVP
Chapter 4: Awesome Cohort Analysis Tools
If you’re looking for some sweet tools to give you deep insights on your cohort groups. Here is a collection of free and paid tools for you to try.
- Cohort Visualizer (Brett Slatkin) [FREE]
- Cohort Analysis Visualizer (Alejandro Rigatuso) [FREE]
- Google Analytics [FREE]
- Cohort.ly [BETA]
- RJMetrics [PAID]
- Mixpanel [PAID]
- KISSMetrics [PAID]
- ChartMogul [PAID]
- Datapine [PAID]
- What is the best web analytics tool for cohort analysis? | Quora
Chapter 5: How to Visualize Cohort Charts
A common question about cohort analysis is: What is the best way to visualize my cohort chart? Here you can find some fantastic resources on how to do just that.
- Retention, Cohorts, And Visualizations | Intercom
- | Michael Herman
- Making Phil Libin style cohort visualizations available to everyone | Airpair
- Fit Christoph Janz’s cohort analysis to your data in less than 5 minutes | Mode Analytics
- What are good ways to visualise a cohort analysis? | Quora
Chapter 6: How to Use SQL for Cohort Analysis
With SQL, you can create cohort analysis charts from the raw data on your database. Here are the best cohort analysis sql content ever published.
- Cohort Analysis: Data Sourcing With SQL | Michael Herman
- Performing Cohort Analysis Using MySQL> | Chartio
- How To Calculate Cohort Retention in SQL | Periscope
- SQL for Cohort Analysis: Activation Dates | David Tuite
- Deep dive into Mailchimp email data using MySQL | Ben Collins
Chapter 7: How to Use R for Cohort Analysis
Using R for cohort analysis is an incredibly powerful way to create and analyze cohort charts. Here are some excellent resources that dive deeper on the subject.
- Measuring user retention using cohort analysis with R | Ivan Kuznetsov
- Cohort Analysis For Startups: Six Summary Reports To Understand Your Customer Base (With Code) | Tomasz Tonguz
- Cohort analysis with R – Retention charts | Analyze Core
- Cohort analysis with R – “layer-cake graph” | Analyze Core
Chapter 8: Incredible Books About Cohort Analysis
You’ve learned a lot about cohort analysis, but there is still so much more great content out there. Here are some incredible books you should pick up to continue your learning.
Lean Analytics Book | Amazon
Learn SQL for Marketers: Run Cohort Analyses, Get... | Amazon
Age-Period-Cohort Analysis: New Models, Methods,... | Amazon
Cohort Analysis (Quantitative Applications in the... | Amazon
A Practical Guide to Age-Period Cohort Analysis... | Amazon
-
urvesh -
Thanks - 1 reply
{{ DiscussionBoard.errors[10247470].message }}-
fkalkhalidi -
Thanks
{{ DiscussionBoard.errors[10248381].message }} -
-