Dashboard Design For Metrics-savvy Software Companies

I have a confession to make: I’m something of a metrics junkie.  I have lost entire days of my life just staring at Google Analytics reports.  Metrics have always activated that same part of my brain that WoW did: ooh, a page view, ooh, a sale, ooh, if this had purple bars on it I’d pay $15 a month.  So I would flip from email to Analytics to e-junkie (the extremely appropriately named payment processor I use) to Analytics to… and end up accomplishing nothing of real importance.

Because although I’m a metrics junkie, I’m a smart metrics junkie.  And any smart metrics junkie can tell you that if your metrics aren’t giving you actionable insights to make decisions that matter to your business, well, you might as well go play WoW for all the good you’re doing.

That’s why, in one of my periodic bits of investing in the business, I built myself a dashboard.

Goals of the Dashboard

A dashboard is, simply, an easy to digest one-glance view on how your business is doing.  Mine is implemented in Rails and it is the page that greets me if I visit my site (password protected, naturally).  The purpose is threefold:

  1. Minimize the time it takes me to do common repetitive tasks.
  2. Show me information about my business at a glance, so that I don’t feel the need to log into my various other sources of info.
  3. Arrange for easy access to drilling down into important things for me.

Like all of my other software, it is a work in progress.  (Incidentally, some folks have offered to buy it when I have mentioned it previously.  I can’t sell it, since it is tied very tightly to my business needs and data available.  At all of ~200 lines of code, though, you can knock one for yourself out in an afternoon.)

Here’s a screengrab from it:

Some comments on what this shows:

Search box (“The Omnibox”): The Omnibox is my Swiss Army Knife support tool.  Given absolutely anything I know about a customer — from her name to email address to transaction number to a (hopefully unique) phrase she has used in her bingo card — it goes off and fetches her customer record.  This is a real timesaver because many of my customers don’t remember what email address they purchased the software under, told Google to obscure their email address (a misfeature in Checkout, if you ask me), purchased with their husband’s credit card, etc etc.  The Omnibox saves me from having to actually do work to find customer records about 80% of the time.  Search results are the same as…

Customer Entries (Latest First): The vagaries of the bingo business mean that I’m overwhelmingly more likely to get a support incident from you in your first 24 hours of use than at any other time.  Accordingly, as soon as I open the dashboard, the last 10 customers pop straight up so I don’t even have to search for them.  (This also serves as a quick visual health check and lets me see if a customer’s transaction didn’t go through.)  This illustrates a core principle of dashboards: do less work, get more done.  Ten keystrokes saved doesn’t sound like a lot until you’ve done it 200 times.

Customer Support Options:  You’ll note some customers have their names in green.  This means they are using the online version of Bingo Card Creator, rather than (or in addition to) the desktop version.  Previously I just made that green to satisfy my curiosity (it gives instant, accurate visual feedback that 70% of my sales come from the online version), but as I got a feel for customer support needs I decorated their records with a pair of hyperlinks.

“Ghost me”: This is the same link you get if you try the Forgot Password function in the online app — one click logs you in.  I right click it, select Chrome’s Private Browsing option (to avoid overwriting my cookie), and suddenly I’m you.  This lets me see exactly what a customer is seeing, so that I can diagnose problems easier, or in a pinch just do what they need done.

“Email password”: The same as the password recovery functionality on my site — mails them a link to let them in so that they can change their password.

Sales Counter: This is only on the page because otherwise I’d a) log into e-junkie to check and then b) start trying to guesstimate how much money I was going to make this month.  Both are bad habits.  Putting it front and center decreased my logins to e-junkie from several times per day to once a blue moon (only when I need to speak with them, which since they run a very tight ship is “Almost never”).

Edit Bingo Cards: Takes me into the original core of the Bingo Card Creator site: a CMS which makes, you guessed it, bingo cards.  This is where I approve work submitted by freelancers, make minor content edits to it, or create new bingo activities.  Again, instant access on the dashboard saves time.  (There are also a few affordances there, like AJAX approval so that all I have to do is mouseover a new card and click OK to approve it.  Do less work, get more done.)

Downloads Per Month: This shows a graph of how many PDFs have been downloaded from my site, on a monthly basis.  It is a quick one glance indicator of how effective my SEO is, from back when I didn’t have the user stats to look at.  I could probably demote it from the dashboard these days.  This information is public, by the way.

All-time Sales: Graph of sales by month.  I mostly use this to check on market seasonality, year over year increase (70%, ho), and whether I’m on pace to make my revenue goals.  This is also public.

A/B Test Results: If you’ve been around this blog much you probably know that I obsessively test and measure.  When I have a particular A/B test on the front burner of my mind it gets promoted to the top of the dashboard.  At the moment nothing I have running is super-critical so they’ve been placed a click away.  You can see some of my A/B test results here — I’m a big believer in code reuse so a portion of my test results are also used for the documentation for my A/B testing library.

E-junkie: Convenience link to my payment processor, where I used to log into a lot.  This should be demoted from the dashboard.

uISV email: The Google Apps for Domains email account I use.  (uISV stands for “Micro-independent software vendor” — i.e. like “small software company” with a more pretentious acronym.)

Logins Today / This Week: This is my “one glance health check” for the business.  I have a rough idea of what these numbers should be.  If they go down far below that, I have broken the login button and need to fix it immediately.  If they go high above that, it must be Halloween.  If they stay flat I might have broken the login button close to Halloween.

Vanity Stats: I keep these around just to satisfy my primal WoW player urges.  They have no particular relevance to my business, but they’re fun to quote to people.

You might think “conversion rate” is a really important number.  See, conversion rate for a channel or a creative or a landing page is a very important number.  Conversion rate for all of your visitors, on the other hand, is very, very sensitive to traffic mix.  Since customers arriving by AdWords always outconvert customers arriving by organic search in aggregate (which is an artifact of my SEO strategy and not to be worried about), a gyration in conversion rate is generally caused more by a change in prospect mix than a strong reaction to a change in my product.

Things Not Pictured

This dashboard can potentially display a few other types of information.  Thankfully, I don’t have an example to show you today.

Exceptions in payment processing: An exception happening in most places in my code is probably a misbehaving spider or a bug.  An exception happening in the callback for successful payments is a bug.  A very critical bug, because it often means that a customer loses access to the software they paid for.  If that happens, the computer sends me an email, my cell phone gets rung, and this whole page gets hidden under a stacktrace written in blaze orange until I hit the “I dealt with it” button.  (This obvious probably won’t happen if the whole site goes down — mon.itor.us watches that for me.)

Regular exceptions get written to my log files.  That is, candidly speaking, where data goes to die.

Bug of The Day: I have a confession to make: I’m not much of a test driven developer.  It is really, sincerely difficult to anticipate every corner case which could happen with customers trying all possible combinations of words and bingo card options.  This causes a huge portion of the user-visible bugs in BCC, and because the symptom is typically “It looks… ugly?”  (for a value of “ugly” not known at runtime) it is sort of hard to capture ahead of time in the predominant Rails testing frameworks.

That’s why I have a wee little daemon who periodically sanity checks all the print jobs people have run recently, looking for anything I’ve identified as the symptom of the Bug of the Day.  Currently, the Bug of the Day is that under certain circumstances the combination of a very long title and a bingo card with four to six short words in a certain box can cause the box to render across multiple pages, which is not desirable.  This is algorithmically checkable, but only in retrospect.

If the daemon detects that a particular print job caused one of the Bugs of the Day to pop up, it displays that fact in red, along with a link which copies the word list to my personal account so that I can reproduce the behavior and start trying to squash it.

This system also lets me sanity check upgrades to the site.  If I cause a regression in behavior, typically (squashed) Bugs of the Day will typically resurface, and my dashboard lights up like a Christmas tree.

What’s On Your Dashboard?

I love hearing implementation details from other businesses, and this is about as wonky as it gets.  What do you put on your dashboard?  Do you have any suggestions for things I should consider adding to mine?

No Responses to “Dashboard Design For Metrics-savvy Software Companies”

  1. Loïc d'Anterroches February 9, 2010 at 12:30 pm #

    In my particular case (code hosting) I have the same kind of data but I am graphing the evolution over time. This provides me with a compact and easy way to assess the situation. You could add sparklines to “ensure” your feeling about the figures on the left.

  2. Brian February 10, 2010 at 9:03 am #

    This is a concept I’m kind of obsessive over lately. I’ve had more fun with my last few side projects by building out the dashboard/admin for them than, in some cases, the actual site itself. It’s interesting to get a sneak peak at how others make them.

  3. Eric February 10, 2010 at 11:09 pm #

    Very cool… how does the bug of the day checking framework work? (How do you encode a bug? How does it check the rendering of the page?)

  4. Patrick February 10, 2010 at 11:21 pm #

    Eric, I’m considering OSSing it if I can figure out a decent way to package it for other people. At the moment it is so hilariously customized to my needs I don’t know if copy/pasting code would even help.

    Here’s what I do:

    1) Add a new method to my Bug of the Day class. The method takes a print job ID as an argument. The method can do arbitrarily complex ruby code to find out a bug. (In my case it usually renders the print job to a temp file, then inspects it. For example, if a bingo card renders across 2 pages, then the total count of pages in the PDF — easily discoverable — will not match the count of pages I expected. raise BugOfTheDayException “Uh oh!”)
    2) Fire a rake task periodically, which grabs an arbitrarily large sample of print jobs and creates Delayed::Jobs for calling BugOfTheDay#someMethod on them, with a low priority so that the site doesn’t block customers to do this.
    3) If the BugOfTheDay method completes without incident, yay. If it generates an exception or fails an assertion, it registers itself to a data store (currently, memcached because I’m lazy). That gets checked next time I open my dashboard.

  5. Nirav Mehta February 11, 2010 at 4:07 am #

    The moment I saw the title of this post in my RSS reader, I knew you had the same itch as I did! I use e-Junkie too (with Paypal for payment processing) and was really tired of tracking sales (and measuring against my targets). I also had no easy way to predict / forecast where my sales are going.

    I scratched my own itch too – and created Putler. Putler is a Paypal reporting, notification, monitoring and planning tool. It works across platforms and keeps track of your Paypal balance. Shows you a nice graph of it, shows the latest transactions, your month to date balance change and also daily average. Since I also wanted to track performance against targets, I added a simple target system as well.

    I plan to expand this and build it into a simple to use, yet powerful tool for web entrepreneurs like us. Putler is free right now and I invite you to take it for a spin (and give feedback)!

    BTW, your post inspired me (as I write this) to add some way create hooks for Putler. That way people can add their own magic to the tool. Configure the URL to send the data to, and then clicking a button could send transaction data to that URL. Will let you do password reset, refunds, and all sorts of other things!

    Cheers!

    :Nirav

  6. Anita Campbell February 13, 2010 at 12:24 pm #

    Patrick, Cool! What software did you build this in?

  7. Patrick February 13, 2010 at 9:53 pm #

    Anita, it is all Ruby on Rails and a bit of elbow grease.

  8. Eoin February 15, 2010 at 3:02 am #

    It’s a good concept that reminded me of one thing: spreading yourself too thin over lots of web probjects would never allow you to implement an admin dashboard for each of those. Rather, it’s better to keep hacking away at your one dear project (as long as it’s shown promising signs).

    Also, 3rd party applications can be tedious at best in dealing with this type of customer service. For example, I run phpBB3, and it’s a struggle each time to understand if a user is activated, how to find their account, how to activate them, how to manually reseet their password. It’s more satisfying when you can implement a dashboard entirely for your own custom application.

  9. Eoin February 22, 2010 at 5:53 am #

    I case across this post of “Admin Panels”. Not sure how they’re meant to integrate with a custom app, but here goes:
    http://www.ourtuts.com/34-outstanding-admin-panels-for-your-web-applications/

  10. Dan Gravell September 6, 2010 at 7:11 am #

    Patrick, how do you integrate e-junkie with Paypal purchases into your analytics? I’ve been looking at ways of integrating e-junkie, Paypal and Google Analytics. It’s rather tough, mainly down to the uncertainty of redirection to thank you pages. For example, at least with Paypal Standard, if the buyer is not registered with Paypal they won’t be automatically redirected to a thank you page after the sale.

    Maybe you don’t use GA for this?

    Maybe something whizzy with IPN?

  11. thebuyercodereview November 2, 2011 at 5:16 am #

    What i don’t realize is in reality how you’re now not really much more smartly-liked than you may be now. You are so intelligent. You recognize therefore significantly on the subject of this topic, produced me personally imagine it from numerous various angles. Its like women and men don’t seem to be involved until it is one thing to accomplish with Lady gaga! Your own stuffs excellent. All the time maintain it up!

  12. wide angle lenses December 3, 2011 at 2:04 am #

    Thank you, I’ve just been searching for info about this subject for ages and yours is the best I have came upon so far. But, what about the conclusion? Are you sure about the supply?|What i do not realize is in truth how you’re no longer really a lot more smartly-liked than you may be right now. You’re so intelligent.

Trackbacks/Pingbacks

  1. Listen to Dashboard Design For Metrics-savvy Software Companies - MicroISV on a Shoestring - Hear a Blog - February 9, 2010

    [...] http://www.kalzumeus.com/2010/02/09/dashboard-design-for-metrics-savvy-software-companies/ [...]

  2. Elsewhere, on April 9th - Once a nomad, always a nomad - April 9, 2010

    [...] Shared Dashboard Design For Metrics-savvy Software Companies: MicroISV on a Shoestring. [...]

Loading...
Grow your software business:
(1~2 emails a week.)