Creating A Business Metric Dashboard

I'm a big fan of business metrics dashboards.  A couple of months ago I put together a digital dashboard that is displayed on a large TV screen in the office. Screen Shot 2016-03-19 at 6.49.31 PM

The dashboard displays the following information:

  1. Weekly calendar and appointments;
  2. Daily amount billed by each firm member;
  3. Monthly amount billed by each firm member;
  4. Total amount of monthly billings;
  5. Google analytics data from firm website;
  6. Constant contact email marketing data;
  7. Time & weather.

Our firm uses Clio for our law practice management, including contacts, documents, billing, and time keeping. Because Clio has an API, you can access your data however you'd like. I'm not much of a programmer, though, so I use Zapier to pull data from Clio. Using Zapier, each time a firm user creates a time entry, that data goes to a private Google Spreadsheet:

Screen Shot 2016-03-19 at 6.47.42 PM

 

 

 

Once the data is in Google Sheets, you can display the information in a variety of ways on a dashboard.  I use Cyfe, which has dozens of "widgets" to connect to your data.

Here's a look at the current dashboard design:

Screen Shot 2016-03-19 at 6.38.59 PM