Metric Frameworks & Guardrails Questions

WITH metrics AS (
  SELECT experiment_id, variant, n,
         metric, metric_control,
         (metric - metric_control) AS lift,
         -- compute se from counts/variance table
         SQRT(variance_variant / n + variance_control / n_control) AS se
  FROM experiment_metrics
),
shrunk AS (
  SELECT *,
    (lift / NULLIF(se,0)) * (n / (n + :tau)) AS z_shrunk
  FROM metrics
),
normalized AS (
  SELECT *,
    1.0 / (1.0 + EXP(-:alpha * z_shrunk)) AS norm_score
  FROM shrunk
),
guardrail AS (
  SELECT experiment_id, variant,
    SUM(weight * GREATEST(0, (value - threshold)/NULLIF(range,0))) AS raw_penalty
  FROM guardrail_metrics
  GROUP BY experiment_id, variant
),
combined AS (
  SELECT n.*, 1 - LEAST(1, COALESCE(g.raw_penalty,0)) AS penalty_factor
  FROM normalized n
  LEFT JOIN guardrail g USING (experiment_id, variant)
)
SELECT experiment_id, variant,
       norm_score * penalty_factor AS experiment_impact_score
FROM combined;

WITH normalized_events AS (
      SELECT
        COALESCE(account_id, device_id) AS user_id,
        DATE_TRUNC('day', event_time) AS event_date,
        event_type, product
      FROM raw.events
      WHERE event_type IN ('login','purchase','use_feature')
        AND event_status='success'
    ),
    daily_active AS (
      SELECT event_date, user_id, MIN(product) AS product
      FROM normalized_events
      GROUP BY 1,2
    )
    SELECT event_date, user_id, product FROM daily_active;