Webshop performance
The nine figures this stack used to publish to Lightdash, rebuilt as code, plus a
cancellations page the Lightdash version never had. Every number
below comes from the dbt marts in warehouse/refarch.duckdb — nothing is computed in a UI, and
nothing is stored anywhere a pull request cannot see it.
Net revenue
Orders
Average order value
Cancellation rate
Net revenue is realised: cancelled orders count as zero, not as revenue. Booked revenue —
every order as placed — was € 346,644 , so
cancellations cost €17,203 . Both columns live
on fct_orders, which is why the two numbers can sit side by side without either being a filter
somebody has to remember. Cancellations breaks the gap down.
Revenue over time
The Q4 peak and the upward trend are deliberate: the synthetic generator is configured with growth and seasonality so the reports have something to show that uniform random data never would.