Home/Answers/Cohort analysis
UNIT ECONOMICS LAB / Cohort analysis

Before Cohort analysis Processing

Before Cohort analysis, back up the original, confirm format/size/quality requirements and close programs that lock the file.

Updated 2026-11-01About 3 minLocal test
Quick answer

Before Cohort analysis, back up the original, confirm format/size/quality requirements and close programs that lock the file. Cohort by signup month/channel for payback, retention and expansion; avoid averages.

Why it matters

Poor preparation leads to overwrites, failures and rework.

By month.

Step by step

  1. Define CAC consistently: sales + marketing spend / new customers.
  2. Use gross margin for LTV and payback, not revenue.
  3. Split by channel/cohort, not one blended number.
  4. Decide budget by payback and cash flow, not only LTV/CAC.

Common mistakes

  • Using revenue instead of gross margin for payback.
  • Counting ad spend only, not sales/tools/labor.
  • Hiding bad channels behind blended CAC.
  • Treating a high LTV/CAC as unlimited spend.

Checklist

  • CAC includes sales + marketing + tools + labor.
  • Payback uses gross margin.
  • Split by channel/cohort.
  • Attribution window, refunds and churn are consistent.
  • Budget considers cash flow and payback.

Key facts

  • By month.
  • By channel.
  • Track payback.

FAQ

How should I prepare before Cohort analysis?

Before Cohort analysis, back up the original, confirm format/size/quality requirements and close programs that lock the file. Cohort by signup month/channel for payback, retention and expansion; avoid averages.

How long does it take?

Usually 1-3 minutes; for intermittent issues, run 30 seconds and retest elsewhere.

Is data uploaded?

Runs locally and does not upload video/audio; extensions may still read the page.

Source: Scalexp