Skip to content

Episode 10 companion playbook

Your Next Sale Is Already in Your Phone — the win-back playbook

Companion to Building Backwards, Episode 10. One afternoon to set up, about twenty minutes a month after that. No new subscription required.

June is an AI co-host. Andrew's voice on the show is an AI-generated clone of his own recordings — Andrew writes and reviews every word. How the show is made

Free — no email requiredRead it or print / save as PDFUpdated November 24, 2026Companion to Episode 10
Affiliate disclosureTools: ChatGPT or Claude, Mailchimp, Brevo. There are no affiliate links in this playbook.

Guided mode

Step through the 3 build steps one at a time. Keeps your place — it doesn't verify work done in your own tools.

On this page

What you need

Your customer list (wherever it lives), a computer or phone, and one free AI chat account (ChatGPT or Claude). Total first-time setup: about 60–90 minutes.

Step 1 — Get the list out (about an hour, once)

Your customer list already exists. It is just scattered. Pick every place you have customers and export or copy them into one spreadsheet (Google Sheets or Excel, your call):

  • Booking / scheduling app (Square Appointments, Vagaro, Booksy, Jobber, Housecall Pro, Calendly): every one of these has an Export or Download customers option under Customers/Clients settings. Export as CSV, open it in your spreadsheet.
  • Square, QuickBooks, Shopify: Customers/Clients section → Export.
  • Phone contacts: iPhone — open Contacts, select the customer contacts, share/export to a file; or sit down for 20 minutes and type the ones that matter into the sheet.
  • A notebook: same thing — type the names in. Twenty names you remember beat four hundred you never look at.

One spreadsheet, these columns: Name | Email or phone | Last visit/job date | What they bought. That last column is the gold — keep it short: "balayage," "fence repair," "2024 tax return," "Tuesday spin class."

Step 2 — Sort by who went quiet (10 minutes)

Add one column: Days since last visit (in Google Sheets: =TODAY()-C2 if C is the date, formatted as a number). Sort largest first. Everyone past the normal gap for YOUR business is your win-back list:

  • Salon, barber, nails: 90+ days
  • Gym, studio: 60+ days
  • House cleaner, landscaper, pool service: one missed cycle
  • Contractor, roofer, plumber: one season since the last job (their house kept aging)
  • Accountant, financial advisor: 12 months, or before your busy season
  • Retail, restaurant: 90+ days since last purchase or visit

Step 3 — The AI step: a real note per person (the one-time build)

Paste the prompt below into ChatGPT or Claude with your spreadsheet attached or pasted in. It drafts one personal note per quiet customer, referencing what they actually bought. You only build this once — save the prompt, reuse it monthly.

The win-back prompt

You are my customer win-back assistant. I own [type of business] called [business name]. Attached/pasted is a spreadsheet of past customers with columns: Name, Contact, Last visit, What they bought.

For each customer whose last visit is over [90] days ago, draft a short, warm re-engagement note (under 70 words) that:
- References what they actually bought last time, naturally, like the owner remembers them
- Mentions one timely reason to come back now: [the holidays are coming / seasonal booking fills up / a new season of appointments opens]
- Ends with one easy ask ("Want your usual slot back?" / "Want me to put you on the schedule?")
- Never discounts by default; add "— mention this note for 10% off" ONLY to the customers I mark YES in the Discount column
- Never mentions anything beyond what they bought (no family, health, or personal details)
- Flags any row where the name or last-visit data looks wrong instead of drafting from it

Output a table: Name | Channel (email or text) | Draft note.

Step 4 — You read every note (non-negotiable, 15 minutes)

Before anything sends, check each note for three things:

  1. The service is real — it references something you actually sell, spelled right.
  2. The name is right — and it's going to the right person.
  3. Nothing private — their last purchase, yes. Their life, never.

Fix or delete any note that fails. You are the last checkpoint; this never gets automated.

Step 5 — Send (free at this size)

  • Under 250 contacts: Mailchimp's free plan covers you.
  • Up to 300 emails a day: Brevo's free plan, no credit card.
  • Under ~100 people (often best): skip the tools. Send the notes yourself from your normal email or texts, 30–50 an evening over a couple of nights. A personal note from a real address beats a marketing template.

Every message must include a working way to opt out, and you honor every unsubscribe, always. These are your customers — the goal is one warm reminder, not a campaign.

Then: the 20-minute monthly run

Once a month: update the Last visit column, re-sort, paste the sheet back into your saved prompt, review the new notes, send. That's it. The businesses that do this steadily don't have slow months — they have lists that get reminded.

Want it done for you?

GreatArrow sets up workflows like this for businesses — same idea, most of the setup handled. It's optional; everything above works without it. (Full disclosure: GreatArrow is Andrew's company.)

Sources

Sources for the numbers quoted in the episode: BIA Advisory Services repeat-customer data via Semrush (semrush.com/blog/customer-retention-stats); Mailchimp and Brevo pricing pages as of November 2026.

Resources & tools

Only the tools and links named in the playbook. Anything without a verified public link is marked as pending rather than guessed.