Open the CSV in Excel, or import it into Google Sheets and choose comma-separated values. Save your working copy in a controlled location. The CSV contains the rows below and space for your notes; it has no macros, formulas or live account connection. The separate Excel workbook contains editable example inputs and formulas that update the forecast.
How to use the template
Build the flow once
Trigger it on a first-ever order placed between Black Friday and Cyber Monday, and exit on a second order. Load the six messages at days 5, 9, 12, 16, 21 and 29. The workbook shows the send dates for a Black Friday buyer and a Cyber Monday buyer and flags gift messages that land after your Christmas order-by date.
Exclude, then retarget
Upload sale-window first-time buyers as a customer list and exclude them from prospecting from day 0. Retarget the ones who haven't reordered from day 7 to day 30 with reviews, how-to clips and the second product, adding the offer only after day 21. Exclude anyone with two or more orders.
Check it pays
Type your cohort size, second-order value, margin, offer cost, SMS cost and retargeting budget. The Economics tab shows the 30-day repeat rate the flow needs to break even, the extra profit at your target rate and the cost per extra second order.
Track sale cohorts against normal ones
Type first-time buyers and second orders by day 7, 14, 30, 60 and 90 for your normal months and each sale window. The tracker averages your normal cohorts, flags each sale cohort against them and charts the curves.
Preview the worksheet
Every row shown here is included in the download. Scroll the table horizontally on a small screen.
| # | Day after first order | Channel |
|---|---|---|
| 1 | 5 | |
| 2 | 9 | |
| 3 | 12 | |
| 4 | 16 | SMS |
| 5 | 21 | |
| 6 | 29 | SMS |
Worked review example
Fictional store: 1,200 first-time buyers in the sale window, a $55 second order at 50% contribution margin, a $5 free gift on the second order, 40% of buyers with SMS consent and $400 of retargeting. Without the flow it expects a 3.5% 30-day repeat rate (last year's sale cohort); its normal first-time buyers come back at 6.0%.
The flow breaks even at a 5.8% repeat rate. At the 7% target it brings 42 extra second orders and $321 of extra profit inside 30 days, at about $20 per extra second order. With no lift at all it would cost $624.
What this template does and does not establish
The economics count only second orders inside 30 days; later orders are ignored, so the real value is likely higher. The research figures are old or vendor-published (Retention Science 2015 holiday data, Optimove 2021 data) and describe other stores, not yours. SMS costs vary by provider and country. Nothing here is legal advice on SMS or email consent.
Primary references
- Entrepreneur: Retention Science 2015 holiday data (4 Dec 2015)
- Optimove: Black Friday 2021 retention data (11 Oct 2022)
- Meta: About customer list custom audiences
- Meta: Choose audience settings in Advantage+ campaigns
- Google: Email sender guidelines
