maiven gateway · online··
manifest · 1d ago
Sign in Back to catalog
Definition
De-identified rollup of open AR by (as_of_day × aging_bucket × customer_segment). customer_segment is the coarse ecommerce segment, not a customer identifier. `open_amount` is summed functional USD; `customers_count` is a distinct count.
What it means
Watch out for
- highMixing as_of_day snapshots
Each `as_of_day` is a full snapshot; summing across snapshots double-counts the same open balance.
- mediumReading customers_count as additive across buckets
`customers_count` is distinct per bucket — a customer with invoices in two buckets counts in each. Summing over-counts distinct customers.
Questions this answers
- “How much AR is more than 90 days overdue?”
- “Open AR by segment for the latest snapshot.”
Related metrics
- ar_aging
The metric-layer surface over this aggregate (includes DSO).
6 of 6
Column
Type
Description
Tests · PII
as_of_day
Date
Snapshot day. Date. Part of the grain.
1 test
aging_bucket
String
current / 1_30 / 31_60 / 61_90 / 90_plus. Part of the grain.
2 tests
customer_segment
String
Customer segment — consumer / business / enterprise / unknown. Part of the grain.
1 test
open_invoices
UInt64
Count of open invoices in the bucket. UInt64.
1 test
customers_count
UInt64
Distinct customers in the bucket. UInt64.
1 test
open_amount
Decimal(18, 2)
Sum of open functional-USD balance in the bucket. Decimal(18,2).
1 test