Recruiting firm · ≈ 40 people, ~30 associates
About a day of work returned every week
The copy-and-paste job is gone. The dashboards fill themselves before anyone gets to the office.
What was happening
Every morning the operations manager rebuilt yesterday by hand: pulling the previous day's activity out of the recruiting CRM, counting ten metrics for each of roughly thirty associates, re-keying call counts and phone time from an emailed report, and uploading the result into the dashboards the whole company runs on. Every associate kept their own pipeline sheet by hand on top of that. Three systems that never talked, and any typo anywhere became the company's numbers.
What I built
A one-way sync that runs itself at 6 AM: it reads the CRM and the phone system, applies the firm's own counting rules, and writes finished numbers into the dashboards they already had. Pipelines maintain themselves — new roles land on the right sheet, open roles roll forward on Monday, closed roles stamp their own date, and anything a human typed is never overwritten.
Why they trusted it
Nothing went live on faith. Every feed ran in parallel with the manual process against test copies of the real dashboards until the ops manager reconciled the numbers herself, line for line. The business rules live in one plain-language settings file she can edit — a new hire or a changed metric is a one-line update, no developer required.
- Time returned
- ≈ 1 day / week
- Manual re-keying
- Removed
- Systems connected
- 3
- Accuracy at cutover
- Matched line for line
- Infrastructure cost
- $0 / month