wowprompt

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.

An MRR waterfall from opening to closing month, a table of movement types with counts and amounts, and net and gross revenue retention
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

  1. Convert every subscription into a monthly amount.
  2. Classify each customer as new, expansion, contraction, churned, reactivated or unchanged.
  3. Sum each class and reconcile opening plus movements to closing.

Output format

  1. | Movement | Customers | Amount | Share of opening MRR |
  2. A waterfall written as lines: opening, plus new, plus expansion, minus contraction, minus churn, plus reactivation, equals closing.
  3. Net revenue retention and gross revenue retention, with the formula used.
  4. The five largest churned and contracted accounts, with any reason given.
  5. Three plain-language findings for the review.
mrr movementmrr waterfallnet revenue retentionsubscription metricssaas churn analysisexpansion revenue

How to run this

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.

Related prompts

All productivity