Share this post on Twitter

Better Stripe Connect support in Sigma

Brian Zeng on December 20, 2017

We built Sigma to help businesses quickly analyze their Stripe data and get to insights faster. Today, we’re adding the ability for Connect platforms to query data about their connected accounts as well.

Platforms like DoorDash, Catawiki, OrderMyGear, and others accept money and pay out to hundreds of thousands of sellers and service providers around the world. For platforms like these, analyzing data for specific accounts or across accounts gets very tricky—often requiring paginating and collating responses across multiple API calls or exporting disparate datasets into a custom analytics stack.

Since launch, many platforms and marketplaces have already started using Sigma to query aggregate data about their businesses. With this update, platforms can quickly use standard SQL queries to look up data for both a specific connected account or across connected accounts.

For example, platforms can now generate a summary of their connected accounts with details such as number of charges, total processed volume, and current balance in various currencies to quickly identify parts of the platform that need attention or new business opportunities:

Business name Country Number of charges Gross volume Currency
Rocketship Inc. US 6,230 321252.49 usd
Pampurred Cats US 1,011 22233.49 usd
Vinted Vellum HK 35,508 952146.23 hkd
Monster Cookies CA 62,744 1334934.66 cad

Platforms can also customize the reports to include just the data columns that are most useful. You can look up the verification status of connected accounts and follow up with sellers who haven’t completed the onboarding process or use Sigma to find connected accounts with active disputes:

Service provider Payments enabled Payouts enabled Verification required Account balance
Hemant B. TRUE TRUE 0
Brian Z. TRUE FALSE legal_entity.verification.document -12.98
Charlie M. TRUE TRUE 0

As with any Sigma query, you can turn these platform-specific queries into a daily, weekly, or monthly report—we’ll automatically run the query on the chosen schedule and email you the results.

These new features currently work for Stripe Connect platforms using Custom or Express accounts. (We don’t have support for platforms querying their Standard accounts at this time.)

We hope these new data tables help platforms analyze their business quickly and easily. If you have questions or feedback, we’d love to hear from you!

Start a free trial of Stripe Sigma for your platform. Request access