Cohort Retention & RFM Funnel Analyzer

A semantic layer over your transaction log, not another generic chart. Cohorts are formed by each customer's first-order month (or ISO week), and retention is the share of the cohort that orders again in each later period — rendered as the classic triangle heatmap with per-cell user counts, size-weighted average retention per period index, and best/worst cohort callouts. RFM follows the standard method: rank every customer on Recency (days since last order), Frequency (order count) and Monetary (total spend), cut each dimension into quintile scores 1–5, and map the three-digit code to the ten lifecycle segments — Champions, Loyal Customers, Potential Loyalists, New Customers, Promising, Needs Attention, At Risk, Can't Lose Them, Hibernating, Lost — each with share of base, average spend, and a recommended play. The funnel counts users who reached each step in strict chronological order (a user only counts for a step if they completed the previous step earlier in time). Everything runs on a header-flexible CSV (user/customer, date/timestamp, amount/revenue, event/action), so an ecommerce export, a Stripe CSV or a product-event dump all work without reformatting.