# Connect analytical data

A complete, curated view of financial and account data across all your connected accounts.

Connect analytical data is a centralized, 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](https://docs.stripe.com/data/sigma.md) or [Stripe Data Pipeline](https://docs.stripe.com/data/access-data-in-warehouse.md) to analyze your entire Connect business with numbers that stay consistent with the Stripe Dashboard and [Connect Insights](https://docs.stripe.com/connect/dashboard/understand-your-connect-business.md).

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](https://docs.stripe.com/connect/charges.md). 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 | Analyze 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, itemized 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 | Analyze your connected-account portfolio, measure onboarding funnels, and track activation milestones. |

## Datasets

The following curated datasets are available in public preview:

[Financial summary](https://docs.stripe.com/data/connect-analytical-data/financial-summary.md): Use the `account_financial_summary_hourly` table to analyze financial metrics, including volume, revenue, fees, chargebacks, and payouts.

[Connect merchants](https://docs.stripe.com/data/connect-analytical-data/merchants.md): Use the `connect_merchants` table to analyze account data such as onboarding milestones, activation dates, behavior settings, and connection status.

[Payments](https://docs.stripe.com/data/connect-analytical-data/payments.md): Use `connect_payments` with transaction-level details for individual charges, including payment volume, revenue, itemized fees, network costs, refunds, disputes, and margin.

## Availability

Connect analytical data is in public preview for Connect platforms that use [Sigma](https://docs.stripe.com/data/sigma.md) or [Stripe Data Pipeline](https://docs.stripe.com/data/access-data-in-warehouse.md). Datasets become available in your workspace as each one completes rollout.