Connect analytical data
A complete, curated view of financial and account data across all your connected accounts.
Connect analytical data is a centralised, curated data layer that gives platforms a complete view of payment activity, revenue and fees across all their connected accounts and charge flows. Query it in Sigma or Stripe Data Pipeline to analyse your entire Connect business with numbers that stay consistent with the Stripe Dashboard and Connect Insights.
Connect analytical data covers all of your connected accounts and every Connect charge flow – including destination charges, on-behalf-of charges, facilitated direct charges and separate charges and transfers. For more information, see Connect charge types. It includes payment activity, revenue and fees across your platform that aren’t available in standard Connect reporting tables.
Features
| Volume reporting | Track gross pay-in and transfer volume across all connected accounts and charge flows. |
|---|---|
| Revenue and margin analysis | Analyse application fees, implicit application fees, revenue share, Stripe fees and network costs to calculate account-level and transaction-level margins. |
| Transaction investigation and reconciliation | Inspect individual charges, itemised fees, refunds and disputes, and reconcile payment activity with connected-account summaries. |
| Chargeback monitoring | Track disputes and refunds by connected account and charge flow. |
| Payout analytics | Report on payout volume and count by connected account. |
| Portfolio and onboarding analysis | Analyse your connected-account portfolio, measure onboarding funnels and track activation milestones. |
Datasets
The following datasets are available:
Financial summary
Use the account_financial_summary_hourly table to analyse financial metrics, including volume, revenue, fees, chargebacks and payouts.
Connect merchants
Use the connect_merchants table to analyse account data such as onboarding milestones, activation dates, behaviour settings and connection status.
Payments
Use connect_payments with transaction-level details for individual charges, including payment volume, revenue, itemised fees, network costs, refunds, disputes and margin.
Availability
Connect analytical data is available for Connect platforms that use Sigma or Stripe Data Pipeline.