Marketing OKR Template and How to Score It

The OKR deck nobody opens after week two

You wrote the OKRs in January. Three objectives, nine key results, a clean slide with progress bars set to zero. By the March check-in, half the key results have no number next to them, one objective quietly changed shape when the roadmap shifted, and the "confidence" column is just everyone's best guess. Nobody scored anything last quarter either — the deck got archived and a new one got built from scratch, because going back and reconciling what actually happened felt like more work than starting over.

This is the normal life cycle of a marketing OKR set that was written but never built to be scored. The objectives were fine. The key results were even measurable. What was missing was a template that turned "we said we'd hit this" into an actual number at the end of the period — and a place to keep that number so it means something the next time you set goals.

This walks through a marketing OKR template you can build in a spreadsheet in under an hour: how to write objectives and key results that are structurally different from each other, how to score a key result on a simple numeric scale instead of a gut-feel color, and how to roll quarterly scores into an annual view without losing the history that makes next quarter's goals better than this quarter's.

What separates an objective from a key result

Most OKR sets break down because the objective and the key results are actually the same sentence written twice. "Increase brand awareness" as an objective, paired with "increase brand awareness score" as a key result, tells you nothing about what changed.

An objective is a direction: qualitative, ambitious, and stated in plain language a non-marketer could repeat back. "Make [product category] the default choice for [buyer segment] evaluating a switch this year" is an objective. It doesn't have a number in it.

A key result is a measurable state that would have to be true if the objective were achieved. It has a number, a unit, and a deadline built into the period. "Grow qualified demo requests from paid channels from a baseline to a defined target by end of quarter" is a key result — swap in your own baseline and target once you have them. "Launch the new campaign" is not a key result; it's a task. A task belongs on the campaign calendar that funds it, not in the key-results column, because a task can be marked done without moving anything that matters.

For a working set of objective/key-result pairs across common marketing goals — pipeline, brand, retention, content — the marketing OKR examples breakdown is a useful reference before you fill in your own template.

The marketing OKR template: five columns that make scoring possible

A scoreable OKR template needs five columns, not more. Extra columns are where OKR sets go to die — a status column, a confidence column, and an owner column all sound useful and all get abandoned by the second month.

1. Objective — the qualitative direction, written once per quarter or per year.
2. Key result — the measurable statement tied to that objective, with a baseline and a target.
3. Baseline — where the number stood at the start of the period. Without this, "increase" and "improve" are unscoreable.
4. Target — the number that would represent a fully achieved key result for the period.
5. Actual — the number as of the check-in date, logged on the same cadence every time.

Everything else — the score, the flag color, the trend arrow — is a formula derived from these five inputs. That's the point: once baseline, target, and actual are filled in consistently, scoring stops being a judgment call and becomes arithmetic.

If you're building the goals side of this from scratch rather than adapting an existing sheet, the marketing goals tracking template walks through the same five-column structure applied to individual goals rather than full OKR sets, which is a good starting point if OKRs feel like too much structure for where your plan is right now.

How to score a key result

Score each key result on a 0.0–1.0 scale rather than a percentage or a color. The formula is simple:

Score = (Actual − Baseline) ÷ (Target − Baseline)

Worked example — plug in your own numbers, these are illustrative only: a key result starts the quarter at a baseline of 40 (qualified demo requests per month) with a target of 100. By check-in, the actual is 76.

Score = (76 − 40) ÷ (100 − 40) = 36 ÷ 60 = 0.60

A score of 1.0 means the target was fully hit. A score above 1.0 means it was exceeded — worth noting, not necessarily worth celebrating, since it can also mean the target was set too low. A common convention among teams that run OKRs on a stretch model is to treat a score in the 0.6–0.8 range as a strong quarter, on the reasoning that a target hit at 1.0 every single time usually means the targets weren't ambitious enough. Whether that convention fits your team is a judgment call for you and your leadership to make — the important thing is picking one convention and applying it consistently, so a 0.6 means the same thing in Q3 that it meant in Q1.

A key result without a baseline isn't a key result yet — it's a target with nothing to measure progress against.

Average the key-result scores under each objective to get an objective score, and you have a single number per objective, per quarter, that's reproducible by anyone who opens the sheet — not dependent on whoever happened to write the status update that week.

Rolling quarterly scores into an annual view

The template earns its keep at the point where a quarter ends and the next one starts. Copy the prior quarter's final scores into an annual summary tab before resetting baselines — the actual from Q1 becomes the baseline for Q2 only if the key result is a running total; if it's a point-in-time metric, the new quarter gets a fresh baseline and target while the annual tab keeps the historical score intact.

This matters because an annual OKR view is not four quarterly views stacked on top of each other — it's a record of whether the direction set at the start of the year is still the right direction by the third quarter. If an objective scored 0.3 two quarters running, that's a signal to revisit whether the objective itself was realistic, not just whether the team executed against it. Keeping that history in one tab, rather than in four separate slide decks, is what makes the annual review something other than a memory exercise.

For a broader look at how quarterly objectives should relate to the annual plan they sit inside, marketing objectives examples covers how to phrase objectives so they survive being revisited three times a year without needing a full rewrite each time.

Common scoring mistakes that quietly break OKRs

A few patterns show up in almost every OKR sheet that stops getting used:

• Key results without a deadline built into the period. "Increase email signups" with no target date drifts — it's still technically true in December that signups increased since January, which makes it unscoreable as a quarterly result.
• Vanity key results. Impressions, followers, and page views move independent of anything the objective is meant to achieve. If the number can go up while the objective clearly isn't being met, it's the wrong key result.
• Too many key results per objective. Beyond three or four, the objective score becomes an average of things that don't actually relate to each other, and the number stops meaning anything specific.
• Scoring only at the end of the quarter. A key result checked once, on the last day, tells you the outcome but not whether anything could have been adjusted mid-quarter. Scoring on a monthly cadence inside the quarter is what turns the template into an early-warning system rather than a postmortem.

Turning the template into a dashboard you check on a cadence

A spreadsheet with five columns and a scoring formula is a complete OKR system — it doesn't require software to work. Where a spreadsheet starts to strain is at the point where you're tracking OKRs alongside a channel-level budget and a campaign calendar and want the three views to stay connected instead of living in separate files that drift out of sync with each other.

If you want the scoring logic built out with conditional formatting, an annual roll-up tab, and the flag thresholds already set, the Marketing OKR & Goal-Tracking Dashboard is the standalone version of this template, ready to fill in. For a dashboard-first view built specifically around KPI targets rather than OKR scoring, the marketing KPI dashboard template is the closer fit. Either lives in the template store alongside the rest of the marketing plan template library.

If you're maintaining OKRs, a budget, and a campaign calendar as three separate documents and want to see whether keeping them in one workspace on a scheduled check-in cadence is worth the switch, a live walkthrough shows how MarketPlans ties scored goals to the budget lines and campaigns funding them.