Generate a Weekly Cohort Retention Report Automatically
Know if customers are sticking — build a weekly cohort retention report from your usage data and deliver it to the team without touching a spreadsheet formula.
- 1
Schedule Weekly
Add a
Schedule Triggerset for Monday. - 2
Pull Activity by Cohort
Add an
HTTP Requestto PostHog fetching active users grouped by signup week. - 3
Build the Retention Matrix
Add a
Codenode computing retention percentages per cohort per week and writing them to a sheet. - 4
Summarize the Trend
Add an
OpenAI/Codestep highlighting whether retention is improving or declining. - 5
Post to Slack
Add a
Slacknode delivering the matrix link and the headline trend. - 6
Activate and Test
Activate the workflow and run it once. Confirm the retention numbers match your analytics.
Frequently asked questions
Which retention definition should I use?
Pick the action that reflects real value in your product and keep it consistent across weeks.
Can I segment cohorts by plan?
Yes — add plan as a grouping dimension to compare retention across pricing tiers.