Yes.
OKR PPP and KPI Google Sheet Tracker
Free
Free OKR example template spreadsheet in Google Sheets for up to a 20 member team to manage their OKR, PPP and KPIs. A rough guide to use it and some tips which might help.
- Improve team communication
- Google Sheet
- Utilise best practice
- Did I mention it is free?
5060
happy users
testimonials
A Few People Like You Recommend You Check This Out
If you like it too, send me an email so I can feature you here too, please!
Tino Dietrich
Andrew Gregory
Ching-Tse Tseng
Guilherme Lameira Oliveira
Jeremiah Jusuf
Mehul Mandalia
Mukesh Bubna
Nurafni Eka Agustina
Rinchen Pakhrin
What
What is an OKR, PPP, KPI Tracker!?
The best way to plan and track your startup is with OKRs, PPPs and KPIs. Yes, those are a lot of acronyms! Don’t worry- I wrote a huge supporting blog you can learn from.
But let’s cover the three terms quickly:
- OKR: The system made famous first by Intel and made known by Google gets all staff to outline their major objectives and the quantifiable actions (i.e. key results) it’ll take to achieve them. This is a technique designed for accountability which is enforced with scores (Which we won’t do).
- KPI: Key Performance Indicators. They tell you how you’re doing with numbers. Or more specifically, they tell you if your startup is going to hit its targets and not go bust.
- PPP: Progress, Plans and Problems. It’s a really simple system used by startups large and small (From Skype to Seedcamp) to facilitate fantastic communication regarding what people are working on. Your daily startup standup is the same structure as your weekly PPP. What you did, what you’re going to do and where you have issues the team needs to help with.
There are fancy tools to manage these and more complicated systems, but this is designed to get you 80% of the benefit AND to be simple enough that staff will actually use this!
What I did was study OKRs, and what other useful tools startups use, simplify them, and put them into a Google Sheet that’s easy to use. And to make it more cool, I designed a way to automatically send updates from the sheet to managers each week!
who
Who Needs an OKR PPP KPI Tracker?
Everyone in startup-related land needs to know about this topic. So whether you are 3 founders, or hitting 20 staff, pay attention
Details
What Does the Tool Look Like?
Here are a few images to have a little gander at for your viewing pleasure.
Need
Why Do You Need an OKR PPP KPI Tracker?
-
1
Small Startups Don’t Have an Easy to Use Tool
- There are paid SaaS around, but well, they cost $!
- The tools get feature bloat to justify higher fees
- Small startups need something simple
-
2
Staff Hate Reporting, So Make it Easy
- You need to create some reporting structure, but the thing is most staff hate doing so!
- As you are growing, communication between staff and teams becomes all the more important
- Rather than annoy them, let them do their planning and updates with a simple tool that they can do when they are good and ready!
-
3
Things Fall Through the Cracks
- Especially in a work remotely world, constant communication becomes all the more important
- Staff crave clarity on their role- be it what their targets are, KPIs their performance is judged against, and to report to their manager
- More than this though, staff need to know their work is contributing to the startup’s success. Are the objectives they set contributing to delivering results?
Track Staff
See what happens round by round
- 1-20 staff
- Add or remove by simply typing a name
- Each member has a dedicated row section
Automated Email Reporting
Managers receive a weekly summary automatically
- 1-5 managers
- Easily add or remove a manager by simply writing in an email
- Automated email
OKR and KPI
Both OKR and KPI are on one sheet
- 5 Objectives and 5 Key Results
- Up to 10 KPI
- Weekly columns
- Managed in quarters (with summary column)
- One year in a sheet
4
PPP
Dedicated sheet for PPP
- Dedicated rows per person
- 1 row per P
- Reminder if not completed
- Mapped weekly
- 52 weeks
5
Secure
No security concerns!
- Save the file to your Google Drive
- Emails sent through your account
- Secure (I can’t access)
Need
Why is My Tool Worth Getting
-
1
I Make Cool Things (and am capable)
- There is a lot of blah around by people who aren’t terribly good at Excel/PowerPoint etc
- You’ll see the attention to detail and actual thought put into what I gift you (so you aren’t wasting your time)
-
2
My Free Tools Are Better Than What Some Charge For
- I only made tools because I couldn’t find anything I would use myself
- Even if you don’t ‘actually need the tool’, the point is to teach you concepts you can apply
-
3
I Don’t Have a Hardcore Marketing Funnel
- I make tools to actually help founders
- You aren’t going to be hounded with emails to get you to buy things
- Whilst I do sell some stuff, seeing the quality I give for free is way better marketing than using fancy words to convince you
video time
Watch a Video On the Tool
People like videos, so when I can (face it), I make some.
Congrats, there’s one to take you through the tracking tool!
read more
Read the Full Blog
This is a pretty page I have made, so downloading tools is cleaner and simpler for you. I’ve moved blog details to blog(s). If you would like to read more, click on!
Pro OKR PPP KPI Tracker Tool
Google is famous for setting OKRs. This is a ridiculously simple Google Sheet your staff will actually use. You can set it up so that you automatically get an email sent weekly with all the updates to keep on top of everyone. Plan your quarterly OKR and KPI in one easy to use sheet with no fancy stuff. Easily manage updates on what the team is doing every week and what they are stuck on through PPPs.
Learn more
SaaS Financial Model
SaaS startup with monthly and annual contracts. Self-onboard and sales supported customers. Think Buffer, Zapier, Hubspot, or Xero. Cohort model with all the capability you expect including expansion revenue, churn and full marketing funnel.
Learn moreAccess
Get the OKR PPP KPI Tracker Tool For Free
Fill in your details and it will be emailed to you.
I’m not sketchy, so here is everything you need to know just in case!
- It is automatically emailed to you!
- I’ll send you some emails about startup/investing after
- You can unsubscribe whenever you want
- Your data is never sold! I’m not organised to even do that lol
- You agree to all T&C legal stuff (to cover my ass)
FAQs
Check the FAQs if you are having issues. Don’t message me if “I can’t download the file”.
Is this free?
How do I download?
Fill in your name and email in the submission form and it will be emailed to you.
I didn't receive the email?
My (automated) system works. You’ve made a basic mistake.
- Check you input your email accurately
- Check your spam folder (Whitelist me if you found the email in spam)
Can I get consulting to use the file?
Yes. You can book a consulting call here:
I have feedback to improve
How do I open the file?
When you press download in an email from me, it normally saves to your Downloads folder.
So go there first to find the file.
I normally have to ZIP the file so it will work with SaaS automation systems.
So get WinZip, WinRAR, or use whatever Mac/PC offers these days. Unzip the file (Right click and press “uncompress” etc). If you don’t know how to do this, then use Google.
Once you uncompress, the ZIP file will remain, and you will see a new file (sort the download folder by date modified if confused).
I assure you that everything I provide works, so if you can’t access it, it’s a ‘you’ problem.
Can I sell / share your tools?
No.
You can share a link to this page, which would be much appreciated!
Can I share your tools on social media?
Please share the link to this page. It would be super-appreciated, but only if you like it!
If you don’t like it, then leave a comment or shoot me an email first so I can take your feedback on board first and see if I can improve!
Reading
Looking For Some Recommended Reading?
Here are some blogs you can check out related to this topic:
Comments (0)
There are no comments yet :(