Fields Reference · Stripe
Stripe Fields List
352 fields · 201 dimensions · 151 metrics · 16 groups
| Field name | Label | Category | Description |
|---|---|---|---|
stripe_account_country | Account country | Account | Country of the Stripe account. |
stripe_account_default_currency | Account default currency | Account | Settlement currency of the Stripe account. |
stripe_account_id | Account ID | Account | Stripe account id (acct_…). |
stripe_account_name | Account name | Account | Business name of the Stripe account. |
stripe_available_on_date | Available on | Charges & payments | Date the net funds became (or become) available in the Stripe balance. |
stripe_average_payment_value | Average payment value | Charges & payments | Average gross amount per charge (includes failed attempts; filter charge_status = succeeded for the average successful p… |
stripe_avg_transaction_amount | Average transaction amount | Charges & payments | Average gross amount per balance transaction. |
stripe_blocked_payments | Blocked payments | Charges & payments | Charges blocked by Radar rules or risk (outcome type = blocked). |
stripe_calculated_statement_descriptor | Statement descriptor (as shown) | Charges & payments | The descriptor Stripe actually put on the customer's statement. |
stripe_captured_amount | Captured amount | Charges & payments | Amount actually captured from the customer (0 for failed or uncaptured charges). |
stripe_card_brand | Card brand | Charges & payments | Card brand: visa, mastercard, amex, … |
stripe_card_country | Card country | Charges & payments | Country of the card's issuing bank. |
stripe_card_funding | Card funding | Charges & payments | credit, debit, prepaid or unknown. |
stripe_card_last4 | Card last 4 | Charges & payments | Last four digits of the card. |
stripe_card_network | Card network | Charges & payments | Network the charge was processed on: visa, mastercard, amex, cartes_bancaires, … |
stripe_card_wallet | Card wallet | Charges & payments | Digital wallet used, if any: apple_pay, google_pay, link, samsung_pay, … |
stripe_charge_captured | Captured | Charges & payments | 1 when the authorised funds were captured; 0 for an authorisation still awaiting capture. |
stripe_charge_disputed | Disputed | Charges & payments | 1 when the customer's bank opened a dispute (chargeback) on the charge. |
stripe_charge_first_payment | First payment | Charges & payments | 1 when this charge is the customer's first successful payment within the lookback (STRIPE_LOOKBACK_DAYS) — the payment t… |
stripe_charge_id | Charge ID | Charges & payments | Stripe charge id (ch_…). |
stripe_charge_paid | Paid | Charges & payments | 1 when the charge was paid (succeeded, or a pending bank debit that is expected to settle). |
stripe_charge_status | Charge status | Charges & payments | succeeded, pending or failed. |
stripe_currency | Currency | Charges & payments | Three-letter ISO currency code of the amount. |
stripe_customer_default_payment_method_type | Default payment method type | Charges & payments | Type of the customer's default payment method (card, sepa_debit, …) when Stripe returns it expanded; otherwise empty. |
stripe_description | Description | Charges & payments | Free-text description attached to the object. |
stripe_disputed_payments | Disputed payments | Charges & payments | Charges that received a dispute (chargeback). |
stripe_failed_payments | Failed payments | Charges & payments | Charges with status failed (declined or blocked). |
stripe_failure_code | Failure code | Charges & payments | Decline code of a failed charge: card_declined, insufficient_funds, expired_card, … |
stripe_failure_message | Failure message | Charges & payments | Human-readable reason the charge failed. |
stripe_first_payment_date | First payment date | Charges & payments | Date of the customer's first successful payment within the lookback window (STRIPE_LOOKBACK_DAYS before the range); empt… |
stripe_first_payments | First payments | Charges & payments | Charges that were a customer's first successful payment within the lookback — a count of newly acquired customers on the… |
stripe_gross_amount | Gross amount | Charges & payments | Gross amount of the movement, signed: positive for money in, negative for money out. |
stripe_invoice_next_payment_attempt | Invoice next payment attempt | Charges & payments | Date of the next automatic payment attempt; empty when none is scheduled. |
stripe_last_payment_date | Last payment date | Charges & payments | Date of the customer's most recent successful payment up to the end of the range, within the lookback window. |
stripe_livemode | Live mode | Charges & payments | 1 when the key reads live data, 0 for a sandbox. |
stripe_metadata | Metadata | Charges & payments | The object's metadata as a JSON string. |
stripe_net_amount | Net amount | Charges & payments | Net impact on the Stripe balance (gross − fees), signed. |
stripe_net_payment_amount | Net payment amount | Charges & payments | Captured minus refunded, before Stripe fees; see balance_transactions.net_revenue for the after-fee figure. |
stripe_outcome_network_status | Outcome network status | Charges & payments | approved_by_network, declined_by_network, not_sent_to_network or reversed_after_approval. |
stripe_outcome_reason | Outcome reason | Charges & payments | Machine-readable reason behind a declined or blocked outcome (e.g. highest_risk_level, rule). |
stripe_outcome_risk_level | Risk level | Charges & payments | Radar risk level: normal, elevated, highest; not_assessed / unknown when Radar did not score it. |
stripe_outcome_seller_message | Outcome message | Charges & payments | Stripe's plain-English explanation of the outcome, for the merchant. |
stripe_outcome_type | Outcome type | Charges & payments | authorized, manual_review, issuer_declined, blocked or invalid. |
stripe_payment_amount | Payment amount | Charges & payments | Gross amount of the charge as requested, successful or not. Use captured_amount for money actually taken. |
stripe_payment_intent_id | Payment intent ID | Charges & payments | Stripe payment intent id (pi_…). |
stripe_payment_method_type | Payment method type | Charges & payments | card, link, sepa_debit, us_bank_account, paypal, klarna, … |
stripe_payment_success_rate | Payment success rate | Charges & payments | Share of attempted charges that succeeded: 1 for succeeded, 0 for failed, empty while pending. Unweighted average across… |
stripe_payments | Payments | Charges & payments | Count of charges (payment attempts). Always 1 per row; sum it. |
stripe_receipt_email | Receipt email | Charges & payments | Address the receipt was sent to. |
stripe_receipt_number | Receipt number | Charges & payments | Transaction number shown on the customer's refund receipt. |
stripe_receipt_url | Receipt URL | Charges & payments | Link to the hosted receipt. |
stripe_risk_score | Risk score | Charges & payments | Radar risk score (0-99) of the charge; empty when Radar did not evaluate it. Average across charges. |
stripe_source_id | Source ID | Charges & payments | Id of the object that produced the movement (ch_, re_, po_, du_, …). |
stripe_source_type | Source type | Charges & payments | Kind of the source object: charge, refund, payout, dispute, transfer, … |
stripe_statement_descriptor | Statement descriptor | Charges & payments | Descriptor requested for the customer's card statement. |
stripe_statement_descriptor_suffix | Statement descriptor suffix | Charges & payments | Suffix appended to the account's statement descriptor for this charge. |
stripe_subscription_default_payment_method_type | Default payment method type | Charges & payments | Type of the subscription's default payment method (card, sepa_debit, …) when Stripe returns it expanded; empty otherwise… |
stripe_successful_payments | Successful payments | Charges & payments | Charges with status succeeded. |
stripe_transaction_status | Transaction status | Charges & payments | available or pending. |
stripe_transaction_type | Transaction type | Charges & payments | Stripe balance transaction type: charge, payment, refund, payout, adjustment, stripe_fee, transfer, … |
stripe_transactions | Transactions | Charges & payments | Count of balance transactions. Always 1 per row; sum it. |
stripe_coupon_amount_off | Coupon amount off | Coupons | Fixed amount taken off the invoice subtotal, in the coupon's currency; 0 for percentage coupons. |
stripe_coupon_duration | Coupon duration | Coupons | forever, once or repeating. |
stripe_coupon_duration_in_months | Coupon duration in months | Coupons | Months the discount applies for a repeating coupon; empty otherwise. |
stripe_coupon_id | Coupon ID | Coupons | Stripe coupon id. |
stripe_coupon_max_redemptions | Coupon max redemptions | Coupons | Maximum number of redemptions across all customers; empty when unlimited. |
stripe_coupon_name | Coupon name | Coupons | Name of the coupon as shown to customers on invoices and receipts. |
stripe_coupon_percent_off | Coupon percent off | Coupons | Percentage taken off the invoice subtotal (50 = 50%); empty for fixed-amount coupons. |
stripe_coupon_redeem_by | Coupon redeem by | Coupons | Last date the coupon can be redeemed; empty when it has no expiry. |
stripe_coupon_times_redeemed | Coupon times redeemed | Coupons | Number of times the coupon has been applied to a customer. |
stripe_coupon_valid | Coupon valid | Coupons | 1 when the coupon can still be applied to a customer. |
stripe_coupons | Coupons | Coupons | Count of coupons. Always 1 per row; sum it. |
stripe_average_orders_per_customer | Average orders per customer | Customer metrics | Successful payments per customer over the lookback window plus the date range, averaged across the customers in the resu… |
stripe_customer_lifetime_value | Customer lifetime value | Customer metrics | Total spent minus total refunded over the lookback window plus the date range. |
stripe_customer_payments_count | Customer payments count | Customer metrics | Number of successful payments by the customer over the lookback window plus the date range. |
stripe_customer_total_spent | Customer total spent | Customer metrics | Amount captured from the customer's successful payments over the lookback window plus the date range — not the account's… |
stripe_customers | Customers | Customer metrics | Count of customers. Always 1 per row; sum it. |
stripe_delinquent_customers | Delinquent customers | Customer metrics | 1 when the customer is delinquent. |
stripe_new_customer_payment_amount | New customer payment amount | Customer metrics | Captured amount from customers whose first successful payment falls inside the date range (customer_type = New); 0 for o… |
stripe_new_customers | New customers | Customer metrics | 1 when the customer's first successful payment (within the lookback window) falls inside the date range. |
stripe_new_customers_payment_amount | New customers payment amount | Customer metrics | Amount captured inside the date range from customers classified New. |
stripe_new_customers_ratio | New customers ratio | Customer metrics | 1 for New customers, 0 otherwise; the average is the share of New customers among the rows. |
stripe_returning_customer_payment_amount | Returning customer payment amount | Customer metrics | Captured amount from customers who had already paid before the date range (customer_type = Returning); 0 for others. |
stripe_returning_customers_payment_amount | Returning customers payment amount | Customer metrics | Amount captured inside the date range from customers classified Returning. |
stripe_billing_city | Billing city | Customers | City of the billing address. |
stripe_billing_country | Billing country | Customers | Country of the billing address. |
stripe_billing_email | Billing email | Customers | Email on the payment's billing details. |
stripe_billing_name | Billing name | Customers | Name on the payment's billing details. |
stripe_billing_postal_code | Billing postal code | Customers | Postal code of the billing address. |
stripe_billing_state | Billing state | Customers | State or region of the billing address. |
stripe_customer_balance | Customer balance | Customers | Balance stored on the customer, signed: negative is credit to apply to the next invoice, positive is an amount owed. |
stripe_customer_city | Customer city | Customers | City of the customer's billing address. |
stripe_customer_country | Customer country | Customers | Country of the customer's billing address. |
stripe_customer_created_date | Customer created date | Customers | Date the customer was created in Stripe (the row's date). |
stripe_customer_delinquent | Customer delinquent | Customers | 1 when the customer's latest invoice payment failed or went past due and has not been settled since. |
stripe_customer_email | Customer email | Customers | Email of the customer. |
stripe_customer_id | Customer ID | Customers | Stripe customer id (cus_…). |
stripe_customer_invoice_prefix | Customer invoice prefix | Customers | Prefix Stripe uses to number this customer's invoices. |
stripe_customer_name | Customer name | Customers | Full name or business name on the customer. |
stripe_customer_phone | Customer phone | Customers | Phone number on the customer. |
stripe_customer_postal_code | Customer postal code | Customers | Postal code of the customer's billing address. |
stripe_customer_state | Customer state | Customers | State or region of the customer's billing address. |
stripe_customer_tax_exempt | Customer tax exempt | Customers | Tax exemption status: none, exempt or reverse (reverse charge). |
stripe_customer_type | Customer type | Customers | New when the customer's first successful payment falls inside the requested date range, Returning otherwise (lookback of… |
stripe_cohort_month | Cohort month | Date & time | The customer's cohort: the calendar month (YYYYMM) of their first paid invoice, ever. A reactivated customer keeps their… |
stripe_date | Date | Date & time | Date, in the account's dashboard timezone. |
stripe_date_time | Date and time | Date & time | Timestamp, in the account's dashboard timezone. |
stripe_day_of_week | Day of week | Date & time | Day of the week (0 = Sunday … 6 = Saturday). |
stripe_hour | Hour | Date & time | Hour of the day (00-23). |
stripe_month | Month | Date & time | Month of the year (01-12). |
stripe_months_since_cohort | Months since cohort | Date & time | Whole calendar months between the customer's cohort month and this row's month; 0 in the cohort month itself. |
stripe_quarter | Quarter | Date & time | Quarter of the year (1-4). |
stripe_week | Week | Date & time | ISO week of the year (01-53). |
stripe_year | Year | Date & time | Year. |
stripe_year_month | Month and year | Date & time | Year and month (YYYYMM). |
stripe_year_quarter | Quarter and year | Date & time | Year and quarter (YYYYQ). |
stripe_year_week | Week and year | Date & time | ISO year and week (YYYYWW). |
stripe_dispute_amount | Disputed amount | Disputes | Amount under dispute (usually the full charge). |
stripe_dispute_has_evidence | Has evidence | Disputes | 1 when evidence has been submitted for the dispute. |
stripe_dispute_id | Dispute ID | Disputes | Stripe dispute id (du_… or dp_…). |
stripe_dispute_is_inquiry | Is inquiry | Disputes | 1 for an inquiry or retrieval request (status warning_* or card case type inquiry) rather than a formal chargeback. |
stripe_dispute_lost_amount | Lost dispute amount | Disputes | Amount of disputes with status lost; 0 for any other status. |
stripe_dispute_network_reason_code | Network reason code | Disputes | Card network's reason code for the dispute (e.g. Visa 10.4, Mastercard 4837). |
stripe_dispute_past_due | Past due | Disputes | 1 when the evidence deadline passed without a submission. |
stripe_dispute_rate | Dispute rate | Disputes | Share of successful payments that were disputed: 1 or 0 per successful charge, empty for failed or pending ones. Unweigh… |
stripe_dispute_reason | Dispute reason | Disputes | Reason the cardholder gave: fraudulent, product_not_received, product_unacceptable, duplicate, subscription_canceled, cr… |
stripe_dispute_reversals_amount | Dispute reversals | Disputes | Amount returned when a dispute was won. |
stripe_dispute_status | Dispute status | Disputes | warning_needs_response, warning_under_review, warning_closed, needs_response, under_review, won, lost or prevented. |
stripe_dispute_win_rate | Dispute win rate | Disputes | Share of closed disputes won: 1 for won, 0 for lost, empty while open or prevented. Unweighted average by count. |
stripe_disputed_amount | Disputed amount | Disputes | Amount withdrawn for disputes (chargebacks), as a positive number. |
stripe_disputes | Disputes | Disputes | Count of disputes and inquiries. Always 1 per row; sum it. |
stripe_disputes_lost | Disputes lost | Disputes | Disputes closed in the cardholder's favour; the amount and the dispute fee stay withdrawn. |
stripe_disputes_open | Disputes open | Disputes | Disputes still awaiting a response or under review (needs_response, under_review, warning_needs_response, warning_under_… |
stripe_disputes_won | Disputes won | Disputes | Disputes closed in the merchant's favour. |
stripe_evidence_due_by | Evidence due by | Disputes | Deadline for submitting evidence, in the account's dashboard timezone. |
stripe_adjustments_amount | Adjustments | Fees & balance | Manual and other adjustments, signed. |
stripe_application_fee_amount | Application fee amount | Fees & balance | Fee collected by a Connect platform application on the charge. |
stripe_application_fees | Application fees | Fees & balance | Fees taken by a Connect platform application. |
stripe_available_balance | Available balance | Fees & balance | Funds available to pay out right now, per currency (snapshot at query time). |
stripe_balance_transaction_id | Balance transaction ID | Fees & balance | Balance transaction id (txn_…) that records the money movement. |
stripe_connect_reserved_balance | Connect reserved balance | Fees & balance | Funds reserved for Connect obligations, per currency. |
stripe_exchange_rate | Exchange rate | Fees & balance | Rate applied when the presentment currency differs from the settlement currency. |
stripe_fee_rate | Fee rate | Fees & balance | Fees ÷ gross amount per payment movement (unweighted average across rows; use fees ÷ gross_volume for the exact rate). |
stripe_fee_type | Fee type | Fees & balance | Comma-separated fee_details types on the movement: stripe_fee, application_fee, tax. |
stripe_fees | Fees | Fees & balance | Fees taken by Stripe (and applications) on the movement. |
stripe_instant_available_balance | Instant available balance | Fees & balance | Funds eligible for Instant Payouts, per currency. |
stripe_pending_balance | Pending balance | Fees & balance | Funds not yet available, per currency (snapshot at query time). |
stripe_reporting_category | Reporting category | Fees & balance | Accounting category: charge, refund, dispute, dispute_reversal, fee, payout, payout_reversal, transfer, other_adjustment… |
stripe_stripe_fees | Stripe fees | Fees & balance | Processing fees charged by Stripe. |
stripe_tax_fees | Tax fees | Fees & balance | Stripe Tax fees. |
stripe_line_item_amount | Line item amount | Invoice line items | Amount of the line after line-level discounts, before tax; negative for credits and proration refunds. |
stripe_line_item_discount_amount | Line item discount amount | Invoice line items | Sum of the discounts applied to the line. |
stripe_line_item_discountable | Line item discountable | Invoice line items | 1 when invoice-level discounts apply to the line. |
stripe_line_item_id | Line item ID | Invoice line items | Stripe invoice line item id (il_…). |
stripe_line_item_metadata | Line item metadata | Invoice line items | The line item's metadata as a JSON string (for subscription lines, the subscription's metadata). |
stripe_line_item_proration | Line item proration | Invoice line items | 1 when the line is a proration credit or charge from a mid-cycle plan change. |
stripe_line_item_quantity | Line item quantity | Invoice line items | Units billed on the line (whole units; usage lines may be truncated). |
stripe_line_item_subtotal | Line item subtotal | Invoice line items | Amount of the line before any discounts or taxes. |
stripe_line_item_tax_amount | Line item tax amount | Invoice line items | Sum of the taxes on the line. |
stripe_line_item_type | Line item type | Invoice line items | What generated the line: subscription_item_details (a subscription item) or invoice_item_details (a one-off invoice item… |
stripe_line_item_unit_amount | Line item unit amount | Invoice line items | Price per unit on the line; may carry fractions of a cent for usage pricing. |
stripe_line_items | Line items | Invoice line items | Count of invoice line items. Always 1 per row; sum it. |
stripe_line_period_end | Line period end | Invoice line items | End of the service period the line covers. |
stripe_line_period_start | Line period start | Invoice line items | Start of the service period the line covers. |
stripe_average_days_to_pay | Average days to pay | Invoices | Average days from finalization to payment across paid invoices; unpaid invoices are left out. |
stripe_average_invoice_value | Average invoice value | Invoices | Average invoice total. |
stripe_draft_invoices | Draft invoices | Invoices | 1 when the invoice is still a draft. |
stripe_invoice_aging_bucket | Invoice aging bucket | Invoices | Age 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_due | Invoice amount due | Invoices | Amount due after applying the customer's credit balance. |
stripe_invoice_amount_overpaid | Invoice amount overpaid | Invoices | Amount paid above the total, credited to the customer's balance. |
stripe_invoice_amount_paid | Invoice amount paid | Invoices | Amount paid so far. |
stripe_invoice_amount_paid_off_stripe | Invoice amount paid off Stripe | Invoices | Amount recorded as paid outside Stripe. |
stripe_invoice_amount_remaining | Invoice amount remaining | Invoices | Amount due minus amount paid. |
stripe_invoice_attempt_count | Invoice attempt count | Invoices | Number of payment attempts made on the invoice. |
stripe_invoice_attempted | Invoice attempted | Invoices | 1 when Stripe has attempted to collect payment at least once. |
stripe_invoice_billing_reason | Invoice billing reason | Invoices | Why the invoice was created: subscription_create, subscription_cycle, subscription_update, subscription_threshold, manua… |
stripe_invoice_collection_method | Invoice collection method | Invoices | charge_automatically or send_invoice. |
stripe_invoice_collection_rate | Invoice collection rate | Invoices | 1 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_amount | Invoice credit notes amount | Invoices | Amount of credit notes issued against the invoice, before and after payment. |
stripe_invoice_customer_country | Invoice customer country | Invoices | Country of the customer's billing address as printed on the invoice. |
stripe_invoice_customer_name | Invoice customer name | Invoices | Customer name as printed on the invoice (a snapshot taken at finalization). |
stripe_invoice_customer_tax_exempt | Invoice customer tax exempt | Invoices | Customer tax status at finalization: none, exempt or reverse. |
stripe_invoice_days_overdue | Invoice days overdue | Invoices | Days between the due date and the end of the date range, for open invoices past their due date; empty otherwise. |
stripe_invoice_days_to_pay | Invoice days to pay | Invoices | Days between finalization (or creation) and payment; empty when unpaid. |
stripe_invoice_discount_amount | Invoice discount amount | Invoices | Sum of the discounts applied at invoice level. |
stripe_invoice_due_date | Invoice due date | Invoices | Payment due date; set for send_invoice collection, empty for automatic charging. |
stripe_invoice_ending_balance | Invoice ending balance | Invoices | Customer balance after the invoice was applied (negative is credit). |
stripe_invoice_finalized_date | Invoice finalized date | Invoices | Date the invoice was finalized (became payable). |
stripe_invoice_hosted_url | Invoice hosted URL | Invoices | Stripe-hosted page where the invoice can be viewed and paid. |
stripe_invoice_id | Invoice ID | Invoices | Stripe invoice id (in_…). |
stripe_invoice_number | Invoice number | Invoices | Human-readable invoice number (prefix-sequence), assigned at finalization. |
stripe_invoice_overdue_amount | Invoice overdue amount | Invoices | Amount remaining on open invoices past their due date at the end of the date range; 0 otherwise. |
stripe_invoice_paid_date | Invoice paid date | Invoices | Date the invoice was paid; empty when unpaid. |
stripe_invoice_paid_out_of_band | Invoice paid out of band | Invoices | 1 when part or all of the invoice was paid outside Stripe (marked paid manually). |
stripe_invoice_pdf_url | Invoice PDF URL | Invoices | Download link for the invoice PDF. |
stripe_invoice_period_end | Invoice period end | Invoices | End of the usage period the invoice covers. |
stripe_invoice_period_start | Invoice period start | Invoices | Start of the usage period the invoice covers. |
stripe_invoice_shipping_amount | Invoice shipping amount | Invoices | Shipping charged on the invoice. |
stripe_invoice_starting_balance | Invoice starting balance | Invoices | Customer balance before the invoice was applied (negative is credit). |
stripe_invoice_status | Invoice status | Invoices | draft, open, paid, uncollectible or void. |
stripe_invoice_subtotal | Invoice subtotal | Invoices | Sum of the line items before invoice-level discounts and tax. |
stripe_invoice_tax | Invoice tax | Invoices | Sum of the taxes on the invoice. |
stripe_invoice_total | Invoice total | Invoices | Total after discounts and tax — what the customer is asked to pay. |
stripe_invoice_total_excluding_tax | Invoice total excluding tax | Invoices | Total after discounts, before tax. |
stripe_invoice_uncollectible_date | Invoice uncollectible date | Invoices | Date the invoice was marked uncollectible; empty otherwise. |
stripe_invoice_voided_date | Invoice voided date | Invoices | Date the invoice was voided; empty otherwise. |
stripe_invoices | Invoices | Invoices | Count of invoices. Always 1 per row; sum it. |
stripe_open_invoices | Open invoices | Invoices | 1 when the invoice status is open (finalized, awaiting payment). |
stripe_paid_invoices | Paid invoices | Invoices | 1 when the invoice status is paid. |
stripe_uncollectible_invoices | Uncollectible invoices | Invoices | 1 when the invoice was marked uncollectible. |
stripe_void_invoices | Void invoices | Invoices | 1 when the invoice was voided. |
stripe_average_payout_amount | Average payout amount | Payouts | Average amount per payout. |
stripe_failed_payouts | Failed payouts | Payouts | Payouts with status failed (the funds returned to the Stripe balance). |
stripe_paid_payout_amount | Paid payout amount | Payouts | Amount of payouts with status paid; 0 for pending, in-transit, canceled or failed ones. |
stripe_payout_amount | Payout amount | Payouts | Amount of the payout, whether or not it arrived; see paid_payout_amount for money that reached the bank. |
stripe_payout_arrival_date | Arrival date | Payouts | Date the funds are expected to (or did) arrive at the destination, in the account's dashboard timezone. |
stripe_payout_automatic | Automatic payout | Payouts | 1 for a payout created by the account's automatic schedule, 0 for a manual one. |
stripe_payout_destination_id | Destination ID | Payouts | Bank account (ba_…) or card (card_…) the payout was sent to. |
stripe_payout_failure_code | Payout failure code | Payouts | Why the payout failed: account_closed, insufficient_funds, no_account, invalid_account_number, … |
stripe_payout_failure_message | Payout failure message | Payouts | Human-readable reason the payout failed. |
stripe_payout_id | Payout ID | Payouts | Stripe payout id (po_…). |
stripe_payout_method | Payout method | Payouts | standard or instant. |
stripe_payout_reconciliation_status | Reconciliation status | Payouts | completed, in_progress or not_applicable — whether the payout's balance transactions have been reconciled. |
stripe_payout_reversals_amount | Payout reversals | Payouts | Amount returned by failed or cancelled payouts. |
stripe_payout_source_type | Payout source type | Payouts | Balance the payout was drawn from: card, fpx or bank_account. |
stripe_payout_statement_descriptor | Payout statement descriptor | Payouts | Descriptor shown on the bank statement for the payout. |
stripe_payout_status | Payout status | Payouts | paid, pending, in_transit, canceled or failed. |
stripe_payout_type | Payout type | Payouts | bank_account or card. |
stripe_payouts | Payouts | Payouts | Count of payouts, any status. Always 1 per row; sum it. |
stripe_payouts_amount | Payouts | Payouts | Amount paid out to the bank account, as a positive number. |
stripe_pending_payout_amount | Pending payout amount | Payouts | Amount of payouts still pending or in transit to the bank; 0 for others. |
stripe_price_active | Price active | Products & prices | 1 when the price can be used for new purchases, 0 when archived. |
stripe_price_billing_scheme | Price billing scheme | Products & prices | per_unit or tiered. |
stripe_price_created_date | Price created date | Products & prices | Date the price was created. |
stripe_price_id | Price ID | Products & prices | Stripe price id (price_…). |
stripe_price_interval | Price interval | Products & prices | Billing interval of a recurring price: day, week, month or year; empty for one-time prices. |
stripe_price_interval_count | Price interval count | Products & prices | Number of intervals between billings (interval=month, interval_count=3 bills quarterly); empty for one-time prices. |
stripe_price_lookup_key | Price lookup key | Products & prices | Lookup key used to reference the price from code. |
stripe_price_monthly_amount | Price monthly amount | Products & prices | Unit amount normalised to one month (month ÷ n, year ÷ 12n, week × 52 ÷ 12n, day × 365 ÷ 12n), rounded to the minor unit… |
stripe_price_nickname | Price nickname | Products & prices | Internal nickname of the price (hidden from customers). |
stripe_price_tiers_mode | Price tiers mode | Products & prices | graduated or volume for tiered prices; empty otherwise. |
stripe_price_type | Price type | Products & prices | one_time or recurring. |
stripe_price_unit_amount | Price unit amount | Products & prices | Amount charged per unit and billing period (per_unit prices; empty-equivalent 0 for tiered). |
stripe_price_usage_type | Price usage type | Products & prices | licensed (bills the subscribed quantity) or metered (bills reported usage); empty for one-time prices. |
stripe_prices | Prices | Products & prices | Count of prices. Always 1 per row; sum it. |
stripe_product_active | Product active | Products & prices | 1 when the product is available for purchase, 0 when archived. |
stripe_product_created_date | Product created date | Products & prices | Date the product was created. |
stripe_product_default_price_id | Product default price ID | Products & prices | Id of the product's default price (price_…). |
stripe_product_description | Product description | Products & prices | Customer-facing description of the product. |
stripe_product_id | Product ID | Products & prices | Stripe product id (prod_…). |
stripe_product_image_url | Product image URL | Products & prices | First image URL of the product. |
stripe_product_metadata | Product metadata | Products & prices | The product's metadata as a JSON string. |
stripe_product_name | Product name | Products & prices | Name of the product. |
stripe_product_revenue | Product revenue | Products & prices | Line amount when the invoice is paid, 0 otherwise — revenue by product and price. |
stripe_product_type | Product type | Products & prices | good or service. |
stripe_product_unit_label | Product unit label | Products & prices | Label for one unit of the product, as shown on invoices and receipts (seat, GB, …). |
stripe_product_units_sold | Product units sold | Products & prices | Line quantity when the invoice is paid, 0 otherwise. |
stripe_product_updated_date | Product updated date | Products & prices | Date the product was last updated. |
stripe_product_url | Product URL | Products & prices | Public web page of the product. |
stripe_products | Products | Products & prices | Count of products. Always 1 per row; sum it. |
stripe_amount_refunded | Amount refunded | Refunds | Amount refunded on the charge so far, full or partial. |
stripe_average_refund_amount | Average refund amount | Refunds | Average amount per refund. |
stripe_charge_refunded | Fully refunded | Refunds | 1 when the whole charge was refunded. A partial refund leaves this 0 — see amount_refunded. |
stripe_customer_refunded_total | Customer refunded total | Refunds | Amount refunded on the customer's payments over the lookback window plus the date range. |
stripe_dispute_is_charge_refundable | Charge refundable | Refunds | 1 when the disputed charge can still be refunded (useful to settle an inquiry before it becomes a chargeback). |
stripe_failed_refunds | Failed refunds | Refunds | Refunds with status failed (the customer's bank could not receive the money). |
stripe_refund_amount | Refund amount | Refunds | Amount of the refund, whether or not it succeeded; see succeeded_refund_amount for money that actually went back. |
stripe_refund_destination_type | Refund destination type | Refunds | Where the money was returned to: card, us_bank_transfer, paypal, customer_cash_balance, … |
stripe_refund_failure_reason | Refund failure reason | Refunds | Why a failed refund could not be delivered: lost_or_stolen_card, expired_or_canceled_card, charge_for_pending_refund_dis… |
stripe_refund_id | Refund ID | Refunds | Stripe refund id (re_… or pyr_…). |
stripe_refund_rate | Refund rate | Refunds | Share of successful payments that were refunded (fully or partially): 1 or 0 per successful charge, empty for failed or … |
stripe_refund_reason | Refund reason | Refunds | duplicate, fraudulent, requested_by_customer or expired_uncaptured_charge. |
stripe_refund_status | Refund status | Refunds | pending, requires_action, succeeded, failed or canceled. |
stripe_refunded_amount | Refunded amount | Refunds | Amount refunded to customers (reporting categories refund and partial_capture_reversal), as a positive number. |
stripe_refunded_payments | Refunded payments | Refunds | Charges that were refunded in full or in part. |
stripe_refunds | Refunds | Refunds | Count of refunds, any status. Always 1 per row; sum it. |
stripe_succeeded_refund_amount | Succeeded refund amount | Refunds | Amount of refunds with status succeeded; 0 for pending, failed or canceled refunds. |
stripe_arpu | ARPU | Revenue & MRR | Average revenue per user = MRR ÷ active subscribers, per day. Average it across days, never sum it. Empty when there are… |
stripe_arr | ARR | Revenue & MRR | Annual recurring revenue = MRR × 12. |
stripe_churned_mrr | Churned MRR | Revenue & MRR | MRR lost by customers whose MRR went to zero, as a positive number, netted per customer within the calendar month. |
stripe_contraction_mrr | Contraction MRR | Revenue & MRR | MRR lost that day by customers who kept paying less (downgrades, removed seats or products), as a positive number. |
stripe_delinquent_churned_mrr | Delinquent churned MRR | Revenue & MRR | Churned MRR lost to customers Stripe could not collect from: a cycle invoice marked uncollectible, a subscription cancel… |
stripe_expansion_mrr | Expansion MRR | Revenue & MRR | MRR added that day by customers who were already paying (upgrades, added seats or products). |
stripe_gross_volume | Gross volume | Revenue & MRR | Gross amount of successful payments (reporting category = charge). |
stripe_mrr | MRR | Revenue & MRR | Monthly recurring revenue in the row's currency, reconstructed from the paid invoices: every subscription line item's ne… |
stripe_mrr_at_entry | MRR at entry | Revenue & MRR | The customer's TOTAL end-of-month MRR in their cohort month — constant for the customer, repeated on every product row: … |
stripe_mrr_churn_type | MRR churn type | Revenue & MRR | Why the cell churned, for rows whose movement is churn: voluntary (the customer or merchant canceled) or delinquent (Str… |
stripe_mrr_growth_rate | MRR growth rate | Revenue & MRR | MRR ÷ previous day's MRR − 1. Empty when the previous day had no MRR. |
stripe_mrr_movement_type | MRR movement type | Revenue & MRR | How the cell's MRR changed since the day before: new, expansion, contraction, churn, reactivation or none. |
stripe_net_new_mrr | Net new MRR | Revenue & MRR | new + expansion + reactivation − contraction − churned MRR. Movements are netted per customer within the calendar month,… |
stripe_net_revenue | Net revenue | Revenue & MRR | Net of payments, refunds and disputes after Stripe fees (what actually stays in the balance from sales). |
stripe_net_revenue_retention | Net revenue retention | Revenue & MRR | (MRR 30 days earlier − churned − contraction + expansion + reactivation over those 30 days) ÷ MRR 30 days earlier. Empty… |
stripe_new_mrr | New MRR | Revenue & MRR | MRR added by customers who had never paid before. Movements are netted per customer within the calendar month (ProfitWel… |
stripe_reactivation_mrr | Reactivation MRR | Revenue & MRR | MRR added that day by customers who had churned before and came back. |
stripe_revenue_churn_rate | Revenue churn rate | Revenue & MRR | (churned + contraction MRR over the trailing 30 days) ÷ MRR 30 days earlier. Empty when there was no MRR then. |
stripe_subscription_mrr | Subscription MRR | Revenue & MRR | This subscription's monthly recurring revenue as of the window end, reconstructed from its paid invoices (net line amoun… |
stripe_voluntary_churned_mrr | Voluntary churned MRR | Revenue & MRR | Churned MRR lost that day to customers who canceled (cancellation reason cancellation_requested, or none recorded), as a… |
stripe_active_subscribers | Active subscribers | Subscription metrics | Distinct customers with MRR > 0 at the end of the day (active or past_due subscriptions past their trial). Counted once … |
stripe_active_subscriptions | Active subscriptions | Subscription metrics | 1 when the status is active or past_due (Stripe counts past_due as active until it becomes unpaid or canceled). |
stripe_average_subscription_value | Average subscription value | Subscription metrics | Average subscription_mrr per subscription. |
stripe_canceled_subscriptions | Canceled subscriptions | Subscription metrics | 1 when the status is canceled. |
stripe_churned_subscribers | Churned subscribers | Subscription metrics | Customers whose MRR went from positive to zero that day. |
stripe_churned_subscriptions | Churned subscriptions | Subscription metrics | 1 when the subscription ended (or was canceled) inside the requested date range and its status is canceled or unpaid. |
stripe_delinquent_churned_subscribers | Delinquent churned subscribers | Subscription metrics | Customers whose MRR went to zero that day because Stripe ended their subscription over failed payments or a dispute (a c… |
stripe_has_active_subscription | Has active subscription | Subscription metrics | 1 when the customer has an active or past_due subscription as of the query. |
stripe_incomplete_subscriptions | Incomplete subscriptions | Subscription metrics | 1 when the status is incomplete or incomplete_expired. |
stripe_new_subscribers | New subscribers | Subscription metrics | Customers whose MRR went from zero to positive that day and who had never paid before. |
stripe_new_subscriptions | New subscriptions | Subscription metrics | 1 when the start date falls inside the requested date range. |
stripe_past_due_subscriptions | Past due subscriptions | Subscription metrics | 1 when the status is past_due. |
stripe_paused_subscriptions | Paused subscriptions | Subscription metrics | 1 when the status is paused. |
stripe_reactivated_subscribers | Reactivated subscribers | Subscription metrics | Customers whose MRR went from zero to positive that day after having churned before. |
stripe_subscriber_churn_rate | Subscriber churn rate | Subscription metrics | Customers churned over the trailing 30 days ÷ (active subscribers 30 days earlier + new subscribers over those 30 days).… |
stripe_subscriptions | Subscriptions | Subscription metrics | Count of subscriptions. Always 1 per row; sum it. |
stripe_trial_conversion_rate | Trial conversion rate | Subscription metrics | trial_conversions ÷ subscriptions whose trial has ended; empty for subscriptions that never trialed so the average ignor… |
stripe_trial_conversions | Trial conversions | Subscription metrics | 1 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_subscriptions | Trialing subscriptions | Subscription metrics | 1 when the status is trialing. |
stripe_unpaid_subscriptions | Unpaid subscriptions | Subscription metrics | 1 when the status is unpaid. |
stripe_voluntary_churned_subscribers | Voluntary churned subscribers | Subscription metrics | Customers whose MRR went to zero that day because they canceled. |
stripe_subscription_age_days | Subscription age (days) | Subscriptions | Whole days from the start date to the end of the date range. |
stripe_subscription_arr | Subscription ARR | Subscriptions | This subscription's annual recurring revenue = subscription_mrr × 12. |
stripe_subscription_billing_cycle_anchor | Billing cycle anchor | Subscriptions | Date the billing cycle is anchored on. |
stripe_subscription_cancel_at | Cancel at | Subscriptions | Date a scheduled cancellation takes effect. |
stripe_subscription_cancel_at_period_end | Cancel at period end | Subscriptions | 1 when the subscription is set to cancel at the end of the current period. |
stripe_subscription_canceled_at | Canceled at | Subscriptions | Date the cancellation was requested. |
stripe_subscription_cancellation_comment | Cancellation comment | Subscriptions | Free-text comment left by the customer on cancellation. |
stripe_subscription_cancellation_feedback | Cancellation feedback | Subscriptions | Customer-selected feedback: too_expensive, missing_features, switched_service, unused, customer_service, too_complex, lo… |
stripe_subscription_cancellation_reason | Cancellation reason | Subscriptions | Why it was canceled: cancellation_requested, payment_disputed, payment_failed. |
stripe_subscription_collection_method | Collection method | Subscriptions | charge_automatically or send_invoice. |
stripe_subscription_coupon_name | Coupon name | Subscriptions | Name of the coupon applied to the subscription. |
stripe_subscription_created_date | Subscription created date | Subscriptions | Date the subscription object was created. |
stripe_subscription_current_period_end | Current period end | Subscriptions | End of the current billing period of the primary item (next renewal). |
stripe_subscription_current_period_start | Current period start | Subscriptions | Start of the current billing period of the primary item. |
stripe_subscription_days_until_due | Days until due | Subscriptions | For send_invoice subscriptions, days the customer has to pay each invoice. |
stripe_subscription_discount_amount_off | Discount amount off | Subscriptions | Fixed amount off per billing period of the subscription-level coupon, in the coupon's currency. |
stripe_subscription_discount_percent_off | Discount percent off | Subscriptions | Percentage discount of the subscription-level coupon. |
stripe_subscription_ended_at | Ended at | Subscriptions | Date the subscription actually ended. |
stripe_subscription_id | Subscription ID | Subscriptions | Stripe subscription id (sub_…). |
stripe_subscription_is_trialing | Is trialing | Subscriptions | 1 while the subscription status is trialing. |
stripe_subscription_item_amount | Item amount | Subscriptions | Σ quantity × unit amount across the subscription's items, per billing period (tiers computed; metered items contribute 0… |
stripe_subscription_item_count | Item count | Subscriptions | Number of items (prices) on the subscription. |
stripe_subscription_item_id | Subscription item ID | Subscriptions | Stripe subscription item id (si_…). |
stripe_subscription_latest_invoice_id | Latest invoice ID | Subscriptions | Id of the most recent invoice of the subscription (in_…). |
stripe_subscription_lifetime_months | Subscription lifetime (months) | Subscriptions | Months 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_ltv | Subscription LTV | Subscriptions | Customer lifetime value = ARPU ÷ subscriber churn rate (trailing 30 days). Empty when either is unavailable or churn is … |
stripe_subscription_plan_label | Plan | Subscriptions | Product name and billing interval of the primary item, e.g. "Pro / month" or "Pro / 3 months". |
stripe_subscription_quantity | Quantity | Subscriptions | Quantity of the primary item. |
stripe_subscription_schedule_id | Schedule ID | Subscriptions | Id of the subscription schedule managing this subscription (sub_sched_…), if any. |
stripe_subscription_start_date | Subscription start date | Subscriptions | Date the subscription started (start_date; can be earlier than created when backdated). |
stripe_subscription_status | Subscription status | Subscriptions | Stripe subscription status: incomplete, incomplete_expired, trialing, active, past_due, canceled, unpaid, paused. |
stripe_subscription_trial_end | Trial end | Subscriptions | Date the trial ends or ended, if any. |
stripe_subscription_trial_start | Trial start | Subscriptions | Date the trial started, if any. |
stripe_subscription_unit_amount | Unit amount | Subscriptions | Unit amount of the primary item's price per billing period (empty for tiered prices). |