Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure

Dimension list for Stripe

191 dimensions available

CategoryFieldCodeDescription
TIMEYearyearYear, e.g. 2017
Quarterquarter
Year & monthyearmonthYear and month, e.g. 2017|06
Year & week (Sun-Sat)yearweekYear and week for US weeks, e.g. 2017|08
Year & week (Mon-Sun)yearweekisoYear and week for ISO weeks, e.g. 2017|08
Year of week (Sun-Sat)yearofweekYear of week for US weeks, e.g. 2017
Year of week (Mon-Sun)yearofweekisoYear of week for ISO weeks, e.g. 2017
MonthmonthMonth, e.g. 6
Week (Sun-Sat)weekUS week number, e.g. 51
Week (Mon-Sun)weekisoISO week number, e.g. 51
Day of weekdayofweek
Day of week (Sun-Sat)dayofweeknameDay of week name for US weeks, e.g. 0 Sunday
Day of week (Mon-Sun)dayofweeknameisoDay of week name for ISO weeks, e.g. 1 Sunday
DatedateDate, e.g. 2017-01-31
Day of monthdayofmonthDay of month, e.g. 2
Hourhour
Minuteminute
ACCOUNTAccount IDaccount_id
Account nameaccount_name
CUSTOMERCustomer IDcustomer_idUnique identifier for the object
Customer currencycustomer_currencyThree-letter ISO code for the currency the customer can be charged in for recurring billing purposes
Customer emailcustomer_emailThe customer's email address
Customer VAT IDcustomer_vat_idUnique identifier for the object
Customer is delinquentcustomer_delinquentWhen the customer's latest invoice is billed by charging automatically, delinquent is true if the invoice's latest charge is failed. When the customer's latest invoice is billed by sending an invoice, delinquent is true if the invoice is not paid by its due date
SOURCESource IDsource_idUnique identifier for the object
Source typesource_typeThe type of the source. The type is a payment method
Source address line 1source_address_line_1Address line 1 (Street address/PO Box/Company name)
Source address line 2source_address_line_2Address line 2 (Apartment/Suite/Unit/Building)
Source address citysource_address_cityCity/District/Suburb/Town/Village
Source address statesource_address_stateState/County/Province/Region
Source address countrysource_address_countryBilling address country, if provided when creating card
Source address zip codesource_address_zipZIP or postal code
Source address zip code checksource_address_zip_checkIf address_zip was provided, results of the check: pass, fail, unavailable, or unchecked
Source metadatasource_metadataSet of key-value pairs that you can attach to an object. This can be useful for storing additional information about the object in a structured format
SOURCE CARDCard brandsource_card_brandCard brand. Can be American Express, Diners Club, Discover, JCB, MasterCard, UnionPay, Visa, or Unknown
Card funding typesource_card_fundingCard funding type. Can be credit, debit, prepaid, or unknown
Card country codesource_card_countryTwo-letter ISO code representing the country of the card. You could use this attribute to get a sense of the international breakdown of cards you've collected
Card holder namesource_card_nameCardholder name
Card expiration monthsource_card_exp_monthTwo digit number representing the card's expiration month
Card expiration yearsource_card_exp_yearFour digit number representing the card's expiration year
Card fingerprintsource_card_fingerprintUniquely identifies this particular card number. You can use this attribute to check whether two customers who've signed up with you are using the same card number, for example
Card tokenization methodsource_card_tokenizationIf the card number is tokenized, this is the method that was used. Can be apple_pay or google_pay
Card CVC checksource_card_cvc_checkIf a CVC was provided, results of the check: pass, fail, unavailable, or unchecked
Card last 4 digitssource_card_last4The last four digits of the card
Card last 4 digits (dynamic)source_card_last4_dynamic(For tokenized numbers only.) The last four digits of the device account number
SHIPPING ADDRESSShipping carriershipping_carrierThe delivery service that shipped a physical product, such as Fedex, UPS, USPS, etc. If multiple carriers were used for this purchase, please separate them with commas
Shipping tracking numbershipping_tracking_numberThe tracking number for a physical product, obtained from the delivery service. If multiple tracking numbers were generated for this purchase, please separate them with commas
Shipping recipient nameshipping_recipient_nameThe name of the customer
Shipping recipient phoneshipping_recipient_phoneThe recipient's phone number
Shipping address line 1shipping_line_1Address line 1 (Street address/PO Box/Company name)
Shipping address line 2shipping_line_2Address line 2 (Apartment/Suite/Unit/Building)
Shipping zip codeshipping_address_zipZIP or postal code
Shipping cityshipping_address_cityCity/District/Suburb/Town/Village
Shipping stateshipping_stateState/County/Province/Region
Shipping countryshipping_address_countryBilling address country, if provided when creating card
COUPONCoupon IDcoupon_idUnique identifier for the object
Coupon durationcoupon_durationOne of forever, once, and repeating. Describes how long a customer who applies this coupon will get the discount
Coupon percent offcoupon_percent_offPercent that will be taken off the subtotal of any invoices for this customer for the duration of the coupon. For example, a coupon with percent_off of 50 will make a $100 invoice $50 instead
Coupon redeem by datecoupon_redeem_byDate after which the coupon can no longer be redeemed
Coupon is validcoupon_validTaking account of the above properties, whether this coupon can still be applied to a customer
Coupon metadatacoupon_metadataA set of key-value pairs that you can attach to a coupon object. It can be useful for storing additional information about the coupon in a structured format
APPLICATIONApplication IDapp_idUnique identifier for the object
APPLICATION FEEApplication fee IDapp_fee_idUnique identifier for the object
Fee currencyapp_fee_currencyThree-letter ISO currency code, in lowercase
Fee is refundedapp_fee_refundedWhether the fee has been fully refunded. If the fee is only partially refunded, this attribute will still be false
Originating transaction IDapp_fee_orig_transactionID of the corresponding charge on the platform account, if this fee was the result of a charge using the destinationparameter
BALANCEBalance typebalance_typeString representing the object's type. Objects of the same type share the same value
Balance currencybalance_currencyThree-letter ISO currency code, in lowercase
BALANCE TRANSACTIONTransaction IDtransaction_idUnique identifier for the object
Transaction typetransaction_typeTransaction type: adjustment, advance, advance_funding, application_fee, application_fee_refund, charge, connect_collection_transfer, issuing_authorization_hold, issuing_authorization_release, issuing_transaction, payment, payment_failure_refund, payment_refund, payout, payout_cancel, payout_failure, refund, refund_failure, reserve_transaction, reserved_funds, stripe_fee, stripe_fx_fee, tax_fee, topup, topup_reversal, transfer, transfer_cancel, transfer_failure, or transfer_refund
Transaction statustransaction_statusIf the transaction's net funds are available in the Stripe balance yet. Either available or pending
Transaction available datetransaction_available_dateThe date the transaction's net funds will become available in the Stripe balance
Transaction currencytransaction_currencyThree-letter ISO currency code, in lowercase
Transaction descriptiontransaction_descriptionAn arbitrary string attached to the object. Often useful for displaying to users
First fee typetransaction_fee_typeType of the fee, one of: application_fee, stripe_fee or tax
First fee descriptiontransaction_fee_descriptionAn arbitrary string attached to the object. Often useful for displaying to users
CHARGECharge IDcharge_idUnique identifier for the object
Charge typecharge_typeString representing the object's type. Objects of the same type share the same value
Charge statuscharge_statusThe status of the payment is either succeeded, pending, or failed
Charge currencycharge_currencyThe status of the payment is either succeeded, pending, or failed
Charge descriptioncharge_descriptionAn arbitrary string attached to the object. Often useful for displaying to users
Charge on behalf ofcharge_on_behalf_ofThe account (if any) the charge was made on behalf of without triggering an automatic transfer
Charge is capturedcharge_capturedIf the charge was created without capturing, this Boolean represents whether it is still uncaptured or has since been captured
Charge is paidcharge_paidtrue if the charge succeeded, or was successfully authorized for later capture
Charge is refundedcharge_refundedWhether the charge has been fully refunded. If the charge is only partially refunded, this attribute will still be false
Charge statement descriptorcharge_statementExtra information about a charge. This will appear on your customer's credit card statement. It must contain at least one letter
Charge failure codecharge_failure_codeError code explaining reason for charge failure if available
Charge failure messagecharge_failure_messageMessage to user further explaining reason for charge failure if available
Charge receipt emailcharge_receipt_emailThis is the email address that the receipt for this charge was sent to
Charge receipt numbercharge_receipt_numberThis is the transaction number that appears on email receipts sent for this charge. This attribute will be null until a receipt has been sent
Charge transfer groupcharge_transfer_groupA string that identifies this transaction as part of a group. See the Connect documentation for details
Charge metadatacharge_metadataSet of key-value pairs that you can attach to an object. This can be useful for storing additional information about the object in a structured format
Outcome typecharge_outcome_typePossible values are authorized, manual_review, issuer_declined, blocked, and invalid
Outcome network statuscharge_outcome_network_statusPossible values are approved_by_network, declined_by_network, not_sent_to_network, and reversed_after_approval. The value reversed_after_approval indicates the payment was blocked by Stripe after bank authorization, and may temporarily appear as "pending" on a cardholder's statement
Outcome risk levelcharge_outcome_risk_levelStripe's evaluation of the riskiness of the payment. Possible values for evaluated payments are normal, elevated, highest. For non-card payments, and card-based payments predating the public assignment of risk levels, this field will have the value not_assessed. In the event of an error in the evaluation, this field will have the value unknown
Outcome reasoncharge_outcome_reasonAn enumerated value providing a more detailed explanation of the outcome's type. Charges blocked by Radar's default block rule have the value highest_risk_level. Charges placed in review by Radar's default review rule have the value elevated_risk_level. Charges authorized, blocked, or placed in review by custom rules have the value rule
Outcome seller messagecharge_outcome_seller_messageA human-readable description of the outcome type and reason, designed for you (the recipient of the payment), not your customer
Fraud user reportcharge_fraud_user_reportAssessments reported by you. If set, possible values of are safe and fraudulent
Fraud user detailscharge_fraud_detailsInformation on fraud assessments for the charge
TRANSFERTransfer IDtransfer_idUnique identifier for the object
Transfers currencytransfer_currencyThree-letter ISO currency code, in lowercase
Transfers descriptiontransfer_descriptionAn arbitrary string attached to the object. Often useful for displaying to users
Transfer is reversedtransfer_reversedWhether the transfer has been fully reversed. If the transfer is only partially reversed, this attribute will still be false
Transfer source typetransfer_source_typeThe source balance this transfer came from. One of card, financing, bank_account, or alipay_account
Transfer source transaction IDtransfer_source_transaction_idUnique identifier for the object
Transfers destination payment IDtransfer_destination_payment_idUnique identifier for the object
Transfer group IDtransfer_group_idUnique identifier for the object
Transfer metadatatransfer_metadataA set of key-value pairs that you can attach to a transfer object. It can be useful for storing additional information about the transfer in a structured format
DESTINATION ACCOUNTDestination IDdestination_idUnique identifier for the object
INVOICEInvoice IDinvoice_idThe ID of the invoice this invoice item belongs to
Invoice currencyinvoice_currencyThree-letter ISO currency code, in lowercase
Invoice descriptioninvoice_descriptionAn arbitrary string attached to the object. Often useful for displaying to users. Referenced as 'memo' in the Dashboard
Invoice period start timeinvoice_period_startStart of the usage period during which invoice items were added to this invoice
Invoice period end timeinvoice_period_endEnd of the usage period during which invoice items were added to this invoice
Invoice next payment attemptinvoice_next_payment_attemptThe time at which payment will next be attempted. This value will be null for invoices where billing=send_invoice
Invoice statusinvoice_statusThe status of the invoice. Can have the values "draft", "open", "paid", "void", and "uncollectible"
Invoice marked uncollectibleinvoice_marked_uncollectible_atThe time that the invoice was marked uncollectible
Invoice metadatainvoice_metadataSet of key-value pairs that you can attach to an object. This can be useful for storing additional information about the object in a structured format
Invoice receipt numberinvoice_receipt_numberThis is the transaction number that appears on email receipts sent for this charge. This attribute will be null until a receipt has been sent
Invoice statement descriptorinvoice_statementExtra information about a charge. This will appear on your customer's credit card statement. It must contain at least one letter
TAX RATESTax rate idtax_rate_idUnique identifier for the object
Tax rate descriptiontax_rate_descriptionAn arbitrary string attached to the tax rate for your internal use only. It will not be visible to your customers
Tax rate nametax_rate_nameThe display name of the tax rates as it will appear to your customer on their receipt email, PDF, and the hosted invoice page
Tax rate jurisdictiontax_rate_jurisdictionThe jurisdiction for the tax rate. You can use this label field for tax reporting purposes. It also appears on your customer’s invoice
INVOICE ITEMInvoice item IDinvoice_item_idUnique identifier for the object
Invoice item currencyinvoice_item_currencyThree-letter ISO currency code
Invoice item descriptioninvoice_item_descriptionAn arbitrary string attached to the object. Often useful for displaying to users
ORDEROrder IDorder_idUnique identifier for the object
Order statusorder_statusCurrent order status. One of created, paid, canceled, fulfilled, or returned
Order currencyorder_currencyThree-letter ISO currency code, in lowercase
Order emailorder_emailThe email address of the customer placing the order
Order shipping methodorder_shipping_methodThe shipping method to select for fulfilling this order. If specified, must be one of the ids of a shipping method in the shipping_methods
Order paid timeorder_paid_time
Order fulfilled timeorder_fulfilled_time
Order cancelled timeorder_cancelled_time
Order returned timeorder_returned_time
Order updated timeorder_updated_time
Order metadataorder_metadataA set of key-value pairs that you can attach to a product object. It can be useful for storing additional information about the order in a structured format
SUBSCRIPTIONSubscription IDsubscription_idUnique identifier for the object
Subscription statussubscription_statusPossible values are trialing, active, past_due, canceled, or unpaid. A subscription still in its trial period is trialing and moves to active when the trial period is over. If subscription billing=charge_automatically it becomes past_due when payment to renew it fails and canceled or unpaid (depending on your subscriptions settings) when Stripe has exhausted all payment retry attempts. If subscription billing=send_invoice it becomes past_due when its invoice is not paid by the due date, and canceled or unpaid if it is still not paid by an additional deadline after that. Note that when a subscription has a status of unpaid, no subsequent invoices will be attempted (invoices will be created, but then immediately automatically closed.)
Subscription start timesubscription_start_timeDate of the last substantial change to this subscription. For example, a change to the items array, or a change of status, will reset this timestamp
Subscription end timesubscription_end_timeIf the subscription has ended, the date the subscription ended
Subscription cancel timesubscription_cancel_timeIf the subscription has been canceled, the date of that cancellation. If the subscription was canceled with cancel_at_period_end, canceled_atwill still reflect the date of the initial cancellation request, not the end of the subscription period when the subscription is automatically moved to a canceled state
Cancel at period endsubscription_cancel_period_endBoolean indicating whether this subscription should cancel at the end of the current period
Subscription trial start timesubscription_trial_startIf the subscription has a trial, the beginning of that trial
Subscription trial end timesubscription_trial_endUnix timestamp representing the end of the trial period the customer will get before being charged for the first time. This will always overwrite any trials that might apply via a subscribed plan
Subscription period start timesubscription_period_startStart of the current period that the subscription has been invoiced for
Subscription period end timesubscription_period_endEnd of the current period that the subscription has been invoiced for. At the end of this period, a new invoice will be created
Subscription metadatasubscription_metadataA set of key-value pairs that you can attach to a Subscription object. It can be useful for storing additional information about the subscription in a structured format
SUBSCRIPTION PLANPlan idsubscription_plan_idUnique identifier for the object
Product IDproduct_idUnique identifier for the object
Product namesubscription_product_nameA brief description of the product
Plan namesubscription_plan_nameA brief description of the plan, hidden from customers
Plan intervalsubscription_plan_intervalOne of day, week, month or year. The frequency with which a subscription should be billed
Plan statement descriptorsubscription_plan_statement
Plan metadatasubscription_plan_metadataSet of key-value pairs that you can attach to an object. This can be useful for storing additional information about the object in a structured format
SUBSCRIPTION ITEMSubscription item IDsubscription_item_idUnique identifier for the object
Subscription item currencysubscription_item_currencyThree-letter ISO currency code
Subscription items descriptionsubscription_item_descriptionAn arbitrary string attached to the object. Often useful for displaying to users
PAYOUTPayout IDpayout_idUnique identifier for the object
Payout typepayout_typeCan be bank_account or card
Payout statuspayout_statusOnly return payouts that have the given status: pending, paid, failed, or canceled
Payout currencypayout_currencyThree-letter ISO currency code, in lowercase
Payout arrival datepayout_arrival_dateDate the payout is expected to arrive in the bank. This factors in delays like weekends or bank holidays
Payout methodpayout_methodThe method used to send this payout, which can be standard or instant
Payout descriptionpayout_descriptionAn arbitrary string attached to the object. Often useful for displaying to users
Payout statement descriptorpayout_statementExtra information about a payout to be displayed on the user's bank statement
Payout source typepayout_source_typeThe source balance to use for this transfer. One of card, financing, bank_account, or alipay_account. For most users, this will default to card
Payout failure codepayout_failure_codeError code explaining reason for payout failure if available
Payout failure messagepayout_failure_messageMessage to user further explaining reason for payout failure if available
Payout failure transaction IDpayout_failure_transaction_idUnique identifier for the object
Payout metadatapayout_metadataSet of key-value pairs that you can attach to an object. This can be useful for storing additional information about the object in a structured format
REFUNDRefund IDrefund_idUnique identifier for the object
Refund statusrefund_statusStatus of the refund. For credit card refunds, this can be succeeded or failed. For other types of refunds, it can be pending, succeeded, failed, or canceled
Refund currencyrefund_currencyThree-letter ISO currency code, in lowercase
Refund reasonrefund_reasonReason for the refund. If set, possible values are duplicate, fraudulent, and requested_by_customer
Refund receipt numberrefund_receipt_numberThis is the transaction number that appears on email receipts sent for this refund
Refund metadatarefund_metadataSet of key-value pairs that you can attach to an object. This can be useful for storing additional information about the object in a structured format
DISPUTEDispute IDdispute_idUnique identifier for the object
Dispute statusdispute_statusCurrent status of dispute. Possible values are warning_needs_response, warning_under_review, warning_closed, needs_response, under_review, charge_refunded, won, or lost
Dispute reasondispute_reasonReason given by cardholder for dispute. Possible values are duplicate, fraudulent, subscription_canceled, product_unacceptable, product_not_received, unrecognized, credit_not_processed, general, incorrect_account_details, insufficient_funds, bank_cannot_process, debit_not_authorized, or customer_initiated
Dispute currencydispute_currencyThree-letter ISO currency code, in lowercase
Dispute charge is refundabledispute_charge_refundableIf true, it is still possible to refund the disputed payment. Once the payment has been fully refunded, no further funds will be withdrawn from your Stripe account as a result of this dispute
Dispute metadatadispute_metadataSet of key-value pairs that you can attach to an object. This can be useful for storing additional information about the object in a structured format
Has evidencedispute_has_evidenceWhether evidence has been staged for this dispute
Evidence due by datedispute_evidence_due_byDate by which evidence must be submitted in order to successfully challenge dispute. Will be null if the customer's bank or credit card company doesn't allow a response for this particular dispute
Evidence is past duedispute_evidence_past_dueWhether the last evidence submission was submitted past the due date. Defaults to false if no evidence submissions have occurred. If true, then delivery of the latest evidence is not guaranteed
REVIEWReview IDreview_idUnique identifier for the object
DEPRECATEDInvoice is paidinvoice_paidWhether payment was successfully collected for this invoice. An invoice can be paid (most commonly) with a charge or with credit from the customer's account balance. Please note that this field will be removed on 2021-08-12
Invoice is forgiveninvoice_forgivenPlease note that this field will be removed on 2021-08-12
Invoice is closedinvoice_closedPlease note that this field will be removed on 2021-08-12