Schema

1version: 2
2
3models:
4    - name: stg_funnel_events
5      description: Step events for the funnel, one row per person/step event.
6      columns:
7          - name: person_id
8            data_tests: [not_null]
9          - name: event_name
10            data_tests:
11                - accepted_values:
12                      values: ['signed_up', 'activated', 'purchased']
13
14    - name: fct_conversion
15      description: Funnel entry/step counts and overall conversion within the window.
16      columns:
17          - name: entered_step_1
18            data_tests: [not_null]
19          - name: overall_conversion
20            data_tests: [not_null]