Cohort Analysis
中级data最低上下文：16K
Builds retention and behavioral cohort analyses from event or transaction data. Defines cohorts by acquisition date or attributes, computes retention and churn curves, generates the SQL or pandas code to produce cohort tables, and interprets the results into actionable insights about engagement and lifecycle.
使用场景
- Computing weekly/monthly retention cohorts
- Building churn and engagement curves
- Generating SQL or pandas for cohort tables
- Comparing cohorts by acquisition channel
- Interpreting cohort trends into recommendations
示例提示词
I have an "events" table (user_id, event_name, event_time) and a "users" table (user_id, signup_date, channel). Produce a monthly signup cohort retention analysis: 1. SQL to build the cohort retention table 2. How to read the resulting matrix 3. Two hypotheses to investigate based on typical retention shapes
推荐模型
兼容工具
claude-codecursorkiroany
模态
输入: text, code
→输出: code, text
相关 Skills
作者
OpenModels Community