Generate recurring weekly reports combining KPIs and pull requests
A product leader uses Claude Code for automatic recurring reports on what developers shipped and whether features helped or hurt KPIs.
Done withClaude Code
- What they did
- David Kelly, a product leader, tracks KPIs for each product in a Metabase dashboard. He prompts Claude Code to build a system that pulls weekly GitHub pull requests, compares them with period-over-period KPI changes, and scores how likely each PR affected each KPI. He connects Zen MCP tools to the OpenAI and Gemini APIs so several models cross-check the analysis. He publishes the full prompt.
- How it went
- He gets a weekly report on whether shipped features helped or hurt KPIs, and he uses it to iterate. The post gives no accuracy figures for the correlations.
- Worth knowing
- A paid Claude plan is needed. He suggests Pro at $20 a month and advises against the API because costs can add up quickly.
Try it yourself with Claude Code
Every [Monday morning], pull the pull requests merged in [repo name] over the past week and our KPI numbers from [KPI source, e.g. a CSV or dashboard export]. Write a one-page report of what shipped, which features likely helped or hurt [KPI names], and what to watch next week. Save it as [file path or format] and show me the first draft before setting up any recurring schedule or sending it to anyone.
Want help getting this working? Join the Vibe Coding Academy ↗ Run by Alex Finn, who also runs this site.
Source: dmkthinks.org · Undated
Related use cases
Turn tickets into merged pull requests
Pulls tasks from GitHub Issues or Linear, then runs Claude Code or Codex in isolated Kubernetes pods to carry each one through to a PR.
Design and build a robotic arm with no CAD experience
A builder used Claude Code with FreeCAD and Claude Vision to design, print, and assemble a 5-DOF servo arm with vision and voice control.
Hand off coding sessions between agent accounts at usage limits
A developer built an app that tracks usage across multiple Codex and Claude Code accounts and auto-hands-off conversations when one hits its limit.
Run a solo company with eight agent departments
A founder set up CEO, CFO, COO, lawyer, accountant, marketing, CTO, and improver agents that share memory and consult each other.
Answer dental clinic calls and manage appointments
The author built a voice AI for a dental clinic that books, reschedules and cancels appointments, checks slots and answers common questions.
Run a one-person studio's office work with a bot team
Fourteen Grok Bots handle research, briefs, infra checks and Buffer social queuing; one turned an itch.io comment into merged Amiga fixes in under a day.
Get 5 like this every morning
The best things people got an AI agent to do, each with the prompt to try it.