Google Spreadsheets for KPI Dashboards

My main project this week has been redoing the tracking of our key performance indicators (KPIs) so that they are centralized in a shared Google Spreadsheet with automatic color coding to indicate where we are in relation to our goals. We’ve been monitoring KPIs for years but never had a system that was as transparent and simple as I would have liked. With that said, our existing One Page Strategic Plan does contain our goals for the current quarter, current year, and next three years in a readily digestible format.

Google Spreadsheets proved to be a logical choice as the framework for tracking our KPIs on a weekly basis due to its flexibility with conditional formatting as well as its team collaboration functionality. The spreadsheet has the following three tabs and content:

Data

  • Department in column one
  • KPI categories in column two
  • Columns three and beyond each represent a week, with the current week in column three
  • Each row with the KPIs has a corresponding row beneath it with the calculated percent of goal in a color coded cell (based on percentages outlined in a previous post)

Goals

  • Similar to the Data tab with departments in column one and KPI categories in column two
  • Columns three and beyond each represent the goal for that KPI in a specific quarter, with column three always being the current quarter

Explanation

  • Columns one and two are the same as in the previous tabs
  • Column three has a paragraph explanation of the KPI and why we track it

I’m excited about tracking our KPIs in this new dashboard format and seeing how it helps us focus on areas where we can improve our business. Please let me know how your organization implements KPI dashboards and any ideas for improvement of ours.

24 thoughts on “Google Spreadsheets for KPI Dashboards

  1. Neat idea. So, what do these spreadsheets look like (feel free to blue or sanitize)? We do a lot of dashboard-type work, and we are always looking at the design of them. It’s not just the numbers, though they are obviously the most important thing. Their effectiveness is also heavily tied to whether the numbers, charts, etc. are easily and quickly understood.

  2. Way cool, David! I tried downloading your spreadsheet template, but it links to an empty search. I would love to see what you’re talking about and try it out on my side.

  3. Wow – just saw the date listed on this original post. This was just linked to via Twitter account and I assumed it was more recent.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s