StructuredFor EntrepreneursStartup Planning & Strategy

Write a Startup Cohort Analysis Template.

When trying to understand whether customers are staying or leaving — and why it matters for your unit economics.

ChatGPT · Claude · Gemini·Beginner·~276 tokens
Curated by the AIPP team
Last updated 14 May 2026 · v3
write-a-startup-cohort-analysis-template.md · 276 words
You are a senior {{role}} brought in to help {{target_user}} complete a Write a Startup Cohort Analysis Template.

# Context
Original working context: Role: You are a growth analyst who helps startups understand retention and lifetime value through cohort analysis. Context: Startup: {{name}}. Business model: {{subscription_marketplace_ecommerce_saas}}. Customer data available: {{describe}}. Task: Design a cohort analysis framework and explain how to interpret it. Format: What a cohort analysis is (plain English, 2 sentences) → How to set up the analysis (step-by-step) → What metrics to track per cohort: retention rate by month, revenue per cohort, LTV by cohort → How to read the results: what a 'healthy' cohort curve looks like vs a 'leaky bucket' → 3 strategic decisions this analysis should inform. Constraints: India-specific context. Use ₹ for all revenue metrics. Include free tools (Google Sheets template structure).

# Goal
Produce the exact deliverable requested for this use-case. Make the output practical, specific, and ready to use.

# Constraints
- Use the user's variables exactly where relevant.
- Avoid generic filler and vague advice.
- Be specific to the stated audience, platform, market, role, industry, or situation.
- Ask only essential clarifying questions if required; otherwise make reasonable assumptions and continue.

# Output
Return the final deliverable in a clean, skimmable format with clear headings, bullets, tables, scripts, templates, or steps as appropriate.

The variables to fill in

PlaceholderWhat to put thereExample
{{name}}NameAmit
{{subscription_marketplace_ecommerce_saas}}Subscription marketplace ecommerce saasinsert your specific value
{{describe}}Describeinsert your specific value
{{role}}Rolefreelance client onboarding strategist
{{target_user}}Target usera freelance consultant

How to customize this prompt

  1. Replace each {{double-curly}} with your real context.
  2. Adjust the constraints section to match your tone — formal, casual, blunt.
  3. If the engagement is recurring, change the duration line to mention milestones rather than days.
  4. Run it in your tool of choice. The output should be ready to paste with at most one small edit.

When to use

When trying to understand whether customers are staying or leaving — and why it matters for your unit economics.

PRO TIP

If your month-1 retention is below 40% for a consumer app or below 70% for a B2B product, your acquisition growth is filling a leaky bucket. Fix retention before scaling acquisition — or you're just accelerating the cash burn.

Related prompts

Structured

Blog Post Drafting Engine

Write a complete, SEO-optimised blog post on the given topic. Include a compelling headline, an engaging introduction, 4-5 subheadings with detailed body paragraphs, and a strong conclusion with a cal

Structured

Email Newsletter Writer

Write a complete email newsletter including subject line, preview text, opening hook, main body content (3 short sections), and a clear call to action.

Structured

YouTube Video Script Writer

Write a complete YouTube video script including a strong hook (first 30 seconds), structured main content with transitions, and a closing that encourages likes, comments, and subscriptions.

Structured

LinkedIn Article Builder

Write a complete LinkedIn article that establishes professional authority, shares a genuine insight, and encourages professional discussion.

★ EXPLORE MORE PROMPTS

More for Entrepreneurs

Browse all prompts built for Entrepreneurs — free and premium, ready to copy.

Browse more prompts →