Weekly Metrics Reporter
Monday narrative of what moved, why, and what to do — pulled straight from your warehouse. 2–3 analyst hours saved every week.
Why build this now
Most weekly reports get skimmed because they're charts-and-chartjunk. An agent-written narrative — '{Metric} is up 14% WoW driven by {Channel}; this reverses the 4-week trend; action: review {Campaign}' — gets read. That's the ROI, not the time saved.
What the $1,000 build includes
- Read-only connection to BigQuery (preferred) or a Sheets dashboard
- Definition of 8–12 KPIs with target ranges and historic baseline
- Weekly cron trigger, runs Monday 7am local
- Narrative structure: headline, 3 biggest movers, trend context, recommended action
- Posts to designated Slack channel with anchor-links to the source dashboards
- On-demand re-run ('/reporter rerun') and ad-hoc question mode
Common gotchas we handle
Data freshness
If your warehouse ETL lands at 6am Monday and the agent runs at 7am, you'll occasionally see half-day gaps. We add a staleness check that pushes the run if fresh data isn't available.
Noise vs signal
Without tuning, the agent will headline a 3% blip as 'significant.' We calibrate thresholds per metric (e.g., only flag >8% on traffic metrics, >2% on churn-adjacent).
Secrets and roles
Warehouse credentials must not leak. We use a service account with row-level permissions matching the Slack channel's audience.
Sample prompt
A redacted version of the prompt skeleton we build around. Your build is tuned to your data.
You are the RevOps analyst for {companyName}. You have these metrics for the week ending {date}: {metricsJson}. Write a weekly report with four sections: Headline (1 line), Biggest Movers (top 3 with WoW % and likely cause), Trend Context (compare to the past 4 weeks), Recommended Action. Use markdown for Slack. Include dashboard links {links}.Questions
Want a Weekly Metrics Reporter for your team?
20-min intro call. I'll tell you if this specific agent is a fit for your stack.
Other agents I build
- Lead Outreach AgentEvery new lead gets researched and a personalized first email drafted — before your rep opens their inbox. 30–45 min saved per rep per day.
- Support Triage AgentEvery support message classified, routed, and drafted — grounded in your docs. Median first-response drops under 5 minutes; reps handle 2–3× the volume.
- Invoice & Expense ReviewerAP team reviews the 5% of invoices that actually need attention. The agent handles the other 95% — duplicates, policy checks, and QBO entry.
- Meeting Prep AgentA one-page brief lands in every external meeting invite 30 min before start. Your reps stop opening LinkedIn on the way to the call.