Customer Retention Analyzer

Group customers by first observed activity and measure monthly return rates with explicit cohort denominators.

On-device No sign-up Free to use

Measure cohort retention controls

Showing an example. Edit to see your own.

?

Paste UTF-8 CSV with headers, or choose a file below. Up to 2 MiB.

Drop your CSV file here

or choose one from your device

One file · CSV and TSV only

    Processed in your browser. Your inputs stay on this device.

    Result

    Showing an example.

    Of two January customers, one returns in February; March remains incomplete.

    Two January customers give a month-zero cohort size and active count of 2, retention 100.00. One returns in February, retention 50.00. March is incomplete as of 2026-03-15 and has blank count and rate.

    Loading the tool. Your result will appear here.

    https://usefreetools.net/customer-cohort-retention · 20 November 2026

    Was this helpful?

    How to use Customer Retention Analyzer

    1. Provide the complete activity history with distinct event IDs, customers and dates.
    2. Set the as-of date through which activity has been observed.
    3. Review each acquisition cohort and its completed calendar-month return rates.
    4. Download the cohort report, keeping incomplete observations separate from zero returns.

    Example: Customer Retention Analyzer

    Of two January customers, one returns in February; March remains incomplete.

    You add
    Customer activity: id,customer,date E1,A,2026-01-05 E2,A,2026-02-10 E3,B,2026-01-20 Observation as-of date: 2026-03-15
    You get
    Two January customers give a month-zero cohort size and active count of 2, retention 100.00. One returns in February, retention 50.00. March is incomplete as of 2026-03-15 and has blank count and rate.

    Supported inputs and limits

    • Up to 2,000 activity rows, 80 columns, 2 MiB and 120 months of cohort history.
    • First activity in the supplied history defines acquisition; omitted earlier history changes that definition.
    • A customer counts once per calendar month.
    • Every return rate uses the original cohort size.
    • Month zero includes acquisition.
    More details

    The current as-of month is always marked incomplete with blank count/rate, including on its final day.

    Future events are refused.

    No causal retention explanation or predictive model is included.

    Where your input is processed

    This tool does not upload your inputs. See the limits for anything saved on your device.

    Questions about Customer Retention Analyzer

    Why does the current month show a blank instead of zero?

    It is an incomplete observation period. Zero would suggest that a full month had elapsed without a return, so the count and rate remain blank.

    Does retention use the previous month as its denominator?

    Every completed age column uses the original acquisition cohort size. A customer can return after a missed month and still count in the later month.

    Can I upload only the most recent three months?

    You can analyze that supplied window, but first observed activity then means first within those rows. Supply complete earlier history when you need actual acquisition cohorts.

    Page updated · Project managed by Tony Hines · Report a problem with Customer Retention Analyzer