Query library
Start with a payment question. Make the query your own.
Revenue & MRR
7 queriesCurrent MRR
Recurring revenue using your workspace settings, by provider and currency.
Daily MRR
Recorded daily MRR over the last 30 days, with gaps left visible.
Monthly MRR trend
The latest recorded MRR in each month, using your workspace settings.
MRR changes
Subscriptions behind changes between recorded daily MRR balances.
Collections by country
Gross collections and tax by country over the last 90 days.
Monthly collections and refunds
Collections, successful refunds and their difference by activity month.
Stripe and Paddle comparison
Monthly collections, failed payments and tax, separated by provider.
Payments & payouts
3 queriesFailed payments
Failed payments from the last 30 days, including customers and failure reasons.
Payment methods
Payment counts and collected amounts by method over the last 90 days.
Recent payouts
Paid Stripe payouts that arrived in the last 30 days.
Stripe onlySubscriptions & retention
3 queriesSubscription cancellations
Current subscription records with a cancellation end date this month.
Popular plans
Active subscriptions and units for each recurring price.
Subscription retention estimate
Estimated retention at 1, 3, 6 and 12 months from subscription lifetimes.
Refunds, disputes & invoices
3 queriesRefund rate
The share of collected value refunded, grouped by the original collection month.
Dispute reasons
Dispute counts and amounts by reason, status and currency.
Unpaid invoices
Open or overdue invoices, with their full invoice totals and customers.
Paddle history
3 queriesHistorical recurring list value
Recorded Paddle recurring value before discounts, at monthly checkpoints.
Paddle onlyRecorded cancellation losses
Observed Paddle cancellations and the recurring list value lost at the time.
Paddle onlySubscription history coverage
How much Paddle history is imported, with recorded, inferred and unknown values.
Paddle only