Independent thinking. Informed defence.

CISO Times

Intelligence for the people behind the defence.

The CISO Decision Brief

Human Risk Metrics Dashboard

Reports reporting rates, repeat clickers, training completion and incident attribution to human factors.

Available soon

Format
Excel
Size
100 KB
Length
12 sheets
Version
1.0
Updated

What's inside

What changed

  1. 1.0

    Published.

Changes across this pack

Preview

The workbook's sheets as you will receive them, with its example rows and the values its formulas calculate. Highlighted [[text]] is for you to replace; rows marked EXAMPLE are for you to delete. Wide sheets scroll sideways. The cover, document control and changelog sheets are in the file.

Instructions

How to use this workbook

StepWhat to do
1On Measure Settings, keep one row per measure: HRM-01, HRM-02, HRM-03, HRM-04, HRM-05, MC-36, MC-34. Enter the unit, whether higher or lower is better, and for each P16 measure its target and tolerance limit as your security and IT leadership team sets them (P11 MR-07). MC-36 and MC-34 keep the metrics pack's definition, target and thresholds (P11 MR-04): change them only there.
2On Campaigns, enter each simulation when its window closes (5 working days after it is sent): the group, the grade, the theme, the recipients and the counts the platform gives. The rates, the window and the grade the progression rule gives calculate. Read the reporting rate first: the behaviour the programme exists to build: a reported attack can be stopped for everyone.
3On Human Factors, judge every incident in the case log (P09) for a human factor, from its root cause: An incident has a human factor when its root cause in the case log includes something a person did or did not do: a click, a credential or code given away, data sent to the wrong person, a procedure not followed. It is recorded as what happened, never as who. The control that should have stopped it is recorded beside it, and the awareness response never replaces fixing that control (AW-02).
4On Monthly Values, enter each month's values for the measures that are not calculated here: HRM-03, HRM-05, MC-36, MC-34. Use the month's last day, the value and 'Out of' for a share, and the value in words. Never copy last month's value forward. Mark 'Break in series' when the definition or source changed this month (P11 MR-09).
5Every measure's owner writes the commentary on Monthly Values for the month, including for the calculated measures. A measure short of target, or a KRI out of green, needs it: the Check column on Measure Settings says where it is missing.
6On the Dashboard, enter the report month (its last day) and the as-at date. Type both; never a formula that changes them. Read the status words, the comparisons and the commentary.
7Take the Dashboard to the security and IT leadership team every month, and the measures short of target or outside green, with the plan's progress, to executive management in the executive committee's monthly report (P11 RL-2, AW-16). The board sees completion through P03 BM-08. Keep a copy of each month's workbook.
8Delete the EXAMPLE rows before use. Do not type over the white calculated columns.

Legend

Yellow cells are inputs. Everything else is calculated or fixed — do not overwrite formulas.

EXAMPLERows marked EXAMPLE in the first column show how a completed row looks. Delete them before approval.

Rule AW-15: "The programme must be judged on behaviour: the human risk measures HRM-01 to HRM-05, with training completion (P11 MC-36) and phishing compromises (P11 MC-34) beside them, each with its target and status in words (P11 MR-12). Where another pack defines a measure, its definition and target are used unchanged (P11 MR-04). Simulation figures are compared only at the same grade: a change of grade is a break in series (P11 MR-09)."

Rule AW-16: "The measures must go monthly to the security and IT leadership team, and monthly to executive management in the metrics programme's executive report, which shows any measure short of target or outside green with the plan's progress (P11). Completion reaches the board through P03 BM-08. Once a year the awareness lead reviews whether each theme changed the behaviour it named, and the next plan keeps, changes or drops it on that evidence."

P11 MR-12: "Every value must be shown with its target or thresholds, its direction since the last period and its status in words (P03 BR-04). Never colour alone, never a combined index, and never a score out of 100."

EXAMPLE: a wholesale distributor with about 900 staff, three warehouses and an online ordering service that takes 60% of its orders, September 2026, as at 30 Sep 2026. Completion is 92%, which says people took the course. Behaviour says more: reporting rose from 22% to 28% at a harder grade, the first report now comes within 4 minutes, and staff reported 83 suspicious emails in September. It is not yet enough: 3 of the quarter's 5 incidents had a human factor, and phishing compromises are amber.

Tailoring — small organisation: report the five human risk measures and the two imported ones quarterly if a month has too few events to read. Keep every value's target, comparison and status in words, and never report a group smaller than the minimum.

Tailoring — regulated entity (NIS2, DORA): the dashboard is the record that the awareness programme and the role training are tested for effectiveness (Implementing Regulation (EU) 2024/2690, Annex points 8.1.3 and 8.2.3). Keep each month's copy.

Tailoring — simulations or IT run by a service provider: the provider's platform report is an input, never the dashboard. Take its counts onto the Campaigns sheet, and keep the judgement of human factors yourself.

Dashboard

Human risk metrics: monthly dashboard

For the security and IT leadership team. Yellow cells are yours; everything else is calculated. Every status is in words; the colour only repeats it. No score and no names (AW-13, P11 MR-12).

Report settings

SettingValue
Month (its last day)30 Sep 2026EXAMPLE: the month the figures describe.
As-at date (the day you read it)30 Sep 2026EXAMPLE: the example quarter end.
Progression: reporting rate at least20%AW-11: over a group's last 2 campaigns at its grade. EXAMPLE value.
Progression: click rate at most15%AW-11. EXAMPLE value.
Smallest group shown10AW-13: no result for a group smaller than this.
Simulation window (working days)5How long a simulation stays open for reports and clicks.

This month at a glance

Status or zoneMeasures
Green: consistent with the risk within appetite0
Amber: the risk may be above appetite1
Red: the risk may be past tolerance0
On target2
Below target, within tolerance4
Outside tolerance0
No target set0
Not available0

Measures short of target or out of green: 5. Commentary still needed: 0.

The measures

MeasureOwned byTarget or thresholdsThis monthCompared with the last periodStatus or zoneOwner's commentary
HRM-01 Simulation reporting rateP16[[40%]] at the group's current grade28% (124 of 441) at Grade 2Not comparable with 26% at Grade 1 last month (AW-15)Below target, within toleranceNot comparable with August's 26%, at Grade 1 (a change of grade is a break in series, AW-15). The same people reported 22% in July at Grade 1, and more at the harder grade in September.
HRM-02 Time to first reportP16[[10]] minutes or less at the group's current grade4 minutes at Grade 2Not comparable with 6 minutes at Grade 1 last month (AW-15)On targetThe first report came in 9, 6 and 4 minutes across the quarter's three campaigns. Not compared with August: the grade changed (AW-15).
HRM-03 Repeat clickersP16[[2%]] or fewer2.5% (11 of 436)No previous valueBelow target, within toleranceAll 11 were offered coaching on 28 Sep 2026, within the 10 working days; 8 accepted and 3 sessions have been held. Nobody has reached the third stage.
HRM-04 Incidents with a human factorP16[[2]] or fewer a quarter3 of 5 incidents this quarterNo previous valueBelow target, within toleranceStaff stopped or first reported 2 of the 5: INC-2026-015 and INC-2026-016.
HRM-05 Role training done by its due dateP16All4 of 4No previous valueOn targetThree Tier 0 administrators before 21 Sep 2026, and J-04 within the induction window. LM-08 falls due for four more privileged users on 19 Oct 2026.
MC-36 Staff security training completionP11, imported unchanged (MR-04)[[95%]]92%No previous valueBelow target, within toleranceWarehouse shift staff completed the short course on the floor terminals. The staff still to complete work night shifts: run the course on each warehouse night shift, HR Learning Lead, by 30 Nov 2026, to reach 95%. Not comparable with the June figure: the definition changed on 26 Jun 2026 (MR-09).
MC-34 Phishing compromisesP11, imported unchanged (MR-04)Amber at 2, red at 4 incidents in 3 months2 in 3 months (INC-2026-014, INC-2026-017)Worse (was 1, last month)Amber: the risk may be above appetite2 in 3 months (INC-2026-014, INC-2026-017): amber, escalated to the owner of R-09 under P11 MR-08 once validated. The fix is the move to an authenticator app; the sign-in codes and prompts theme moved to February to follow it (PC-2).

Status: On target; Below target, within tolerance; Outside tolerance; No target set. Zone (MC-34): Green: consistent with the risk within appetite; Amber: the risk may be above appetite; Red: the risk may be past tolerance. Simulation figures are compared only at the same grade (AW-15).

Incidents this quarter, by human factor (HRM-04)

Human factorIncidents
Opened a malicious attachment or link1
Gave away a password or code1
Sent data to the wrong person1
Did not follow a procedure0
Stopped or first reported by staff2

What happened, never who. The control that should have stopped each one is on the Human Factors sheet, and fixing it comes first (AW-02).

Context: suspicious emails staff reported (not a measure)

MonthReported by staffOf which real phishing
31 Jul 2026419
31 Aug 20265712
30 Sep 20268316

EXAMPLE: the reporting habit carrying over to real mail. Thank every report (AW-08).

Non-working days (public holidays)

DateHoliday

[[e.g. a public holiday]]

Measure Settings

One row per measure. Yellow columns are yours; the rest calculate for the report month on the Dashboard. MC-36 and MC-34 are the metrics pack's, unchanged (P11 MR-04).

RowMeasure IDMeasure (calc)Owned by (calc)Type (calc)UnitBetter whenTargetTolerance limitAmber atRed atTarget or thresholds in wordsSource (calc)Campaign row (calc)Previous campaign row (calc)Values row (calc)Previous values row (calc)This period (calc)Previous period (calc)Grade now (calc)Grade before (calc)Value in words (calc)Comparison (calc)Status or zone (calc)Commentary (calc)Check (calc)
EXAMPLEHRM-01Simulation reporting rateP16KPIShareHigher0.4000.200[[40%]] at the group's current gradeCampaigns3230.2810.2602128% (124 of 441) at Grade 2Not comparable with 26% at Grade 1 last month (AW-15)Below target, within toleranceNot comparable with August's 26%, at Grade 1 (a change of grade is a break in series, AW-15). The same people reported 22% in July at Grade 1, and more at the harder grade in September.OK
EXAMPLEHRM-02Time to first reportP16KPIMinutesLower10.00030.000[[10]] minutes or less at the group's current gradeCampaigns3244.0006.000214 minutes at Grade 2Not comparable with 6 minutes at Grade 1 last month (AW-15)On targetThe first report came in 9, 6 and 4 minutes across the quarter's three campaigns. Not compared with August: the grade changed (AW-15).OK
EXAMPLEHRM-03Repeat clickersP16KPIShareLower0.0200.050[[2%]] or fewerMonthly Values50.0252.5% (11 of 436)No previous valueBelow target, within toleranceAll 11 were offered coaching on 28 Sep 2026, within the 10 working days; 8 accepted and 3 sessions have been held. Nobody has reached the third stage.OK
EXAMPLEHRM-04Incidents with a human factorP16KPICountLower2.0003.000[[2]] or fewer a quarterHuman Factors63.0003 of 5 incidents this quarterNo previous valueBelow target, within toleranceStaff stopped or first reported 2 of the 5: INC-2026-015 and INC-2026-016.OK
EXAMPLEHRM-05Role training done by its due dateP16KPIShareHigher1.0000.900AllMonthly Values71.0004 of 4No previous valueOn targetThree Tier 0 administrators before 21 Sep 2026, and J-04 within the induction window. LM-08 falls due for four more privileged users on 19 Oct 2026.OK
EXAMPLEMC-36Staff security training completionP11, imported unchanged (MR-04)KPIShareHigher0.9500.850[[95%]]Monthly Values80.92092%No previous valueBelow target, within toleranceWarehouse shift staff completed the short course on the floor terminals. The staff still to complete work night shifts: run the course on each warehouse night shift, HR Learning Lead, by 30 Nov 2026, to reach 95%. Not comparable with the June figure: the definition changed on 26 Jun 2026 (MR-09).OK
EXAMPLEMC-34Phishing compromisesP11, imported unchanged (MR-04)KRICountLower24Amber at 2, red at 4 incidents in 3 monthsMonthly Values922.0001.0002 in 3 months (INC-2026-014, INC-2026-017)Worse (was 1, last month)Amber: the risk may be above appetite2 in 3 months (INC-2026-014, INC-2026-017): amber, escalated to the owner of R-09 under P11 MR-08 once validated. The fix is the move to an authenticator app; the sign-in codes and prompts theme moved to February to follow it (PC-2).OK

Monthly Values

One row per measure per month. Values for HRM-03, HRM-05, MC-36, MC-34; commentary for every measure, including HRM-01, HRM-02, HRM-04, whose values are calculated on the Campaigns and Human Factors sheets.

RowMonth endMeasure IDMeasure (calc)ValueOut of (for a share)Value in wordsBreak in seriesOwner's commentaryKey (calc)Check (calc)
EXAMPLE31 Jul 2026MC-34Phishing compromises00 in 3 monthsMC-34|46234OK
EXAMPLE31 Aug 2026MC-34Phishing compromises11 in 3 monthsMC-34|46265OK
EXAMPLE30 Sep 2026HRM-01Simulation reporting rateNot comparable with August's 26%, at Grade 1 (a change of grade is a break in series, AW-15). The same people reported 22% in July at Grade 1, and more at the harder grade in September.HRM-01|46295OK
EXAMPLE30 Sep 2026HRM-02Time to first reportThe first report came in 9, 6 and 4 minutes across the quarter's three campaigns. Not compared with August: the grade changed (AW-15).HRM-02|46295OK
EXAMPLE30 Sep 2026HRM-03Repeat clickers114362.5% (11 of 436)All 11 were offered coaching on 28 Sep 2026, within the 10 working days; 8 accepted and 3 sessions have been held. Nobody has reached the third stage.HRM-03|46295OK
EXAMPLE30 Sep 2026HRM-04Incidents with a human factorStaff stopped or first reported 2 of the 5: INC-2026-015 and INC-2026-016.HRM-04|46295OK
EXAMPLE30 Sep 2026HRM-05Role training done by its due date444 of 4Three Tier 0 administrators before 21 Sep 2026, and J-04 within the induction window. LM-08 falls due for four more privileged users on 19 Oct 2026.HRM-05|46295OK
EXAMPLE30 Sep 2026MC-36Staff security training completion82890092%Warehouse shift staff completed the short course on the floor terminals. The staff still to complete work night shifts: run the course on each warehouse night shift, HR Learning Lead, by 30 Nov 2026, to reach 95%. Not comparable with the June figure: the definition changed on 26 Jun 2026 (MR-09).MC-36|46295OK
EXAMPLE30 Sep 2026MC-34Phishing compromises22 in 3 months (INC-2026-014, INC-2026-017)2 in 3 months (INC-2026-014, INC-2026-017): amber, escalated to the owner of R-09 under P11 MR-08 once validated. The fix is the move to an authenticator app; the sign-in codes and prompts theme moved to February to follow it (PC-2).MC-34|46295OK

Campaigns

One row per simulation campaign, one a month, entered when its window closes. Counts from the platform; no names (AW-13). The grade the progression rule gives: a group moves up when its last 2 campaigns at its grade reach the thresholds on the Dashboard (AW-11).

RowCampaign IDSentGroupGradeThemeRecipientsReportedClickedEntered a credentialFirst report (minutes)Window closes (calc)Month (calc)Reporting rate (calc)Click rate (calc)Credential rate (calc)Grade the rule gives (calc)Check (calc)
EXAMPLESIM-2026-0714 Jul 2026Group A1CA-01444986318921 Jul 202631 Jul 202622%14%4%1OK
EXAMPLESIM-2026-0825 Aug 2026Group B1CA-02446116541461 Sep 202631 Aug 202626%12%3%1OK
EXAMPLESIM-2026-0917 Sep 2026Group A2CA-074411245817424 Sep 202630 Sep 202628%13%4%2OK

Human Factors

One row per incident in the case log (P09), judged for a human factor from its root cause: what happened, never who, with the control that should have stopped it.

RowIncident IDDetectedSeverity declaredSeverity finalHuman factorWhat happened (never who)Control that should have stopped itStopped or first reported by staffThis quarter (calc)Check (calc)
EXAMPLEINC-2026-01412 Aug 202611Opened a malicious attachment or linkA warehouse office user opened a phishing attachment.The account had local administrator rights (P09 PIA-01, P14 PA-03), and the site's office network was not yet separated (P05 TA-04).NoYesOK
EXAMPLEINC-2026-0152 Sep 202633NoneThe accounts payable clerk called the supplier back on the number on file and stopped the change.The call-back worked as designed (P05 TA-02).YesYesOK
EXAMPLEINC-2026-0169 Sep 202622Sent data to the wrong personA customer service agent sent a customer spreadsheet to the wrong business customer, and reported it at once.Address autocomplete and no warning for external recipients (P09 PIA-06).YesYesOK
EXAMPLEINC-2026-01722 Sep 202623Gave away a password or codeA sales administrator entered a password and a text-message code into a fake sign-in page.Second factors by text message can be phished (P12 GAP-06; P14 does not accept them for privileged access).NoYesOK
EXAMPLEINC-2026-01829 Sep 202644NoneNone: an internet-wide campaign against a published weakness.The patch was already applied.NoYesOK

Lists

MeasureIDMeasureNameMeasureOwnerMeasureTypeMeasureTargetUnitBetterFactorYesNoGradeThemeID
HRM-01Simulation reporting rateP16KPI[[40%]] at the group's current gradeShareHigherOpened a malicious attachment or linkYes1CA-01
HRM-02Time to first reportP16KPI[[10]] minutes or less at the group's current gradeMinutesLowerGave away a password or codeNo2CA-02
HRM-03Repeat clickersP16KPI[[2%]] or fewerCountSent data to the wrong person3CA-03
HRM-04Incidents with a human factorP16KPI[[2]] or fewer a quarterDid not follow a procedure4CA-04
HRM-05Role training done by its due dateP16KPIAllNoneCA-05
MC-36Staff security training completionP11, imported unchanged (MR-04)KPI[[95%]]CA-06
MC-34Phishing compromisesP11, imported unchanged (MR-04)KRIThresholds on Measure SettingsCA-07

CA-08

CA-09

CA-10

CA-11

CA-12

Definitions

Definitions

TermMeaning in this workbook
HRM-01 Simulation reporting ratePeople who reported the month's simulation through the reporting route within the campaign window, out of the people it was sent to, shown with its grade.
HRM-02 Time to first reportMinutes from the month's simulation being sent to the first report of it through the reporting route, shown with its grade.
HRM-03 Repeat clickersPeople who clicked in two or more simulations in the last 12 months, out of the people sent two or more in that time. A group figure; never a list of names (AW-13).
HRM-04 Incidents with a human factorIncidents in the quarter whose root cause in the case log includes a person's action or omission (P09), shown beside the incidents that a member of staff stopped or first reported.
HRM-05 Role training done by its due dateRole modules that fell due in the period and were completed by their due date (AW-06, AW-07), out of all that fell due.
MC-36 Staff security training completionStaff in post at the period end who have completed the security training due for their role in the last 12 months, as a share of all staff in post. Defined by the metrics pack (P11), used unchanged.
MC-34 Phishing compromisesIncidents in the last 3 calendar months whose root cause was a phishing email: an account taken over, or malware run from an attachment or link. Counted from the incident case log by the date detected. Defined by the metrics pack (P11), used unchanged.
ReportedThe person used the reporting route for the simulated email. This is the behaviour the programme exists to build.
ClickedThe person opened the link or attachment in a simulated email. Opening the email alone is not recorded.
Entered a credentialThe person typed something into the simulated sign-in page. What they typed is never stored.
Reporting ratePeople who reported a simulation, out of the people it was sent to.
Time to first reportThe minutes from a simulation being sent to the first report of it. It shows how soon a real attack would be known.
Repeat clickerSomeone who clicked in two or more simulations within 12 months.
GradeHow hard a simulation is to spot, from Grade 1 (many cues) to Grade 4 (one cue, tailored to a role).
Campaign measure 1: reporting rateThe behaviour the programme exists to build: a reported attack can be stopped for everyone.
Campaign measure 2: time to first reportHow soon a real attack would be known.
Campaign measure 3: click rateContext only: it moves with the grade and the lure, and a falling click rate with no reporting is not success.
Campaign measure 4: credentials enteredThe worst outcome of a click: the share of clicks that would have given an account away.
Human factorA person's action or omission that was one of an incident's causes in the case log's root cause, recorded as what happened, never as who.
Group resultA simulation result for a group of at least the minimum size, with no name in it.
Status: On targetAt or better than the target.
Status: Below target, within toleranceShort of the target, inside the tolerance limit. The owner's commentary gives the plan and the date.
Status: Outside toleranceBeyond the tolerance limit. The owner's commentary says what is decided.
Not availableNo value for the period: no campaign that month, or nothing entered. Last month's value is never carried forward.
Zone: GreenGreen: consistent with the risk within appetite. The indicator is where the risk owner expects it while the linked risk is within appetite.
Zone: AmberAmber: the risk may be above appetite. The indicator is at a level at which the linked risk may have moved above appetite. The risk owner reviews it.
Zone: RedRed: the risk may be past tolerance. The indicator is at a level at which the linked risk may have moved past tolerance. Executive management is told and the risk is reassessed.
Compared with the last periodBetter, Same or Worse than last month (last quarter for HRM-04), with that figure; Not comparable when the grade changed (AW-15) or the series broke (P11 MR-09); No previous value when there is none.
(calc)A column or cell the workbook calculates. Do not type or paste over it.
EXAMPLEA worked example: a wholesale distributor with about 900 staff, three warehouses and an online ordering service that takes 60% of its orders, September 2026. Delete before use.

Framework References

Framework references

These references indicate relevance only and do not reproduce the text of any standard.

FrameworkReferenceSupported by
ISO/IEC 27001:2022Clause 9.1 — Monitoring, measurement, analysis and evaluationThe dashboard as a whole: what is measured about people's behaviour, when, and how the results are evaluated each month
ISO/IEC 27001:2022Annex A 6.3 — Information security awareness, education and trainingCampaigns and HRM-05: whether awareness and training change what people do
NIST CSF 2.0GV.OV-03 — “Organizational cybersecurity risk management performance is evaluated and reviewed for adjustments needed”Status, comparison and commentary: the awareness programme's performance evaluated and reviewed each month
NIS2 — Directive (EU) 2022/2555Article 21(2)(g) — “basic cyber hygiene practices and cybersecurity training”The dashboard as a whole: whether cybersecurity training as a risk-management measure works
NIS2 — Implementing Regulation (EU) 2024/2690Article 1 — lays down the technical and methodological requirements of the Article 21(2) measures, and further specifies when an incident is significant, for DNS service providers, TLD name registries, cloud computing, data centre and content delivery network providers, managed service and managed security service providers, providers of online marketplaces, online search engines and social networking services platforms, and trust service providersWhom the Implementing Regulation binds: for other entities it shows what a supervisor expects
NIS2 — Implementing Regulation (EU) 2024/2690Annex, point 8.1.3 — “The awareness raising programme shall, where appropriate, be tested in terms of effectiveness. The awareness raising programme shall be updated and offered at planned intervals taking into account changes in cyber hygiene practices, and the current threat landscape and risks posed to the relevant entities.”HRM-01 to HRM-04: the awareness programme tested for effectiveness
NIS2 — Implementing Regulation (EU) 2024/2690Annex, point 8.2.3 — “The training referred to in point 8.2.1 shall be relevant to the job function of the employee and its effectiveness shall be assessed.” It covers “(a) instructions regarding the secure configuration and operation of the network and information systems, including mobile devices; (b) briefing on known cyber threats; (c) training of the behaviour when security-relevant events occur.”HRM-05: role training whose effectiveness is assessed
DORA — Regulation (EU) 2022/2554Article 13(6) — “Financial entities shall develop ICT security awareness programmes and digital operational resilience training as compulsory modules in their staff training schemes. Those programmes and training shall be applicable to all employees and to senior management staff, and shall have a level of complexity commensurate to the remit of their functions. Where appropriate, financial entities shall also include ICT third-party service providers in their relevant training schemes in accordance with Article 30(2), point (i).”Tailoring for financial entities: evidence that the compulsory awareness programme reaches and changes staff behaviour

Editions referenced: ISO/IEC 27001:2022 incl. Amd 1:2024; NIST CSF 2.0; Directive (EU) 2022/2555 (NIS2) and Implementing Regulation (EU) 2024/2690; Regulation (EU) 2022/2554 (DORA); Regulation (EU) 2016/679 (GDPR)

ISO/IEC 27001 references name the clause or control this document relates to. They do not say that meeting it meets any other framework's requirement.

Prepared by Zero One Cybersecurity · Published by CISO Times

CISO Times Resource Licence — Internal Use