Cohort Retention SQL with Correct Zero-Event Handling
Asked Jun 18, 2026Modified 4 days agoViewed 7 timesWorks with: GPT-4o, Claude 3.5 Sonnet, Gemini 1.5 Pro
0
What this prompt does
Generates a weekly cohort retention query with a full date spine so zero-activity users appear as 0% retention rather than being dropped as NULL.
- Compatible models:
- GPT-4o, Claude 3.5 Sonnet, Gemini 1.5 Pro
- Category:
- Data
Generates a weekly cohort retention query with a full date spine so zero-activity users appear as 0% retention rather than being dropped as NULL. Use this when building retention dashboards that need accurate week-over-week cohort metrics.
Act as a Product Analytics Engineer. Build cohort retention in [database].
Tables: users(user_id, signup_date, plan_type),
events(user_id, event_type, event_date).
Goal: weekly retention by signup cohort, last 12 weeks.
Retained = at least one [event_type] in week N post-signup.
Return: cohort_week, weeks_since_signup, cohort_size, retained_users,
retention_rate (decimal). Handle zero-event users as 0%, not NULL.
Comment the date spine logic.
Source: https://www.buildfastwithai.com/blogs/ai-prompts-data-analyst-python-sql-chatgpt-2026
Prompt Curator
120rep · asked Jun 18, 2026
0 Responses
Want to respond? Log in.