Business Ops

Weekly KPI Dashboard

Configure your key metrics once, enter weekly numbers, and get an auto-updating dashboard with trends, targets, and RAG status indicators. No formulas to write — just fill in the data.

What's Inside

KPI Config — Define up to 12 KPIs with names, targets, units (%, $, #), and direction (higher-is-better or lower-is-better). Set RAG thresholds for each metric.
Weekly Data — One row per week. Enter your actuals in each column. Formulas auto-calculate week-over-week change, cumulative totals, and distance-to-target.
Dashboard — Auto-generated KPI cards with current value, trend arrow, RAG status (green/amber/red), sparkline-style trend bars, and a summary table showing all metrics at a glance.

Key Features

RAG status indicators (red/amber/green) auto-calculated from your thresholds
Week-over-week percentage change with directional arrows
Conditional formatting highlights metrics that are off-track
Works for any business — SaaS metrics, sales KPIs, marketing funnels, or operational targets
Protected formulas so your team can't accidentally break the dashboard
Print-ready layout for weekly leadership meetings

Sample Formulas

Here are some of the formulas powering this template:

Week-over-week change

=IF(B3="","",IF(B2=0,"N/A",(B3-B2)/B2))

RAG status based on target threshold

=IF(B3="","",IF(B3>=Config!C2,"Green",IF(B3>=Config!D2,"Amber","Red")))

Sparkline trend for the last 8 weeks

=SPARKLINE(FILTER(B2:B,B2:B<>""),{"charttype","line";"color","#0F9D58";"linewidth",2})

Get this template free

Enter your email and we'll give you instant access to copy this template into your Google Drive.

You're in.

Click below to copy this template into your Google Drive. Check your email for setup instructions.

Make a Copy

Need this connected to live data?

We build custom KPI dashboards that pull from Stripe, HubSpot, Google Analytics, and more — auto-updated, no manual entry.

Start a build