Subscription & MRR Tracker

Turn subscribers data into clear MRR metrics without heavy analytics. This prompt pack shows ChatGPT how to build a subscription and MRR tracker in Google Sheets or Excel.

- Subscribers tab structure with plan, price, status and dates
- Formulas for MRR, new MRR and churned MRR per month
- Cohort (join month) logic for deeper insights
- Summary view with headline metrics and trends
- Conditional formatting to flag at-risk customers (nearing renewal)