Monthly recurring revenue movement split into new, expansion, contraction and churn
Breaks the change in monthly recurring revenue into new customers, upgrades, downgrades, cancellations and reactivations, with net revenue retention, so a subscription business can see what really moved. Use it for a monthly review, an investor update or when total revenue grew but something feels wrong.
The output this prompt produced, unedited.
The prompt
Constraints first
Count revenue as recurring only for active paid plans; one-time fees and setup charges stay out.
Annual plans are spread into a monthly amount before any comparison.
A customer who cancels and returns in the same month is a change in plan, not churn plus new.
Never invent a figure; mark anything missing and explain how it limits the result.
Inputs
Month being reviewed: [e.g. October 2026]
Customer list for last month and this month: [paste customer ID, plan, billing period, amount, status]
Plan price list: [paste]
Discounts or credits applied: [paste, or none]
Steps
Convert every subscription into a monthly amount.
Classify each customer as new, expansion, contraction, churned, reactivated or unchanged.
Sum each class and reconcile opening plus movements to closing.
Output format
| Movement | Customers | Amount | Share of opening MRR |
A waterfall written as lines: opening, plus new, plus expansion, minus contraction, minus churn, plus reactivation, equals closing.
Net revenue retention and gross revenue retention, with the formula used.
The five largest churned and contracted accounts, with any reason given.
Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.
The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.