Schema

1version: 2
2
3models:
4    - name: fct_retention
5      description: Weekly recurring retention matrix (cohort_week × weeks_later).
6      columns:
7          - name: retention_rate
8            data_tests: [not_null]
9    - name: fct_stickiness
10      description: Distribution of users by active days in the trailing window.
11      columns:
12          - name: active_days_in_period
13            data_tests: [unique, not_null]
14    - name: fct_lifecycle
15      description: New / returning / resurrecting counts per week.
16      columns:
17          - name: week
18            data_tests: [unique, not_null]