ye myat
book intro →

AI Agents for Weekly Metrics Reports

Pull MRR, churn, burn rate, and runway from Stripe and your accounting tool every Monday. Formatted, compared to last week, and in your inbox before standup.

01the problem

You know you should be tracking MRR, churn, burn rate, and runway weekly. But every Monday you open Stripe, open your accounting tool, paste numbers into a spreadsheet, and try to remember what changed. By the time you have the picture, your standup already started. Some weeks you skip it entirely.

02what the agent does

Every Monday at 8 AM, the agent connects to Stripe and your accounting tool. It pulls MRR, new customers, churn, burn rate, and calculates runway. It compares everything to last week, highlights what improved, flags what needs attention, and delivers a formatted report to your inbox before your first meeting.

Example output

agent output

Weekly Metrics — Week of 2026-03-09

MetricThis WeekLast WeekChange
MRR$42,500$38,200+11.3%
New customers128+50%
Churn13-66.7%
Burn rate$35,000$37,000-5.4%
Runway11.2 months10.4 months+0.8

Highlights

  • MRR crossed $40K for the first time
  • Churn dropped to 1 (lowest since launch)
  • New customer growth driven by Product Hunt feature (Mar 5)

Watch

  • Burn rate still above $30K target. Infra costs up 12% from February.
  • 2 failed payments pending retry (total $890)

Try it yourself

Copy these prompts into Claude Cowork. Connect your tools. The agent handles the rest.

01
Scheduled weekly metrics report
Set up once. Key metrics land in your inbox every Monday morning.
Run every Monday at 8:00 AM.

1. Pull revenue metrics from Stripe: MRR, new customers, churn, net revenue
2. Pull expense data from accounting tool: burn rate, major cost categories
3. Calculate runway based on current cash and burn rate
4. Compare all metrics to last week and last month
5. Write a report with: metrics table (this week vs. last week vs. change), highlights (what improved), and watch items (what needs attention)
6. Save to projects/metrics/weekly/YYYY-MM-DD.md
7. Email to me with subject: 'Weekly Metrics — [YYYY-MM-DD]'

FAQ

Common questions about setting up this agent.

What data sources can the agent pull from?+
Claude Cowork connects to Stripe, QuickBooks, Xero, Google Sheets, and Notion. If your data lives in a tool with an API, you can build a Cowork skill to connect it. If it's in a spreadsheet, the agent reads that directly.
Can I customize which metrics are tracked?+
Yes. The metrics here are common for pre-seed to Series A startups. You define what matters to your board: MRR, ARR, CAC, LTV, gross margin. Set it once and the agent follows that template every week.
How is this different from a dashboard?+
A dashboard shows you data when you go look at it. This delivers a formatted, interpreted report to your inbox on schedule. It doesn't replace Metabase or Looker. It replaces the 30 minutes you spend every Monday pulling numbers and writing the summary yourself.

More for startup founders

Daily Planning

Start every morning with a prioritized work plan built from your calendar, Slack, email, and project tools. No manual assembly required.

view

Invoice Chasing

Automatically detect overdue invoices, draft follow-up emails, and escalate the ones that need attention. No more awkward manual chasing.

view

Lead Warming

Re-engage cold leads with personalized outreach based on recent company news and your last conversation. No more 'just checking in' emails.

view

Want this running for your team?

I set up AI agents like this for startup founders. 30 minutes, no strings.

book intro →