Documentation Index

Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt

Use this file to discover all available pages before exploring further.

Stripe metrics and dimensions

Prev Next

Supermetrics brings all your Stripe data into Google Sheets, Looker Studio, Power BI, Excel, BigQuery, Snowflake, Redshift, Azure

62 metrics206 dimensions

ACCOUNT

account_id
account_name

APPLICATION

app_id

APPLICATION FEE

app_fee_id
app_fee_currency
app_fee_refunded
app_fee_orig_transaction
app_fee_amount
app_fee_amount_refunded

BALANCE

balance_type
balance_currency
balance_amount
balance_source_card
balance_source_bank
balance_source_bitcoin

BALANCE TRANSACTION

transaction_id
transaction_type
transaction_status
transaction_available_date
transaction_currency
transaction_description
transaction_fee_type
transaction_fee_description
transaction_amount
transaction_net
transaction_fee
transaction_refund
transaction_charge_percent
transaction_fee_percent
transaction_refund_percent
transaction_average_amount
transaction_average_net
transaction_average_charge
transaction_average_refund
transaction_charge_amount
transaction_charge_net
transaction_charge_fee
charge_fee_percent
charge_average_amount
charge_average_net
charge_average_fee
transactions
transaction_charges
transaction_fees
transaction_refunds

CHARGE

charge_id
charge_type
charge_status
charge_currency
charge_description
charge_on_behalf_of
charge_captured
charge_paid
charge_refunded
charge_statement
charge_failure_code
charge_failure_message
charge_receipt_email
charge_receipt_number
charge_transfer_group
charge_metadata
charge_outcome_type
charge_outcome_network_status
charge_outcome_risk_level
charge_outcome_reason
charge_outcome_seller_message
charge_fraud_user_report
charge_fraud_details
charge_amount
charge_amount_refunded
charge_app_fee

COUPON

coupon_id
coupon_duration
coupon_percent_off
coupon_redeem_by
coupon_valid
coupon_metadata
coupon_duration_in_months
coupon_amount_off
coupon_max_redeems
coupon_times_redeemed

CUSTOMER

customer_id
customer_currency
customer_email
customer_vat_id
customer_delinquent
customer_created_date
customer_created_datetime
customer_account_balance

DATASOURCE

dataSourceName
system_metadata.data_source_logins
system_metadata.data_source_login_owners

DEPRECATED

invoice_paid
invoice_forgiven
invoice_closed

DESTINATION ACCOUNT

destination_id

DISPUTE

dispute_id
dispute_status
dispute_reason
dispute_currency
dispute_charge_refundable
dispute_metadata
dispute_has_evidence
dispute_evidence_due_by
dispute_evidence_past_due
dispute_amount
dispute_evidence_submissions

INVOICE

invoice_id
invoice_currency
invoice_description
invoice_period_start
invoice_period_end
invoice_next_payment_attempt
invoice_status
invoice_marked_uncollectible_at
invoice_metadata
invoice_receipt_number
invoice_statement
invoice_amount_due
invoice_total
invoice_subtotal
invoice_tax_percent
invoice_tax
invoice_app_fee
invoice_payment_attempts
invoice_amount_starting_balance
invoice_amount_ending_balance

INVOICE ITEM

invoice_item_id
invoice_item_currency
invoice_item_description
invoice_item_tax
invoice_item_amount

ORDER

order_id
order_status
order_currency
order_email
order_shipping_method
order_paid_time
order_fulfilled_time
order_cancelled_time
order_returned_time
order_updated_time
order_metadata
order_amount
order_amount_returned
order_app_fee

PAYOUT

payout_id
payout_type
payout_status
payout_currency
payout_arrival_date
payout_method
payout_description
payout_statement
payout_source_type
payout_failure_code
payout_failure_message
payout_failure_transaction_id
payout_metadata
payout_amount

QUERY

system_metadata.query_date_range_start
system_metadata.query_date_range_end
system_metadata.query_timezone
system_metadata.query_filters
system_metadata.query_date_start
system_metadata.query_date_end
system_metadata.query_duration
system_metadata.query_accounts
system_metadata.query_excluded_accounts

REFUND

refund_id
refund_status
refund_currency
refund_reason
refund_receipt_number
refund_metadata
refund_amount

REVIEW

review_id

SHIPPING ADDRESS

shipping_carrier
shipping_tracking_number
shipping_recipient_name
shipping_recipient_phone
shipping_line_1
shipping_line_2
shipping_address_zip
shipping_address_city
shipping_state
shipping_address_country

SOURCE

source_id
source_type
source_address_line_1
source_address_line_2
source_address_city
source_address_state
source_address_country
source_address_zip
source_address_zip_check
source_metadata

SOURCE CARD

source_card_brand
source_card_funding
source_card_country
source_card_name
source_card_exp_month
source_card_exp_year
source_card_fingerprint
source_card_tokenization
source_card_cvc_check
source_card_last4
source_card_last4_dynamic

SUBSCRIPTION

subscription_id
subscription_status
subscription_start_time
subscription_end_time
subscription_cancel_time
subscription_cancel_period_end
subscription_trial_start
subscription_trial_end
subscription_period_start
subscription_period_end
subscription_metadata
subscription_quantity
subscription_appfee_percent
subscription_tax_percent

SUBSCRIPTION ITEM

subscription_item_id
subscription_item_currency
subscription_item_description

SUBSCRIPTION PLAN

subscription_plan_id
product_id
subscription_product_name
subscription_plan_name
subscription_plan_interval
subscription_plan_statement
subscription_plan_metadata
subscription_plan_amount
subscription_plan_intervals
subscription_plan_trial_days

TAX RATES

tax_rate_id
tax_rate_description
tax_rate_name
tax_rate_jurisdiction

TIME

today
year
quarter
yearmonth
yearweek
yearweekiso
yearofweek
yearofweekiso
month
week
weekiso
dayofweek
dayofweekname
dayofweeknameiso
date
dayofmonth
hour
minute

TRANSFER

transfer_id
transfer_currency
transfer_description
transfer_reversed
transfer_source_type
transfer_source_transaction_id
transfer_destination_payment_id
transfer_group_id
transfer_metadata
transfer_amount
transfer_amount_reversed