Skip to content
Create account
or
Sign in
The Stripe Docs logo
/
Ask AI
Create account
Sign in
Get started
Payments
Revenue
Platforms and marketplaces
Money management
Developer tools
Overview
Billing
Tax
Reporting
Data
    Overview
    Schema
    Custom reports
    Sigma API
    Create custom reports
    Write queries using Sigma
    Query data across an organization
    Sync Stripe data
    Data Pipeline
    Export data to a data warehouse
    Export data to cloud storage
    Data management
    Data freshness
    Business and product data use cases
    Import external data
Startup incorporation
HomeRevenueData

Query data across accounts belonging to an organization

Use Sigma with Organizations to query multiple accounts.

Copy page

If you use Organizations, you can use Sigma to run queries across multiple accounts. These queries can provide insight into your customers and payments across your entire business.

Get started

Before you begin, complete the following steps:

  1. Create an organization, adding all the accounts you want to include in your queries.
  2. Enable Sigma in each account you want to include in your queries.

To run and execute Sigma queries, you must be assigned an organization-level role with permissions to view reports, such as Analyst.

Run Sigma queries across multiple accounts

To run Sigma queries that span multiple accounts in your organization, follow these steps:

  1. From the Dashboard, use the account picker to select your organization. Expand Reporting, then click Sigma.

  2. Write a new query, choose from saved queries, or select from the list of templates.

  3. To specify the accounts you want to run your query on, click Run on accounts, then Select accounts.

  4. Run the query across the accounts you selected.

Return results for each account

By default, queries return results that include data across all selected accounts. To return results for each account, you can group results by merchant_id. For example, the following query returns the sum of Payment Intents in the last 14 days for each account and currency:

select merchant_id, currency, sum(amount) as total_payment_volume_last_14d from payment_intents where created >= date_add('day', -14, current_date) group by 1, 2
merchant_idcurrencytotal_payment_volume_last_14d
acct_kHLem4cG1kCcijnUSD4934823
acct_sExiya3VvONSEKGCAD2235991
acct_7jql9fyNXKn3p7UGBP1870021
acct_GKW0D80lncUHiBuEU9008212

Filter accounts within a query

To use the merchant_id field to filter results to specific accounts directly in your query, add a WHERE merchant_id = 'acct_id' clause. For example, the following query returns the total volume of payments in a specific account:

select currency, sum(amount) as total_payment_volume_last_14d from payment_intents where created >= date_add('day', -14, current_date) AND merchant_id in ( 'acct_d8upQPPBbFtSIe1', 'acct_1fCSEPk3waoDZox' ) group by 1
currencytotal_payment_volume_last_14d
USD8833809
CAD9008212
Was this page helpful?
YesNo
Need help? Contact Support.
Join our early access program.
Check out our changelog.
Questions? Contact Sales.
LLM? Read llms.txt.
Powered by Markdoc