Video guide 5 of 12 · Your data · 1:32
Entering KPI data in SimpleKPI
How the KPI Data sheet works: whose figures you're entering, which periods you see, notes, and spreadsheets in and out.
What this guide shows
- Pick a person at the top to enter figures on their sheet. They save as you go.
- Use the multi period view to catch up on several months, or the single period view for one month against target.
- Filter by category to see only the KPIs you need.
- Add a note to a figure that needs explaining. It stays with the figure.
- Upload figures from a spreadsheet in the example layout, or export your sheet to Excel.
Transcript
What's said in the video, by chapter. Press a time to play from there.
Where your figures go in
KPI Data is where your figures go in. Here's how to make it a two minute job. We'll choose whose sheet you're on, pick the periods you need, add notes, and bring figures in from a spreadsheet.
Whose sheet
Everyone sees the KPIs assigned to them. If you look after a team, pick a person at the top, and you're on their sheet. Here's Simon's, with just the figures he enters. Type them in for him, and they save as you go.
Which periods
Now the periods. The multi period view shows months side by side, good for catching up. The single period view shows one month, every KPI down the page, with how it's doing against target and its trend. Step back or forward a period, or pick a date. And filter by category to see just the KPIs you need.
Notes
When a figure needs explaining, add a note. Net profit dipped in July, so say why. The note stays with the figure, so whoever reads it later knows the story.
Upload and export
Already keep your figures in Excel? Under More Options, upload a spreadsheet. Download the example to see the layout it expects, fill it in, and choose your file. You can export to Excel too, for a copy of your sheet.