Every Monday at 8 a.m. I used to sit down with four spreadsheets, half a coffee, and a blank Google Doc that radiated quiet judgment. My job was to write the weekly KPI digest that our leadership team read at 10 a.m. sharp. It took forty-five minutes, every single week, without fail, because I was manually computing week-over-week deltas, assigning status colours by squinting at the numbers, and then trying to write prose that made a cold column of figures actually tell a story. The hard 10 a.m. deadline turned every Monday morning into a small, recurring, self-inflicted panic attack.
The five-minute version
Now I copy our weekly metrics straight out of the analytics dashboard into a plain text block — metric names, this week's value, last week's value, and our targets — and paste the whole messy lump into the Weekly KPI Digest for Leadership prompt running on Gemini 3 Pro Preview. Gemini is genuinely the right pick here for a specific reason: it handles the ugly tabular paste without me having to clean or align anything first, and it is unusually good at synthesising a wall of numbers into a readable, board-friendly narrative. Thirty seconds later I have a formatted digest with traffic-light statuses, trend callouts, and recommended actions. I spend four minutes tweaking one or two sentences to sound like me. Done, and it is not even 8:10.
What the CRO actually said
The first week I used it, our CRO pinged me within ten minutes of the digest landing: 'this is cleaner than usual — did you get help?' I said yes, and politely declined to specify that the help had a context window and a Google login. The recommended actions were noticeably sharper than the ones I used to write, because each one was tied to a specific metric instead of being the kind of vague managerial encouragement I default to when I am tired. And the open-questions section flagged two numbers we had been quietly treating as hard data when they were actually rough, hand-entered estimates. That single flag kicked off a five-minute conversation we had been successfully avoiding for about a month.
- Time to produce the weekly digest dropped from 45 minutes to 5, reclaiming most of a stressful Monday morning
- Zero arithmetic errors since I switched — and I was absolutely making small ones by hand, which is mortifying in a report executives read
- Leadership engagement with the report visibly went up; people now quote specific lines back to me in meetings
- The Recommended Actions section became a standing item on the 10 a.m. agenda instead of being skimmed and forgotten
The one rule I lean on hardest
Early on, it surfaced a 'trend' that was not actually in my data — a small, plausible-sounding extrapolation that read as confident and was completely made up. This is the single scariest failure mode for anything you put in front of a board, because a confident wrong number is worse than no number at all. The prompt already says, in writing, never invent a figure, but I added a belt-and-suspenders line to the top of my own paste: 'Do not infer any metric not explicitly listed below.' It has never happened again since. If you take exactly one thing from this entire post, let it be that the anti-hallucination rule is the whole ballgame for executive reporting.
Takeaway
I will add one honest caveat, because no tool is all upside. The first three weeks, I caught myself trusting the output a little too much and skimming the review step. Then one Monday the prompt mislabelled a metric as 'On track' because I had pasted last week's stale target by mistake — the model did exactly what I told it, which was the problem. The fix was not the model; it was me. Now I treat the four-minute review as sacred and non-negotiable, and I double-check the targets paste every single week. The prompt does the heavy lifting, but a human still has to own the send button, because a human's name is on the email.
This is now the single most-used tool in my work week, and it is the one I would fight to keep if someone tried to take my whole prompt library away. Grab the Weekly KPI Digest for Leadership prompt on Prompt Dock and paste in your own ugly Monday spreadsheet dump, alignment problems and all. You will get your Monday morning back, your report will somehow look like an entire data team produced it, and your CRO will think you have mysteriously levelled up. Let them think that.