Zum Inhalt springen
Search the hub

← All suppliers

Finance

Stripe

Payments: charge/PaymentIntent, invoice, subscription — API load, PII and GMV/MRR measures.

Templates only — grain, filters, custom fields and ownership are firm-specific.

Copy formulas into the KPI Definition Card, then adapt grain and filters.

Example

GMV (gross)

What is gross payment volume in the period?

SUM(amount) / power(10, currency_exponent) FROM payment_intent WHERE status = succeeded AND created IN period
Grain
Succeeded PaymentIntent
Fields
PaymentIntent.amount, PaymentIntent.currency, PaymentIntent.status, PaymentIntent.created
Dimensions
currency, country, payment_method_type, product

amount is in minor units — divide by 10^exponent before aggregation (Stripe currency exponents).

Adapt: Subtract refunds/disputes in a net-GMV variant or show separately.

Example

Refund amount

How much was refunded in the period?

SUM(amount) / power(10, currency_exponent) FROM refund WHERE status = succeeded AND created IN period
Grain
Succeeded refund
Fields
Refund.amount, Refund.status, Refund.charge, Refund.created
Dimensions
currency, country, payment_method_type

Refund.amount in minor units; use charge/PaymentIntent for dimension joins.

Adapt: Separate partial vs full refunds and reason codes (duplicate/fraudulent).

Successful payments

How many payments succeeded in the period?

COUNT(*) FROM payment_intent WHERE status = 'succeeded' AND created IN period
Grain
PaymentIntent
Fields
PaymentIntent.status, PaymentIntent.created, PaymentIntent.currency
Dimensions
currency, country, payment_method_type, product

Use PaymentIntent status=succeeded; not only Charge without PI on newer integrations.

Adapt: Exclude test mode (livemode=false) and zero-amount auths.

Dispute rate

What share of charges has a dispute?

COUNT(DISTINCT dispute.charge) / COUNT(DISTINCT charge.id) WHERE charge.created IN period
Grain
Charge in period
Fields
Dispute.charge, Dispute.status, Charge.id, Charge.created
Dimensions
currency, country, payment_method_type

Join Dispute.charge; do not load evidence objects — id/status/amount only.

Adapt: Lock won/lost/needs_response and amount vs count rate.

MRR (subscriptions)

What is monthly recurring revenue of active subscriptions?

SUM(normalized_monthly_unit_amount * quantity) / power(10, currency_exponent) FROM subscription_item WHERE subscription.status IN (active, past_due)
Grain
Active subscription item
Fields
Subscription.status, Subscription.items.data.price.unit_amount, Subscription.items.data.price.product
Dimensions
currency, product, country

unit_amount in minor units; normalize month/year interval to monthly equivalent.

Adapt: Clarify trialing, discounted coupons and usage-based prices in the definition.

Formula overview

Same formulas as a table — copy into KPI cards or SQL drafts.

Label Formula Grain Fields
GMV (gross) SUM(amount) / power(10, currency_exponent) FROM payment_intent WHERE status = succeeded AND created IN period Succeeded PaymentIntent PaymentIntent.amount, PaymentIntent.currency, PaymentIntent.status, PaymentIntent.created
Refund amount SUM(amount) / power(10, currency_exponent) FROM refund WHERE status = succeeded AND created IN period Succeeded refund Refund.amount, Refund.status, Refund.charge, Refund.created
Successful payments COUNT(*) FROM payment_intent WHERE status = 'succeeded' AND created IN period PaymentIntent PaymentIntent.status, PaymentIntent.created, PaymentIntent.currency
Dispute rate COUNT(DISTINCT dispute.charge) / COUNT(DISTINCT charge.id) WHERE charge.created IN period Charge in period Dispute.charge, Dispute.status, Charge.id, Charge.created
MRR (subscriptions) SUM(normalized_monthly_unit_amount * quantity) / power(10, currency_exponent) FROM subscription_item WHERE subscription.status IN (active, past_due) Active subscription item Subscription.status, Subscription.items.data.price.unit_amount, Subscription.items.data.price.product

Tour