We built Stripe Sigma to help businesses quickly analyse their Stripe data and to enable teams to get faster business insights.
Use predefined SQL queries or write new custom queries right inside the Stripe Dashboard – no data engineering required.
With structured access to your data, you can easily identify which customers are least likely to churn, which geographies contribute the most revenue, and more.
Get answers to all your Stripe-related questions when you need them. Reports can be scheduled and automatically generated on a daily, weekly, or monthly basis.
Move faster by saving frequently-run queries. Share queries with other teams directly in Sigma or download them as CSV reports.
What percentage of disputes did we contest?
What was our charge volume in February?
Which customers have not paid their invoices?
Which charges reconcile with our latest bank payout?
How much does cash flow change from month to month?
What is our company's daily balance?
How many active customers do we have?
Why do customers dispute payments?
What are our most popular subscription plans?
How many payments are made with each payment card brand?
How much revenue comes from different customer channels?
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 pre-built 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.
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.
Save frequently-used queries to run them again at any time or share a link to a useful query so that any of your team-mates 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.
Sigma gives us legitimate evidence to challenge a chargeback, whereas before Stripe, we had no visibility whatsoever. The new level of data and insight we can get out of Stripe compared to what we could get previously is just night and day. It really helped us improve and speed up our decision-making.
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.
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.
Have all your Stripe data at your fingertips and pull custom Stripe reports with SQL. Sigma is charged when a user or connected account processes a transaction or submits an authorization or payment request.
With Stripe Organisations, centrally manage all lines of business or subsidiaries across multiple Stripe accounts in the Dashboard, and access new business insights by using Sigma to analyse data across all your accounts.
Analyse and create custom reports using your Stripe data.
Details on how to build custom Stripe reports.
Simplify accrual accounting.