Finance & Ops · n8n

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.

difficulty Advancedsetup 45 minresult The team gets a clear weekly view of how each signup cohort retains, guiding product and growth decisions.
  1. 1

    Schedule Weekly

    Add a Schedule Trigger set for Monday.

  2. 2

    Pull Activity by Cohort

    Add an HTTP Request to PostHog fetching active users grouped by signup week.

  3. 3

    Build the Retention Matrix

    Add a Code node computing retention percentages per cohort per week and writing them to a sheet.

  4. 4

    Summarize the Trend

    Add an OpenAI/Code step highlighting whether retention is improving or declining.

  5. 5

    Post to Slack

    Add a Slack node delivering the matrix link and the headline trend.

  6. 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.

About this recipe. Recipes on FlowRecipesHub are written for business owners, not developers, and are tested before publishing — how recipes get made. Some ingredient links are affiliate links that cost you nothing — full disclosure.