Monthly Metrics
Built by a CEO, for CEOs Why it exists
You have revenue hiding in Stripe. We’ll find it.
Cancellations you can still save, upsells you haven’t spotted, segments that never stay. SpawnLoop shows you what moved revenue, why, and which customers to call.
Read-only access to Stripe. Free up to 100 customers.
Revenue grew 1.3% to $155,864.65 on higher recurring revenue, while contraction among continuing customers reached a six-month high.
-
Driver
New and returning customers brought $32,601.34; Acme Secure accounted for 41% of it.
HypothesisThe annual Secure bundle launched in June is converting Cloud customers.
-
Deviation
Contraction was $2,567.74, above its six-month range of $1,573.63–$2,481.69.
-
Risk
9 accounts holding $2,881.35 of MRR show a sharp drop in total payment.
Revenue bridge
Suggested actionReview the 9 high-priority accounts on Churn Early Warning.
Written for you every month, with the evidence behind each finding. Illustrative numbers for a fictional company.
- Read-onlyCan’t charge, refund or change anything in Stripe.
- Computed, not generatedThe database writes the numbers. The model writes the words.
- GAAP next to billedGAAP under ASC 606, kept separate from billed revenue.
- FreshSyncs with Stripe about every 15 minutes.
Product
The answers your board will ask for, ready before the meeting.
Every view on the same definitions, the same periods, and a drill-down to the customers behind each number.
Sample data · Acme Corp Illustrative numbers for a fictional company, as shown in the sample dashboard.
Retention Analysis
Trailing 12-month NRR is 80.7%. The base is shrinking.
Cohorts
About a quarter of every cohort is gone by month 6.
- 90%+
- 75%+
- 60%+
ICP
Dental practices kept 19 points more customers at 12 months.
TargetAvoid Score out of 100, on cohorts 12 months or older.
Open ICPChurn Early Warning
33 customers’ payments are falling. 9 are flagged high priority.
$11,045.25 MRR across all 33
Open the watchlistAnd 18 views in all
Every view your revenue team asks for.
- AI Summary
- Ask AI
- Monthly Metrics
- Product Performance
- Expansion & Contraction
- MRR Distribution
- Expansion Candidates
- ICP
- Vertical Insights
- Retention Analysis
- Churn Insights
- Churn Early Warning
- Collections → Churn
- Commitments & Renewals
- First Month Free / Paid
- Coupons
- Refunds
- Analysis Exports
Ask AI
Ask in plain English. It answers from your numbers, or tells you why it can’t.
Pick a question. These are the app’s own examples, answered on the sample company.
How has ARPU trended over the last 8 months?
- AI model mapped the analysis
- Checking that the reporting data is current
- Calculating the requested metrics
- AI model composed the answer
ARPU, total revenue per active customer, moved from $130.71 in Jan to $130.32 in Aug, down 0.3%. It peaked at $135.13 in Mar.
Can you show the same ARPU trend but break it down for each product?
- AI model mapped the analysis
- Checking that the reporting data is current
- Calculating the requested metrics
- AI model composed the answer
Acme Secure earns the most per paying customer, $114.01 in Aug, and moved the most, +6.7% since Jan. Each figure is that product’s revenue over its own paying customers.
What was the monthly churn this year?
- AI model mapped the analysis
- Checking that the reporting data is current
- Calculating the requested metrics
- AI model composed the answer
205 customers churned from January to August, taking $108,455.74 of prior-month revenue. April was the worst month: 31 customers and $16,576.88. August: 26 customers, $13,406.08.
What’s the new revenue for this month so far?
- AI model mapped the analysis
- Checking that the reporting data is current
- Calculating the requested metrics
- AI model composed the answer
$39,827.06 from 91 customers in their first paid month of August: $34,415.29 recurring, $3,203.05 one-time and $2,208.72 usage.
Which customer will churn next month?
- AI model mapped the analysis
- Checking that the reporting data is current
- AI model composed the answer
Can’t answer that as asked
I can’t predict which customer will churn next month. Churn Early Warning ranks customers whose payments are declining, but that’s an observed signal—not a churn probability.
I can instead show which customers churned last month or the recent customer-churn trend.
Every figure comes from a validated query, never from the model. Each answer lists the steps it took.
Built by a CEO, for CEOs
“I wished this existed two startups ago. Getting revenue right to the penny shouldn’t take a finance team days in Excel.”
Aaron Lee, founder. Former CEO of Smith.ai. Former CTO of The Home Depot. Co-founder and CTO of Redbeacon.
Every month I waited for a spreadsheet to tell me what had already happened. SpawnLoop is the revenue view I wanted on Monday morning: what moved, why, and who to call.
Every seat at the table
One set of numbers for the whole leadership team.
CEO
Know what moved revenue, and why.
The month on one page: drivers, risks and what to do next.
- AI Summary
- Product Performance
- ICP
CFO and controller
One revenue number, everywhere.
GAAP under ASC 606 next to billed revenue, with collections and renewals in the same model.
- Monthly Metrics
- Retention Analysis
- Commitments & Renewals
CRO and rev ops
Who’s expanding, who’s slipping, where to aim.
Expansion candidates, a churn watchlist, and the segments that retain best.
- Expansion Candidates
- Churn Early Warning
- ICP
For the people who read footnotes
Why the numbers hold up.
Your controller will ask. Here are the answers.
Every invoice line, understood
- Each line maps to its product, even when plans and prices change. Old plans roll up into today’s product.
- Recurring (MRR), usage and one-time revenue are classified separately, with prorations kept apart.
- Refunds attach to the invoice they reverse. Prepaid multi-month invoices spread across the months they cover.
- Internal, test and spam accounts are excluded. Salesforce adds vertical and sub-vertical.
Revenue terms with one precise meaning
- GAAP revenue under ASC 606, kept separate from billed revenue.
- New, expansion, contraction, free-to-paid, reactivated and churned MRR reconcile month over month.
- NRR and GRR on a strict opening cohort, so GRR can never exceed 100%.
- Logo churn and revenue churn kept apart. A product churn is never mistaken for a lost customer.
How the AI stays honest
- It chooses from a registered catalog of measures and filters. It never writes free-form SQL.
- Every request is checked before it runs. Results arrive as exact figures the model can’t alter.
- Ambiguous or unsafe questions get a clear “can’t answer”, with a reason.
- Hypotheses in the monthly report are labelled, and kept apart from the evidence.
Security and access
- Stripe asks you to approve read-only access to invoices, refunds and subscriptions. Uninstall any time.
- The AI never sees raw invoices, SQL, emails or contact details.
- Your account’s data scope is enforced on the server on every query, never chosen by the model.
- Each answer says which month it covers and when the data was last rebuilt.
Your board will see these numbers eventually. See them first.
Connect Stripe with read-only access. SpawnLoop drafts your C-suite report from your own billing data, with the evidence behind every finding.