Posts

Showing posts from May, 2014

It's a ZEN day!

Image
Today is a very special day for me as as an entrepreneur and investor. About an hour ago, Zendesk went public on the New York Stock Exchange. The last time I watched an IPO so carefully was when Shopping.com, the company that had bought my price comparison startup, went public – almost ten years ago . Here are a few visual impressions of my love affair with Zendesk, which began six years ago: Huge congrats and thanks to the entire Zendesk team – I couldn't be more proud of you guys!

Three more ways to look at cohort data

Image
I've just added three new charts to my Excel template for cohort analysis . The first one shows the MRR development of several customer cohorts over the cohorts' lifetime: Each of the green lines represents a customer cohort. The x-axis shows the "lifetime month", so the dot at the end of the line at the bottom right, for example, represents the MRR of the January 2013 customer cohort (all customers who converted in January 2013) in their 9th month after converting. Here are some of the things that you can see in this chart: The second chart is based on exactly the same data but shows MRR for calendar months as opposed to cohort lifetime months, and it uses a slightly different visualization: One of the things you can see here is the contribution of older cohorts to your current MRR (something to keep in mind if you're considering a price increase and are thinking about the impact of grandfathering ): The third chart shows cumulated revenues minus CACs for differe...