4 ms·
This was a super interesting article, Tom. The two graphs you have really tell a clear story, and I really enjoyed how you laid out different strategies for di
by wdewind 12y ago
This was a super interesting article, Tom. The two graphs you have really tell a clear story, and I really enjoyed how you laid out different strategies for different market types. This makes it very obvious what customer acquisition levers you're talking about, as well as what happens when you pull on them. I've been very impressed with your writing, between stuff like this and the Grouper Rails Missing Parts series. Please keep it up!
- TheCowboy 12y agoI really enjoyed this piece as well. The two graphs are exceptional in providing clarity. I'd be interested in knowing what he used to create these graphs, and if they have a special name.
- tomblomfield 12y agoThanks for reading. It's a form of cohort analysis, and I've heard the graphs called "Cohort Revenue". It's pretty simple to construct - you can download the Excel file I used at http://www.filedropper.com/churn http://www.filedropper.com/churn
- thibaut_barrere 12y agoI really love this chart as well because it seems to convey the evolution quite naturally - I will implement a version for my payment provider. Thanks for sharing! EDIT: I downloaded the cohort data for my SaaS from Recurly and injected all this into a google spreadsheets. With maybe 10 minutes of work I had my data, and it's pretty good. Thanks again :-)
- mwetzler 12y agoIt's called a "stacked area chart" and you can make them with something as simple as keynote, excel, google charts, etc. I just made our cohort graph yesterday in keynote, based on data exported from Stripe. The input for the graph is a very simple table. One row for each cohort (or colored bar in the graph), and one column for each month in your timeline. In the cells you simply put the amount of revenue you earned from customers in each cohort in that month.