Data slices

Pre-aggregated analytics endpoints — MRR, cash flow, P&L, balances, forecasts.

Reports in the SaaSFlow UI are powered by data slices: pre-aggregated analytics endpoints under /companies/{companyId}/data/{slice}. Each slice has typed parameters and returns a structured shape.

Single slice

POST /companies/{companyId}/data/{slice}
{
    "timeZone": "Europe/Berlin",
    ...sliceSpecificParams
}

All slices accept an optional timeZone and slice-specific filters (date range, account, product, etc.).

Batch

When you need multiple slices for the same screen, batch them:

POST /companies/{companyId}/data/batch
{
    "timeZone": "Europe/Berlin",
    "slices": [
        { "type": "mrrData", "from": "2026-01-01", "to": "2026-12-31" },
        { "type": "cashFlowTimeSeries", "from": "2026-01-01", "to": "2026-12-31" }
    ]
}

The batch endpoint runs slices in parallel server-side and returns:

{
    "results": [ ... ]
}

Available slices

Subscription metrics:

Slice	Powers
`mrrData`	MRR over time
`mrrAtDate`	MRR at a single date
`mrrByProduct`	MRR split by product
`mrrChangeEvents`	New / expansion / contraction / churn events
`customerMrr`	MRR per customer
`customerChanges`	Customers that changed in a period
`customerMonthlyData`	Per-customer monthly history
`monthlyData`	Per-month new / upgrade / downgrade / churn / revenue
`cohorts`	Cohort retention grid
`retentionCohortDetail`	Customer-level cell drill-down

Cash and balances:

Slice	Powers
`cashFlowTimeSeries`	Inflows / outflows per period (+ forecast option)
`cashFlowByCategory`	Cash flow split by category
`balanceTimeSeries`	Account balance over time
`accountBalanceByAccount`	Current balance per account
`accountBalanceKpis`	Total cash + change vs previous period
`balanceByCashType`	Balance split by account type

P&L:

Slice	Powers
`profitLossData`	Full P&L per period
`revenueExpenses`	Revenue/expense summary
`revenueExpensesBar`	Bar-chart data
`revenueExpensesByCategory`	Revenue/expenses by category
`topExpenseVendors`	Top expense vendors
`periodDetails`	Period-level detail

Generic:

Slice	Powers
`analytics`	Arbitrary analytics passthrough

Slice tools in MCP

Each slice is also exposed as an MCP tool named data_{slice}. See MCP tools.

Single slice

Batch

Available slices

Slice tools in MCP

On this page