Metrics on track
3
Metrics behind
0
Average attainment
97%
Marketing KPI Dashboard
The monthly numbers that matter: traffic, leads, customers, cost and conversion against target.
8 free kpi dashboard templates, ready to edit in your browser and download for Excel, Word, Google Sheets or your calendar app. This collection brings together 8 spreadsheets from HR Analytics & Dashboards, Marketing Analytics & Dashboards and KPIs & Performance. Start with Marketing KPI Dashboard, KPI Scorecard and HR Metrics Dashboard: each comes with realistic sample content, working formulas or ready-to-use wording, and a step-by-step guide.
Metrics on track
3
Metrics behind
0
Average attainment
97%
The monthly numbers that matter: traffic, leads, customers, cost and conversion against target.
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.
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.
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.
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.
Portfolio budget
$3,305,000
Spent to date
$2,027,500
Portfolio CPI
1
Every project’s budget, spend, progress and RAG status in one place, rolled up by programme.
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.