Retention SQL
Month-over-month retention.
- Snippet
- Analytics snippets
- 1 blank to fill
SELECT cohort_month, months_since, COUNT(DISTINCT user_id) FROM Table GROUP BY 1, 2 ORDER BY 1, 2;
Orange words are blanks you have not filled yet. Press ⌘ Return to copy.
About this template
Month-over-month retention.
- Category
- Data and analytics
- Pack
- Analytics snippets
- Type
- Snippet, a short message
- Asks for
- Table
Use it anywhere you write: email, chat, a document or a support tool. If you send it often, save the finished text as a snippet in ClipBuddy and paste it again from your clipboard history with ⌘⇧V.
Template source
The template as written, with its blanks in double braces, such as {{Name}}.
SELECT cohort_month, months_since, COUNT(DISTINCT user_id)
FROM {{Table}}
GROUP BY 1, 2
ORDER BY 1, 2;