Cohort Retention Analyzer: methods and data limits

Measure return activity by first-observed weekly or monthly cohorts.

Use the guide alongside the working tool.

Explicit working sample

user,date
A,2026-08-01
B,2026-08-07
A,2026-09-12
A,2026-10-05
C,2026-09-02
D,2026-09-11
C,2026-10-10

Measure return activity by first-observed weekly or monthly cohorts. Cohorts begin at the first observed event per user in your input, not verified signup dates. Period retention counts distinct active users, not rolling/unbounded retention. Unfinished and unobserved periods stay blank. Supply the final complete observation date; imported history truncation can bias acquisition cohorts. Reports contain aggregate cohorts, not user identifiers.

Prepare the input

Measure return activity by first-observed weekly or monthly cohorts.

CSV, TSV and arrays of scalar JSON objects are supported. Identifiers stay text. Empty cells are missing by default; add special missing tokens only if their meaning is certain. Use the sample to inspect the exact workflow.

Review the method

Cohorts begin at the first observed event per user in your input, not verified signup dates. Period retention counts distinct active users, not rolling/unbounded retention. Unfinished and unobserved periods stay blank. Supply the final complete observation date; imported history truncation can bias acquisition cohorts. Reports contain aggregate cohorts, not user identifiers.

Keep the useful output

Review the summary and result records. Transformation tools retain separate change, rejected-record or diagnostics datasets where relevant. Choose the dataset before exporting; a report and a cleaned dataset serve different purposes.

CSV exports protect formula-like text. JSON keeps data portable without making an Excel workbook. Reports and editable backups may contain private source values; download only what you intend to share. No automatic account storage or server processing is used.

Ready to apply this workflow?

Try Cohort Retention Analyzer →

Explore a related workflow

A/B Test Analyzer: methods and data limits
Compare conversion rates with intervals, uplift and adjusted significance.
SQL Data Explorer: methods and data limits
Query local records with joins, CTEs and window functions.
Parquet Viewer & Converter: methods and data limits
Inspect local Parquet metadata and export selected records.
SQLite Database Explorer: methods and data limits
Explore tables, indexes and foreign keys in a local database.

All practical guides →

Keep your original files and review the result. Found unclear instructions? Contact Team Edtoolkits.