Public preview

Query connected account data Public preview

Access structured attributes about your connected accounts, including onboarding milestones, activation dates, account configuration, and connection status.

The connect_merchants table includes data for all v1 Accounts and all v2 Accounts that have the merchant configuration.

Learn more about the features for Connect analytical data.

Before you begin

Review the table details before you get started:

Caution

Some onboarding milestones have limited historical coverage. For records before a coverage start, NULL means that Stripe didn’t capture the historical event. When comparing multiple milestones, limit the cohort to the latest applicable coverage start.

Get started with the data

The following query lists connected accounts for your platform with their configuration, country, and derived onboarding status. Because the status compares completed_onboarding_at and capabilities_fully_enabled_at, the query limits the onboarding cohort to December 2025 and later.

SELECT
 connected_account_merchant_id,
 identity__connected_account_merchant_country,
 identity__legal_entity_type,
 capability_summary_status,
 is_active_connection,
 connected_at,
 started_onboarding_at,
 completed_onboarding_at,
 capabilities_fully_enabled_at,
 CASE
 WHEN capabilities_fully_enabled_at IS NOT NULL THEN 'ENABLED'
 WHEN completed_onboarding_at IS NOT NULL THEN 'COMPLETED_NOT_ENABLED'
 WHEN started_onboarding_at IS NOT NULL THEN 'STARTED_NOT_COMPLETED'
 ELSE 'NOT_STARTED'
 END AS onboarding_status
FROM connect_merchants
-- Use the latest coverage start for the milestones compared above.
WHERE started_onboarding_at >= TIMESTAMP '2025-12-01 00:00:00'
ORDER BY connected_at DESC

Schema overview

The connect_merchants table is a current-state account dimension for all platform–connected account relationships. It’s a wide-dimension table, with each row representing one connected account and columns representing an account’s attributes and lifecycle status. This differs from the financial summary table, which is a vertical metrics table.

Identity and connection columns

These columns identify the platform–account relationship and its current connection state.

Core account attribute columns

Account behavior configuration columns

These columns describe the configured behavior of the connected account, such as who pays fees, who bears responsibility for negative balances, and how requirements are collected. Only controlling platforms can access them. For details about which v1 and v2 Account properties correspond to these columns, see the Account property map.

Onboarding milestone columns

These columns capture the timestamp, device type, and access method for each step in the connected account onboarding flow. All values are from the first occurrence of each event.

Financial activation columns

These columns capture the first date the connected account processed specific payment activity through the platform.

Example queries

Analyze the account onboarding funnel

Measure conversion at each step of the onboarding funnel. Use this query to identify bottlenecks and compare funnel performance across accounts.

SELECT
 identity__connected_account_merchant_country,
 COUNT(*) AS total_connections,
 COUNT(started_onboarding_at) AS started_onboarding,
 COUNT(authentication_completed_at) AS completed_authentication,
 COUNT(personal_and_business_details_completed_at) AS completed_personal_details,
 COUNT(bank_and_financial_details_completed_at) AS completed_bank_details,
 COUNT(completed_onboarding_at) AS completed_onboarding,
 COUNT(capabilities_fully_enabled_at) AS capabilities_enabled,
 ROUND(100.0 * COUNT(capabilities_fully_enabled_at) / NULLIF(COUNT(started_onboarding_at), 0), 1)
 AS start_to_enabled_pct
FROM connect_merchants
WHERE is_active_connection = TRUE
 -- Use the latest coverage start for the milestones compared above.
 AND started_onboarding_at >= TIMESTAMP '2025-12-01 00:00:00'
GROUP BY 1
ORDER BY total_connections DESC

Track activation milestones across connected accounts

Identify which connected accounts have processed their first payment, LPM transaction, or payout. Use this to track activation cohorts and find accounts that have onboarded but not yet transacted. Because this analysis uses capabilities_fully_enabled_at, the query limits the onboarding cohort to December 2025 and later.

SELECT
 connected_account_merchant_id,
 identity__connected_account_merchant_country,
 capabilities_fully_enabled_at,
 first_card_pay_in_date,
 first_lpm_pay_in_date,
 first_payout_date,
 CASE
 WHEN first_card_pay_in_date IS NOT NULL OR first_lpm_pay_in_date IS NOT NULL
 THEN 'ACTIVATED'
 WHEN capabilities_fully_enabled_at IS NOT NULL
 THEN 'ENABLED_NOT_ACTIVATED'
 ELSE 'NOT_ENABLED'
 END AS activation_status,
 DATE_DIFF('day', CAST(capabilities_fully_enabled_at AS DATE), first_card_pay_in_date)
 AS days_to_first_card_payment
FROM connect_merchants
WHERE is_active_connection = TRUE
 AND started_onboarding_at >= TIMESTAMP '2025-12-01 00:00:00'
ORDER BY capabilities_fully_enabled_at DESC

Segment accounts by configured behavior

Group connected accounts by configured behavior to audit your account portfolio.

SELECT
 connect_controller_fees_payer,
 connect_controller_losses_payments,
 connect_controller_requirement_collection,
 connect_controller_dashboard_type,
 COUNT(*) AS account_count,
 COUNT(CASE WHEN capability_summary_status = 'ENABLED' THEN 1 END) AS enabled_count,
 COUNT(CASE WHEN capability_summary_status = 'RESTRICTED' THEN 1 END) AS restricted_count,
 COUNT(CASE WHEN capability_summary_status = 'RESTRICTED_SOON' THEN 1 END) AS restricted_soon_count
FROM connect_merchants
WHERE is_active_connection = TRUE
GROUP BY 1, 2, 3, 4
ORDER BY account_count DESC

Join with financial summary for a combined account view

Combine account attributes from connect_merchants with financial performance from account_financial_summary_hourly. Join on (platform_merchant_id, connected_account_merchant_id), which use acct_… identifiers in both tables.

SELECT
 a.connected_account_merchant_id,
 a.identity__connected_account_merchant_country,
 a.capability_summary_status,
 a.capabilities_fully_enabled_at,
 a.first_card_pay_in_date,
 DATE_TRUNC('month', f.primary_revenue_date) AS activity_month,
 SUM(CASE WHEN f.category = 'VOLUME' AND f.metric_type = 'GROSS_CONNECT_PAY_IN'
 THEN f.amount_usd END) AS gross_pay_in_usd,
 SUM(CASE WHEN f.category = 'REVENUE' AND f.metric_type = 'APPLICATION_FEE'
 THEN f.amount_usd END) AS application_fee_usd
FROM connect_merchants a
LEFT JOIN account_financial_summary_hourly f
 ON a.platform_merchant_id = f.platform_merchant_id
 AND a.connected_account_merchant_id = f.connected_account_merchant_id
WHERE a.is_active_connection = TRUE
GROUP BY 1, 2, 3, 4, 5, 6
ORDER BY 6 DESC, 7 DESC NULLS LAST