KPIs & OKRs: Designing, Scoring and Cascading Goals

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Turn four channels' raw counts into conversion rate, average order value, return rate and CAC, and avoid the classic numerator/denominator traps.
• Measure every KPI's gap to target (with 'lower is better' KPIs), set a Red/Amber/Green status with IFS, count the Reds and colour them.
• Score six key results from baseline to target, capped between 0 and 1, grade them Green/Yellow/Red and report the share in Green.
• Weight nine key results by importance, roll them up into three objective scores with SUMIF ÷ SUMIF, and combine the objectives into one OKR score.
• Roll five team OKR scores up to three company objectives with alignment weights, combine them into the company score, and see why additive KRs are summed before you score them.
• Test whether wishlist adds lead new customers by correlating the two series with a lag of 0 and 2 months, forecast August from June's wishlist adds and chart both series.
• Track online revenue against target month by month: variance %, a running year-to-date total, YTD achievement and a target-vs-actual line chart.
• Check a KPI's raw data before you report it: the completeness %, IQR fences for outliers, a flag for every day and the average of the clean days.