On target
6
Amber
5
Red
1
KPI Scorecard
Business KPIs against target with achievement, red-amber-green status, change since last period and a perspective summary.
12 free kpi report templates, ready to edit in your browser and download for Excel, Word, Google Sheets or your calendar app. This collection brings together 12 spreadsheets from HR Analytics & Dashboards, KPIs & Performance and Marketing Analytics & Dashboards. Start with KPI Scorecard, Marketing KPI Dashboard and Hotel Occupancy & Revenue Report: each comes with realistic sample content, working formulas or ready-to-use wording, and a step-by-step guide.
On target
6
Amber
5
Red
1
Business KPIs against target with achievement, red-amber-green status, change since last period and a perspective summary.
Metrics on track
3
Metrics behind
0
Average attainment
97%
The monthly numbers that matter: traffic, leads, customers, cost and conversion against target.
Occupancy
76%
ADR
$126
RevPAR
$96
Daily rooms sold and room revenue turned into occupancy, ADR and RevPAR for the period.
Sales
$308,840
Conversion rate
14%
Average transaction value
$33
Weekly footfall, transactions, units and sales by store, turned into conversion, basket value and units per sale.
Inventory accuracy
80%
Net variance value
-$303
Gross variance value
$303
Schedule counts by ABC class, record counted versus system quantity, and see variance in units, value and percent with inventory accuracy.
Total followers
20,975
Follower growth
8%
Engagement rate
6%
Monthly results by platform: followers, reach, engagement rate, clicks and what each post type earned.
Revenue closed
$104,000
Team attainment
78%
Change on last week
-$7,000
The week in numbers: revenue, new pipeline, activity and target attainment by rep and for the team.
Hires
5
Average time to hire
36
Offer acceptance
63%
Applicants at each stage by role, conversion between stages, time to hire and cost per hire.
Headcount now
89
Annualised turnover
26%
Voluntary share of leavers
87%
Headcount, joiners, leavers, turnover and absence by month, with the year’s rates worked out.
Revenue
$159,850
Average order value
$39
ROAS
7.4
Monthly orders, revenue, ad spend and refunds for each channel, with AOV, ROAS and refund rate.
Total headcount
310
Women overall
48%
Women in leadership
33%
Measure representation by level, compare hiring and promotion rates, and track progress against your DEI targets.
Revenue this month
$655,000
Revenue, last 12 months
$7,013,000
EBITDA margin this month
16%
One page that answers how the business did this month: revenue, margins, EBITDA, cash, DSO and customers against target, with 12-month trends.