Stripe fields list — Porter Metrics docs

Stripe Fields List

352 fields · 201 dimensions · 151 metrics · 16 groups

352 of 352
Field nameLabelCategoryDescription
stripe_account_countryAccount countryAccountCountry of the Stripe account.
stripe_account_default_currencyAccount default currencyAccountSettlement currency of the Stripe account.
stripe_account_idAccount IDAccountStripe account id (acct_…).
stripe_account_nameAccount nameAccountBusiness name of the Stripe account.
stripe_available_on_dateAvailable onCharges & paymentsDate the net funds became (or become) available in the Stripe balance.
stripe_average_payment_valueAverage payment valueCharges & paymentsAverage gross amount per charge (includes failed attempts; filter charge_status = succeeded for the average successful p…
stripe_avg_transaction_amountAverage transaction amountCharges & paymentsAverage gross amount per balance transaction.
stripe_blocked_paymentsBlocked paymentsCharges & paymentsCharges blocked by Radar rules or risk (outcome type = blocked).
stripe_calculated_statement_descriptorStatement descriptor (as shown)Charges & paymentsThe descriptor Stripe actually put on the customer's statement.
stripe_captured_amountCaptured amountCharges & paymentsAmount actually captured from the customer (0 for failed or uncaptured charges).
stripe_card_brandCard brandCharges & paymentsCard brand: visa, mastercard, amex, …
stripe_card_countryCard countryCharges & paymentsCountry of the card's issuing bank.
stripe_card_fundingCard fundingCharges & paymentscredit, debit, prepaid or unknown.
stripe_card_last4Card last 4Charges & paymentsLast four digits of the card.
stripe_card_networkCard networkCharges & paymentsNetwork the charge was processed on: visa, mastercard, amex, cartes_bancaires, …
stripe_card_walletCard walletCharges & paymentsDigital wallet used, if any: apple_pay, google_pay, link, samsung_pay, …
stripe_charge_capturedCapturedCharges & payments1 when the authorised funds were captured; 0 for an authorisation still awaiting capture.
stripe_charge_disputedDisputedCharges & payments1 when the customer's bank opened a dispute (chargeback) on the charge.
stripe_charge_first_paymentFirst paymentCharges & payments1 when this charge is the customer's first successful payment within the lookback (STRIPE_LOOKBACK_DAYS) — the payment t…
stripe_charge_idCharge IDCharges & paymentsStripe charge id (ch_…).
stripe_charge_paidPaidCharges & payments1 when the charge was paid (succeeded, or a pending bank debit that is expected to settle).
stripe_charge_statusCharge statusCharges & paymentssucceeded, pending or failed.
stripe_currencyCurrencyCharges & paymentsThree-letter ISO currency code of the amount.
stripe_customer_default_payment_method_typeDefault payment method typeCharges & paymentsType of the customer's default payment method (card, sepa_debit, …) when Stripe returns it expanded; otherwise empty.
stripe_descriptionDescriptionCharges & paymentsFree-text description attached to the object.
stripe_disputed_paymentsDisputed paymentsCharges & paymentsCharges that received a dispute (chargeback).
stripe_failed_paymentsFailed paymentsCharges & paymentsCharges with status failed (declined or blocked).
stripe_failure_codeFailure codeCharges & paymentsDecline code of a failed charge: card_declined, insufficient_funds, expired_card, …
stripe_failure_messageFailure messageCharges & paymentsHuman-readable reason the charge failed.
stripe_first_payment_dateFirst payment dateCharges & paymentsDate of the customer's first successful payment within the lookback window (STRIPE_LOOKBACK_DAYS before the range); empt…
stripe_first_paymentsFirst paymentsCharges & paymentsCharges that were a customer's first successful payment within the lookback — a count of newly acquired customers on the…
stripe_gross_amountGross amountCharges & paymentsGross amount of the movement, signed: positive for money in, negative for money out.
stripe_invoice_next_payment_attemptInvoice next payment attemptCharges & paymentsDate of the next automatic payment attempt; empty when none is scheduled.
stripe_last_payment_dateLast payment dateCharges & paymentsDate of the customer's most recent successful payment up to the end of the range, within the lookback window.
stripe_livemodeLive modeCharges & payments1 when the key reads live data, 0 for a sandbox.
stripe_metadataMetadataCharges & paymentsThe object's metadata as a JSON string.
stripe_net_amountNet amountCharges & paymentsNet impact on the Stripe balance (gross − fees), signed.
stripe_net_payment_amountNet payment amountCharges & paymentsCaptured minus refunded, before Stripe fees; see balance_transactions.net_revenue for the after-fee figure.
stripe_outcome_network_statusOutcome network statusCharges & paymentsapproved_by_network, declined_by_network, not_sent_to_network or reversed_after_approval.
stripe_outcome_reasonOutcome reasonCharges & paymentsMachine-readable reason behind a declined or blocked outcome (e.g. highest_risk_level, rule).
stripe_outcome_risk_levelRisk levelCharges & paymentsRadar risk level: normal, elevated, highest; not_assessed / unknown when Radar did not score it.
stripe_outcome_seller_messageOutcome messageCharges & paymentsStripe's plain-English explanation of the outcome, for the merchant.
stripe_outcome_typeOutcome typeCharges & paymentsauthorized, manual_review, issuer_declined, blocked or invalid.
stripe_payment_amountPayment amountCharges & paymentsGross amount of the charge as requested, successful or not. Use captured_amount for money actually taken.
stripe_payment_intent_idPayment intent IDCharges & paymentsStripe payment intent id (pi_…).
stripe_payment_method_typePayment method typeCharges & paymentscard, link, sepa_debit, us_bank_account, paypal, klarna, …
stripe_payment_success_ratePayment success rateCharges & paymentsShare of attempted charges that succeeded: 1 for succeeded, 0 for failed, empty while pending. Unweighted average across…
stripe_paymentsPaymentsCharges & paymentsCount of charges (payment attempts). Always 1 per row; sum it.
stripe_receipt_emailReceipt emailCharges & paymentsAddress the receipt was sent to.
stripe_receipt_numberReceipt numberCharges & paymentsTransaction number shown on the customer's refund receipt.
stripe_receipt_urlReceipt URLCharges & paymentsLink to the hosted receipt.
stripe_risk_scoreRisk scoreCharges & paymentsRadar risk score (0-99) of the charge; empty when Radar did not evaluate it. Average across charges.
stripe_source_idSource IDCharges & paymentsId of the object that produced the movement (ch_, re_, po_, du_, …).
stripe_source_typeSource typeCharges & paymentsKind of the source object: charge, refund, payout, dispute, transfer, …
stripe_statement_descriptorStatement descriptorCharges & paymentsDescriptor requested for the customer's card statement.
stripe_statement_descriptor_suffixStatement descriptor suffixCharges & paymentsSuffix appended to the account's statement descriptor for this charge.
stripe_subscription_default_payment_method_typeDefault payment method typeCharges & paymentsType of the subscription's default payment method (card, sepa_debit, …) when Stripe returns it expanded; empty otherwise…
stripe_successful_paymentsSuccessful paymentsCharges & paymentsCharges with status succeeded.
stripe_transaction_statusTransaction statusCharges & paymentsavailable or pending.
stripe_transaction_typeTransaction typeCharges & paymentsStripe balance transaction type: charge, payment, refund, payout, adjustment, stripe_fee, transfer, …
stripe_transactionsTransactionsCharges & paymentsCount of balance transactions. Always 1 per row; sum it.
stripe_coupon_amount_offCoupon amount offCouponsFixed amount taken off the invoice subtotal, in the coupon's currency; 0 for percentage coupons.
stripe_coupon_durationCoupon durationCouponsforever, once or repeating.
stripe_coupon_duration_in_monthsCoupon duration in monthsCouponsMonths the discount applies for a repeating coupon; empty otherwise.
stripe_coupon_idCoupon IDCouponsStripe coupon id.
stripe_coupon_max_redemptionsCoupon max redemptionsCouponsMaximum number of redemptions across all customers; empty when unlimited.
stripe_coupon_nameCoupon nameCouponsName of the coupon as shown to customers on invoices and receipts.
stripe_coupon_percent_offCoupon percent offCouponsPercentage taken off the invoice subtotal (50 = 50%); empty for fixed-amount coupons.
stripe_coupon_redeem_byCoupon redeem byCouponsLast date the coupon can be redeemed; empty when it has no expiry.
stripe_coupon_times_redeemedCoupon times redeemedCouponsNumber of times the coupon has been applied to a customer.
stripe_coupon_validCoupon validCoupons1 when the coupon can still be applied to a customer.
stripe_couponsCouponsCouponsCount of coupons. Always 1 per row; sum it.
stripe_average_orders_per_customerAverage orders per customerCustomer metricsSuccessful payments per customer over the lookback window plus the date range, averaged across the customers in the resu…
stripe_customer_lifetime_valueCustomer lifetime valueCustomer metricsTotal spent minus total refunded over the lookback window plus the date range.
stripe_customer_payments_countCustomer payments countCustomer metricsNumber of successful payments by the customer over the lookback window plus the date range.
stripe_customer_total_spentCustomer total spentCustomer metricsAmount captured from the customer's successful payments over the lookback window plus the date range — not the account's…
stripe_customersCustomersCustomer metricsCount of customers. Always 1 per row; sum it.
stripe_delinquent_customersDelinquent customersCustomer metrics1 when the customer is delinquent.
stripe_new_customer_payment_amountNew customer payment amountCustomer metricsCaptured amount from customers whose first successful payment falls inside the date range (customer_type = New); 0 for o…
stripe_new_customersNew customersCustomer metrics1 when the customer's first successful payment (within the lookback window) falls inside the date range.
stripe_new_customers_payment_amountNew customers payment amountCustomer metricsAmount captured inside the date range from customers classified New.
stripe_new_customers_ratioNew customers ratioCustomer metrics1 for New customers, 0 otherwise; the average is the share of New customers among the rows.
stripe_returning_customer_payment_amountReturning customer payment amountCustomer metricsCaptured amount from customers who had already paid before the date range (customer_type = Returning); 0 for others.
stripe_returning_customers_payment_amountReturning customers payment amountCustomer metricsAmount captured inside the date range from customers classified Returning.
stripe_billing_cityBilling cityCustomersCity of the billing address.
stripe_billing_countryBilling countryCustomersCountry of the billing address.
stripe_billing_emailBilling emailCustomersEmail on the payment's billing details.
stripe_billing_nameBilling nameCustomersName on the payment's billing details.
stripe_billing_postal_codeBilling postal codeCustomersPostal code of the billing address.
stripe_billing_stateBilling stateCustomersState or region of the billing address.
stripe_customer_balanceCustomer balanceCustomersBalance stored on the customer, signed: negative is credit to apply to the next invoice, positive is an amount owed.
stripe_customer_cityCustomer cityCustomersCity of the customer's billing address.
stripe_customer_countryCustomer countryCustomersCountry of the customer's billing address.
stripe_customer_created_dateCustomer created dateCustomersDate the customer was created in Stripe (the row's date).
stripe_customer_delinquentCustomer delinquentCustomers1 when the customer's latest invoice payment failed or went past due and has not been settled since.
stripe_customer_emailCustomer emailCustomersEmail of the customer.
stripe_customer_idCustomer IDCustomersStripe customer id (cus_…).
stripe_customer_invoice_prefixCustomer invoice prefixCustomersPrefix Stripe uses to number this customer's invoices.
stripe_customer_nameCustomer nameCustomersFull name or business name on the customer.
stripe_customer_phoneCustomer phoneCustomersPhone number on the customer.
stripe_customer_postal_codeCustomer postal codeCustomersPostal code of the customer's billing address.
stripe_customer_stateCustomer stateCustomersState or region of the customer's billing address.
stripe_customer_tax_exemptCustomer tax exemptCustomersTax exemption status: none, exempt or reverse (reverse charge).
stripe_customer_typeCustomer typeCustomersNew when the customer's first successful payment falls inside the requested date range, Returning otherwise (lookback of…
stripe_cohort_monthCohort monthDate & timeThe customer's cohort: the calendar month (YYYYMM) of their first paid invoice, ever. A reactivated customer keeps their…
stripe_dateDateDate & timeDate, in the account's dashboard timezone.
stripe_date_timeDate and timeDate & timeTimestamp, in the account's dashboard timezone.
stripe_day_of_weekDay of weekDate & timeDay of the week (0 = Sunday … 6 = Saturday).
stripe_hourHourDate & timeHour of the day (00-23).
stripe_monthMonthDate & timeMonth of the year (01-12).
stripe_months_since_cohortMonths since cohortDate & timeWhole calendar months between the customer's cohort month and this row's month; 0 in the cohort month itself.
stripe_quarterQuarterDate & timeQuarter of the year (1-4).
stripe_weekWeekDate & timeISO week of the year (01-53).
stripe_yearYearDate & timeYear.
stripe_year_monthMonth and yearDate & timeYear and month (YYYYMM).
stripe_year_quarterQuarter and yearDate & timeYear and quarter (YYYYQ).
stripe_year_weekWeek and yearDate & timeISO year and week (YYYYWW).
stripe_dispute_amountDisputed amountDisputesAmount under dispute (usually the full charge).
stripe_dispute_has_evidenceHas evidenceDisputes1 when evidence has been submitted for the dispute.
stripe_dispute_idDispute IDDisputesStripe dispute id (du_… or dp_…).
stripe_dispute_is_inquiryIs inquiryDisputes1 for an inquiry or retrieval request (status warning_* or card case type inquiry) rather than a formal chargeback.
stripe_dispute_lost_amountLost dispute amountDisputesAmount of disputes with status lost; 0 for any other status.
stripe_dispute_network_reason_codeNetwork reason codeDisputesCard network's reason code for the dispute (e.g. Visa 10.4, Mastercard 4837).
stripe_dispute_past_duePast dueDisputes1 when the evidence deadline passed without a submission.
stripe_dispute_rateDispute rateDisputesShare of successful payments that were disputed: 1 or 0 per successful charge, empty for failed or pending ones. Unweigh…
stripe_dispute_reasonDispute reasonDisputesReason the cardholder gave: fraudulent, product_not_received, product_unacceptable, duplicate, subscription_canceled, cr…
stripe_dispute_reversals_amountDispute reversalsDisputesAmount returned when a dispute was won.
stripe_dispute_statusDispute statusDisputeswarning_needs_response, warning_under_review, warning_closed, needs_response, under_review, won, lost or prevented.
stripe_dispute_win_rateDispute win rateDisputesShare of closed disputes won: 1 for won, 0 for lost, empty while open or prevented. Unweighted average by count.
stripe_disputed_amountDisputed amountDisputesAmount withdrawn for disputes (chargebacks), as a positive number.
stripe_disputesDisputesDisputesCount of disputes and inquiries. Always 1 per row; sum it.
stripe_disputes_lostDisputes lostDisputesDisputes closed in the cardholder's favour; the amount and the dispute fee stay withdrawn.
stripe_disputes_openDisputes openDisputesDisputes still awaiting a response or under review (needs_response, under_review, warning_needs_response, warning_under_…
stripe_disputes_wonDisputes wonDisputesDisputes closed in the merchant's favour.
stripe_evidence_due_byEvidence due byDisputesDeadline for submitting evidence, in the account's dashboard timezone.
stripe_adjustments_amountAdjustmentsFees & balanceManual and other adjustments, signed.
stripe_application_fee_amountApplication fee amountFees & balanceFee collected by a Connect platform application on the charge.
stripe_application_feesApplication feesFees & balanceFees taken by a Connect platform application.
stripe_available_balanceAvailable balanceFees & balanceFunds available to pay out right now, per currency (snapshot at query time).
stripe_balance_transaction_idBalance transaction IDFees & balanceBalance transaction id (txn_…) that records the money movement.
stripe_connect_reserved_balanceConnect reserved balanceFees & balanceFunds reserved for Connect obligations, per currency.
stripe_exchange_rateExchange rateFees & balanceRate applied when the presentment currency differs from the settlement currency.
stripe_fee_rateFee rateFees & balanceFees ÷ gross amount per payment movement (unweighted average across rows; use fees ÷ gross_volume for the exact rate).
stripe_fee_typeFee typeFees & balanceComma-separated fee_details types on the movement: stripe_fee, application_fee, tax.
stripe_feesFeesFees & balanceFees taken by Stripe (and applications) on the movement.
stripe_instant_available_balanceInstant available balanceFees & balanceFunds eligible for Instant Payouts, per currency.
stripe_pending_balancePending balanceFees & balanceFunds not yet available, per currency (snapshot at query time).
stripe_reporting_categoryReporting categoryFees & balanceAccounting category: charge, refund, dispute, dispute_reversal, fee, payout, payout_reversal, transfer, other_adjustment…
stripe_stripe_feesStripe feesFees & balanceProcessing fees charged by Stripe.
stripe_tax_feesTax feesFees & balanceStripe Tax fees.
stripe_line_item_amountLine item amountInvoice line itemsAmount of the line after line-level discounts, before tax; negative for credits and proration refunds.
stripe_line_item_discount_amountLine item discount amountInvoice line itemsSum of the discounts applied to the line.
stripe_line_item_discountableLine item discountableInvoice line items1 when invoice-level discounts apply to the line.
stripe_line_item_idLine item IDInvoice line itemsStripe invoice line item id (il_…).
stripe_line_item_metadataLine item metadataInvoice line itemsThe line item's metadata as a JSON string (for subscription lines, the subscription's metadata).
stripe_line_item_prorationLine item prorationInvoice line items1 when the line is a proration credit or charge from a mid-cycle plan change.
stripe_line_item_quantityLine item quantityInvoice line itemsUnits billed on the line (whole units; usage lines may be truncated).
stripe_line_item_subtotalLine item subtotalInvoice line itemsAmount of the line before any discounts or taxes.
stripe_line_item_tax_amountLine item tax amountInvoice line itemsSum of the taxes on the line.
stripe_line_item_typeLine item typeInvoice line itemsWhat generated the line: subscription_item_details (a subscription item) or invoice_item_details (a one-off invoice item…
stripe_line_item_unit_amountLine item unit amountInvoice line itemsPrice per unit on the line; may carry fractions of a cent for usage pricing.
stripe_line_itemsLine itemsInvoice line itemsCount of invoice line items. Always 1 per row; sum it.
stripe_line_period_endLine period endInvoice line itemsEnd of the service period the line covers.
stripe_line_period_startLine period startInvoice line itemsStart of the service period the line covers.
stripe_average_days_to_payAverage days to payInvoicesAverage days from finalization to payment across paid invoices; unpaid invoices are left out.
stripe_average_invoice_valueAverage invoice valueInvoicesAverage invoice total.
stripe_draft_invoicesDraft invoicesInvoices1 when the invoice is still a draft.
stripe_invoice_aging_bucketInvoice aging bucketInvoicesAge of open invoices at the end of the date range: current (not yet due), 1-30, 31-60, 61-90 or 90+ days overdue; empty …
stripe_invoice_amount_dueInvoice amount dueInvoicesAmount due after applying the customer's credit balance.
stripe_invoice_amount_overpaidInvoice amount overpaidInvoicesAmount paid above the total, credited to the customer's balance.
stripe_invoice_amount_paidInvoice amount paidInvoicesAmount paid so far.
stripe_invoice_amount_paid_off_stripeInvoice amount paid off StripeInvoicesAmount recorded as paid outside Stripe.
stripe_invoice_amount_remainingInvoice amount remainingInvoicesAmount due minus amount paid.
stripe_invoice_attempt_countInvoice attempt countInvoicesNumber of payment attempts made on the invoice.
stripe_invoice_attemptedInvoice attemptedInvoices1 when Stripe has attempted to collect payment at least once.
stripe_invoice_billing_reasonInvoice billing reasonInvoicesWhy the invoice was created: subscription_create, subscription_cycle, subscription_update, subscription_threshold, manua…
stripe_invoice_collection_methodInvoice collection methodInvoicescharge_automatically or send_invoice.
stripe_invoice_collection_rateInvoice collection rateInvoices1 for paid invoices, 0 for open and uncollectible ones, empty for drafts and voids; the average is the share of finalize…
stripe_invoice_credit_notes_amountInvoice credit notes amountInvoicesAmount of credit notes issued against the invoice, before and after payment.
stripe_invoice_customer_countryInvoice customer countryInvoicesCountry of the customer's billing address as printed on the invoice.
stripe_invoice_customer_nameInvoice customer nameInvoicesCustomer name as printed on the invoice (a snapshot taken at finalization).
stripe_invoice_customer_tax_exemptInvoice customer tax exemptInvoicesCustomer tax status at finalization: none, exempt or reverse.
stripe_invoice_days_overdueInvoice days overdueInvoicesDays between the due date and the end of the date range, for open invoices past their due date; empty otherwise.
stripe_invoice_days_to_payInvoice days to payInvoicesDays between finalization (or creation) and payment; empty when unpaid.
stripe_invoice_discount_amountInvoice discount amountInvoicesSum of the discounts applied at invoice level.
stripe_invoice_due_dateInvoice due dateInvoicesPayment due date; set for send_invoice collection, empty for automatic charging.
stripe_invoice_ending_balanceInvoice ending balanceInvoicesCustomer balance after the invoice was applied (negative is credit).
stripe_invoice_finalized_dateInvoice finalized dateInvoicesDate the invoice was finalized (became payable).
stripe_invoice_hosted_urlInvoice hosted URLInvoicesStripe-hosted page where the invoice can be viewed and paid.
stripe_invoice_idInvoice IDInvoicesStripe invoice id (in_…).
stripe_invoice_numberInvoice numberInvoicesHuman-readable invoice number (prefix-sequence), assigned at finalization.
stripe_invoice_overdue_amountInvoice overdue amountInvoicesAmount remaining on open invoices past their due date at the end of the date range; 0 otherwise.
stripe_invoice_paid_dateInvoice paid dateInvoicesDate the invoice was paid; empty when unpaid.
stripe_invoice_paid_out_of_bandInvoice paid out of bandInvoices1 when part or all of the invoice was paid outside Stripe (marked paid manually).
stripe_invoice_pdf_urlInvoice PDF URLInvoicesDownload link for the invoice PDF.
stripe_invoice_period_endInvoice period endInvoicesEnd of the usage period the invoice covers.
stripe_invoice_period_startInvoice period startInvoicesStart of the usage period the invoice covers.
stripe_invoice_shipping_amountInvoice shipping amountInvoicesShipping charged on the invoice.
stripe_invoice_starting_balanceInvoice starting balanceInvoicesCustomer balance before the invoice was applied (negative is credit).
stripe_invoice_statusInvoice statusInvoicesdraft, open, paid, uncollectible or void.
stripe_invoice_subtotalInvoice subtotalInvoicesSum of the line items before invoice-level discounts and tax.
stripe_invoice_taxInvoice taxInvoicesSum of the taxes on the invoice.
stripe_invoice_totalInvoice totalInvoicesTotal after discounts and tax — what the customer is asked to pay.
stripe_invoice_total_excluding_taxInvoice total excluding taxInvoicesTotal after discounts, before tax.
stripe_invoice_uncollectible_dateInvoice uncollectible dateInvoicesDate the invoice was marked uncollectible; empty otherwise.
stripe_invoice_voided_dateInvoice voided dateInvoicesDate the invoice was voided; empty otherwise.
stripe_invoicesInvoicesInvoicesCount of invoices. Always 1 per row; sum it.
stripe_open_invoicesOpen invoicesInvoices1 when the invoice status is open (finalized, awaiting payment).
stripe_paid_invoicesPaid invoicesInvoices1 when the invoice status is paid.
stripe_uncollectible_invoicesUncollectible invoicesInvoices1 when the invoice was marked uncollectible.
stripe_void_invoicesVoid invoicesInvoices1 when the invoice was voided.
stripe_average_payout_amountAverage payout amountPayoutsAverage amount per payout.
stripe_failed_payoutsFailed payoutsPayoutsPayouts with status failed (the funds returned to the Stripe balance).
stripe_paid_payout_amountPaid payout amountPayoutsAmount of payouts with status paid; 0 for pending, in-transit, canceled or failed ones.
stripe_payout_amountPayout amountPayoutsAmount of the payout, whether or not it arrived; see paid_payout_amount for money that reached the bank.
stripe_payout_arrival_dateArrival datePayoutsDate the funds are expected to (or did) arrive at the destination, in the account's dashboard timezone.
stripe_payout_automaticAutomatic payoutPayouts1 for a payout created by the account's automatic schedule, 0 for a manual one.
stripe_payout_destination_idDestination IDPayoutsBank account (ba_…) or card (card_…) the payout was sent to.
stripe_payout_failure_codePayout failure codePayoutsWhy the payout failed: account_closed, insufficient_funds, no_account, invalid_account_number, …
stripe_payout_failure_messagePayout failure messagePayoutsHuman-readable reason the payout failed.
stripe_payout_idPayout IDPayoutsStripe payout id (po_…).
stripe_payout_methodPayout methodPayoutsstandard or instant.
stripe_payout_reconciliation_statusReconciliation statusPayoutscompleted, in_progress or not_applicable — whether the payout's balance transactions have been reconciled.
stripe_payout_reversals_amountPayout reversalsPayoutsAmount returned by failed or cancelled payouts.
stripe_payout_source_typePayout source typePayoutsBalance the payout was drawn from: card, fpx or bank_account.
stripe_payout_statement_descriptorPayout statement descriptorPayoutsDescriptor shown on the bank statement for the payout.
stripe_payout_statusPayout statusPayoutspaid, pending, in_transit, canceled or failed.
stripe_payout_typePayout typePayoutsbank_account or card.
stripe_payoutsPayoutsPayoutsCount of payouts, any status. Always 1 per row; sum it.
stripe_payouts_amountPayoutsPayoutsAmount paid out to the bank account, as a positive number.
stripe_pending_payout_amountPending payout amountPayoutsAmount of payouts still pending or in transit to the bank; 0 for others.
stripe_price_activePrice activeProducts & prices1 when the price can be used for new purchases, 0 when archived.
stripe_price_billing_schemePrice billing schemeProducts & pricesper_unit or tiered.
stripe_price_created_datePrice created dateProducts & pricesDate the price was created.
stripe_price_idPrice IDProducts & pricesStripe price id (price_…).
stripe_price_intervalPrice intervalProducts & pricesBilling interval of a recurring price: day, week, month or year; empty for one-time prices.
stripe_price_interval_countPrice interval countProducts & pricesNumber of intervals between billings (interval=month, interval_count=3 bills quarterly); empty for one-time prices.
stripe_price_lookup_keyPrice lookup keyProducts & pricesLookup key used to reference the price from code.
stripe_price_monthly_amountPrice monthly amountProducts & pricesUnit amount normalised to one month (month ÷ n, year ÷ 12n, week × 52 ÷ 12n, day × 365 ÷ 12n), rounded to the minor unit…
stripe_price_nicknamePrice nicknameProducts & pricesInternal nickname of the price (hidden from customers).
stripe_price_tiers_modePrice tiers modeProducts & pricesgraduated or volume for tiered prices; empty otherwise.
stripe_price_typePrice typeProducts & pricesone_time or recurring.
stripe_price_unit_amountPrice unit amountProducts & pricesAmount charged per unit and billing period (per_unit prices; empty-equivalent 0 for tiered).
stripe_price_usage_typePrice usage typeProducts & priceslicensed (bills the subscribed quantity) or metered (bills reported usage); empty for one-time prices.
stripe_pricesPricesProducts & pricesCount of prices. Always 1 per row; sum it.
stripe_product_activeProduct activeProducts & prices1 when the product is available for purchase, 0 when archived.
stripe_product_created_dateProduct created dateProducts & pricesDate the product was created.
stripe_product_default_price_idProduct default price IDProducts & pricesId of the product's default price (price_…).
stripe_product_descriptionProduct descriptionProducts & pricesCustomer-facing description of the product.
stripe_product_idProduct IDProducts & pricesStripe product id (prod_…).
stripe_product_image_urlProduct image URLProducts & pricesFirst image URL of the product.
stripe_product_metadataProduct metadataProducts & pricesThe product's metadata as a JSON string.
stripe_product_nameProduct nameProducts & pricesName of the product.
stripe_product_revenueProduct revenueProducts & pricesLine amount when the invoice is paid, 0 otherwise — revenue by product and price.
stripe_product_typeProduct typeProducts & pricesgood or service.
stripe_product_unit_labelProduct unit labelProducts & pricesLabel for one unit of the product, as shown on invoices and receipts (seat, GB, …).
stripe_product_units_soldProduct units soldProducts & pricesLine quantity when the invoice is paid, 0 otherwise.
stripe_product_updated_dateProduct updated dateProducts & pricesDate the product was last updated.
stripe_product_urlProduct URLProducts & pricesPublic web page of the product.
stripe_productsProductsProducts & pricesCount of products. Always 1 per row; sum it.
stripe_amount_refundedAmount refundedRefundsAmount refunded on the charge so far, full or partial.
stripe_average_refund_amountAverage refund amountRefundsAverage amount per refund.
stripe_charge_refundedFully refundedRefunds1 when the whole charge was refunded. A partial refund leaves this 0 — see amount_refunded.
stripe_customer_refunded_totalCustomer refunded totalRefundsAmount refunded on the customer's payments over the lookback window plus the date range.
stripe_dispute_is_charge_refundableCharge refundableRefunds1 when the disputed charge can still be refunded (useful to settle an inquiry before it becomes a chargeback).
stripe_failed_refundsFailed refundsRefundsRefunds with status failed (the customer's bank could not receive the money).
stripe_refund_amountRefund amountRefundsAmount of the refund, whether or not it succeeded; see succeeded_refund_amount for money that actually went back.
stripe_refund_destination_typeRefund destination typeRefundsWhere the money was returned to: card, us_bank_transfer, paypal, customer_cash_balance, …
stripe_refund_failure_reasonRefund failure reasonRefundsWhy a failed refund could not be delivered: lost_or_stolen_card, expired_or_canceled_card, charge_for_pending_refund_dis…
stripe_refund_idRefund IDRefundsStripe refund id (re_… or pyr_…).
stripe_refund_rateRefund rateRefundsShare of successful payments that were refunded (fully or partially): 1 or 0 per successful charge, empty for failed or …
stripe_refund_reasonRefund reasonRefundsduplicate, fraudulent, requested_by_customer or expired_uncaptured_charge.
stripe_refund_statusRefund statusRefundspending, requires_action, succeeded, failed or canceled.
stripe_refunded_amountRefunded amountRefundsAmount refunded to customers (reporting categories refund and partial_capture_reversal), as a positive number.
stripe_refunded_paymentsRefunded paymentsRefundsCharges that were refunded in full or in part.
stripe_refundsRefundsRefundsCount of refunds, any status. Always 1 per row; sum it.
stripe_succeeded_refund_amountSucceeded refund amountRefundsAmount of refunds with status succeeded; 0 for pending, failed or canceled refunds.
stripe_arpuARPURevenue & MRRAverage revenue per user = MRR ÷ active subscribers, per day. Average it across days, never sum it. Empty when there are…
stripe_arrARRRevenue & MRRAnnual recurring revenue = MRR × 12.
stripe_churned_mrrChurned MRRRevenue & MRRMRR lost by customers whose MRR went to zero, as a positive number, netted per customer within the calendar month.
stripe_contraction_mrrContraction MRRRevenue & MRRMRR lost that day by customers who kept paying less (downgrades, removed seats or products), as a positive number.
stripe_delinquent_churned_mrrDelinquent churned MRRRevenue & MRRChurned MRR lost to customers Stripe could not collect from: a cycle invoice marked uncollectible, a subscription cancel…
stripe_expansion_mrrExpansion MRRRevenue & MRRMRR added that day by customers who were already paying (upgrades, added seats or products).
stripe_gross_volumeGross volumeRevenue & MRRGross amount of successful payments (reporting category = charge).
stripe_mrrMRRRevenue & MRRMonthly recurring revenue in the row's currency, reconstructed from the paid invoices: every subscription line item's ne…
stripe_mrr_at_entryMRR at entryRevenue & MRRThe customer's TOTAL end-of-month MRR in their cohort month — constant for the customer, repeated on every product row: …
stripe_mrr_churn_typeMRR churn typeRevenue & MRRWhy the cell churned, for rows whose movement is churn: voluntary (the customer or merchant canceled) or delinquent (Str…
stripe_mrr_growth_rateMRR growth rateRevenue & MRRMRR ÷ previous day's MRR − 1. Empty when the previous day had no MRR.
stripe_mrr_movement_typeMRR movement typeRevenue & MRRHow the cell's MRR changed since the day before: new, expansion, contraction, churn, reactivation or none.
stripe_net_new_mrrNet new MRRRevenue & MRRnew + expansion + reactivation − contraction − churned MRR. Movements are netted per customer within the calendar month,…
stripe_net_revenueNet revenueRevenue & MRRNet of payments, refunds and disputes after Stripe fees (what actually stays in the balance from sales).
stripe_net_revenue_retentionNet revenue retentionRevenue & MRR(MRR 30 days earlier − churned − contraction + expansion + reactivation over those 30 days) ÷ MRR 30 days earlier. Empty…
stripe_new_mrrNew MRRRevenue & MRRMRR added by customers who had never paid before. Movements are netted per customer within the calendar month (ProfitWel…
stripe_reactivation_mrrReactivation MRRRevenue & MRRMRR added that day by customers who had churned before and came back.
stripe_revenue_churn_rateRevenue churn rateRevenue & MRR(churned + contraction MRR over the trailing 30 days) ÷ MRR 30 days earlier. Empty when there was no MRR then.
stripe_subscription_mrrSubscription MRRRevenue & MRRThis subscription's monthly recurring revenue as of the window end, reconstructed from its paid invoices (net line amoun…
stripe_voluntary_churned_mrrVoluntary churned MRRRevenue & MRRChurned MRR lost that day to customers who canceled (cancellation reason cancellation_requested, or none recorded), as a…
stripe_active_subscribersActive subscribersSubscription metricsDistinct customers with MRR > 0 at the end of the day (active or past_due subscriptions past their trial). Counted once …
stripe_active_subscriptionsActive subscriptionsSubscription metrics1 when the status is active or past_due (Stripe counts past_due as active until it becomes unpaid or canceled).
stripe_average_subscription_valueAverage subscription valueSubscription metricsAverage subscription_mrr per subscription.
stripe_canceled_subscriptionsCanceled subscriptionsSubscription metrics1 when the status is canceled.
stripe_churned_subscribersChurned subscribersSubscription metricsCustomers whose MRR went from positive to zero that day.
stripe_churned_subscriptionsChurned subscriptionsSubscription metrics1 when the subscription ended (or was canceled) inside the requested date range and its status is canceled or unpaid.
stripe_delinquent_churned_subscribersDelinquent churned subscribersSubscription metricsCustomers whose MRR went to zero that day because Stripe ended their subscription over failed payments or a dispute (a c…
stripe_has_active_subscriptionHas active subscriptionSubscription metrics1 when the customer has an active or past_due subscription as of the query.
stripe_incomplete_subscriptionsIncomplete subscriptionsSubscription metrics1 when the status is incomplete or incomplete_expired.
stripe_new_subscribersNew subscribersSubscription metricsCustomers whose MRR went from zero to positive that day and who had never paid before.
stripe_new_subscriptionsNew subscriptionsSubscription metrics1 when the start date falls inside the requested date range.
stripe_past_due_subscriptionsPast due subscriptionsSubscription metrics1 when the status is past_due.
stripe_paused_subscriptionsPaused subscriptionsSubscription metrics1 when the status is paused.
stripe_reactivated_subscribersReactivated subscribersSubscription metricsCustomers whose MRR went from zero to positive that day after having churned before.
stripe_subscriber_churn_rateSubscriber churn rateSubscription metricsCustomers churned over the trailing 30 days ÷ (active subscribers 30 days earlier + new subscribers over those 30 days).…
stripe_subscriptionsSubscriptionsSubscription metricsCount of subscriptions. Always 1 per row; sum it.
stripe_trial_conversion_rateTrial conversion rateSubscription metricstrial_conversions ÷ subscriptions whose trial has ended; empty for subscriptions that never trialed so the average ignor…
stripe_trial_conversionsTrial conversionsSubscription metrics1 when the subscription had a trial that ended and went on to a paid period (still active/past_due, or ended more than a…
stripe_trialing_subscriptionsTrialing subscriptionsSubscription metrics1 when the status is trialing.
stripe_unpaid_subscriptionsUnpaid subscriptionsSubscription metrics1 when the status is unpaid.
stripe_voluntary_churned_subscribersVoluntary churned subscribersSubscription metricsCustomers whose MRR went to zero that day because they canceled.
stripe_subscription_age_daysSubscription age (days)SubscriptionsWhole days from the start date to the end of the date range.
stripe_subscription_arrSubscription ARRSubscriptionsThis subscription's annual recurring revenue = subscription_mrr × 12.
stripe_subscription_billing_cycle_anchorBilling cycle anchorSubscriptionsDate the billing cycle is anchored on.
stripe_subscription_cancel_atCancel atSubscriptionsDate a scheduled cancellation takes effect.
stripe_subscription_cancel_at_period_endCancel at period endSubscriptions1 when the subscription is set to cancel at the end of the current period.
stripe_subscription_canceled_atCanceled atSubscriptionsDate the cancellation was requested.
stripe_subscription_cancellation_commentCancellation commentSubscriptionsFree-text comment left by the customer on cancellation.
stripe_subscription_cancellation_feedbackCancellation feedbackSubscriptionsCustomer-selected feedback: too_expensive, missing_features, switched_service, unused, customer_service, too_complex, lo…
stripe_subscription_cancellation_reasonCancellation reasonSubscriptionsWhy it was canceled: cancellation_requested, payment_disputed, payment_failed.
stripe_subscription_collection_methodCollection methodSubscriptionscharge_automatically or send_invoice.
stripe_subscription_coupon_nameCoupon nameSubscriptionsName of the coupon applied to the subscription.
stripe_subscription_created_dateSubscription created dateSubscriptionsDate the subscription object was created.
stripe_subscription_current_period_endCurrent period endSubscriptionsEnd of the current billing period of the primary item (next renewal).
stripe_subscription_current_period_startCurrent period startSubscriptionsStart of the current billing period of the primary item.
stripe_subscription_days_until_dueDays until dueSubscriptionsFor send_invoice subscriptions, days the customer has to pay each invoice.
stripe_subscription_discount_amount_offDiscount amount offSubscriptionsFixed amount off per billing period of the subscription-level coupon, in the coupon's currency.
stripe_subscription_discount_percent_offDiscount percent offSubscriptionsPercentage discount of the subscription-level coupon.
stripe_subscription_ended_atEnded atSubscriptionsDate the subscription actually ended.
stripe_subscription_idSubscription IDSubscriptionsStripe subscription id (sub_…).
stripe_subscription_is_trialingIs trialingSubscriptions1 while the subscription status is trialing.
stripe_subscription_item_amountItem amountSubscriptionsΣ quantity × unit amount across the subscription's items, per billing period (tiers computed; metered items contribute 0…
stripe_subscription_item_countItem countSubscriptionsNumber of items (prices) on the subscription.
stripe_subscription_item_idSubscription item IDSubscriptionsStripe subscription item id (si_…).
stripe_subscription_latest_invoice_idLatest invoice IDSubscriptionsId of the most recent invoice of the subscription (in_…).
stripe_subscription_lifetime_monthsSubscription lifetime (months)SubscriptionsMonths from the start date to the end date (or to the end of the date range while it runs), as days ÷ 30.4375.
stripe_subscription_ltvSubscription LTVSubscriptionsCustomer lifetime value = ARPU ÷ subscriber churn rate (trailing 30 days). Empty when either is unavailable or churn is …
stripe_subscription_plan_labelPlanSubscriptionsProduct name and billing interval of the primary item, e.g. "Pro / month" or "Pro / 3 months".
stripe_subscription_quantityQuantitySubscriptionsQuantity of the primary item.
stripe_subscription_schedule_idSchedule IDSubscriptionsId of the subscription schedule managing this subscription (sub_sched_…), if any.
stripe_subscription_start_dateSubscription start dateSubscriptionsDate the subscription started (start_date; can be earlier than created when backdated).
stripe_subscription_statusSubscription statusSubscriptionsStripe subscription status: incomplete, incomplete_expired, trialing, active, past_due, canceled, unpaid, paused.
stripe_subscription_trial_endTrial endSubscriptionsDate the trial ends or ended, if any.
stripe_subscription_trial_startTrial startSubscriptionsDate the trial started, if any.
stripe_subscription_unit_amountUnit amountSubscriptionsUnit amount of the primary item's price per billing period (empty for tiered prices).