metric_ar_aging

beta

metric table

Open AR totals by aging bucket and customer segment, with DSO.

Definition

Open accounts-receivable totals bucketed by overdue band and customer segment, as of a snapshot day, plus a per-segment revenue figure (`revenue_amount`, the invoiced base split across the segment's buckets by open-AR share). `dso` is a formula measure: (open AR / credit sales) × 30 days.

What it means

Watch out for

highComputing DSO over a single bucket
`dso` divides total open AR by credit sales. Filtering to one aging bucket gives a partial-AR DSO, not the headline figure — compute it over all buckets for a segment.
highMixing as_of_day snapshots
Each as_of_day is a full snapshot; summing across snapshots double-counts the same open balance.

Questions this answers

“What is DSO by customer segment for the latest snapshot?”
“How much AR is more than 90 days overdue?”

Related metrics

ap_aging
The payables counterpart; pair for a working-capital view.

7 of 7

Column

Type

Description

Tests · PII

as_of_day

Date

Snapshot day. Date. Grain + sort key.

1 test

aging_bucket

String

current / 1_30 / 31_60 / 61_90 / 90_plus. Dimension.

1 test

customer_segment

String

Customer segment — consumer / business / enterprise / unknown. Dimension.

1 test

open_invoices

UInt64

Open invoices in the bucket. UInt64.

1 test

customers_count

UInt64

Distinct customers in the bucket. UInt64.

1 test

open_amount

Decimal(18, 2)

Open functional-USD balance in the bucket. Decimal(18,2).

1 test

revenue_amount

Decimal(18, 2)

Segment invoiced base amount, split across buckets by open-AR share (the DSO denominator). Decimal(18,2).

1 test