OKR Template for Notion (Free)
Notion is one of the most popular tools for OKR tracking because its linked database system can represent the hierarchical relationship between objectives, key results, and the initiatives that move them — all connected through relation and rollup properties. When set up correctly, a Notion OKR workspace gives you real-time visibility into OKR progress without requiring manual updates or status meetings.
This template provides the complete Notion database structure with the property types, formula examples, and view configurations that make OKR tracking actually useful. It includes the Objectives database, the Key Results database, the Initiative tracking database, a weekly check-in workflow, and the quarterly review process. Copy the structure into your Notion workspace and customize property names and values to match your team's terminology.
Why OKR tracking fails — and how Notion fixes it
Most OKR implementations fail not because the team chose the wrong objectives but because the tracking system creates too much friction. Updating progress requires navigating to multiple locations, running manual calculations, or attending status meetings just to answer "where are we against the key result?" When updating is hard, it does not happen. When updates do not happen, the OKR system becomes decorative rather than functional.
Notion's linked databases solve this by making the OKR hierarchy automatic. Key Results relate to their parent Objective via a Relation property. The Objective's Progress field is a Rollup that averages the progress of all related Key Results. When a team member updates the Current value on a Key Result, the Objective progress updates automatically — no spreadsheet formulas, no manual aggregation, no status meeting required.
The second common OKR tracking failure is disconnecting the OKRs from the work. Teams set OKRs in Q1 planning and then execute their quarterly roadmap with no explicit connection between the sprint stories and the key results they are supposed to move. Notion allows you to add an Initiatives database that relates to Key Results — this creates the connection between the work being done (initiatives and tickets) and the outcomes being tracked (key results).
Template sections
5 sections covering the complete okrs workflow.
Objectives database structure
Create a Notion database named "Objectives" with these property types. The database stores one row per objective across all levels (company, team, and individual). Level is a Select property that filters views by scope. The Progress rollup is the automation that makes the whole system work.
Objectives database properties: - Name (Title): The objective statement — should be inspirational and direction-setting - Quarter (Select): Q1 2025, Q2 2025, Q3 2025, Q4 2025 - Level (Select): Company, Product, Engineering, Design, Marketing, Individual - Owner (Person): The person accountable for this objective - Status (Select with color): On Track (green), At Risk (yellow), Off Track (red), Achieved (blue), Abandoned (gray) - Progress (Rollup → from Key Results → Average of Progress %): Auto-calculated from key results - Key Results (Relation → Key Results database): Linked KRs - Notes (Text): Context and commentary for weekly check-ins
Tips
- Set the Status to auto-based on Progress using a Notion formula: if(prop("Progress") >= 70, "On Track", if(prop("Progress") >= 40, "At Risk", "Off Track")) — this removes the manual status update step
- Use Notion's filter to create a "My OKRs" view that shows only objectives where Owner = Current User — makes personal OKR review much faster
- The Level property enables a single database to serve all OKR levels — filter by Level for company, team, and individual views
Key results database structure
Create a linked database named "Key Results" with numeric tracking properties. Every key result must have a Target (the goal), a Current (the current value), and a Progress formula that calculates completion percentage. The Unit property handles different types of metrics: percentages, counts, dollar amounts, and custom units.
Key Results database properties: - Name (Title): The key result statement — measurable, specific, binary when possible - Objective (Relation → Objectives database): Parent objective - Unit (Select): % (percentage), # (count), $ (dollar), x (multiplier), Custom - Target (Number): The number that represents 100% achievement - Current (Number): Updated weekly — the actual current value - Baseline (Number): Starting value at the beginning of the quarter - Progress (Formula): if(prop("Target") == 0, 0, min(100, round((prop("Current") - prop("Baseline")) / (prop("Target") - prop("Baseline")) * 100))) - Owner (Person): Who is accountable for moving this KR - Last Updated (Date): When Current was last updated
Tips
- The Progress formula subtracts the Baseline before dividing by Target — this correctly handles key results where the baseline is not zero (e.g., improving retention from 25% to 35% should show 0% at quarter start, not 71%)
- Cap the formula at 100% with min(100, ...) — overachievement is good but should not skew the Objective rollup above 100%
- The Last Updated date tells you which KRs are going stale — create a filter view showing KRs not updated in the last 7 days to surface at-risk tracking
Database views and dashboard configuration
Configure views that serve different audiences: a board view for weekly team reviews grouped by status, a table view filtered by current quarter for detailed progress, and a gallery view for executive or board presentations that emphasizes progress bars.
Recommended Notion views: 1. "OKR Board" (Board view): Group by Status. Filter: Quarter = current quarter. Shows all objectives by status at a glance. Use in weekly team OKR reviews. 2. "Quarterly Table" (Table view): Filter by Quarter and Level. Columns: Name, Owner, Progress, Status, Key Results count. Sortable for prioritization discussions. 3. "My OKRs" (Table view): Filter: Owner = Current User. Helps individuals track their OKRs without seeing the whole company set. 4. "Company OKRs" (Gallery view): Filter: Level = Company. Each card shows objective name and progress bar. Good for all-hands or board presentations. 5. "At Risk" (Table view): Filter: Status = At Risk OR Off Track. Review this view at weekly OKR check-in to focus attention on lagging KRs.
Tips
- Create the views before sharing the template with the team — an empty database with no views is confusing and reduces adoption
- Pin the "OKR Board" view at the top of the Notion sidebar for quick access during team meetings
- The Gallery view with progress bars is surprisingly effective for executive presentations — visual progress is more digestible than a table of numbers in a 30-minute board meeting
Weekly check-in workflow
OKR progress only matters if it is updated consistently. The check-in workflow defines when updates happen, who is responsible, and what gets reviewed. The recommended cadence is weekly async updates (each KR owner updates the Current value by Monday noon) and a 30-minute weekly OKR review meeting that focuses on at-risk items only.
Weekly OKR check-in process: 1. EVERY MONDAY by 12pm: Each Key Result owner updates the "Current" value in Notion. No other action required — Progress and Objective rollup update automatically. 2. MONDAY 2pm (30 min): OKR check-in meeting. Review only the "At Risk" and "Off Track" views. For each item: what is the blocker, what help is needed, is the target still achievable? 3. Async update in Slack (#okr-updates): Each team lead posts a 2-sentence status for their team's objectives every Friday. Format: "O1 [On Track/At Risk]: [One sentence on progress]. [One sentence on blockers or changes.]" 4. MID-QUARTER (week 6): Full OKR review — assess whether targets need to be adjusted based on new information. Adjustments should be the exception, not the rule.
Tips
- Make the Monday Current value update a non-negotiable — 15 minutes per team per week is the minimum investment to make the OKR system useful
- The weekly meeting should be 30 minutes maximum and should NOT discuss on-track objectives — only items that are at risk or off track. This keeps the meeting focused and under time.
- Use Notion's reminder feature to send each KR owner a Monday morning reminder to update their Current value — reduce the friction of remembering
Quarterly review and reset process
At the end of each quarter, conduct a structured OKR review before setting the next quarter's objectives. The review covers three areas: measurement (what percentage of key results were achieved?), learning (what did we learn about what moves our metrics?), and carry-forward (which objectives and key results should continue?).
Q3 2025 OKR Review agenda: 1. Measurement (15 min): For each objective, report final Progress %. Classify: Achieved (>70%), Partially achieved (40-70%), Missed (<40%). Calculate team-level achievement rate. 2. Learning (20 min): For each missed KR: what did we learn? Was the target wrong, the strategy wrong, or the execution wrong? This is the most valuable part of the review. 3. Carry-forward decisions (10 min): Which objectives continue into Q4? Which key results need to be reset with new baselines? Which objectives are complete and should be archived? 4. Q4 input (15 min): Based on learnings, what should change in Q4? Present 2-3 recommendations to leadership before the Q4 planning meeting.
Tips
- An achievement rate of 60–70% across key results is healthy — it means targets were ambitious but achievable. Close to 100% means targets were too easy; below 40% means targets were unrealistic or the strategy was wrong.
- Archive completed objectives — do not delete them. The history of what your team worked on and achieved is organizational knowledge that becomes valuable in hiring, investor updates, and post-mortems.
- Write a one-page OKR retrospective after each quarter: what did we achieve, what did we miss, and what is the most important thing we learned. Share it with the full company — this transparency builds culture.
Copy-paste template
# OKRs — [Q Quarter] [Year] *Last updated: [Date] | Owner: [Name]* --- ## Company Objectives ### O1: [Objective — inspirational, direction-setting statement] *Owner: [Name] | Status: [On Track / At Risk / Off Track] | Progress: [X]%* | Key Result | Baseline | Current | Target | Progress | Owner | |---|---|---|---|---|---| | KR1: [Specific measurable outcome] | [Start value] | [Current value] | [Target value] | [X]% | [Name] | | KR2: [Specific measurable outcome] | [Start value] | [Current value] | [Target value] | [X]% | [Name] | | KR3: [Specific measurable outcome] | [Start value] | [Current value] | [Target value] | [X]% | [Name] | --- ## [Team] Objectives ### O2: [Objective] *Owner: [Name] | Status: [On Track] | Progress: [X]%* | Key Result | Baseline | Current | Target | Progress | Owner | |---|---|---|---|---|---| | KR1: [Specific measurable outcome] | [Start value] | [Current value] | [Target value] | [X]% | [Name] | | KR2: [Specific measurable outcome] | [Start value] | [Current value] | [Target value] | [X]% | [Name] | --- ## Weekly Check-In Log *Updated every Monday by 12pm by Key Result owners.* | Week | Highlight | At-risk items | Action taken | |---|---|---|---| | Week 1 | [Progress highlight] | [KR at risk] | [Action] | | Week 2 | [Progress highlight] | None | — | --- ## Quarter-End Review **Achievement rate:** [X]% of key results achieved (>70% progress) **Top win:** [Biggest achievement this quarter] **Biggest miss:** [What we fell short on and why] **Key learning:** [Most important thing we learned this quarter] **Carry-forward to next quarter:** [Objectives or KRs continuing]
Frequently asked questions
Generate instead of filling in templates
Connect your tools, and Vantage generates the content using real product data. Free to start.
Free to start. No credit card required.