Video guide 2 of 12 · Your KPIs · 2:12
Setting up a KPI in SimpleKPI
What each setting on a KPI does, from how often it's updated to the thresholds that color it red, amber or green.
What this guide shows
- Choose how often a KPI is updated, from daily to yearly, and its format: a number, a percentage, a currency or a length of time.
- Set the frequency before you add figures. Once a KPI has data it can't be changed.
- Add a target, say whether up or down is best, and set the RAG thresholds.
- Choose whether it adds up as a sum or an average, and the working week for a daily KPI.
- Group your KPIs into categories as the list grows.
Transcript
What's said in the video, by chapter. Press a time to play from there.
What a KPI holds
Every KPI has a few settings that decide how it's measured, colored and added up. Here's what each one does. We'll look at how often it's updated and its format, its target and colors, how it adds up, and where it lives.
Updates and format
Open any KPI with its edit button. First, how often it's updated: daily, weekly, monthly, quarterly or yearly. Choose the rhythm your figures really arrive in. Once a KPI has data, this can't be changed. Next, its format: a whole number, a percentage, a currency, or a length of time, like days or weeks. It's how every figure is shown, on the data sheet, on charts and in reports.
Targets and colors
Now the target. Add one, and every figure is measured against it. Under More Options, say which direction is best. For revenue, up is good. Then set your RAG thresholds: the figures that decide when a result shows red, amber or green. Those are the colors you'll see across the app, so set them to what really counts as on track. For something like accounts receivable days, fewer is better. Choose down, and the colors turn round with it.
How it adds up
How should a KPI add up over time? Revenue is a sum: twelve months make a year. A margin is an average, so choose Average, and a year shows the typical month, not a total that means nothing. For a daily KPI, choose your working week: the days your team enters figures.
Categories
As your list grows, group your KPIs. Press Manage on the KPIs page, and add your categories: finance, sales and operations. Then tick the KPIs that belong together, and move them in. A new KPI goes into whichever category is selected.