Build the weekly dashboard from your own numbers, then check whether it would have told you something you did not already know.
What to do
- Export candidates and jobs from the process you set up in Module 8 — or use the practice data if yours is still a test setup.
- Build the five numbers from Lesson 5, keeping raw data, sums and dashboard on separate sheets.
- Add counts next to every percentage.
- Add the date it was last refreshed.
- Write one paragraph: what needs attention this week, and why.
- Separately, work out your funnel percentages and compare them with the planning numbers from Module 3, Lesson 1.
What to hand in
The dashboard, the paragraph, and a short note on where your real percentages differ from the planning numbers — and what that means for how many people you actually need to find per hire.
How to know you have done it right
| Check | Good looks like |
|---|---|
| Everything is actionable | Every number maps to something someone would do |
| Counts shown | No bare percentages anywhere |
| Small samples flagged | Counts under ten shown as counts, not percentages |
| Structure | Re-exporting the data does not break the sums |
| Readable | A hiring manager could read it without you there |
| One screen | No scrolling |
Check yourself before Module 11
- Which number surprised you? That is the one worth watching.
- Is there someone on the going-cold list you had forgotten? Most people find at least one.
- Where is your biggest drop between stages, and is it quality or delay? Check the booking time before deciding.
- How many of your percentages rest on fewer than ten people? Those are not measurements yet.
Without an export
If your system cannot export, or you do not have one, build the dashboard from the practice data instead. The spreadsheet works with any list of candidates that has a stage and a date, including one you keep by hand. The five numbers do not need a system. They need a record.
How long to spend
Sixty minutes. If it takes three hours you are building a reporting suite rather than a weekly dashboard — and the suite is the thing that stops being updated in week four.