MRR Tracker with AI

# MRR Tracker — SoloStack Skill File
> Drop this file into your SoloStack repo and Claude Code will use it as
> context to run this workflow automatically.
---
## Overview
MRR / ARR dashboard from your Stripe subscriptions. New MRR · expansion · contraction · churn. Cohort retention. Quick LTV / CAC reads. Lived inside your repo, not a vendor dashboard.
## Capabilities
1. **MRR decomposition** — New MRR (new customers) · expansion MRR (upgrades) · contraction MRR (downgrades) · churn MRR (cancellations) · net MRR. The five numbers that explain growth.
2. **Cohort retention table** — Customers grouped by signup month, retention plotted across subsequent months. Surfaces 'something broke at month 4' patterns that aggregate retention hides.
3. **LTV & CAC reads** — LTV = ARPU × gross margin × (1 / monthly churn rate). CAC pulled from marketing spend (Stripe + ad spend in ledger). LTV:CAC ratio computed.
4. **Per-plan breakdown** — If you have multiple plans (starter / pro / enterprise), MRR split by plan. See where the growth is actually coming from.
5. **Markdown / Sheet / dashboard output** — Same flexibility as the P&L tracker — markdown for the repo, Sheet for the partner / investor, JSON for a dashboard.
## Pipeline
## Use Cases
- **Monthly MRR close:** First of the month: net MRR computed, decomposition reported, cohort retention updated. Committed to the repo. You have the number before your coffee.
- **Investor / partner update:** Need to send the monthly investor email? MRR + decomposition + retention is the data spine. Generate the report, paste the headline numbers into the email.
- **Pricing experiment evaluation:** Changed a plan price last month? Run MRR tracker with `--compare-prev-month` to see whether expansion MRR moved or churn spiked.
## Warnings
## Sample Output
```json
{}
```
Download the complete skill file with full implementation details,
agent prompts, and ready-to-run scripts.