OKR dashboard: objectives, key results, and progress

An OKR dashboard shows each objective, its measurable key results, and progress from an agreed baseline to a target. Use the same period and definition for the baseline, actual, and target. The score should make a review easier while preserving the evidence behind the result.

Start with the outcome and the source file

Write the objective as the business outcome the team wants to change. Each key result then needs a unit, direction, baseline, target, owner, period, and source reference. A completed activity can be useful supporting evidence, but it does not by itself prove a revenue, service, or retention outcome.

For revenue, use the sales ledger with its credits and reporting dates. For response time, use qualifying support-event timestamps. For renewal rate, use eligible renewal decisions and their outcomes. Keep the underlying numerator and denominator with a percentage so the reviewer can test the rate.

Use versioned metric definitions when the business definition changes. If an apparent improvement comes from excluding difficult customers, the dashboard should not present it as the same key result.

Set out a quarterly example

A US distributor has the objective "Strengthen repeat-customer relationships." Its baseline is the quarter ended June 30, 2026; the target and actual cover the quarter ended September 30, 2026. These are completed quarters, so quarterly revenue is compared with quarterly revenue rather than a partial-period actual.

The renewal target means 92 renewals out of an assumed 100 eligible decisions; it is a planning assumption, not an observed result. Actual eligibility must come from the quarter's renewal register. The table uses equal eligible counts to keep the worked arithmetic transparent, not to suggest that eligibility stays constant in practice.

Assign an accountable business owner to every row and retain the extraction date and evidence reference. The broader company dashboard covers the continuing business view; this page focuses on progress against the quarter's chosen change.

Calculate progress from the baseline

Key-result progress = (Actual - Baseline) / (Target - Baseline)

The signed formula works for increasing and decreasing measures. Response time has both a negative numerator and a negative denominator, producing positive progress when the time falls toward the target.

Revenue proves as (1,200,000 - 1,000,000) / (1,400,000 - 1,000,000) = 50.0%. Response proves as (8 - 12) / (4 - 12) = 50.0%, and renewals as (88.0% - 84.0%) / (92.0% - 84.0%) = 50.0%.

Percentages use one decimal. Each row has achieved half its planned improvement, but none has reached its target. The remaining gaps are $200,000 of revenue, 4 hours of response-time reduction, and 4.0 percentage points of renewal-rate improvement, directly from target minus actual in the appropriate direction.

In Google Sheets, create a calculation sheet with key result in A, baseline in B, target in C, actual in D, progress in E, weight in F, and evidence reference in G. Copy the first table's numeric baseline, target, and actual into B2:D4, keeping the supporting evidence references in G2:G4. Enter renewal percentages as percentage values. In E2, use this formula and fill down:

=IF(OR(B2="",C2="",D2=""),"Missing",IF(C2=B2,"Define maintenance rule",(D2-B2)/(C2-B2)))

Google's IF documentation describes choosing a result from a logical test. Here, missing inputs stay visible, and a zero change target is flagged instead of being divided by zero. Format valid numeric results as percentages. Verify numeric imports before relying on this check; text that looks like a number is still a data-quality problem.

Choose whether to summarize an objective

Keep raw progress visible before applying any presentation rule. A result below baseline should show negative progress. A result beyond target can exceed full completion. If management wants capped scores or critical-result gates, document that choice rather than silently building it into the arithmetic.

For this example, the business owner chooses equal weights for the three key results. Put those weights, each =1/3, in F2:F4. The objective score is:

=IF(COUNT(E2:E4)<>ROWS(E2:E4),"Incomplete",SUMPRODUCT(E2:E4,F2:F4)/SUM(F2:F4))

Google's SUMPRODUCT documentation describes multiplying corresponding entries and summing their products. The numeric-count check prevents missing progress from quietly entering this summary. Separately check that every agreed weight is present and nonnegative and that the weights sum to the intended total.

Here, (50.0% + 50.0% + 50.0%) / 3 = 50.0%. Change only response-time actual from 8 hours to 6 hours: (6 - 12) / (4 - 12) = 75.0%, and the objective becomes (50.0% + 75.0% + 50.0%) / 3 = 58.3%. The variation changes the score without changing revenue or renewal performance.

Covirage is not affiliated with Google.

Review the evidence and the next decision

The objective owner should explain the gap, the supporting rows, and the action proposed for the next period. The finance or operations reviewer checks whether the result reconciles to the relevant source export. Keep the target version fixed for that review; changing it after seeing actuals changes the commitment being assessed.

A performance dashboard can show ongoing target exceptions beside the OKR review. Use a dashboard audit when the displayed actual and the source file disagree before discussing why progress was missed.

Where it goes wrong

• Actual divided by target. That ignores the starting point and can make an unchanged business look close to completion.
• Mixed periods. A partial quarter's revenue against a full-quarter baseline understates progress. Show a comparable period or an explicitly defined milestone.
• Missing values become zero. Missing evidence is incomplete reporting, not proof of no progress or instant service.
• Averages hide essential commitments. A stronger revenue score cannot automatically compensate for a missed critical service result. Keep individual rows visible.

Check your own key results in Covirage

Bring your quarterly key-result workbook and the business exports behind the actuals. Covirage maps the columns, and its tools compute and check the figures; the external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.

See board reporting for the supporting leadership reporting context.