Revenue & retention
Model: fct_orders · refreshed 12 min ago
Filters
Last 90 daysAll channelsRegion: DOExclude test accounts+ Add filter
Net revenue
RD$41.8M
▲ 11.2% QoQ
Active customers
9,412
▲ 486 net new
Gross margin
58.4%
▼ 0.9 pts vs plan
90-day retention
72%
▲ 4 pts vs cohort Q1
Net revenue
JunJulAug
Revenue by channel
Cohort retention
M0
M1
M2
M3
M4
M5
M6
Feb
Mar
Abr
May
Jun
Jul
Ago
Metric definition — net_revenue
-- owner: finance@empresa.do certified 2026-06-02
SELECT
date_trunc('day', o.placed_at) AS day,
sum(o.gross_amount - o.discount
- o.refund_amount - o.tax_amount) AS net_revenue
FROM fct_orders o
WHERE o.status IN ('paid','settled')
AND o.is_test = false
GROUP BY 1
-- 41 downstream dashboards depend on this metric
Pipeline health
| Model | Rows | Last run | Duration | Tests | Status |
|---|---|---|---|---|---|
| stg_orders | 4.2M | hace 12 min | 48 s | 14 / 14 | Passing |
| fct_orders | 4.2M | hace 12 min | 2 m 11 s | 22 / 22 | Passing |
| dim_customers | 9,412 | hace 12 min | 19 s | 9 / 9 | Passing |
| fct_subscriptions | 11,806 | hace 48 min | 1 m 04 s | 7 / 8 | 1 warning |
| mart_marketing_attrib | 2.1M | hace 6 h | 4 m 32 s | 5 / 11 | Failing |