This page documents all 15 views available to the Analytics API. You can also fetch this live for your account from GET /schema.

Conventions:

Monetary columns are integer cents unless noted — divide by 100 for display.
UInt64/Int64 values are returned as JSON strings (precision-safe); parse client-side.
Nullable(...) columns can be null.
Facts join to dimensions on the *_id columns called out below.

How the tables join

dim_customer ──< fact_signal >── dim_product
     │   │             │ (trace_id)
     │   │             └──────────────< fact_cost >── dim_product
     │   │
     │   └──< fact_delivered_value (signal_id ↔ fact_signal.signal_id)
     │
     ├──< fact_order >── dim_plan
     │       └──< fact_order_line >── dim_product
     │
     ├──< fact_invoice >──< fact_invoice_line (order_line_id ↔ fact_order_line.id)
     ├──< fact_payment (invoice_id ↔ fact_invoice.id)
     ├──< fact_usage_summary (order_line_id ↔ fact_order_line.id)
     └──< fact_credit_transaction >── dim_credits_currency

Common join keys:

From	Column	To
any fact	`customer_id`	`dim_customer.id`
any fact	`product_id`	`dim_product.id`
`fact_signal`	`trace_id`	`fact_cost.trace_id` (cost-per-signal)
`fact_signal`	`signal_id`	`fact_delivered_value.signal_id`
`fact_order`	`plan_id`	`dim_plan.id`
`fact_invoice_line`	`order_line_id`	`fact_order_line.id` (revenue by product)
`fact_payment`	`invoice_id`	`fact_invoice.id`
`fact_credit_transaction`	`credits_currency_id`	`dim_credits_currency.id`

Dimensions

`dim_customer`

One row per customer. Join id to any fact’s customer_id. Supports hierarchy rollups (parent_customer_id), segmentation (annual_revenue, status, churn_date), and geography (country/state/city).

Column	Type	Description
`id`	UUID	Internal customer UUID. Primary key.
`name`	String	Customer display name.
`legal_name`	String	Legal entity name. May differ from display name.
`email`	String	Primary email address.
`external_id`	String	Customer ID in your external system.
`display_id`	String	Human-readable short id (e.g. CUST-001).
`parent_customer_id`	Nullable(UUID)	Parent customer for hierarchy rollups. NULL if top-level.
`default_currency`	String	Default billing/reporting currency (e.g. USD).
`status`	String	Lifecycle status (e.g. active, churned).
`churn_date`	Nullable(DateTime64)	When the customer churned. NULL if active.
`annual_revenue`	Nullable(Int64)	Self-reported annual revenue in whole dollars.
`creation_source`	String	Acquisition channel/source (e.g. api, csv_import).
`country`	String	Country from billing address.
`state`	String	State/region from billing address.
`city`	String	City from billing address.
`created_at`	DateTime64	When the record was created.
`updated_at`	DateTime64	When the record was last modified.

`dim_product`

One row per product (also called an agent). Products are AI agents/services or prepaid credit bundles. Join id to any fact’s product_id.

Column	Type	Description
`id`	UUID	Internal product UUID. Primary key.
`name`	String	Product display name.
`description`	String	Product description.
`external_id`	String	Product ID in your external system.
`display_id`	String	Human-readable short id (e.g. PRD-001).
`product_code`	String	Internal/external product code or SKU.
`type`	String	`agent` (AI agent/service) or `prepaidCreditBundle`.
`active`	Bool	Whether the product is currently active/sellable.
`credits_currency_id`	Nullable(UUID)	For `prepaidCreditBundle` products, the credits currency sold.
`metadata`	String	User-defined JSON metadata.
`archived_at`	Nullable(DateTime64)	When archived. NULL if active.
`created_at`	DateTime64	When the product was created.
`updated_at`	DateTime64	When the product was last modified.

`dim_plan`

A plan is a pricing configuration within a plan group. Plans form an upgrade/downgrade chain via has_next_plan/has_prev_plan. Join from fact_order.plan_id.

Column	Type	Description
`id`	UUID	Plan UUID. Primary key.
`name`	String	Plan display name (e.g. Free, Standard, Premium).
`description`	String	Plan description.
`plan_group_id`	UUID	Groups related plans (e.g. tiers of a pricing page).
`type`	String	`flat` (fixed fee), `usage` (metered), or `credit` (prepaid).
`billing_frequency`	String	How often billed (e.g. monthly, yearly).
`billing_type`	String	`Advance` (pre-pay) or `Arrears` (post-pay).
`has_next_plan`	UInt8	1 if a higher-tier plan exists, else 0.
`has_prev_plan`	UInt8	1 if a lower-tier plan exists, else 0.
`created_at`	DateTime64	When the plan was created.
`updated_at`	DateTime64	When the plan was last modified.

`dim_credits_currency`

Defines the types of credits your organization uses. Join from fact_credit_transaction.credits_currency_id or dim_product.credits_currency_id.

Column	Type	Description
`id`	UUID	Credits currency UUID. Primary key.
`name`	String	Display name (e.g. “AI Credits”).
`key`	String	Unique programmatic key (e.g. “ai_credits”).
`description`	String	What this credits currency represents.
`archived_at`	Nullable(DateTime64)	When archived. NULL if active.
`created_at`	DateTime64	When created.
`updated_at`	DateTime64	When last modified.

`dim_organization`

Your organization. Typically one row.

Column	Type	Description
`id`	UUID	Organization UUID. Primary key.
`name`	String	Organization display name.
`created_at`	DateTime64	When created.
`updated_at`	DateTime64	When last modified.

Usage

`fact_signal`

One row per signal (event) — the core usage metric. COUNT over time, group by signal_name, customer_id, or product_id. Join trace_id to fact_cost for cost-per-signal, or signal_id to fact_delivered_value for value delivered.

Column	Type	Description
`signal_id`	String	Unique signal id (MongoDB ObjectID — not a UUID). Primary key.
`signal_name`	String	Signal type name (e.g. api_call, document_processed).
`product_id`	Nullable(UUID)	Product (agent) that generated the signal.
`customer_id`	Nullable(UUID)	Customer the signal is attributed to.
`trace_id`	Nullable(String)	OpenTelemetry trace id. Join to `fact_cost.trace_id`.
`has_delivered_value`	UInt8	1 if the signal has delivered-value calculations.
`data`	JSON	Your free-form JSON payload. Schema varies per `signal_name`. See querying metadata.
`created_at`	DateTime64	When the signal was recorded. Use for time-series.

Cost

`fact_cost`

One row per AI/LLM call. SUM(cost_amount) for total spend; group by vendor, model, customer_id, or product_id. Includes token usage and latency.

Column	Type	Description
`cost_id`	String	Unique cost trace id (MongoDB ObjectID). Primary key.
`trace_id`	String	OpenTelemetry trace id. Join to `fact_signal.trace_id`.
`customer_id`	Nullable(UUID)	Customer attributed. NULL if unattributed.
`external_customer_id`	Nullable(String)	External customer id you provided.
`product_id`	Nullable(UUID)	Product attributed. NULL if unattributed.
`external_agent_id`	Nullable(String)	External product/agent id you provided.
`vendor`	String	AI provider (e.g. openai, anthropic, mistral).
`model`	String	Model identifier (e.g. gpt-4, claude-3-sonnet).
`trace_name`	String	Operation type (e.g. chat, embeddings).
`cost_amount`	Int64	Cost in cents. `SUM` for total spend.
`cost_currency`	String	Currency code for `cost_amount`.
`input_tokens`	Int64	Input/prompt tokens consumed. 0 if unavailable.
`output_tokens`	Int64	Output/completion tokens generated. 0 if unavailable.
`signal_name`	Nullable(String)	Linked signal name, if attributed.
`start_time`	DateTime64	When the call started. Use for time-series.
`end_time`	DateTime64	When the call completed.
`duration_ms`	Int64	Call duration in milliseconds.
`pricing_used`	Nullable(String)	JSON of the pricing config used. NULL on older traces.

Delivered value

`fact_delivered_value`

The business value delivered per signal, by value type. Join signal_id to fact_signal, or customer_id/product_id to dimensions.

Column	Type	Description
`signal_id`	String	Source signal id (MongoDB ObjectID).
`signal_name`	String	Semantic event type name.
`organization_id`	String	Organization that owns the signal.
`product_id`	Nullable(String)	Internal product UUID.
`customer_id`	Nullable(String)	Internal customer UUID.
`value_type_id`	String	UUID of the value type.
`value_type_name`	String	Display name of the value type.
`value_type_slug`	String	Stable slug for the value type.
`delivered_value_cents`	Int64	Monetary value in cents.
`delivered_value_currency`	String	Currency code.
`unit_value`	Float64	Raw unit value (e.g. hours saved).
`unit`	String	Unit identifier.
`unit_category`	String	Unit category (e.g. duration, count).
`effective_timestamp`	DateTime64	Historical timestamp, else created_at.
`created_at`	DateTime64	When the source signal was created.

Revenue & billing

`fact_order`

Contracts and subscriptions — one row per order. Join customer_id to dim_customer, plan_id to dim_plan. Compare total_billed_amount to total_amount for billing progress.

Column	Type	Description
`id`	UUID	Order UUID. Primary key.
`display_id`	String	Human-readable order id.
`external_id`	String	Order id in your external system.
`customer_id`	UUID	Customer who owns the contract.
`billing_customer_id`	Nullable(UUID)	Bill-to customer if different from `customer_id`.
`plan_id`	Nullable(UUID)	Pricing plan. NULL if none attached.
`name`	String	Order display name.
`status`	String	`draft` or `active`.
`currency`	String	ISO currency code.
`total_amount`	Int64	Total contract value (cents) over the full term.
`order_amount`	Int64	Order amount (cents) before billing.
`total_billed_amount`	Int64	Cumulative billed so far (cents, incl tax).
`billed_amount_no_tax`	Int64	Total billed excluding tax (cents).
`billed_tax`	Int64	Total tax billed so far (cents).
`pending_billing_amount`	Int64	Amount not yet billed (cents).
`payment_terms`	String	DueOnReceipt, Net15, Net30, …
`subscription_terms`	Int32	Term length in billing periods.
`start_date`	DateTime64	Contract start date.
`end_date`	Nullable(DateTime64)	Contract end date. NULL if open-ended.
`metadata`	String	User-defined JSON metadata.
`created_at`	DateTime64	When created.
`updated_at`	DateTime64	When last modified.

`fact_order_line`

Product-level order line items — links products to revenue. SUM(total_amount) by product_id for revenue-by-product. Filter effective_until IS NULL for current lines only.

Column	Type	Description
`id`	UUID	Order line UUID. Primary key.
`display_id`	String	Human-readable line id.
`order_id`	UUID	Parent order. Join to `fact_order.id`.
`product_id`	UUID	Product on this line. Join to `dim_product.id`.
`customer_id`	UUID	Customer who owns the order (denormalized).
`currency`	String	Currency code (denormalized from order).
`name`	String	Line item name.
`description`	String	Line item description.
`line_type`	String	STANDARD, PRORATION_CREDIT, or PRORATION_CHARGE.
`status`	String	`draft` or `active`.
`total_amount`	Int64	Line total contract value (cents).
`total_billed_amount`	Int64	Cumulative billed on this line (cents, incl tax).
`billed_amount_no_tax`	Int64	Total billed excluding tax (cents).
`billed_tax`	Int64	Tax billed on this line (cents).
`effective_until`	Nullable(DateTime64)	When superseded by an amendment. NULL = current.
`start_date`	DateTime64	Line billing start date.
`end_date`	Nullable(DateTime64)	Line billing end date. NULL if open-ended.
`created_at`	DateTime64	When created.
`updated_at`	DateTime64	When last modified.

`fact_invoice`

One row per invoice. SUM(total_incl_tax) for revenue; filter status = 'posted' for finalized invoices. Use due_date + payment_status for aging analysis.

Column	Type	Description
`id`	UUID	Invoice UUID. Primary key.
`display_number`	String	Human-readable invoice number (e.g. INV-001).
`display_id`	String	Short id shown in the UI.
`customer_id`	UUID	Customer billed. Join to `dim_customer.id`.
`order_id`	Nullable(UUID)	Order this invoice belongs to. NULL for manual invoices.
`status`	String	building, draft, pending, posted, voided, canceled, error.
`payment_status`	String	pending, paid, partiallyPaid, overdue, error.
`source`	String	order_based or manual.
`currency`	String	ISO currency code.
`total_excl_tax`	Int64	Total excluding tax (cents).
`total_incl_tax`	Int64	Total including tax (cents). Primary revenue metric.
`tax_amount`	Int64	Tax amount (cents).
`tax_rate`	Float64	Tax rate as a fraction (0.2 = 20%).
`tax_exempt`	Bool	Whether the invoice is tax-exempt.
`discount_amount`	Int64	Total discount applied (cents).
`amount_paid`	Int64	Amount collected (cents).
`amount_due`	Int64	Outstanding amount owed (cents).
`amount_remaining`	Int64	Remaining balance after payments and credit notes (cents).
`credit_notes_total`	Int64	Total credited back via credit notes (cents).
`issue_date`	DateTime64	When issued. Primary date for revenue time-series.
`posted_date`	Nullable(DateTime64)	When finalized/posted. Use for revenue recognition.
`due_date`	Nullable(DateTime64)	Payment due date.
`start_date`	DateTime64	Billing period start.
`end_date`	Nullable(DateTime64)	Billing period end.
`metadata`	String	User-defined JSON metadata.
`created_at`	DateTime64	When created.
`updated_at`	DateTime64	When last modified.

`fact_invoice_line`

One row per line on an invoice. Join order_line_id → fact_order_line.id → dim_product.id to break invoiced revenue down by product.

Column	Type	Description
`id`	UUID	Invoice line UUID. Primary key.
`display_id`	String	Human-readable line id.
`invoice_id`	UUID	Parent invoice. Join to `fact_invoice.id`.
`order_id`	Nullable(UUID)	Order this line relates to.
`order_line_id`	Nullable(UUID)	Order line this was generated from.
`description`	String	Line item description.
`payment_status`	String	pending, paid, partiallyPaid, overdue, error.
`currency`	String	ISO currency code.
`quantity`	Int32	Quantity billed (e.g. signals, seats, units).
`amount_before_discount`	Int64	Amount before discounts (cents).
`discount_amount`	Int64	Discount applied (cents).
`total_before_tax`	Int64	Total after discount, before tax (cents).
`tax`	Int64	Tax amount (cents).
`tax_rate`	Float64	Tax rate as a fraction.
`total_after_tax`	Int64	Total including tax (cents). Primary per-line revenue metric.
`balance_amount`	Int64	Unpaid balance remaining (cents).
`credited_amount`	Int64	Amount credited back via credit notes (cents).
`start_date`	DateTime64	Billing period start.
`end_date`	DateTime64	Billing period end.
`created_at`	DateTime64	When created.
`updated_at`	DateTime64	When last modified.

`fact_payment`

One row per payment received. SUM(amount) for cash collected; filter payment_status = 'posted' for confirmed payments. Join invoice_id to fact_invoice.id for reconciliation.

Column	Type	Description
`id`	UUID	Payment UUID. Primary key.
`display_id`	String	Human-readable payment id.
`customer_id`	UUID	Customer who paid. Join to `dim_customer.id`.
`invoice_id`	Nullable(UUID)	Invoice this payment is applied to.
`order_id`	Nullable(UUID)	Order this payment is associated with.
`payment_type`	String	creditCard, bankTransfer, ach, cash, check.
`payment_status`	String	draft, posted, canceled, processing, failed, requiresAction.
`amount`	Int64	Payment amount (cents).
`currency`	String	ISO currency code.
`allocations`	Int64	Amount allocated to invoice lines (cents).
`balance`	Int64	Unallocated balance remaining (cents).
`payment_date`	DateTime64	When paid/received. Primary date for cash-flow time-series.
`metadata`	String	User-defined JSON metadata.
`created_at`	DateTime64	When created.
`updated_at`	DateTime64	When last modified.

`fact_usage_summary`

Billed usage per signal per billing period — links usage to revenue. SUM(subtotal) by signal_name to see which signals drive revenue. Compare signal_count to included_quantity to see overage.

Column	Type	Description
`id`	UUID	Usage summary UUID. Primary key.
`customer_id`	UUID	Customer this usage is for.
`order_id`	UUID	Order this usage is billed under.
`order_line_id`	UUID	Order line attributed. Join for usage-by-product.
`invoice_id`	Nullable(UUID)	Invoice this usage was billed on. NULL if not yet invoiced.
`signal_name`	String	Signal name this usage relates to.
`status`	String	collecting, billed, or voided.
`currency`	String	Currency code for `subtotal`.
`signals_quantity`	Int64	Raw number of signals recorded in the period.
`signal_count`	Int64	Billable signal count after dedup/filtering.
`included_quantity`	Nullable(Int64)	Signals included free before billing.
`min_quantity`	Nullable(Int64)	Minimum billable quantity (minimum commit).
`subtotal`	Int64	Billed amount for this usage (cents).
`start_date`	DateTime64	Billing period start.
`end_date`	DateTime64	Billing period end.
`created_at`	DateTime64	When created.
`updated_at`	DateTime64	When last modified.

Credits

`fact_credit_transaction`

One row per credit grant, spend, or pending grant. Filter type = 'SPEND' for consumption; group by signal_name or product_id for usage breakdowns. Join credits_currency_id to dim_credits_currency.

Column	Type	Description
`id`	UUID	Credit transaction UUID. Primary key.
`customer_id`	UUID	Customer this transaction belongs to.
`product_id`	Nullable(UUID)	Product associated. NULL for non-product grants.
`credits_currency_id`	UUID	Which credits currency was used.
`order_id`	Nullable(UUID)	Order that triggered this transaction.
`type`	String	GRANT, SPEND, or PENDING_GRANT.
`origin_code`	String	Source of the movement (e.g. purchased).
`amount`	Int64	Credit amount. Positive for grants, negative for spends.
`balance_before`	Int64	Balance before this transaction.
`balance_after`	Int64	Balance after this transaction.
`signal_name`	String	Signal that triggered the spend. Empty if not signal-triggered.
`signal_mongo_id`	String	Id of the triggering signal. Links to `fact_signal.signal_id`.
`signal_created_at`	Nullable(DateTime64)	When the triggering signal was created.
`spend_group_id`	Nullable(UUID)	Groups related spends from the same signal.
`created_at`	DateTime64	When the transaction occurred.