Free editable template

Black Friday second-purchase kit: 30-day email, SMS and retargeting flow

Turn first-time Black Friday and Cyber Monday buyers into repeat customers. The Excel workbook schedules six messages by day after the first order, checks gift messages against your Christmas order-by date, lists the audiences to exclude and retarget, works out the 30-day repeat rate the flow needs to pay for itself, and compares each sale cohort with your normal first-time buyers at days 7, 14, 30, 60 and 90.

By GaaS editorial · Sources checked · 6 worksheet rows

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 orderChannel
15Email
29Email
312Email
416SMS
521Email
629SMS

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

Continue the work