miniwarehouse
events to bronze to dbt to metrics

Authorisation rate

loading

Settlement lag

p50 hours, typical day
p95 hours, typical day
loading

Recurring revenue

loading

Approvals against declines, per day

Authorisation to capture, hours

p50 and p95, never a mean. An item that misses the nightly clearing batch waits for the next one, and that is a step change a mean would hide.

MRR curve

A running sum of movements, never a stored total. A renewal at an unchanged price is real cash and moves MRR by nothing, which is why the curve is flatter than the order chart.

What moved MRR

Worst approval days

The pipeline

select a run, or start one
idle running done failed click any box for what it does, what it relies on, and the hard questions about it

Detail

Pick a box in the diagram above.

Around this design

The themes next to this one, answered to the same depth.

Run detail

Real runs only. Nothing here is seeded, so an empty table means the pipeline has not been run rather than that something failed to load.
no run selected

Snowflake-ready

DuckDB
engine today
Snowflake
target, not exercised