The Wayback Machine - https://web.archive.org./web/20220409062254/https://stripe.com/en-gb-us/sigma

Your business data at your fingertips

Instant answers powered by SQL

We built Stripe Sigma to help businesses quickly analyse their Stripe data and to enable teams to get faster business insights.

  • Know your company

    With structured access to your data, you can identify which customers are least likely to churn this year, look up which geographies contribute the most revenue, see which products are most popular in February, and much more.

  • No setup, no ETLs

    Just write SQL queries to create custom reports and get instant answers, right inside the Dashboard - no need to dedicate engineers to build or maintain data pipelines or warehouses.

  • Democratise data

    Free data from silos and let teammates from finance, support, product management, and other teams run reports directly and take action faster.

Ready to use Stripe Sigma?

Activate a free trial for your business or learn more below.

Optimised for fast answers

We’ve already written the queries for the most useful reports for different types of businesses: From computing ARPU to analysing the payment methods your customers prefer, you can jump in quickly by editing one of our prebuilt templates or start from scratch to fully customise your report. We’ve also added syntax highlighting, descriptive errors, and auto-completion for data tables and columns - it’s like a built-in IDE for writing queries.

Syntax documentation

selectid,amount,currency,source_idfrombalance_transactions
  • idPrimary key

    Unique ID.

  • amountBigint

    The amount (in the smallest currency unit; e.g. cents in USD and yen in JPY).

  • amount_dueBigint
  • amount_offBigint
  • amount_refundedBigint
  • amount_reversedBigint
  • customersTable
  • customers.account_balanceBigint
  • customers.business_vat_idVarchar
  • customers.createdTimestamp
  • customers.currencyVarchar
  • customers.default_source_idVarchar
  • customers.delinquentBoolean
  • customers.descriptionVarchar
  • customers.discount_coupon_idForeign key
  • source_idForeign key

    ID of the related payment source.

  • source_transaction_idVarchar
  • source_transfer_idVarchar
  • source_typeVarchar
  • sourcesTable
  • sources_metadataTable
  • sources_metadata.keyVarchar
  • source_idForeign key

    ID of the related payment source.

  • source_transaction_idVarchar
  • source_transfer_idVarchar
  • source_typeVarchar
  • source_idForeign key

    ID of the related payment source.

  • balance_transactionsTable
  • balance_transactions.amountBigint
  • balance_transactions.automatic_transfer_idForeign key
  • balance_transactions.available_onTimestamp
  • balance_transactions.createdTimestamp
  • balance_transactions.currencyVarchar

Stripe data, at the ready

Quick sidebar access to a full map of the structure of your data stored in Stripe (including any additional metadata you send us) makes it easy to combine all the relevant data needed from across Stripe’s products - payments, payouts, customers, subscriptions, refunds, and more.

Preview the full schema available in Stripe Sigma.

No column or table names matched.
Payment tables
balance_transaction_fee_details
balance_transaction_idvarchar
amountbigint
applicationvarchar
currencyvarchar
descriptionvarchar
typevarchar
balance_transactions
idvarchar
amountbigint
available_ontimestamp
createdtimestamp
currencyvarchar
descriptionvarchar
feebigint
netbigint
statusvarchar
typevarchar
source_idvarchar
automatic_transfer_idvarchar
charges
idvarchar
amountbigint
amount_refundedbigint
application_fee_idvarchar
balance_transaction_idvarchar
capturedboolean
createdtimestamp
currencyvarchar
customer_idvarchar
descriptionvarchar
destination_idvarchar
dispute_idvarchar
failure_codevarchar
failure_messagevarchar
invoice_idvarchar
order_idvarchar
paidboolean
receipt_emailvarchar
receipt_numbervarchar
refundedboolean
statement_descriptorvarchar
statusvarchar
source_transfer_idvarchar
transfer_idvarchar
transfer_groupvarchar
application_idvarchar
source_idvarchar
card_idvarchar
card_address_cityvarchar
card_address_countryvarchar
card_address_line1varchar
card_address_line1_checkvarchar
card_address_line2varchar
card_address_statevarchar
card_address_zipvarchar
card_address_zip_checkvarchar
card_brandvarchar
card_countryvarchar
card_customer_idvarchar
card_cvc_checkvarchar
card_dynamic_last4varchar
card_exp_monthinteger
card_exp_yearinteger
card_fingerprintvarchar
card_fundingvarchar
card_last4varchar
card_namevarchar
card_tokenization_methodvarchar
charges_metadata
charge_idvarchar
keyvarchar
valuevarchar
disputes
idvarchar
amountbigint
charge_idvarchar
createdtimestamp
currencyvarchar
is_charge_refundableboolean
reasonvarchar
statusvarchar
evidence_access_activity_logvarchar
evidence_billing_addressvarchar
evidence_cancellation_policy_idvarchar
evidence_cancellation_policy_disclosurevarchar
evidence_cancellation_rebuttalvarchar
evidence_customer_communication_idvarchar
evidence_customer_email_addressvarchar
evidence_customer_namevarchar
evidence_customer_purchase_ipvarchar
evidence_customer_signature_idvarchar
evidence_duplicate_charge_documentation_idvarchar
evidence_duplicate_charge_idvarchar
evidence_product_descriptionvarchar
evidence_receipt_idvarchar
evidence_refund_policy_idvarchar
evidence_refund_policy_disclosurevarchar
evidence_refund_refusal_explanationvarchar
evidence_service_datevarchar
evidence_service_documentation_idvarchar
evidence_shipping_addressvarchar
evidence_shipping_carriervarchar
evidence_shipping_datevarchar
evidence_shipping_documentation_idvarchar
evidence_shipping_tracking_numbervarchar
evidence_uncategorized_file_idvarchar
evidence_uncategorized_textvarchar
evidence_details_due_bytimestamp
evidence_details_has_evidenceboolean
evidence_details_past_dueboolean
evidence_details_submission_countinteger
disputes_metadata
dispute_idvarchar
keyvarchar
valuevarchar
refunds
idvarchar
amountbigint
balance_transaction_idvarchar
charge_idvarchar
createdtimestamp
currencyvarchar
reasonvarchar
receipt_numbervarchar
statusvarchar
refunds_metadata
refund_idvarchar
keyvarchar
valuevarchar
Transfer tables
transfer_reversals
idvarchar
amountbigint
balance_transaction_idvarchar
createdtimestamp
currencyvarchar
transfer_idvarchar
transfers
idvarchar
amountbigint
amount_reversedbigint
application_fee_idvarchar
balance_transaction_idvarchar
createdtimestamp
currencyvarchar
datetimestamp
descriptionvarchar
destination_idvarchar
destination_payment_idvarchar
failure_codevarchar
failure_messagevarchar
reversedboolean
source_transaction_idvarchar
source_typevarchar
statement_descriptorvarchar
statusvarchar
transfer_groupvarchar
typevarchar
transfers_metadata
transfer_idvarchar
keyvarchar
valuevarchar
Customer tables
customers
idvarchar
account_balancebigint
business_vat_idvarchar
createdtimestamp
currencyvarchar
delinquentboolean
descriptionvarchar
emailvarchar
default_source_idvarchar
shipping_namevarchar
shipping_phonevarchar
shipping_address_cityvarchar
shipping_address_countryvarchar
shipping_address_line1varchar
shipping_address_line2varchar
shipping_address_postal_codevarchar
shipping_address_statevarchar
discount_coupon_idvarchar
discount_customer_idvarchar
discount_endtimestamp
discount_starttimestamp
discount_subscriptionvarchar
customers_metadata
customer_idvarchar
keyvarchar
valuevarchar
Billing tables
coupons
idvarchar
amount_offbigint
createdtimestamp
currencyvarchar
durationvarchar
duration_in_monthsinteger
max_redemptionsinteger
percent_offinteger
redeem_bytimestamp
times_redeemedinteger
validboolean
coupons_metadata
coupon_idvarchar
keyvarchar
valuevarchar
invoice_items
idvarchar
amountbigint
currencyvarchar
customer_idvarchar
datetimestamp
descriptionvarchar
discountableboolean
invoice_idvarchar
period_endtimestamp
period_starttimestamp
plan_idvarchar
prorationboolean
quantityinteger
subscription_idvarchar
invoice_items_metadata
invoice_item_idvarchar
keyvarchar
valuevarchar
invoice_line_items
invoice_idvarchar
source_idvarchar
amountbigint
currencyvarchar
descriptionvarchar
discountableboolean
period_endtimestamp
period_starttimestamp
plan_idvarchar
prorationboolean
quantityinteger
subscriptionvarchar
source_typevarchar
invoices
idvarchar
amount_duebigint
application_feebigint
attempt_countinteger
attemptedboolean
charge_idvarchar
closedboolean
currencyvarchar
customer_idvarchar
datetimestamp
descriptionvarchar
ending_balancebigint
forgivenboolean
next_payment_attempttimestamp
paidboolean
period_endtimestamp
period_starttimestamp
receipt_numbervarchar
starting_balancebigint
statement_descriptorvarchar
subscription_idvarchar
subscription_proration_datetimestamp
subtotalbigint
taxbigint
tax_percentdouble
totalbigint
webhooks_delivered_attimestamp
discount_coupon_idvarchar
discount_customer_idvarchar
discount_endtimestamp
discount_starttimestamp
discount_subscriptionvarchar
invoices_metadata
invoice_idvarchar
keyvarchar
valuevarchar
plans
idvarchar
amountbigint
createdtimestamp
currencyvarchar
intervalvarchar
interval_countinteger
namevarchar
statement_descriptorvarchar
trial_period_daysinteger
plans_metadata
plan_idvarchar
keyvarchar
valuevarchar
subscriptions
idvarchar
application_fee_percentdouble
cancel_at_period_endboolean
canceled_attimestamp
createdtimestamp
current_period_endtimestamp
current_period_starttimestamp
customer_idvarchar
ended_attimestamp
plan_idvarchar
quantityinteger
starttimestamp
statusvarchar
tax_percentdouble
trial_endtimestamp
trial_starttimestamp
discount_coupon_idvarchar
discount_customer_idvarchar
discount_endtimestamp
discount_starttimestamp
discount_subscriptionvarchar
subscriptions_metadata
subscription_idvarchar
keyvarchar
valuevarchar
Other tables
application_fees
idvarchar
account_idvarchar
amountbigint
amount_refundedbigint
application_idvarchar
balance_transaction_idvarchar
charge_idvarchar
createdtimestamp
currencyvarchar
originating_transaction_idvarchar
refundedboolean
sources
idvarchar
amountbigint
client_secretvarchar
createdtimestamp
currencyvarchar
flowvarchar
statusvarchar
typevarchar
usagevarchar
code_verification_attempts_remaininginteger
code_verification_statusvarchar
owner_emailvarchar
owner_namevarchar
owner_phonevarchar
owner_verified_emailvarchar
owner_verified_namevarchar
owner_verified_phonevarchar
owner_address_cityvarchar
owner_address_countryvarchar
owner_address_line1varchar
owner_address_line2varchar
owner_address_postal_codevarchar
owner_address_statevarchar
owner_verified_address_cityvarchar
owner_verified_address_countryvarchar
owner_verified_address_line1varchar
owner_verified_address_line2varchar
owner_verified_address_postal_codevarchar
owner_verified_address_statevarchar
receiver_addressvarchar
receiver_amount_chargedbigint
receiver_amount_receivedbigint
receiver_amount_returnedbigint
redirect_return_urlvarchar
redirect_statusvarchar
redirect_urlvarchar
sources_metadata
source_idvarchar
keyvarchar
valuevarchar
transfer_reversals_metadata
transfer_reversal_idvarchar
keyvarchar
valuevarchar

Save and share queries with your team

Save frequently-used queries to run them again at any time or share a link to a useful query so that any of your teammates can use it too.

Stripe Sigma has helped accelerate our financial close process. Instead of manually combining multiple data sources each month, we’re now able to run a few simple queries in Sigma, enabling faster monthly reconciliation for credit card transactions.

Kelly Hofmann, Revenue Accounting

With a query that took less than 5 minutes to write, our team has been able to identify unpaid invoices and recapture tens of thousands of dollars of revenue - 8 percent of failed payments - in just two months.

Steven Moldavskiy, Business Intelligence

We handle orders for thousands of stores, so financial reporting can get challenging. Stripe Sigma gives us a lightning-fast, reliable way to analyse our financial data and helps us run the business more efficiently.

James Skidmore, Co-founder & COO

Before Stripe Sigma, we built our own tool to analyse our Stripe data, but it took our engineers weeks to build, required ongoing work to maintain and update, and it wasn’t always accurate. Sigma now gives all our teams accurate data without any engineering work.

Tracy Rogers, Data Scientist

Pricing

Stripe warehouses and makes all of your business’s historical data highly available with extensive parallelism so that you can generate even complex reports in seconds. Stripe Sigma’s monthly pricing is based on how many charges, authorisations, and application fees your business processed in the previous month. Learn more

  • 0–500

    /charge

  • 501–1,000

    1.8¢/charge

  • 1,001–5,000

    1.6¢/charge

  • 5,001–50,000

    1.4¢/charge

  • 50,001–∞

infrastructure fee