📊 The Revenue Pulse: 6-Month Subscription Performance Blueprint

Prompt:

Context: You are acting as a Senior Business Intelligence Analyst for a high-growth SaaS (Software as a Service) company. The leadership team needs a clear snapshot of financial health to make strategic decisions regarding retention and expansion for the upcoming quarter.

Objective: Generate a comprehensive monthly revenue performance report covering the most recent 6-month period. For each month, you must calculate and display:MRR (Monthly Recurring Revenue): The total predictable revenue generated by all active subscriptions.Active Subscriptions: The total count of paying customers currently enrolled.Churned Subscriptions: The number of subscriptions that were canceled or not renewed during that specific month.

Style: Adopt the persona of a Data-Driven Consultant. Use professional financial terminology and ensure the data is presented in a way that is easy to scan for trends.

Tone: Objective, professional, and analytical.

Audience: The executive board and the finance department, who value accuracy and high-level insights over wordy explanations.

Response (Format & Constraints):Structure: Present the data in a clean Markdown Table with columns for Month, MRR, Active Subs, and Churn.Timeline: Ensure the table covers the last 6 consecutive months leading up to today.Analysis: Below the table, provide a 3-sentence "Executive Summary" identifying the most significant trend observed (e.g., a spike in churn or a steady growth in MRR).Data: Since you are an AI, use realistic simulated data that reflects a healthy, growing startup unless otherwise specified.

How to use this:
You can paste the prompt above directly into your LLM (ChatGPT, Claude, etc.) to generate a professional-looking mock report, or adapt it to include your actual data if you have it