Data & Analysis
Advanced
Cohort Retention Script-2
Write SQL/Python scripts to calculate monthly user retention cohorts.
👁️ 4740 views
❤️ 110 likes
📋 274 copies
The Prompt Template
Write a [SQL_OR_PYTHON] script to calculate monthly cohort retention rates. Input tables: users (id, created_at) and activities (user_id, event_date). Output: cohort grid displaying month of signup vs percentage of users active in month 1, 2, 3, etc.
250 characters
Tags
Works Best With
ChatGPT Claude