WITH selected AS(SELECT *,CASE {{definition}} WHEN 'quality' THEN confirmed_quality_use WHEN 'ready' THEN ready_at IS NOT NULL WHEN 'export' THEN exported_at IS NOT NULL END chosen,CASE {{definition}} WHEN 'quality' THEN confirmed_use_at WHEN 'ready' THEN ready_at WHEN 'export' THEN exported_at END chosen_at FROM v_task WHERE ({{persona}}='all' OR persona={{persona}}) AND ({{workflow}}='all' OR workflow={{workflow}})) ,early AS(SELECT user_id,COUNT(*) early_tasks,SUM(CASE WHEN chosen=1 AND julianday(chosen_at)<julianday(signup_at)+7 AND ({{definition}}<>'quality' OR julianday(reviewed_at)<julianday(signup_at)+7) THEN 1 ELSE 0 END) early_value FROM selected WHERE julianday(created_at)>=julianday(signup_at) AND julianday(created_at)<julianday(signup_at)+7 GROUP BY user_id),cohort AS(SELECT c.*,COALESCE(e.early_tasks,0) early_tasks,COALESCE(e.early_value,0) early_value FROM v_user_cohort c LEFT JOIN early e USING(user_id) WHERE mature42=1 AND ({{persona}}='all' OR c.persona={{persona}})) SELECT CASE WHEN early_tasks=0 THEN '0' WHEN early_tasks=1 THEN '1' WHEN early_tasks<=3 THEN '2–3' ELSE '4+' END task_band,AVG(early_value*1.0) mean_early_value_tasks,AVG(return28_41*1.0) return_fraction,COUNT(*) eligible_users FROM cohort GROUP BY 1