Subchapter 95.2

Dim Activation Criteria

Dim Activation Criteria · Modeling Activation Metrics · PostHog/skills · Skills Docs

references/dbt/dim_activation_criteria.sql

SQL8 lines460 B

1-- The activation definition, as data. Keeping it in a one-row seed/model (not hard-coded in every query)
2-- means the definition lives in one place and can be versioned. Swap to a dbt seed if you prefer a CSV.
3{{ config(materialized='table') }}
4
5select
6    'key_action'  as action_event,   -- the validated key action
7    3             as min_count,       -- count threshold within the window
8    7             as window_days      -- early window from signup

dim_activation_criteria.sql on GitHub