Home / Connectors / Stripe
Connector

Stripe connector: datasets and metric definitionsBeta

Bring in payments, refunds, fees and payouts that match the Stripe Balance report, plus subscriptions and MRR by month. Updates daily.

7 datasets20 metric definitionsRead-onlyRefreshes daily

When you connect Stripe, Quiriz imports the datasets below and adds the metric definitions to Company Context, the one place your company’s definitions live. Every answer that uses one of these metrics uses the same definition, in the app, in Slack and in the Excel, Sheets, PowerPoint, Slides, Word and Docs add-ins. An admin can edit any of them.

DatasetsMetric definitionsWorks withQuestionsFAQ

Datasets

DatasetWhat it holds
[Stripe] PaymentsOne row per charge in its own currency, dated in the Stripe account time zone, failed attempts included (is_failed). Money that reached the balance is in [Stripe] Balance transactions. is_home_currency marks the account currency; never add currencies together. is_refunded = 1 for any refund, partial included.
21 columnscreated_date, month, charge_id, payment_intent_id, balance_transaction_id, status, currency, is_home_currency, amount, amount_captured, amount_refunded, payment_method_type, card_brand, failure_code, customer_id, customer_name, invoice_id, is_succeeded, is_failed, is_refunded, is_disputed
[Stripe] Balance transactionsOne row per balance transaction, like Stripe's Balance report, dated in the account time zone: gross, fee and net signed as Stripe signs them (refunds, disputes, fees and payouts negative). Net volume = net where is_sales_activity = 1. is_home_currency marks the account currency; never add currencies together.
22 columnscreated_date, month, available_date, txn_id, type, reporting_category, currency, is_home_currency, gross, fee, net, source_id, charge_id, customer_id, customer_name, description, is_charge, is_refund, is_dispute, is_fee, is_payout, is_sales_activity
[Stripe] SubscriptionsOne row per current subscription (active, past due, trialing, unpaid, paused) with its MRR by Stripe Billing's rules; is_counted = 1 for the ones Stripe counts. Canceled history is in [Stripe] MRR by month.
20 columnssubscription_id, customer_id, customer_name, status, product_id, product_name, price_id, interval, interval_count, quantity, currency, is_home_currency, mrr, start_date, trial_end, current_period_end, cancel_at, is_counted, is_trialing, is_canceling
[Stripe] InvoicesOne row per invoice in its own currency, dated in the account time zone. days_past_due counts from the due date for open invoices only. is_home_currency marks the account currency; never add currencies together.
20 columnscreated_date, month, invoice_id, number, status, currency, is_home_currency, subtotal, discount, tax, total, amount_paid, amount_remaining, due_date, days_past_due, subscription_id, customer_id, customer_name, is_open, is_paid
[Stripe] MRR by monthOne row per subscription per month-end by Stripe Billing's MRR rules (active and past due count; trials, metered items and tax do not; forever coupons subtracted, once and repeating coupons not). Past months from invoices, the current month from live subscriptions (is_latest = 1). A plan switch shows as one churn and one new. Group by month_end; never add month-ends together. Subscriptions in other currencies are not converted (is_home_currency). Tax-inclusive prices count the tax inside the price. After a mid-period upgrade, the upgrade month-end shows the old price until the next renewal.
18 columnsmonth_end, month, subscription_id, customer_id, customer_name, product_id, product_name, interval, currency, is_home_currency, mrr, mrr_change, is_new, is_expansion, is_contraction, is_churn, is_reactivation, is_latest
[Stripe] Subscription snapshotsA dated copy of the Subscriptions dataset each day (daily for 90 days, then Mondays for 24 months). Compare two snapshot_date values; never add dates together.
21 columnssnapshot_date, subscription_id, customer_id, customer_name, status, product_id, product_name, price_id, interval, interval_count, quantity, currency, is_home_currency, mrr, start_date, trial_end, current_period_end, cancel_at, is_counted, is_trialing, is_canceling
[Stripe] CustomersOne row per customer named by a payment, subscription or invoice: name and country only, no email, phone or address. first_payment_date is the first successful charge in the imported payments.
7 columnscustomer_id, customer_name, customer_country, created_date, first_payment_date, is_subscriber, is_delinquent

Metric definitions

Each metric is a total over the period you ask about. A metric built from other metrics, such as a rate, divides the totals for the whole period; it does not average daily rates. Dated by is the date column that decides which period a row belongs to.

[Stripe] Payments

MetricHow it is calculatedDated byNotes
PaymentsCount of distinct charge_idcreated_dateCharge attempts, successful or not, by charge date.
Successful paymentsCount of distinct charge_id, where is_succeeded = 1created_dateCharges that succeeded, by charge date.
Failed paymentsCount of distinct charge_id, where is_failed = 1created_dateCharges that failed (declined cards and the like), by charge date.
Payment success rateSuccessful payments ÷ Paymentscreated_dateSuccessful payments divided by all charge attempts, as a decimal (0.95 = 95%).

[Stripe] Balance transactions

MetricHow it is calculatedDated byNotes
Gross volumeSum of gross, where is_charge = 1 AND is_home_currency = 1created_dateSuccessful charges before refunds, disputes and fees, by balance transaction date.
Refunded amountSum of gross, where is_refund = 1 AND is_home_currency = 1created_dateRefunds, shown negative as in Stripe; a failed refund returns money and shows positive.
Dispute lossesSum of gross, where is_dispute = 1 AND is_home_currency = 1created_dateDisputed amounts withdrawn, shown negative as in Stripe; a won dispute returns money and shows positive.
Processing feesSum of fee, where is_home_currency = 1created_dateThe Stripe fee on every balance transaction (charges, refunds, disputes, instant payouts), shown positive.
Other Stripe feesSum of gross, where is_fee = 1 AND is_home_currency = 1created_dateFees Stripe bills as their own transactions (Billing, Radar, Tax, Connect), shown negative as in Stripe.
Net volumeSum of net, where is_sales_activity = 1 AND is_home_currency = 1created_dateGross volume less refunds, disputes and all Stripe fees: the Dashboard's net volume from sales.
PayoutsSum of gross, where is_payout = 1 AND is_home_currency = 1created_dateMoney sent to the bank account, shown negative as in Stripe; a failed or canceled payout shows positive.

[Stripe] Subscriptions

MetricHow it is calculatedDated byNotes
Active subscriptionsCount of distinct subscription_id, where is_counted = 1Today’s snapshotSubscriptions Stripe counts in MRR today (active and past due).

[Stripe] MRR by month

MetricHow it is calculatedDated byNotes
MRRSum of mrr, where is_latest = 1 AND is_home_currency = 1Today’s snapshotMonthly recurring revenue today, by Stripe Billing's rules (active and past-due subscriptions, after forever coupons, before tax). For MRR over time use MRR by month.
MRR by monthSum of mrr, where is_home_currency = 1month_endMonthly recurring revenue at each month-end. Group by month_end; never add month-ends together.
ARRmrr × 12Today’s snapshotAnnual recurring revenue today: current MRR times twelve.
New MRRSum of mrr_change, where is_new = 1 AND is_home_currency = 1month_endMRR from subscriptions paying for the first time, by month-end.
Expansion MRRSum of mrr_change, where is_expansion = 1 AND is_home_currency = 1month_endMRR added by upgrades and added seats, by month-end.
Contraction MRRSum of mrr_change, where is_contraction = 1 AND is_home_currency = 1month_endMRR lost to downgrades, shown negative, by month-end.
Churned MRRSum of mrr_change, where is_churn = 1 AND is_home_currency = 1month_endMRR lost to cancellations and unpaid subscriptions, shown negative, by month-end.
Reactivation MRRSum of mrr_change, where is_reactivation = 1 AND is_home_currency = 1month_endMRR from subscriptions that came back after churning, by month-end.

Works with other connectors

Questions to ask

Ask Stripe in plain words

Try the questions on sample data with no signup, then connect Stripe read-only and ask your own.

Try Quiriz free →

Frequently asked questions

Does Quiriz change anything in Stripe?
No. The Stripe connector is read-only. Quiriz reads the data into datasets and never writes back to Stripe.
How often does the Stripe data refresh?
Once a day. Each dataset shows when it was last updated, and answers use the latest refresh.
Can I change how a metric is calculated?
Yes. The definitions are added to Company Context, where an admin can edit the formula, the filter or the date it uses. A daily refresh never overwrites a definition someone has changed.
Can I combine Stripe with other sources?
Yes. An admin can also define a metric from metrics on different datasets. See cross-source metrics.

All connectors: Quiriz connectors. Definitions on this page are generated from the product’s own connector code.