Our projects
Early-warning tracker
Every morning it checks your performance against the targets, and alerts you when something slips.
Quiet when things are fine. Loud when they’re not.
early-warning-check · every morning, 07:00Done
1Yesterday’s numbers come in
Done- sales-by-location.csv3,600 rows
- stock-levels.csv2,700 rows
- returns.csv640 rows
- targets.xlsx60 locations
At 07:00 the run collects yesterday’s figures for every location. Nobody has to open a file.
2Every location checked
Done60of 60 locations
all locations checked
- Sales, stock and returns lined up against targets
- 57 locations on track: nothing to send
- !3 locations slipping: owners alerted
3Alerts only when something slips
Done3of 3 alerts sent
- Westgatereturns 3x last week’s levelAlert
- Harbour Roadbest seller down to 2 days of stockAlert
- Riversidesales 18% under target, 4 days runningAlert
3 alerts sent by 07:02. The other 57 locations: nothing to report.Example run · illustrative data
Example run on illustrative data, with screen time compressed. Names and figures are made up.
What goes in, what comes out.
What you give it
- Yesterday’s numbersSales, stock and returns for each location
- Your targetsWhat on track means for each location
It runs on its own
Checks by itself every morning at 07:00
What you get
- A daily check of every locationLogged in a sheet, so you can see the history
- An alert when something slipsTo whoever owns that location, with the reason
- Silence when all is wellNo daily report that nobody reads
How it runs
- 1Every morning the run collects yesterday’s numbers on its own.
- 2Each location is checked against its own targets, with rules you can read.
- 3Anything off track is written up in one line: what slipped, by how much, since when.
- 4Only the people who need to act get an email. Everyone else hears nothing.
Runs on
Your Google Sheets and email. No new software for your team to learn, and $0 recurring costs.
What it isn’t
- A dashboard to check every morning
- A daily email nobody reads