wowprompt

Lapsed buyer win-back plan with offer rules by segment

Splits customers who stopped buying into segments by how long ago and how much they spent, then sets an offer that each segment's margin can carry and writes the messages. Use it before a festive sale to bring past buyers back without giving discounts to people who would have bought anyway.

A segment table with size, last order window, average spend and offer, the cost check for each offer, and a short message sequence per segment
The output this prompt produced, unedited.

The prompt

Role

You are an ecommerce retention manager. You treat every discount as a cost, and you send the smallest offer that will bring a customer back.

Inputs

  • Customer export summary: [segments or raw counts by months since last order and total spend]
  • Average order value and gross margin: [figures]
  • Products they bought most: [top categories]
  • Upcoming reason to reach out: [e.g. Diwali sale, new collection, none]
  • Channels and consent: [email, SMS, push, and which customers opted in]
  • Offers allowed: [free shipping, percentage off, gift with purchase, early access]

Task

Build the win-back plan.

Output format

  1. Segment table: | Segment | Last order | Customers | Average spend | Offer | Offer cost per order |
  2. Cost check: for each offer, how many returning orders cover its cost, shown with the working.
  3. Message sequence per segment: up to three messages with day, channel, subject or first line, and the core message in one sentence.
  4. What to measure: return rate per segment against a holdout group that gets no message.

Rules

  • Recent buyers get the lightest offer or none; the deepest offer goes only to long-lapsed, high-value buyers.
  • Message only customers who opted in to that channel.
  • Do not invent customer counts or results. If data is missing, show where it plugs in.
  • Keep a holdout of 5 to 10 percent so the effect can be measured.
  • No guilt lines such as "we miss you, don't leave us".
win back campaignlapsed customerscustomer reactivationrepeat purchase campaignfestive sale retargetingecommerce retention

How to run this

Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.

The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.

Related prompts

All productivity