E03 · Defend activation
Synthetic practice, not company performance.
One decision
What qualifies as a first useful result?
Run the exact query
WITH b AS (SELECT * FROM v_user_cohort WHERE ('all'='all' OR persona='all') AND ('all'='all' OR primary_workflow='all') AND ('all'='all' OR substr(signup_at,1,7)='all') AND date(signup_at)>='2026-05-01' AND date(signup_at)<'2026-10-01') SELECT persona,COUNT(*) eligible_users,SUM(activated7) activated_users,100.0*AVG(activated7) activation_pct FROM b WHERE mature7=1 GROUP BY persona;
Download SQL · Result CSV · Metabase saved question
Chart and reading
Count users, retain mature zero-task signups and require review/use before day seven.
Challenge your recommendation
Does a late review leak future information into the first week?
Guardrails: All mature signups, including zero-task users. Workflow filter means primary intended workflow.
Next evidence: Confirm whether users, accounts or invited seats are the right production denominator.
PRD sections: 6, 14. Open proposed PRD
Your spoken decision
State one takeaway, one caveat and one action in 30 seconds. Then stop.
Connect this finding
What this chart helps decide · Follow the connected decision · Canonical metric definitions
Optional model answer — try your own first
E03 · Defend activation
Decision: What qualifies as a first useful result?
Readout: Count users, retain mature zero-task signups and require review/use before day seven.
Actual query output (synthetic), first rows:
| persona | eligible_users | activated_users | activation_pct |
|---|---|---|---|
| developer | 94 | 8 | 8.51063829787234 |
| marketing | 93 | 4 | 4.301075268817205 |
| training | 93 | 6 | 6.451612903225806 |
Model spoken answer: I would use first-week confirmed value among all eligible signups and report the missing-review limit.
Caveat/counterargument: Does a late review leak future information into the first week? All mature signups, including zero-task users. Workflow filter means primary intended workflow.
Next evidence: Confirm whether users, accounts or invited seats are the right production denominator.
Deliberately left out: Generated-video counts, which use task grain rather than user activation.