Introducing: The One-Slide Update Deck

When we start to work with a new portfolio company, one of the things we always suggest is that in addition to (sometimes lots of) ad hoc communication via eMail, Skype, Basecamp, etc. we set up a standing meeting or call, at least during the first 9-12 months following our investment. Typically it's a one-hour monthly call, and the purpose of these calls is to get us updated and to talk through current issues. Our experience is that these calls are a very effective and efficient way to discuss things and to find out how we can help. The last thing we want to do is be a burden on the founders, and so we try to be very respectful of the their time (even if we're not as efficient as Oliver Samwer with his famous "supercalls" - 12 hours, 180 companies, or something like that).

Just like a regular Board Meeting, these monthly calls work best if the investors get an update before the call, so that the call can be spent discussing key challenges rather than spending too much time going through numbers and updates. And that brings me to the topic of this post: The One-Slide Update Deck.

Founders often ask me if I have a preferred format for updates and KPIs. And while I can point them to my SaaS metrics dashboard for KPIs, we've never had something like a template for other updates. So here's my attempt to create a super-simple deck which you can use to update your investors (or me!):

The idea is that in the beginning you create a rough roadmap for the next 12 months, broken down into key areas like Product & Tech, Sales & Marketing and Team/Hiring (see slide 1), plus a financial plan. Better yet, you already have a plan :-) and you discuss that with your investors to get everyone on the same page.

Then, every month you create one slide which shows progress and problems, as well as the original plan, in each of the three key areas, plus key metrics. I've borrowed the "Progress, plans, problems" technique from Seedcamp; the metrics are taken from my own SaaS dashboard template. So just one slide, once a month, with information you should already have anyway, and you should have a great basis for highly productive calls or meetings with your investors.

It obviously doesn't matter if you use Keynote, Google Docs or something else, and depending on the needs of your company you may want to emphasize different key areas or include other KPIs. So this isn't meant to be prescriptive but rather a suggestion or a starting point for founders who are thinking about reporting for the first time – if you are already providing more comprehensive monthly reports, don't change it!

If you want to take a closer look, here is a PDF and here is the original Keynote version.

Thanks to Nicolas, Rodrigo and Michael for providing valuable feedback on the draft of the slides!

A KPI dashboard for early-stage SaaS startups – new and improved!

[Update 01/17/2015: There's a new company called ChartMogul (which we invested in) which makes it easy to get a real-time dashboard similar to the template below. Check it out!]

[Note: This post first appeared as a guest post on the blog of Totango. In case you don't know Totango, it is a powerful analytics product which gives online services the information they need to increase user engagement, conversion and retention. If you're a SaaS company you should check it out. Thanks to Guy Nirpaz and his team for publishing my post, which I am republishing here.]

In talking to a pretty large number of SaaS entrepreneurs in the last few years I've observed that there's a considerable amount of uncertainty around metrics: Which KPIs are the most important ones, what's the right way to calculate churn, CACs, MRR and other key metrics, how can I estimate customer lifetime value – these and other questions come up all the time, and the answers aren’t always obvious.

I've tried to address some of these questions in a couple of blog posts:

• 9 Worst Practices in SaaS Metrics
• Excel template for cohort analyses in SaaS
• The 8th DO for SaaS startups - Stay on top of your KPIs

I also put together a template which I thought SaaS startups could find useful and which also makes it easier for us as a VC to communicate what KPIs we're looking for when we talk to SaaS entrepreneurs. Needless to say a template can only be a starting point, as every SaaS startup is different and needs to build its own, customized dashboard. Nonetheless it seems like the template, first published in April of this year, struck a chord with many SaaS founders and investors: The blog post got more than 60,000 page views (which I assume is quite a lot for a niche topic on a VC blog, at least if you’re not Fred Wilson :-) ) and I get requests for the Excel file every day.

In the meantime I’ve put some more work into the dashboard. You can download it here. (And if you like it, tweet it!)

Here’s how the charts look like with some sample data in it:

Click for a larger version

The main improvement of this version is that it now includes different pricing tiers and annual plans. This makes the spreadsheet considerably larger, but I feel it's necessary if you have multiple pricing tiers and contract lengths, and you can collapse a lot of the rows to get a concise view of the top KPIs.

I hope you find it useful! If you have any questions, comments or suggestions, please feel free to email me at christoph@pointninecap.com.

I'm selling my SaaS dashboard and all it costs is a tweet

My financial planning sheet for SaaS startups, my KPI dashboard for SaaS startups and my "9 Horror Worst Practices in SaaS Metrics" slides got a fair bit of popularity lately and two hundred or so people emailed me and requested one of the original Excel files.

That brought me to the idea of selling them. But fear not, I don't want your money, all I want is a tweet. Or a Facebook post. (And if you really want to get one of the files without tweeting, drop me an email and I'll send it to you, although I can't guarantee that it's not bad for your karma.)

So...here are the "pay with a tweet" links:

Financial planning

Dashboard

Worst Practices

A KPI dashboard for early-stage SaaS startups

[Update 12/20/2013: I have extended the dashboard to include multiple pricing tiers and annual subscription plans. Check it out here.]

[Update 01/17/2015: There's a new company called ChartMogul (which we invested in) which makes it easy to get a real-time dashboard similar to the template below. Check it out!]

Over the last few years I've helped quite a lot of SaaS startups to create or fine-tune their KPI dashboards. While every situation is a bit different there's also a lot of overlap, which made me think that it would make sense to publish my template (not without polishing it a bit). I hope other SaaS startups will find it useful, and it will also make it easier for us to communicate what KPIs we're looking for when we talk to SaaS entrepreneurs.

Not surprisingly the dashboard looks quite similar to the financial planning sheet that I've posted some time ago. Below are two Excel screenshots, and 

here is the Google Docs version.

If you prefer the Excel version, which looks a bit nicer, click here to download it. (And if you like it, tweet it!)

The sheet contains some notes on the right side. I was going to note a few additional things here but it's gotten really late here in Europe so I'll leave that for another day. If you find any bugs, let me know and I'll fix them tomorrow morning. :)

One comment, though. Although I've developed this sheet on my own, I've learned a lot about SaaS metrics from David Skok, who I am very thankful for. David created a SaaS dashboard as well, it's a bit more sophisticated and has a slightly different focus, but it's quite similar. Check it out, and if you have not read his brilliant articles about SaaS yet I highly recommend that you do so. They are an absolute must-read for every SaaS entrepreneur.

Like this post? Follow me on Twitter.