Simple Template For Tracking OKRs Weekly And Quarterly

Objectives and Key Results (or more commonly knowns as OKRs) are a well-defined way to codify a company's strategy along with tracking progress towards the intended results. John Doerr introduced OKRs at Google to great effect and has since written an insightful book called Measure What Matters that goes into the OKR framework and how it's successfully being used at various companies.

The OKR process can become overly complex rife with over analysing the data behind the numbers, poorly quantifying the key results and/or poorly communicating the ongoing impact they're having. I have seen many companies abandon the initiative part way through a quarter or even after a few quarters of failed attempts. 

I've distilled the OKR process for product engineering teams and the wider company down to a simple tracker that can be used on a weekly basis. Below I will explain the "team tracker" along with some examples, followed by how each team's OKRs come together into a simple view across the company that anyone can understand.

Team OKR Tracker

The team OKR tracker is the starting point for the manager of each team. OKRs don't have a mandated length of time but I find doing them on a quarterly cadence allows enough time to make the upfront planning worth the time invested while still allowing for regular points throughout the year where strategic initiatives can be adjusted. Here is what a fresh version of the template looks like prior to a team's manager populating it with objectives, key results, owners and their associated weekly progress tracking:

There are several parts of the above sheet template which are worth digging into further:

• Objective: This is what you want to accomplish. An objective should be aspirational, significant to the company, personally meaningful and ambitious. I'd recommend having no more than 5 but ideally 3 or less objectives per team (the old adage of less is more can't be said enough when setting objectives).

• Key Result: This is how you will track the achievement of the objective. Key results should be easily measurable and limited in number. This is how the company measures progress towards its objectives while remaining flexible on the exact tactics to implement.

• Owner: There should be a single owner for any given key result who is responsible for driving its success. In a product team this is often the CTO, Head of Product/Engineering/Design, Product Owner, Scrum Master, Tech Lead, etc.

• Weekly Percentage Tracking: Each week throughout the quarter the owners of the OKRs should get together to discuss the progress of each one based on the percentage in the spreadsheet. Similar to a daily standup within a product team, any blockers or impediments should be raised and decisions made to resolve them. 

• Final: This is simply the final result of each OKR at the end of the quarter. Note that sometimes it may take a week or two in order to determine the steady state of actual metrics associated with a given OKR (e.g. waiting for A/B test results for a feature deployed on the last day of the quarter).

• Forecast: This should be regularly discussed and re-forecasted if necessary to get an accurate picture of where the progress toward an OKR might end up at the end of a quarter. This is obviously hard to achieve with complete certainty but even when accounting for the usual margin of error, it's still a valuable way to indicate to everyone which OKRs are on track and which ones are struggling.

• Notes: Along with updating the weekly percentage of the OKRs, each owner can add a few notes about what is happening. This can be particularly valuable when a key result is not moving (aka still at 0%) but the team is making good progress with the build which will be deployed in the future and which will subsequently increase the key result pecentage.

• Averages: This is simply an average across all the OKRs for the team. If teams are aiming for the usual ~70% achievement rate (aka the OKRs taken together were ambitious but not impossible) this section highlights how the team is tracking on that overall goal.

Team OKR Tracker Examples

The team OKR tracker below has been populated with examples of potential objectives, key results, owners and associated weekly progress tracking for a fictional product engineering team:

Company "Roll Up" OKR Tracker

Each team within the company (e.g. Sales, Product, Marketing, People, etc) has their own OKR tracking sheet which is then "rolled up" into an overall high-level view. This view shows progress across the company against the previously-defined OKRs. It is able to give the executive team, the board and/or the rest of the company (via a monthly all hands meeting or weekly email) a simple view of which teams are doing well and which teams may need some additional help or resources in order to achieve their goals before the OKR period comes to an end.

Google Sheet Template

I've provided the OKR tracker as a Google Sheet which can be easily copied and used within your own company: https://docs.google.com/spreadsheets/d/1aEpVezdaaxrDv7hxex25ozS6QD_deP5cUcoKLn35aww

Interviewing Benedict Evans at Appear Here's Global Gathering

The Venue and Agenda

On January 24th, 2020 Appear Here held its Annual Global Gathering where we brought together world class investors, retailers, landlords and technologists for a day of insights, lessons and knowledge sharing:

My chat with Benedict Evans

I had the pleasure of hosting a fireside chat with the infamous Benedict Evans (formerly a Partner at a16z and now based in London). Benedict is widely considered to be a thought leader for the tech industry and his weekly newsletter frequently shapes the conversation around new tech developments, artificial intelligence, regulation, big tech companies, mobile and venture capital for a global audience. He has an avid following which includes 130k newsletter subscribers and 280k Twitter followers.

We covered a range of topics including high street retail, machine learning/data science and acquisition channels for brands. Below I've included the list of questions we worked our way through during the 30min conversation:

1. You've said. "Everything the Internet has done to media, it's now doing to retail", tell us more.

2. Do you think the high street is dying? Why or why not?

3. What does the future for the high street look like?

4. If it was up to you, in what ways would you like to see retail change or be disrupted by tech?

5. What role do you think machine learning/data science could play in retail?

6. We hear a lot about machine learning and data science, what are some useful ways to think about machine learning? (You've said, "Machine learning is the new database" tell us more)

7. As the cost of online advertising increases, how do marketers continue to grow their businesses?

8. Why do you think Amazon hasn't been as successful with offline retail as they are with online?

9. What do you make of the rise and fall of WeWork; what can we learn from it?

10. After working in SF and London, what differences do you see and what can we learn from them?

Benedict's "Standing on the Shoulders of Giants" Presentation from Davos

Just earlier that week, Benedict had been in Davos to present an annual presentation on tech trends. In a recent blog post he said "Every year, I produce a big presentation digging into macro and strategic trends in the tech industry. This year, ‘Standing on the shoulders of giants’ looks at what it means that 4bn people have a smartphone; we connected everyone, and now we wonder what the Next Big Thing is, but meanwhile, connecting everyone means we connected all the problems. Tech is becoming a regulated industry, but we don’t really know what that will mean." I've pulled out some notable slides from that presentation below that relate to the discussion we had at Appear Here's Global Gathering:

Benedict has clearly thought carefully about how technology is evolving and it was a pleasure to speak with him about those trends as they apply to retail, data science and startups.