Cohorts

Cohort: "Power builders"
Definition:
├── Has done: agent_run_completed
│   └── At least 10 times
│   └── In the last 30 days
├── AND user property: plan = "enterprise"

Users who:
├── Did [event_name]
│   ├── Frequency: at least N times / exactly N times / at most N times
│   ├── Time frame: in the last N days / between dates / ever
│   └── Where: [property filters]
│
└── Did NOT do [event_name]
    └── Time frame: in the last N days / ever

✓ Did "agent_run_completed" at least 5 times in the last 30 days
✓ Did NOT do "integration_connected" in the last 7 days
✓ Did "workflow_published" where surface = "in_app"

Users where:
├── [property_name] [operator] [value]
│
│ Operators:
│ ├── String: is, is_not, contains, is_set, is_not_set
│ ├── Number: =, ≠, >, ≥, <, ≤, between
│ └── Boolean: is_true, is_false

✓ plan is "pro"
✓ successful_runs > 50
✓ has_completed_onboarding is_true
✓ email is_set

Users who:
├── Are in cohort "Active Traders"
├── AND are NOT in cohort "Churned Users"

Users who:
├── Did agent_run_completed (5+ times)
├── AND country = "US"
├── AND plan = "pro"

Users who:
├── Did agent_run_completed (5+ times)
├── OR did workflow_published
├── OR seat_count > 25

Users who:
├── (Did agent_run_completed AND workflow_id = "weekly_report")
├── OR
├── (Did agent_run_completed AND workflow_id = "crm_sync" AND count >= 10)

Day 1:
"Active builders" cohort: 500 users

Day 7:
- 50 new users matched (5+ runs)
- 30 users unmatched (30-day window moved)
"Active builders" cohort: 520 users

Insights Report:
├── Event: agent_run_completed
├── Filter: Cohort = "Power builders"
└── See metrics for that segment only

Funnel: Landing → Signup → Activation
├── Cohort A: "Twitter users" → 8% conversion
├── Cohort B: "Discord users" → 15% conversion
└── Cohort C: "Organic" → 12% conversion

Retention:
├── Birth: signup_completed
├── Return: agent_run_completed
├── Filter: Cohort = "High-value workspaces"
└── See retention for that segment

Breakdown by cohort:
├── Power builders: 45% of runs
├── Casual users: 35% of runs
└── New users: 20% of runs

"Power Users"
├── Did any_event at least 50 times
├── In the last 30 days

"Casual Users"
├── Did any_event at least 5 times
├── AND at most 20 times
├── In the last 30 days

"At-Risk Users"
├── Did any_event in the last 90 days
├── AND did NOT do any_event in the last 14 days

"High workspaces"
├── User property: seat_count > 50
├── OR did workflow_published at least 5 times in the last 30 days

"Multi-integration"
├── Did integration_connected where provider = "slack"
├── AND did integration_connected where provider = "salesforce"

"Newly activated"
├── Did agent_run_completed in the last 7 days
├── AND did NOT do agent_run_completed before 7 days ago

"New Users (This Week)"
├── User property: first_seen in the last 7 days

"Completed Onboarding"
├── Did onboarding_completed

"Churned"
├── Did any_event in the last 90 days
├── AND did NOT do any_event in the last 30 days

"Twitter Acquisition"
├── User property: utm_source = "twitter"
├── OR initial_referrer contains "twitter.com"

"Organic Search"
├── User property: utm_medium = "organic"
├── OR initial_referrer contains "google.com"
├── OR initial_referrer contains "bing.com"

"Heavy automation"
├── Did workflow_published at least 3 times
├── AND did run_succeeded at least 20 times
├── In the last 30 days

"Template-first"
├── Did template_applied at least 5 times
├── OR user property: favorite_template_id is_set

"Power builders" - 523 users
├── user_12345 (matched 3 days ago)
├── user_67890 (matched 1 week ago)
├── user_abc (matched 2 weeks ago)
└── ... (520 more)

✅ Good names:
"Active Traders (30d, 5+ swaps)"
"High-Value Users (>$10k volume)"
"Twitter Acquisition - Q1 2024"

❌ Poor names:
"Cohort 1"
"Test"
"Users"

✅ Focused:
Users who completed 10+ agent runs in 30 days

❌ Overly complex:
Many unrelated AND conditions that are hard to reason about and maintain

Name: "Churn Risk"
Description: Users active 30-90 days ago but not in last 30 days.
             Use for win-back campaigns.