6DuckLearn Skills

cohort analysis

Perform cohort analysis on user engagement data — retention curves, feature adoption trends, and segment-level insights. Use when analyzing user retention by cohort, studying feature adoption over time, investigating churn patterns, or identifying engagement trends.

data-analytics Tags: pm-data-analytics, data-analytics, pm-skills

Cohort Analysis & Retention Explorer

Analyze user engagement and retention patterns by cohort to identify trends in user behavior, feature adoption, and long-term engagement.

Instructions

  1. Read and validate data (CSV, Excel, JSON)
  2. Calculate cohort retention rates and engagement trends
  3. Identify retention curves, drop-off patterns, anomalies
  4. Suggest follow-up research methods
  5. Provide Python scripts for reproducible analysis if requested

Output Format

  • Data summary and quality assessment
  • Key metrics, retention rates, trend analysis
  • Pattern identification (2-3 significant insights)
  • Research recommendations and next steps

Further Reading

Related skills

  • ab test analysis — Analyze A/B test results with statistical significance, sample size validation, confidence intervals, and ship/extend/stop recommendations. Use when evaluating experiment results, checking if a test reached significance, interpreting split test data, or deciding whether to ship a variant.
  • sql queries — Generate SQL queries from natural language descriptions. Supports BigQuery, PostgreSQL, MySQL, and other dialects. Reads database schemas from uploaded diagrams or documentation. Use when writing SQL, building data reports, exploring databases, or translating business questions into queries.
  • interview script — Create a structured customer interview script with JTBD probing questions, warm-up, core exploration, and wrap-up sections. Follows The Mom Test principles — no leading questions, no pitching, focus on past behavior. Use when preparing for user interviews, creating interview guides, or planning discovery research.
  • analyze feature requests — Analyze and prioritize a list of feature requests by theme, strategic alignment, impact, effort, and risk. Use when reviewing customer feature requests, triaging a backlog, or making prioritization decisions.
  • ansoff matrix — Generate an Ansoff Matrix analysis mapping growth strategies across market penetration, market development, product development, and diversification. Use when considering growth options, planning market expansion, or evaluating strategic growth paths.
  • beachhead segment — Identify the first beachhead market segment for a product launch. Evaluates segments against burning pain, willingness to pay, winnable market share, and referral potential. Use when choosing a first market, targeting an initial customer segment, or planning market entry strategy.