Stripe fields

Prev Next

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

62 metrics203 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_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

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