Guys! During the YC Startup School I gradually started to implement different ideas to track primary metrics and I have involved my team to set OKR (Objectives and Key Results) and track their important metrics too. Eventually it has been structured on a dashboard using just google spreadsheets and formulas and charts. I'd like to share this framework with you and hope you'll find it helpful: https://docs.google.com/spreadsheets/d/1zKKajgd1YUom4oiALpxWA87eiJxllx_MCzx78_HFcwk/edit?usp=sharing Just make a copy of this spreadsheet and you'll be able to edit and play with numbers. What you can do with this spreadsheet stuffed with automatic formulas: * Choose your CWGR (Compound Weekly Growth Rate) and get your Point B after 10 weeks. * Weekly update your primary metric and see your weekly change (with color coding) + CWGR (an answer to investor's favourite question - "What's your growth rate?"). * Track your 10th week prediction given your current CWGR. Track your min, max range of weekly growth fluctuation. * Track your Point B threshold, ideal growth curve and current progress - all in one chart Another benefit is as a motivational system. If your employees hit their weekly target growth rate, they earn scores that turn into $$ depending on how many times they hit the target during the 4 week period. You will find details in comments to the specific cells. Also, I've programmed 2 calculators: : What CWGR do I need to get from A to B for N weeks? Calculator A : How long will it take to get from A to B given my CWGR? Calculator B I would appreciate your thoughts, feedback, critics and comments! * * * Telegram: @badgerhoneymoon Facebook: https://www.facebook.com/denis.burkatsky
