One cohort, two outcomes
Illustration: 1,000 eligible first-time buyers have completed a ninety-day purchase window. Of 220 buyers with later order records, 20 have only cancellations or replacement exchanges. After adequate return follow-up, 30 of the 200 qualifying repeat buyers keep none of those purchases; 170 keep merchandise. Both rates below use the original cohort. These are invented counts, not a benchmark or campaign result.
- Qualifying repeat buyers: 220 − 20 = 200.
- Second-purchase rate: 200 / 1,000 = 20%.
- Retained-repeat rate: 170 / 1,000 = 17%.
Fix the customer and first-purchase definition
Choose a stable customer identifier and document guest-account matching, history coverage, test orders and cancellations. If older orders are missing, label the cohort first observed in this dataset rather than confidently calling every buyer new. For the proposed analysis, freeze membership at the first qualifying paid, non-cancelled purchase. Keep later first-order refunds visible as an outcome; silently dropping dissatisfied customers can change the denominator and flatter retention.
Measure customers at the same age
Define the window from each customer’s first qualifying purchase, such as ninety elapsed days, with a timezone and cutoff. Count only customers old enough to finish that window in a simple fixed-window rate. Keep younger customers pending. Shopify’s cohort report offers configurable intervals, metrics and filters; a calendar-month cell is not automatically the same as ninety days since each individual purchase. Record the export settings before comparing a dashboard with your own calculation.
Separate order placement from retained purchases
Define a qualifying later purchase independently of the number of order records. Exclude cancellations and replacement-only exchanges from a new-purchase count, and resolve duplicates or split orders. Count each customer once in the numerator. Maintain a separate retained-repeat view: at least one qualifying later purchase within the same purchase window with merchandise kept after the agreed returns follow-up. State how partial returns, refunds without physical returns and unresolved records are handled.
Read the difference before changing a flow
A purchase near day ninety needs its own return follow-up after delivery; the purchase window and return observation window are different clocks. Mark that result provisional until the evidence is mature. Then compare acquisition channel, discount, category, delivery issues and relevant availability. A lower rate does not automatically mean the reminder was late. Turn one supported finding into a reviewed journey proposal and distinguish observed retention, attributed flow revenue and experimentally estimated additional effect.
Use this at work
- Freeze customer identity, first-order rules and the denominator.
- Set the purchase window, timezone and data cutoff.
- Count qualifying customers once; review cancellations and exchanges.
- Keep return observation and immature outcomes explicit.
- Review the journey before assigning a cause or sending a message.
Reference material
Platform guidance checked 4 October 2026. The definitions, examples and review steps below are Faccelerate editorial proposals.