Repeat Purchase and Cohort Analysis
Understand customer loyalty over time.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
Analyze repeat purchase behavior. Data: customer orders with anonymized customer ID, order date, and order value: [PASTE_ORDER_DATA]. Business type and typical repurchase cycle: [REPURCHASE_CYCLE]. Return: 1. Cohort table: customers grouped by first purchase month; columns show the percent who ordered again in months 1, 2, 3, 6, and 12. Describe how to compute it in a spreadsheet step by step. 2. Average orders per customer and revenue per customer by cohort. 3. Time between first and second order (median and distribution description). 4. What first products lead to higher repeat rates, if the data includes products. 5. Three hypotheses on why some cohorts are better (acquisition source, season, offer). 6. Actions: post-purchase email timing, replenishment reminders, and bundles, each with a test design. 7. Data limits: small cohorts, missing identifiers, guest checkouts. Explain every calculation so I can check it. Do not state a retention number that you cannot derive from the data.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.