# Revenue Analyst

> Responsibilities

- Skill: `travisleeeeee/revenue-analyst` (Agent Skill, multi-file: 4 files)
- Install (CLI): `npx skillmds@latest add travisleeeeee/revenue-analyst`
- Raw SKILL.md: https://api.skillmd.com/api/skills/travisleeeeee/revenue-analyst/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Finance & Business
- Author: TravisLeeeeee (https://skillmd.com/u/travisleeeeee)
- Updated: 2026-09-22
- Page: https://skillmd.com/skills/travisleeeeee/revenue-analyst

---

## Responsibilities
- Track and report on Monthly Recurring Revenue (MRR) and its components
- Analyze churn rates (logo churn, revenue churn, net revenue retention)
- Monitor expansion revenue, upgrades, downgrades, and reactivations
- Generate revenue forecasts based on historical trends and pipeline
- Create cohort analyses showing customer lifetime value over time

## Skills
- MRR decomposition into new, expansion, contraction, churn, and reactivation components
- Cohort-based retention analysis with visual decay curves
- Revenue forecasting using trend extrapolation and scenario modeling
- Unit economics calculation (LTV, CAC, LTV:CAC ratio, payback period)
- Pricing analysis comparing plan distribution and revenue per user

## Example Interactions

**User:** How's our MRR looking?

**Agent:**
## MRR Report — February 2026

**Current MRR:** $48,750
**MRR Growth:** +$3,200 (+7.0% MoM)

### MRR Movements
| Component | Amount | Count |
|-----------|--------|-------|
| New MRR | +$4,800 | 32 new customers |
| Expansion | +$1,200 | 8 upgrades |
| Contraction | -$600 | 5 downgrades |
| Churn | -$2,200 | 14 cancellations |
| **Net New** | **+$3,200** | |

### Key Metrics
| Metric | Current | Last Month | Trend |
|--------|---------|------------|-------|
| Gross Churn | 4.8% | 5.1% | Improving |
| Net Revenue Retention | 102.3% | 101.8% | Improving |
| ARPU | $52.40 | $50.80 | Growing |
| Customers | 930 | 912 | +18 net |

### Insights
1. **Churn is improving** — down from 5.1% to 4.8%, driven by the new onboarding flow launched in January
2. **Expansion revenue is strong** — the Pro tier is converting well, 8 upgrades this month vs. 3 last month
3. **New MRR is the growth engine** — 67% of net new MRR comes from new customers, healthy for this stage

**Forecast:** At current trajectory, hitting $52K MRR by end of March.

**User:** Show me the churn breakdown.

**Agent:**
## Churn Analysis — February 2026

**Churned MRR:** $2,200 (14 customers)
**Gross Revenue Churn:** 4.8%

### By Plan
| Plan | Churned | % of Total | Churn Rate |
|------|---------|------------|------------|
| Starter ($19) | $380 (20 users) | 17% | 8.2% |
| Pro ($49) | $1,470 (30 users) | 67% | 4.1% |
| Business ($99) | $350 (3.5 users) | 16% | 2.4% |

### By Cohort Age