project
Pulse Activation, Cohorts, and Retention
Trustworthy activation funnel and cohort-retention analysis from product events. This public brief explains the scenario, deliverables, dataset, assessed skills, and guided-versus-independent expectations without revealing the full solution.
Open project workspace
Scenario and deliverables
Trustworthy activation funnel and cohort-retention analysis from product events.
The project expects SQL, assumptions, bounded result snapshots, validation checks, and a local report export.
Milestones
Each milestone is graded as an activity and contributes to project evidence only after independent or transfer validation.
| Step | Deliverable |
|---|---|
| S01 | Event audit |
| S02 | Milestone times |
| S03 | Activation classification |
| S04 | Funnel |
| S05 | Account-month activity |
| S06 | Cohort retention |
| S07 | Segment comparison |
| S08 | Product report |
Dataset, prerequisites, and workspace
The public brief describes the work; the app workspace provides the editor, dataset, hints, checker, and final export tools.
Pulse Product datasetPrerequisite: Aggregate Functions and Null SemanticsPrerequisite: GROUP BY and Report GrainPrerequisite: Dates, Timestamps, Time Zones, and Half-Open RangesPrerequisite: Period Grouping, Complete Calendars, Cohorts, and Retention FoundationsPrerequisite: Window Foundations and RankingOpen workspace